Teardata Basics - I

** Source: NCR TSG ( Teradata Solutions Group ) BOOK

Teradata was the first commercial database system to support a trillion bytes of data. It is hard to imagine the size of a trillion. Most people are comfortable with Kilobytes, Megabytes and even Gigabytes, but Terabytes are another order of magnitude. To put it in perspective, the lifespan of the average person is 2.5 Giga seconds (or said differently 2,500,000,000 seconds). A tera-second is 31,688 years!

How Large is a Trillion

1 Kilobyte = 103 = 1000 bytes

1 Megabyte = 106 = 1,000,000 bytes

1 Gigabyte = 109 = 1,000,000,000 bytes

1 Terabyte = 1012 = 1,000,000,000,000 bytes

1 Petabyte = 1015 = 1,000,000,000,000,000 bytes

1 Exabyte = 1018 = 1,000,000,000,000,000,000 bytes

1 Zetabyte = 1021 = 1,000,000,000,000,000,000,000 bytes

1 Yottabyte = 1024 = 1,000,000,000,000,000,000,000,000 bytes

1 million seconds = 11.57 days

1 billion seconds = 31.6 years

1 trillion seconds = 31,688 years

1 million inches = 15.7 miles

1 trillion inches = 15,700,000 miles (30 roundtrips to the moon)

1 million square inches = .16 acres = .0002 sq. miles

1 trillion square inches = 249 square miles (larger than Singapore)

$1 million = < $ .01 for every person in U.S.

$1 billion = $ 3.64 for every person is U.S.

$1 trillion = $ 3,636 for every person in U.S.

The Teradata Charter

• Relational database

• Enormous capacity

- Billions of rows

- Terabytes of data

• High performance parallel processing

• Single database server for multiple clients

• Network and mainframe connectivity

• Industry standard access language (SQL)

• Manageable growth via modularity

• Fault tolerance at all levels of hardware and software

• Data integrity and reliability