Flat File Database - Terms

Terms

"Flat file database" may be defined very narrowly, or more broadly. The narrower interpretation is correct in database theory; the broader covers the term as generally used.

Strictly, a flat file database should consist of nothing but data and, if records vary in length, delimiters. More broadly, the term refers to any database which exists in a single file in the form of rows and columns, with no relationships or links between records and fields except the table structure.

Terms used to describe different aspects of a database and its tools differ from one implementation to the next, but the concepts remain the same. FileMaker uses the term "Find", while MySQL uses the term "Query"; but the concept is the same. FileMaker "files", in version 7 and above, are equivalent to MySQL "databases", and so forth. To avoid confusing the reader, one consistent set of terms is used throughout this article.

However, the basic terms "record" and "field" are used in nearly every flat file database implementation.

Read more about this topic:  Flat File Database

Famous quotes containing the word terms:

    I had a long day’s work, starting at eight in the morning and ending after nine at night, but in those days [we] ... did not think of our day in terms of hours. We liked our work, we were proud to do it well, and I am afraid that we were very, very happy.
    Louie Mayer (b. c. 1914)

    Women have acquired equal place to man in society, but the double standard has really never been relinquished; certainly not by men. Modern man’s fear of passivity or of the active woman proves to be as eternal as modern woman’s struggle to come to terms with her femininity.
    Peter Blos (20th century)

    It is not [the toddler’s] job yet to consider other people’s feelings, he has to come to terms with his own first. If he hits you and you hit him back to “show him what it feels like,” you will have given a lesson he is not ready to learn. He will wail as if hitting was a totally new idea to him. He makes no connections between what he did to you and what you then did to him; between your feelings and his own.
    Penelope Leach (20th century)