A case study in specifying data requirements for a decision support system database
An atomic database is a collection of detailed and archival data primarily used to support a decision support system (DSS). Typically, atomic data are generated externally from other sources. In order to build an atomic data base in which data represent the information the DSS users expect, detailed data requirements must be specified to the source system. The basic types of information a source system needs are a list of required data items, the frequency and terms of data needs, and the method of interface. A detailed list of required items recommended for inclusion in any specifications of external data requirements is presented in this paper. Because of the volume of information involved in such specifications, a matrix presentation is believed to be the best organizational format to describe the requirements concisely and precisely. The specifications of external data requirements written for the Worldwide Household Goods Information System for Transportation Modernization (WHIST-MOD) project for the Personal Property Directorate (MTPP) of the Military Traffic Management Command (MTMC) are presented as a case study in this paper. It has been shown that the specifications in this case study effectively serve the objective of such a document. It is recommended that the concept presented in this paper be used as a guideline in specifying data requirements for an atomic database. 5 refs., 2 figs.
- Research Organization:
- Oak Ridge National Lab. (ORNL), Oak Ridge, TN (United States)
- Sponsoring Organization:
- USDOD
- DOE Contract Number:
- AC05-84OR21400
- OSTI ID:
- 6540714
- Report Number(s):
- ORNL/TM-11583; ON: DE91001006
- Country of Publication:
- United States
- Language:
- English
Similar Records
User interface in ORACLE for the Worldwide Household Goods Information System for Transportation Modernization (WHIST-MOD)
The program specifications for the user interface using SAS reg sign software for the worldwide household goods information system for transportation modernization (WHIST-MOD). [Logistics]