Abstract
In decision-making situations requiring "what-if" analysis, in statistical databases, and in distributed databases, it is desirable to explicitly store derived data without losing consistency with the original data. We introduce independently-updated views (IUVs) for storage and use of derived data for decision-support systems. IUVs support multiple versions, provide derivation transparency, maintain data consistency, and afford control over time of derivation. The notion of data consistency is extended to allow for multiple versions so that versions are consistent with the actively updated database on which they are defined. Implementation issues are discussed and the cost of retrieving IUVs representing different types of derived data is estimated.
Original language | English (US) |
---|---|
Pages (from-to) | 119-140 |
Number of pages | 22 |
Journal | Decision Support Systems |
Volume | 17 |
Issue number | 2 |
DOIs | |
State | Published - May 21 1996 |
Keywords
- Derived data
- Relational databases
- Versions
- View updates
- Views
- What-if analysis
ASJC Scopus subject areas
- Management Information Systems
- Information Systems
- Developmental and Educational Psychology
- Arts and Humanities (miscellaneous)
- Information Systems and Management