Derived data for decision support systems

Richard G. Ramirez, Uday Kulkarni, Kathleen A. Moser

Research output: Contribution to journalArticle

2 Scopus citations

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 languageEnglish (US)
Pages (from-to)119-140
Number of pages22
JournalDecision Support Systems
Volume17
Issue number2
DOIs
StatePublished - May 21 1996

    Fingerprint

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

Cite this