Abstract
Multiple scenarios are critical to what-if analysis. Alternate versions of a database are required. Each version is manipulated and updated as if it were the real database; however, only differences between the version and the real database are stored. Extensions to relational databases to support alternate versions include hypothetical relations and derived relations with exceptions. This paper introduces independently-updated views (IUVs) for creating multiple scenarios and analyzes the overhead for supporting different types of views and queries. The overhead is minimum for creating what-if scenarios based on aggregate views and on views which are small subsets of the database. In case of views which require retrieval of entire or large portions of base tables, the overhead can be high.
Original language | English (US) |
---|---|
Article number | 183973 |
Pages (from-to) | 136-145 |
Number of pages | 10 |
Journal | Proceedings of the Annual Hawaii International Conference on System Sciences |
Volume | 2 |
DOIs | |
State | Published - 1991 |
Event | 24th Annual Hawaii International Conference on System Sciences, HICSS 1991 - Kauai, United States Duration: Jan 8 1991 → Jan 11 1991 |
ASJC Scopus subject areas
- General Engineering