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:

    But the nature of our civilized minds is so detached from the senses, even in the vulgar, by abstractions corresponding to all the abstract terms our languages abound in, and so refined by the art of writing, and as it were spiritualized by the use of numbers, because even the vulgar know how to count and reckon, that it is naturally beyond our power to form the vast image of this mistress called “Sympathetic Nature.”
    Giambattista Vico (1688–1744)

    Ay, ay, the best terms will grow obsolete: damns have had their day.
    Richard Brinsley Sheridan (1751–1816)

    One of the most highly valued functions of used parents these days is to be the villains of their children’s lives, the people the child blames for any shortcomings or disappointments. But if your identity comes from your parents’ failings, then you remain forever a member of the child generation, stuck and unable to move on to an adulthood in which you identify yourself in terms of what you do, not what has been done to you.
    Frank Pittman (20th century)