Home » Tutorials » The Table family

The Table family

Our Categories

Blog Stats

  • 34,479 hits

Calendar

April 2013
M T W T F S S
« Mar   May »
1234567
891011121314
15161718192021
22232425262728
2930  

A Database table

Please visit SQLVERSITY.COM for more details.

 A table is a basic unit of data storage in database which organizes the data in rows(Tuples) and columns(Attributes/fields). Each row in a table contains one record and it simply refers to a two dimensional representation of your data using rows and columns. A table has a specified number of columns, but can have any number of rows. In short, a table is the only thing for storing data in the database.

A Database Table

Rows(Tuples)

Each row in a table contains one record and we can have any number of rows in a table. You can have a table without rows. But we cannot create a table without columns.

A row oriented database is a database in which the data of a particular record is organized in a row. The above table data will be arranged as below if it is in row oriented database.

1,AAA,Manager,80000

2,BBB,Project Lead,60000

3,CCC,Team Lead,40000

4,DDD,Senior Associate,20000

5,EEE,Associate,10000

Columns(fields)

Each column in a table stores the data which are of same data type. Column names in a table must be unique. We can have limited number of columns in a table based on database.

A column oriented database is a database in which the data of a particular record is organized in a column. The above table data will be arranged as below if it is column oriented database.

1,2,3,4,5

AAA,BBB,CCC,DDD,EEE

Manager,Project Lead,Team Lead,Senior Associate,Associate

80000,60000,40000,20000,10000

Advertisements

1 Comment

  1. Good One …simple and elegant..

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: