Types of Flat File Database
Below are some types of Flat File Database
- JavaScript Object Notation (JSON): It is a simple data transfer format that is easy to read and write for people. JSON files are perfect for hierarchically storing more difficult data structures since they express data as nested lists and dictionaries, which are identical to arrays and objects in JavaScript.
- Initialization File(INI): INI files are arranged into header-defined parts, with key-value pairs shown underneath each section.
- Comma Separated Values(CSV): These are a type of file that creates tabular data in plain text. They are conceivably the most well-known format. Commas are utilised to separate the various fields inside each record, and each line in the file represents a single record.
- Xtensible Markup Language(XML): It is an adaptable text format that may be utilised to display structured data. Similar to HTML, XML files determine objects and properties using tags, which enables the creation of sophisticated data structures with hierarchical relationships.
Flat File Database
A database kept in a file known as a flat file is referred to as a flat-file database. Every entry has the same format, and there are no systems in place for indexing or determining the links between items. The file is simple to read.
A flat file can be a binary file or a plain text file such as CSV, txt, or TSV file. Although connections cannot be explicitly declared in the database format, they can be deduced from the data in the database. While very big databases can also be flat, the phrase has always denoted a tiny database.