Flat File Database

The flat file database store the record in the file which can be notepad or any word processor file. Flat file database contains the set of records each record is place in single row separated by delimiters. In modern database systems records are stored in multiple tables having relationship but in flat file system all records are stored in single file one record per row.

Implementation of Flat File databases

-Berkeley DBBorland Reflex
-MySQL CSV, a storage engine for MySQL 5.x

Example Flat File Database

id    name    team
1     Amy     Blues
2     Bob     Reds
3     Chuck   Blues
4     Dick    Blues
5     Ethel   Reds
6     Fred    Blues
7     Gilly   Blues
8     Hank    Reds


Be Sociable, Share!

Leave a Reply