Data Warehousing Community Forum
February 09, 2012, 01:04:54 pm

Pages: [1]   Go Down
  Print  
Author Topic: Data Storage  (Read 3241 times)
Naaga
DW Fresher
*

Reputation: +2/-0
Offline Offline

Posts: 1


View Profile
« on: February 23, 2011, 06:03:49 pm »

Hi..

Am new to Teradata...  i want to know how the data are stored in database tables..  not rows & column matrix... my Question is how the data stored physically ... internally ...

Thanks
 Kiss



Logged
herbert11
DW Apprentice
**

Reputation: +4/-0
Offline Offline

Posts: 25


View Profile
« Reply #1 on: September 07, 2011, 01:25:34 pm »

Storage space is divided into pages which are numbered in a sequence. It is a basic unit for input-output operation. It has a header which stores all the information about the page. The space is divided in 8 pages. The rows are divided into a series of partitions of a user defined size. B-tree or any heap structure is used to store the row in each partition. The leaf node store the data and the data reachable from these are stored in other nodes.
Logged
Pages: [1]   Go Up
  Print  
 
Jump to: