Derived data for decision support systems

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

Research output: Contribution to journalArticle

2 Citations (Scopus)

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

Decision support systems
Databases
Computer Communication Networks
Decision Making
Costs and Cost Analysis
Transparency
Decision making
Data Base
Costs
Data base

Keywords

  • Derived data
  • Relational databases
  • Versions
  • View updates
  • Views
  • What-if analysis

ASJC Scopus subject areas

  • Management Information Systems
  • Information Systems
  • Information Systems and Management

Cite this

Derived data for decision support systems. / Ramirez, Richard G.; Kulkarni, Uday; Moser, Kathleen A.

In: Decision Support Systems, Vol. 17, No. 2, 21.05.1996, p. 119-140.

Research output: Contribution to journalArticle

Ramirez, Richard G. ; Kulkarni, Uday ; Moser, Kathleen A. / Derived data for decision support systems. In: Decision Support Systems. 1996 ; Vol. 17, No. 2. pp. 119-140.
@article{3fb95be214b646fc82650fcdebdd4613,
title = "Derived data for decision support systems",
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.",
keywords = "Derived data, Relational databases, Versions, View updates, Views, What-if analysis",
author = "Ramirez, {Richard G.} and Uday Kulkarni and Moser, {Kathleen A.}",
year = "1996",
month = "5",
day = "21",
doi = "10.1016/0167-9236(95)00008-9",
language = "English (US)",
volume = "17",
pages = "119--140",
journal = "Decision Support Systems",
issn = "0167-9236",
publisher = "Elsevier",
number = "2",

}

TY - JOUR

T1 - Derived data for decision support systems

AU - Ramirez, Richard G.

AU - Kulkarni, Uday

AU - Moser, Kathleen A.

PY - 1996/5/21

Y1 - 1996/5/21

N2 - 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.

AB - 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.

KW - Derived data

KW - Relational databases

KW - Versions

KW - View updates

KW - Views

KW - What-if analysis

UR - http://www.scopus.com/inward/record.url?scp=0030149322&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0030149322&partnerID=8YFLogxK

U2 - 10.1016/0167-9236(95)00008-9

DO - 10.1016/0167-9236(95)00008-9

M3 - Article

VL - 17

SP - 119

EP - 140

JO - Decision Support Systems

JF - Decision Support Systems

SN - 0167-9236

IS - 2

ER -