TeraData a Leading industry in DataWareHouse

Ever Thought Why Teradata is leading industry in Datawarehouse !!!

Performance Tuning using parallel processing, this is the clever process by Teradata to dominate the world of Datawarehouse. Their architecture is based on the following main components, which makes processing super fast and efficient.

• Access Module Processor (AMP) , a series of parallel processing processors.
• Parsing Engine the boss/ mind behind the whole Teradata architecture, it takes SQL from user, comes up with a plan over one of two byNets (byNet0 & byNet1) and the AMPs get its simultaneously, they do their portion of work and return it to the parsing engine over the byNet

See, how beautifully the whole table is distributed over multiple AMPs.

TeraData systems can add AMPs for Linear Scalability for large data to define the key feature of any datawarehouse. This process of parallel AMPs give more processing power to the indexing techniques (Unique Primary Index & Non Unique Primary Index) by following beautiful Teradata architecture.

So, all in all its a powerful tool to handle large amount of data in fast and furious amount of time.

Get in touch with this series !