Wednesday, 4 June 2014

5 Things about Teradata everyone wants to know

Teradata is a fully scalable relational database management system produced by Teradata Corp. It is widely used to manage large data warehousing operations. The Teradata database system is based on off-the-shelf symmetric multiprocessing technology combined with communication networking, connecting symmetric multiprocessing systems to form large parallel processing systems.

Teradata mainly differs in the following factors with conventional databases:
  • Avoiding joins
  • Using summarized data to avoid aggregation
  • Storing data in sorted order
  • Using index to avoid large scans
  • Teradata powerful concept is query parallelism

More: Read complete tutorial on Teradata processing  

No comments:

Post a Comment

5 Top Teradata DATE functions read now

The following are the list of DATE functions. These are very frequently being used in Teradata.   Current DATE SELECT CURRENT_DATE; T...