flat file

A single plain text file that holds all the data as lines, with no tables linked to each other and no rules enforced.

In more detail

The course starts from a CSV file (comma-separated values), where every order line repeats the customer's name and city. Nothing stops two copies of the same fact from disagreeing, nothing checks that values are valid, and answering a question means writing a loop over every line. A relational database fixes each of these problems.

Example

1004,2024-04-21,Chen Wei,Singapor,SG,HDMI Cable,1,1500   # the misspelt city is a second, disagreeing copy

Related terms

Taught in

References