Teradata Tutorials
Teradata Tutorials Overview
Welcome to Teradata Tutorials. The intent of these tutorials is to provide in depth
understanding of Teradata Database.
Teradata Overview
It is an RDBMS that Drives companies data ware housing OLTP,OLAP, DSS,DATA MART
Appliances.
(A) An OPEN SYSTEM, which executes on Unix MP- RAS(Discantioned in TDD) Windows
2000,xp,NOVEL,SUSE LINUX etc The Above operating system
(B) Compatible with ANSI standard
(C) Acts like a SERVER
(D) Run on single(or)Multiple NODES
(E) Built in parallelism
I Tera Byte = 102 Bytes=1024 GB(GIGA Byte)
Teradata Applications
Enterprise Data ware house
Active Data ware house
Internet And E-Commerce
CRM[Customer Relationship Management]
Data Mart Appliance etc
TeradataHistory
1979
TeradataCorporation
1982
First Version DBC/1012
1996
2006 Tera data-NCR
2007
TD NCR Separated
TD V1R1 V1R4
(V-Version,R-Release)
[V1 R1 , V1R2, V1R3 V1R4]
TD V2R1 V2R7
(V2 R1 , V2R3, V3R3 ,V2R4, V2 R5 , V2R6, V2R7)
TD12 (2007)
TD13 View Point Version
TD14Up Coming
Certification Version APR 2010 onwards TD12 Real time companies
V2 R5, V2R6, V2R7 TD12, TD13 very few
Teradata Enterprise Architecture
Teradata Architecture
Teradata Database system are 2 types
SMP
MPP
a) SMP[Symmetric Multi- Processing]
Teradatadatabase system is called SMP System it have a single NODE That contains multiple
CPU sharing Memory pool.
b) MPP[Massively parallel Processing]
Here multiple NODES are connected together via a component called as BYNET
Here all the NODES communication with each other with the help of vistual processes
Real time usage
To perform mode operation and to have better storage this is recommended.
NODE ARCHITECTURE
PE
Passing Engine
PDF
Parallel Data Base Extension
AMP
Access Module Processor
VDISK
VPRDC
Virtual Disk
Virtual Processor
NODE
It is important building block of the Teradata Database system it is collection of hardware and
software components.
A server can also called as a node
Channel Attached system and network attached systems can be connect to a NODE
Channel driver and Teradata GATEWAY are the application RUN under the operating system as
processes
Remaining component runs under PDE
PE and AMP Virtual processor, where BYNET Is an Internal Layer between PE and AMP
PDE[Parallel Data Base Extension]
It Runs Teradatacomponent in parallel
TPA[Trusted parallel Application]
A data base is called pure parallel application (or) Trusted parallel application, its Runs under
PDE
Teradata is a database, which is running under PDE, so we call it. Teradatahas pure parallel
Data base and trusted data base
SMP ARCHITECTURE[Symmetric Multi- Processing]
Single NODE Architecture can also be called as SMP Architecture, Here BYNET Can also referred
as BROAD LESS BYNET(or) VIRTUAL BYNET(or)S OFT Ware BYNET
Recommended
For GIGA BYTES of data processing with minimum operation, this is recommended
MPP Architecture(Massively parallel processor)
Collection of NODE which make larger configuration which Is called MPP
All these nodes are connected via component called BYNET,
Which allows multiple virtual processors and multiple NODES Communicate with each other
This BYNET can also called as BOARD ORIENTED BYNET(OR) HARD WARE BYNET.
Terdata BYNET Features
Fault Tolerance
Each BYNET having network path to connected to the NODES, if there is a failure in any net
work path simple it reconfiguration Itself and avoids the un- usable or failed path, in this way it
is fault occurrence. It tolerates it self
Load Balances
It BYNET O is not able to reconfiguration or not able to handle traffic, than all instructions
redirected to BYNET1 and it is Balance the Load.
High scalability
If we increase the Number of NODES Teradata Doesnt sacrifice any perform are and its scales
Linearly.
NOTE
V2 R5 512 NODES
V2R6, TD121024 NODES
Latest Version2048 NODES be can connect to BYNET upcoming
Some companies And Number of the NODES
JPMC 40 NODES
BOA 40 NODES
DBS 8 NODES
ICICI Productial 4 NODES
CISCO 44 NODES
WALL MART 340 NODES
Barclays 11 NODES (or)
Recommendation
If Processing Tera BYTES of data and many operations the MPP is recommended.
Difference between Teradata And Other RDBMS
TERA DATA
Other RDBMS
Architectures
Shared Nothing
Shared Every thing
Processes
MIPS[Millions of Instructions/sec
KIPS[Thousand of institutions/sec]
Indexes
Better Distribution And Retrieval
Only FASI Retrieval
Parallelism
Un-conditional
conditional
Bulk Load
Many
Limited
Facilities
Enterprise wide Data ware housing OLTP More
stores
TERA BYTES[Billions of rows]
GIGA BYTES[Millions of rows]
CRM[Customer, Relationship Management]
Teradata Advantages
Automatic, Even Data Distribution
In Other RDBMS Sequential distribution is Automatic, But in Teradata Even(or) Uniform
(or)Random distribution is Automatic
High Scalability
NODE
NODE
WORK
WORK
USERS
USERS
Other, RDBMS Linear Scalability Application Teradata
If increase Number of Node, USERS (OR) WORK, TeradataDoesnt sacrifice any performance and
its scales linearly
Matura optimizer
Older Version of Oracle/SQL Server
32 Joins/Queries
32 Sub Queries/Queries
Older Version of Tera data
64 Joins/Queries
64 Sub Queries/Queries
Formatting Commands
Analytical Commands
Aggregate Commands etc.
As Teradata is having powerful optimizer so that it is able to perform above operations.
Models The Business
Teradata highly flexible to 3NF[3rd Normal Form] and its supports the below models also
1.
Normalization
2.
Star schema
3.
Snow Flake schema
4.
Bus schema
5.
Galaxy Schema
6.
Hybrid Schema
Acts Like a Single Data Store
Tara data is warehouse, where we can stoke both CHANNEL ATTACHED Data and NETWORK
ATTACHED Data.
Low cost TCO[total cost of ownership]
Many Bulk Load Facilities
There are many facilities in Teradatato load and un-load
BTEQ-Load/Un- load
FAST LOAD-LOAD
MULTI LOAD- LOAD
FAST EXPORT- UN-LOAD
T PUMP-LOAD
OLE LOAD- LOAD/UN-LOAD
TeradataPARALLEL TRANSPORTER (TPT)-LOAD/UN-LOAD
TeradataPARALLEL TRANSPORTER API etc.
Many appliances added supported from teradata 13 onwards those are
Extreme data appliance1550/1555
Active Enterprise Data ware house 5555/5550
Data mart appliance 2550/2555/2500 etc
Teradata Installation
Installing Teradata is very simple. It asks 2 things.
Storage space
Custom and typical option
Un zip folder, zip folder
Go to setup.exe
Click Main Menu
Install TeradataExpress
Installation Requirement
Minimum32-bit system Requirement
Micro soft windows XP with SP3
Micro soft windows Server 2003 with SP2
Micro soft windows Server 2008
Micro soft windows vista
Micro soft windows 7
Minimum hard ware Requirement
1 GB Memory
5 GB to 12GB of Free Disk space
Click Next install Menu and install below component one by one
Teradata BYNET DRIVER
Tara data Database
Tara data Express tool
Tara data tools and utilities
Note
It takes Max 20 to 25 minutes for entire installation
