what is the difference between a flat- file and a relational database
what is the difference between a flat- file and a relational database
Answers
A flat file is conceptually the simplest storage format. Records are stored line by line with no structural relationship between them.
A relational database may use a flat file behind the scenes for storage, but provides a layer of abstraction to allow querying of the data and returning related records.
A flat file would be used when no advanced querying is required, or processing power is limited and speed is important. Such as logging GPS coordinate on a small device.
Whereas a relational database would be used when the application logic needs to be kept as simple as possible, but lots of interrelated bits of data need to be stored and retrieved. Most websites make heavy use of relational databases.
19 May 2011
I don't know the answer...lol..!!!
05 March 2021
Flat file
1.Data is stored in a single tables.
2.It is suitable for less amount of data.
Relational file
1.Data is stored in multiple tables.
2.It is suitable for large amount of data.
23 May 2022
Flat - stores data in single , flat table with rows and columns
Relationl - stores data in multiple table with relationships
16 June 2025
Flat - stores data in single , flat table with rows and columns
Relationl - stores data in multiple table with relationships
16 June 2025
Add an answer
Similar questions