Derived data for decision support systems

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

Research output: Contribution to journalArticlepeer-review

2 Scopus citations


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
Issue number2
StatePublished - May 21 1996


  • 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


Dive into the research topics of 'Derived data for decision support systems'. Together they form a unique fingerprint.

Cite this