Database Concepts for the Systems Analyst
Files and Tables
- Some of the types of files and tables include: (continued)
- Archival files and tables contain master and transaction file records that have been deleted from on-line storage.
- Records are rarely deleted; they are merely moved from on-line storage to off-line storage.
- Archival requirements are dictated by government regulation and the need for subsequent audit or analysis.
- Table look-up files contain relatively static data that can be shared by applications to maintain consistency and improve performance.