The cost of retrievals in what-if databases

R. G. Ramirez, U. R. Kulkarni, K. A. Moser

Research output: Contribution to journalConference articlepeer-review


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 languageEnglish (US)
Article number183973
Pages (from-to)136-145
Number of pages10
JournalProceedings of the Annual Hawaii International Conference on System Sciences
StatePublished - 1991
Event24th Annual Hawaii International Conference on System Sciences, HICSS 1991 - Kauai, United States
Duration: Jan 8 1991Jan 11 1991

ASJC Scopus subject areas

  • Engineering(all)


Dive into the research topics of 'The cost of retrievals in what-if databases'. Together they form a unique fingerprint.

Cite this