Define Teradata :
Do you know one of the most famous Relational Database Management System? It is called Teradata. For the purpose of constructing large-scale data warehousing applications, it is mainly suitable. The parallelism concept is achieved by the concept of Teradata. The company called Teradata developed it.
Evolution of Teradata :
Here is a list of achievements and progress of Teradata over the years:
1979: Incorporation was done by Teradata.
1984: First database computer DBC/1012 was released.
1986: Teradata was named by Fortune magazine as Product of the year
1999: Using Teradata with 130 Terabytes was considered as the largest database in the world.
2002: With Partition Primary Index and Compression, Teradata V2R5 was released along with compression.
2006: Master Data Management Solution is done by Launch of Teradata.
2008: Active Data Warehousing was released by Teradata 13.0.
2011: Advanced Analytics Space has been entered by Acquired Teradata Aster.
2012: Version 14.0 of Teradata was introduced.
2014: Version 15.0 of Teradata was introduced.
Features of Teradata:
Here are few features of Teradata:
No Sharing Architecture: Shared Nothing Architecture or No Sharing Architecture is the other name for Teradata architecture. The disks linked with AMPS, Teradata Nodes, and Access Module Processors (AMPs) work independently. There is no sharing done with others.
Parallelism that is unlimited: Massively Parallel Processing (MPP) Architecture is the basis for Teradata database system. The workload is divided evenly across the entire system by MPP architecture. Among its processes, the tasks are split by the Teradata system and run a parallel system for being sure of a completed task quickly.
Linear Scalability: There is a high scalability of Teradata systems and the scaling limit is up to 2058 Nodes. For instance, the capacity of the system can be doubled by doubling the number of AMPs.
Connectivity: Channel Attached systems are connected with Teradata like Mainframe or Network attached systems.
Mature Optimizer: One of the matured optimizers in the market is called Teradata optimizer. Since the starting, it can be designed in parallel. For each release, it has been refined.
SQL: For interacting with the data stored in tables, Teradata supports industry-standard SQL. Apart from that, it offers its own extension.
Robust Utilities: Robust utilities are offered by Teradata for importing or exporting data from/to Teradata systems like FastLoad, FastExport, MultiLoad, and TPT.
Automatic Distribution: The data is distributed automatically with Teradata evenly to the disks and there is no need of any manpower over here.
Stay connected to CRB Tech for more technical optimization and other updates and information.