Database Concepts for the Systems Analyst
Files and Tables
- Some of the types of files and tables include: (continued)
- Transaction files or tables contain records that describe business events.
- The data describing these events normally has a limited useful lifetime.
- In information systems, transaction records are frequently retained on-line for some period of time.
- Subsequent to their useful lifetime, they are archived off-line.
- Document files and tables contain stored copies of historical data for easy retrieval and review without the overhead of re-generating the document.