|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/25/2006 4:37:00 PM
Posts: 1,
Visits: 1
|
|
|
i want to know the advantages of teradata over other databases . And also disadvantages,(why 1 organisation should go for teradata and why not?)
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 2/27/2007 4:49:00 PM
Posts: 3,
Visits: 1
|
|
Advantages
1)Teradata database is Linearly scalable. - We can expand the database capacity by just adding more nodes to the existing database.If the data volume grows we can add more hardware and expand the database capacity.
2)Extensive paralell processing - Teradata has a extensive paralell processing capacity,It can handle multiple adhoc requests and many concurrent users.
3)Shared nothing architecture - Teradata database has shared nothing architecture,It has high fault tolerance and data protection.
Disadvantages
1)It is not suitable for small transaction OLTP databases.
Koti C | EDW ETL Dev
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 4/12/2009 9:23:27 PM
Posts: 44,
Visits: 21
|
|
Disadvantage: Teradata development and DBA resources are harder to come by and therefore more expensive.
My opinion - people can learn something about Oracle by reading "Oracle for Dummies" for $20. The cheapest book is Tom Coffing's $85 "Teradata SQL." You can attend a class on Oracle at a community college for $200 - $500. A Teradata seminar costs thousands. (We're paying $1,120/ head to have someone from Coffing's firm come out to lead a four-day seminar.)
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 2/18/2008 4:01:01 AM
Posts: 30,
Visits: 14
|
|
Teradata is not as open as Oracle in Tech.
many key tech is still under the control of Teradata PS,
and Teradata is for enterprise application, not as widely used as Oracle or Sybase
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 4/22/2008 1:21:41 AM
Posts: 11,
Visits: 12
|
|
It's not really a consideration for enterprise software. Teradata is designed for very high data volumes. If you tried that on Oracle with a $20 Oracle DBA or someone just out of a training course they would be completely at sea. They just wouldn't know how to optimise it for high data volume loads and intense user query. For a database of this size the experienced DBAs for Oracle or DB2 may be as expensive as the DBAs for Teradata although probably more numerous.
Companies are choosing Teradata because they perceive it to be better at high volume data warehouse work than the RDBMS products such as Oracle and DB2. Teradata have designed a DW database for fast loading of huge data volumes and fast SQL querying. It is more specialised for DW than Oracle or DB2.
Vincent McBurney
blogs.ittoolbox.com/bi/websphere
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 4/26/2007 5:58:00 AM
Posts: 2,
Visits: 1
|
|
Single Version of Truth, Parallel aware optimizer, reduces dba activities and
Good warehouse incase of huge data...
Maintain as DW is not so easy in terms of cost.
cheers,
Maanchaala
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/12/2009 8:11:55 AM
Posts: 2,
Visits: 5
|
|
Dear Sir,
Tera Data is comparable to SAP BW?
Regards,
Biswarup Pal
hi
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/12/2009 8:11:55 AM
Posts: 2,
Visits: 5
|
|
Dear Sir,
Our Data warehousing size is 1.5 TB and it is increased by around 120 GB/month.
We are using SAP BI 7.0 and have Oracle 10G data base and planing to buy SAP BIA.
Should we go for TERADATA?
Regards,
Biswarup Pal
hi
|
|
|
|