Home » Tutorials » Flat File Based DBMS (FDBMS)

Flat File Based DBMS (FDBMS)

Our Categories

Blog Stats

  • 32,852 hits

Calendar

March 2013
M T W T F S S
« Feb   Apr »
 123
45678910
11121314151617
18192021222324
25262728293031

Flat File Database

Please visit SQLVERSITY.COM for more details.

A flat file database is a database which stores the data in plain text file. It is a database consisting of a single table with no structure and relationship.

This kind of database holds one record in a row and fields are separated by delimiters like commas or tabs spaces or pipe symbols or may have fixed length.

For example, create a text file and write the below text in it.

AAA

BBB

CCC

Flat file

Now save the file. Believe me you have created a flat file database. It is just a simple flat file database which contains only 1 attribute(column) and 3 Tuples(rows).

Disadvantages:

  • Flat file databases do not link the data in one file to the data in another file.
  • If any application is using a flat file database as source, application itself should have the logic to access that flat file. If you take the above example, application should have the logic inside it to know the data for the first column there  from position 1 to 3 in the flat file.
  • It is not easy to find the duplicates in the data.
Advertisements

2 Comments

  1. Concise and to the point…an excellent article

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: