Performance Analysis of “What-If” Databases Using Independently Updated Views

:Multiple scenarios are critical to “what-if” analysis. Scenarios are built using alternate versions of a database; each version shows, in detail, the result of a decision or a combination of decisions. Relational database management systems, despite their widespread use, lack the explicit capabilities for what-if analysis. We present a concept called independently updated views (IUVs) for creating multiple scenarios. An IUV corresponds to a version of the database. 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. This paper describes an experiment for measuring the overhead of using IUV s for supporting what-if analysis for a range of typical views and queries. Results indicate that the overhead is minimal for creating what-if scenarios based on views with aggregate functions (SUM, AVG) and on views that are small subsets of the database. These are the classes of views that are more often used in decision making. For views that require retrieval of entire or large portions of the database, the overhead can be high and special data structures may be required.

• 저널Journal of Management Information Systems · 9(1) · 185–203
• 토픽Advanced Database Systems and Queries · Computer Networks and Communications
• DOI10.1080/07421222.1992.11517953
• 저자R.G. Ramirez, Uday Kulkarni, K.A. Moser