Data Warehousing Community Forum
February 09, 2012, 01:04:54 pm
Home
Help
Search
Login
Register
Data Warehousing Community Forum
>
Databases
>
Teradata
>
Data Storage
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: Data Storage (Read 3241 times)
Naaga
DW Fresher
Reputation: +2/-0
Offline
Posts: 1
Data Storage
«
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
Logged
herbert11
DW Apprentice
Reputation: +4/-0
Offline
Posts: 25
Re: Data Storage
«
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
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> Introductions
=> Anouncements & News
=> Suggestions
=> General Discussion
=> Job Opportunities
-----------------------------
Data Warehousing
-----------------------------
=> Data Warehousing Concepts
=> Data Modeling
-----------------------------
Databases
-----------------------------
=> Oracle
===> PL/SQL
=> Microsoft SQL Server
=> IBM DB2
=> Teradata
-----------------------------
ETL Tools
-----------------------------
=> Informatica
===> Installation & Configuration
=> Data Stage
=> Ab Initio
=> Oracle Warehouse Builder
=> DTS/SSIS
-----------------------------
Reporting Tools
-----------------------------
=> Business Objects
=> Cognos
=> Crystal Reports
=> Hyperion
=> Brio
=> Microstrategy
-----------------------------
Operating Systems
-----------------------------
=> UNIX / Linux
===> Unix Shell Scripting
=> Windows
-----------------------------
Other Technologies & Tools
-----------------------------
=> JAVA