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 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)
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
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