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:

    Most critical writing is drivel and half of it is dishonest.... It is a short cut to oblivion, anyway. Thinking in terms of ideas destroys the power to think in terms of emotions and sensations.
    Raymond Chandler (1888–1959)

    I’ve never been on good terms with God, but now I’m becoming His intimate, for He is truly absolute and extremely legitimate.
    Franz Grillparzer (1791–1872)

    One of your biggest jobs as a parent of multiples is no bigger than simply talking to your children individually and requiring that they respond to you individually as well. The benefits of this kind of communication can be enormous, in terms of the relationship you develop with each child, in terms of their language development, and eventually in terms of their sense of individuality, too.
    Pamela Patrick Novotny (20th century)