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:

    We are well advised to keep on nodding terms with the people we used to be, whether we find them attractive company or not. Otherwise they turn up unannounced and surprise us, come hammering on the mind’s door at 4am of a bad night and demand to know who deserted them, who betrayed them, who is going to make amends. We forget all too soon the things we thought we could never forget.
    Joan Didion (b. 1934)

    They were pipes of pagan mirth,
    And the world had found new terms of worth.
    He laid him down on the sunburned earth
    And raveled a flower and looked away.
    Play? Play? What should he play?
    Robert Frost (1874–1963)

    I hope that you live on good terms with yourself and the gods.
    Henry David Thoreau (1817–1862)