Teradata is an open-source Database Management System for developing large-scale applications for data warehousing. It supports several data warehouse operations at once using the concept of parallelism. Teradata is a massively open processing system that can be used on the server platforms Unix/Linux/Windows.
Teradata software is created by Teradata Corporation, which is an American IT company. It’s a provider of analytics platforms, software, and other related services. The company creates products to consolidate data from various sources and make it available for analysis.
History of Teradata
Teradata was a division from NCR Corporation. It was incorporated in 1979 however it split from NCR in October 2007. Michael Koehler became the first CEO of Teradata.
Keystones in Teradata Corporation:
1979 – Teradata was added to the company in 1979.
1984 – The release of the first database computer DBC/1012
1986 1985 – Fortune magazine declared Teradata to be the “Product of the Year”
1999 – Largest database developed with Teradata with 130 Terabytes
2002 – Teradata V2R5 version release , with Partition Primary and compression
2006 – Launch of Teradata Master Data Management solution
2008- Teradata 13.0 is released including Active Data Warehousing
2011 . – Purchases Teradata Aster and plunges into the Advanced Analytics Space
2012 – Teradata 14.0 introduced
2014 – Teradata 15.0 introduced
2015- Teradata Buys Apps Marketing Platform Appoxee
20162016 Terada join hands with Big data
2017- Teradata Acquires San Diego’s StackIQ
Why Teradata?
Teradata provides a complete suite of service which focuses on Data Warehousing
The system is built on open architecture. So whenever any faster devices are available and integrated into the already build architecture.
Teradata can handle 50+ petabytes worth of information.
Single operation view for a large Teradata multi-node system using Service Workstation
Compatible with wide range of BI tools to pull data.
It may serve as a single point of control to allow the DBA to manage the Database.
High-performance, diverse query database analytics, sophisticated load management
Teradata allows you to get the same data in multiple deployment options
In the next installment of the Teradata tutorial, we’ll learn about features of Teradata.
Features of Teradata SQL
Teradata has the following features:
Linear Scalability: Offers linear scaling when dealing with huge amounts of data. It can be achieved by adding nodes to improve the performance of the system.
Unlimited Parallelism: Teradata is based on MPP (Massively Parallel Processing Architecture). So, it is specifically designed to be a parallel system from the beginning. It is possible to divide a massive task into smaller ones and run them in parallel
Mature Optimizer Teradata Optimizer can handle up to 64 joins an query.
The low cost of ownership: Tera data has a low total cost of ownership. It is simple to setup, maintain, and administrate.
Load & Unload utilities Teradata offers load and unload utilities to move data from or into the Teradata System.
Connectivity: This system can be connected to channel-attached devices such as a mainframe and network-attached systems.
SQL: Teradata supports SQL to interface with the tables that store data. It provides its extension.
Robust Utilities: Teradata provides robust tools for importing/exporting data from/to Teradata systems like FastExport, FastLoad, MultiLoad, and TPT.
Automatic Distribution: Teradata will distribute data automatically to the disks with no need for manual intervention.
The next step in this Teradata SQL tutorial, we will explore Teradata Architecture.
Teradata Architecture
Teradata architecture is an Massively Parallel Processing Architecture.
Three key aspects of Teradata are:
Parsing Engine
BYNET
Access Module Processors (AMPs)
Teradata Storage Architecture
Parsing Engine:
The Parsing Engine decodes queries and formulates it’s execution program. It manages user sessions. It is optimized and then sends an email to users.
So, when the client makes queries for inserting entries, Parsing Engine sends the records to the The Message Passing layer. The Message Passing Layer, also known as BYNET is a software and hardware component. It offers networking capability. It also retrieves the records and then sends the row to the target AMP.
AMP:
AMP stands to mean Access Module Processor. It records data on these disks. AMP conduct following activities:
Controls a small portion of the database
Controls a specific portion of each table
Perform all the task involved in generating the results such as sorting, aggregation and join
Perform lock and Space management
Teradata Retrieval Architecture
If the client uses queries to search for records in the database, the Parsing engine sends an email to BYNET. Then, BYNET transmits the retrieval request to the appropriate AMPs.
They search their disks parallel and recognize the required records and send these to BYNET. BYNET forwards the information to Parsing Engine which will then be transmitted back to your client.
Next in this Teradata Database tutorial, we will explore Teradata SQL assistant commands.
Types of Teradata SQL commands
Teradata Database supports following basic SQL commands:
Data Definition Language (DDL) commands
Data Control Language (DCL) commands
Data Manipulation Language (DML) commands
Applications of Teradata Database
The following are the most popular Teradata Applications:
Control of Customer Information: Helps to maintain long-lasting relationships with customers.
Master Data Management Aids to create an environment in which master information can be used for synchronization, storage, and storage.
Financial and Performance Management: The organization can improve the speed and quality of financial reports. It lowers the costs of finance infrastructure and helps to manage the company’s performance.
Supply Chain Management: Improve supply chain operations which help to provide better customer service, shorter cycle times, and lower inventories.
Demand Chain Management helps to increase the quality of customer service and sales. It also aids companies in determine what customers will want from their item in a precise manner.
Summary
Teradata meaning: Teradata is an open-source Database Management System for developing massive-scale data warehouse applications.
Teradata was an entity within NCR Corporation. It was established in 1979, but separated from NCR in October 2007
Teradata provides a complete suite of service which focuses on Data Warehousing
Teradata provides linear scalability when dealing with huge amounts of data. It does this by adding nodes to improve the performance of the system.
Three important components of Teradata are 1) Parsing Engine 2) MPP 3.) Access Module Processors (AMPs)
Teradata provides a full collection of products that meet Data warehousing and ETL needs of any business
Teradata application mainly used to manage Supply Chain Management, Master Data Management, Demand Chain Management and more.