td histry_12

8/3/2019 TD HISTRY_12

http://slidepdf.com/reader/full/td-histry12 1/6

DATA WAREHOUSEDATA WAREHOUSE

1.INMON DEFINED DATA WAREHOUSE.1.INMON DEFINED DATA WAREHOUSE.

DATA WAREHOUSE ISDATA WAREHOUSE IS

SUBJECT ORIENTED(BANKING,RETAIL,INSURANCE)SUBJECT ORIENTED(BANKING,RETAIL,INSURANCE) INTEGRATED (no. of files)INTEGRATED (no. of files) TIME VARIANT (As the time moves on Data must beTIME VARIANT (As the time moves on Data must be

increased).increased).

NON VOLATILE (Once entered Data will not be erased).NON VOLATILE (Once entered Data will not be erased).AND COLLECTION OF DATA IN SUPPORT OFAND COLLECTION OF DATA IN SUPPORT OFMANAGEMENTS DECISIONSMANAGEMENTS DECISIONS..

2.IT IS INTEGRATION OF DATA FROM VARIOUS SOURCE2.IT IS INTEGRATION OF DATA FROM VARIOUS SOURCE

SYSTEMS.SYSTEMS.

3.TERADATA DESIGNED FOR ANALYTICAL PROCESSING3.TERADATA DESIGNED FOR ANALYTICAL PROCESSING

RATHER THAN TRANSACTIONAL PROCESSING.RATHER THAN TRANSACTIONAL PROCESSING.

4.TERADATA WAS THE 14.TERADATA WAS THE 1STST COMMERCIAL DATABASECOMMERCIAL DATABASE

SYSTEM TO SUPPORT A TRILLION BYTES OF DATA.SYSTEM TO SUPPORT A TRILLION BYTES OF DATA.

8/3/2019 TD HISTRY_12


TERADATA HISTORYTERADATA HISTORY

1979 TERADATA CORPORATION GROUNDED IN LA, CA1979 TERADATA CORPORATION GROUNDED IN LA, CA

1982 YNET TECH ADOPTED.1982 YNET TECH ADOPTED.

1983 THE 11983 THE 1STST DBC TD COMPUTER RELEASED,ITS REVENUE ISDBC TD COMPUTER RELEASED,ITS REVENUE IS$3MILLION.$3MILLION.

1989TD TOOK HELP OF NCR.

1989TD TOOK HELP OF NCR.

1991 AT&T JOINED WITH NCR.1991 AT&T JOINED WITH NCR.

1992 TD IS MERGED IN TO NCR.1992 TD IS MERGED IN TO NCR.

1996 AT&T CAME OUT OF TD, NCR ARE PARTNERS.1996 AT&T CAME OUT OF TD, NCR ARE PARTNERS.

1997 WORLDS 11997 WORLDS 1STST COMMERCIAL WAREHOUSE REVENUE ISCOMMERCIAL WAREHOUSE REVENUE IS $200 $200 MILLIONMILLION..

2000 100 SYSTEMS GOT PRODUCTIONISED LIKE2000 100 SYSTEMS GOT PRODUCTIONISED LIKEWALMART,CITIGROUP,FEDEX ETC.WALMART,CITIGROUP,FEDEX ETC.

2002 TDV2R5 RELEASED IN THE MARKET.2002 TDV2R5 RELEASED IN THE MARKET.

2006 NCR , TD SEPERATED AND V2R6 RELEASED.2006 NCR , TD SEPERATED AND V2R6 RELEASED.

2007 TDV2R12 RELEASED IN THE MARKET.2007 TDV2R12 RELEASED IN THE MARKET.

8/3/2019 TD HISTRY_12


DIFF B/W TD AND OTHER RDBMSDIFF B/W TD AND OTHER RDBMS

TERADATATERADATA

1.SHARED NOTHING1.SHARED NOTHINGARCHITECTURE.ARCHITECTURE.

2.UNCONDITIONAL ||ISM.2.UNCONDITIONAL ||ISM.

3.PROCESS TERABYTES OF DATA.3.PROCESS TERABYTES OF DATA.

4.STORES BILLIONS OF ROWS.4.STORES BILLIONS OF ROWS.

5.MANY LOADING UTILITIES.5.MANY LOADING UTILITIES.

6.INDEXES FOR BETTER STORAGE6.INDEXES FOR BETTER STORAGEAND FASTER RETRIEVAL.AND FASTER RETRIEVAL.

ORACLE,SQL SERVERORACLE,SQL SERVER

1.SHARED EVERYTHING1.SHARED EVERYTHINGARCHITECTURE.ARCHITECTURE.

2.CONDITIONAL ||ISM.2.CONDITIONAL ||ISM.

3.PROCESS GIGA BYTERS OF DATA.3.PROCESS GIGA BYTERS OF DATA.

4.STORES ONLY MILLION.4.STORES ONLY MILLION.

5.LIMITED LOADING UTILITIES.5.LIMITED LOADING UTILITIES.

6.INDEXES FOR FASTER RETRIEVAL.6.INDEXES FOR FASTER RETRIEVAL.

8/3/2019 TD HISTRY_12


Top 9 Reasons Why Teradata Is THE Data

Warehouse Database

1 Maximum Scalability

2 Complex Query Performance

3 Parallel Self Balancing

4 Best Mainframe Integration

5 Mission-Critical Availability

6 Lowest Total Cost of Ownership

7 Ability to Model the Business 8 Quickest Time to Solution

9 Complete Support Infrastructure

8/3/2019 TD HISTRY_12


TERADATA

TD is a RDBMS which drives companiesDWH and composed of S/W and H/W.

TD is capable of supporting manyconcurrent users from various clientpaltforms(over TCP/IP or IBM channelconnection).

With TD RDBMS, we can acess,store andoperate on data using sql.

Built on Parallel Architecture.

8/3/2019 TD HISTRY_12


TD provides

CAPACITY:1.Terabytes of detailed data stored in billions of rows.2.Thousands of millions of instructions per second(MIPS) to process

data.PARALLEL PROCESSING:

.Makes TD RDBMS Faster Than other RELATIONAL SYSTEMS.SINGLE DATA STORE:1.Can be acessable by n/w attached and channel attached systems.2.Supports the requirements of many diverse clients.FAULT TOLERANCE:Automatically detects and recovers from n/w failures.

DATA INTEGRITY:.Ensures that transactions either complete or rollback to µSTABLESTATE IF A FAULT OCCURS¶.

SCALABLE GROWTH:.Allows expansion without sacrificing the performance.

td histry_12

Documents