5 Things about Teradata everyone wants to know
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