Definition of flat-file in English English dictionary
1 As a noun, an ASCII text file consisting of records of a single type, in which there is no embedded structure information governing relationships between records 2 As an adjective, describes a flattened representation of a database as single file from which the structure could implicitly be rebuilt
A human-readable data-file in a convenient form for interchange of database information
When the flat file became unmanageable, we switched to a proper database system.
A text file Unlike many other systems, standard UNIX applications use text files instead of imposing particular formatting conventions on the document This results in much easier sharing of information between applications
A file that has no formatting In a relational database, a flat file is sometimes synonymous with a relation A flat file has no hierarchical structure
A database that consists of a single table Lightweight database programs such as the database component in Microsoft Works are sometimes called 'flat-file managers' (or list managers) because they can only handle single-table databases More powerful programs, such as FileMaker Pro, Access, Approach and Paradox, can handle multi-table databases, and are called relational database managers, or RDBMSs
Any file having fixed-record length, or in EDI, the file produced by EDI translation software to serve as input to the interface Usually has the same fields as the original file, but each field is expanded to its maximum length Does not have delimiters
An ASCII text file that usually means the contents of a database table saved in plain text format for conversion to another database Each row is one record from the database A table of 35,000 students would take 35,000 lines in a flat file, assuming all the variables were output in one line The example below has each field separated (or delimited) by the "pipe" symbol "|"
an ASCII data file produced by a business application that is converted into ANSI ASC X12 format by translation software, and vice versa It typically uses fixed-length format rather than variable length ANSI ASC X12 format Also known as a User Defined File (UDF)
A database in ASCII format that separates records by a special character See also ASCII, database
An electronic record that is stripped of all specific application (program) formats This allows the data elements to be migrated into other applications for manipulation This mode of stripping electronic data prevents data loss due to hardware and proprietary software obsolescence
A database that consists of a single table Some database programs such as the database component in Microsoft Works are called 'flat-file managers' (or list managers) because they can only handle single-table databases More powerful programs, such as Access, Approach and Paradox, can handle multi-table databases, and are called relational database managers, or RDBMSs
A flat-file database keeps information organized in a structured manner, typically in one big file A desktop spreadsheet application is an example of a flat-file database management system These are useful for Web publishers preparing content because a large body of information can be assembled and then distributed in a consistent format Flat-file databases typically lack support for processing transactions (inserts and updates) from concurrent users Thus, collaboration or ecommerce Web sites generally rely on a relational database management system as a back-end
A computer file used to transfer information from one computer program to another based on fixed-length data fields rather than the variable length fields used in X12 or UN/EDIFACT formats See X12 and UN/EDIFACT
a component of a file system or entry on a storage device, that is treated as having no special structure beyond that of bytes, characters, words and/or lines
All the fields are contained in one table and are not related to other tables So, in the case of payroll and personnel tables duplication occurs as names and addresses need to be maintained in both tables When normalisation is carried out on such data three related tables may be formed, with the common data such as employee name and address details being kept in a seperate table which is related to both payroll and personnel tables
A collection of data records having minimal structure Unlike a database, it contains only data, no structural information (metadata) is stored Therefore working on flat files can be very fast On the other hand it requires the application program to include all the logic that manipulates the data in the file Data manipulation can occur on only one file at a time Files can share duplicate data but the only time the files interact is when data is copied from one file to another See also: database, DBMS
This term usually refers to a file that consists of a series of fixed-length records that include some sort of record type code
A computer file where all the information is run together in a signal character string
In electronic records, a simple two-dimensional arrangement of data elements used in data bases to store all necessary descriptive information about the data in a location within the file itself