Flat file database

A flat file database flat-file database in which data is stored in plain text. It is generally to store and retrieve a small amount of data in a local text file. Need a database not: the host as free web does not allow their users to the MySQL database for free use. In this case, the database flat file is an alternative. How to store data: In a database, data stored in tabular form. An example of a table of typical database is given below. Name class age 9 15 John 6, 11 Susan Emile 10 15 If we want to save such a table in a flat file structure file database is as follows. John 9 ^ ^ ^ ^ ^ ^ 15 Susan Emili 6 ^ ^ 11 ^ ^ 10 ^ ^ 15 Here, I used a new string "^" is used as column separator, and a new character, online line of separation. By choosing such a separation, we must confirm that the data itself, not the chain. We need to filter the data string before each such write operation. Problems flat file database: 1 A flat file is a SISO (serial Serial Out) memory system. New data can be entered at the end of the file. So if we want to edit or delete a record from our database, or if we set a new record in the insert between the two data sets, we re-order, then write the database file entire data. Thus, the velocity decreases with farm size of the file database. In fact, the basic data flat file should be used more than 5 MB in size. 2. Flat file database is not very safe in a multiuser environment, such as blog, guestbook, etc., where many users share the same database from different ends.

Or for further references, check out the following resources: