Independence and mappings in model-based decision support systems

Richard G. Ramirez, Chee Ching, Robert St Louis

Research output: Contribution to journalArticle

8 Citations (Scopus)

Abstract

Independence of applications from logical and physical data structures is one of the cornerstones of modern database systems. Similar concepts may be applied to model management in a decision support system (DSS) to facilitate model portability, sharing, and multi-purpose application. In this paper we define the concepts of model/data and model/ solver independence, present an extended architecture for DSS, and show its implementation. The architecture supports separate solver, model, and data bases and uses mappings to integrate them. Computationally-equivalent solvers support portability, while non-computationally-equivalent solvers allow a model to be used without modification for different purposes (what if, goal seeking, optimization). The implementation integrates an SQL database system with a mathematical modeling language.

Original languageEnglish (US)
Pages (from-to)341-358
Number of pages18
JournalDecision Support Systems
Volume10
Issue number3
DOIs
StatePublished - 1993

Fingerprint

Decision Support Techniques
Decision support systems
Databases
Language
Data structures
Data base
Data Base
Portability

Keywords

  • Data independence
  • Decision support systems
  • Linear programming
  • Model management
  • Structured modeling

ASJC Scopus subject areas

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

Cite this

Independence and mappings in model-based decision support systems. / Ramirez, Richard G.; Ching, Chee; St Louis, Robert.

In: Decision Support Systems, Vol. 10, No. 3, 1993, p. 341-358.

Research output: Contribution to journalArticle

Ramirez, Richard G. ; Ching, Chee ; St Louis, Robert. / Independence and mappings in model-based decision support systems. In: Decision Support Systems. 1993 ; Vol. 10, No. 3. pp. 341-358.
@article{c75a3ed5a5654a5a8e922eede028105f,
title = "Independence and mappings in model-based decision support systems",
abstract = "Independence of applications from logical and physical data structures is one of the cornerstones of modern database systems. Similar concepts may be applied to model management in a decision support system (DSS) to facilitate model portability, sharing, and multi-purpose application. In this paper we define the concepts of model/data and model/ solver independence, present an extended architecture for DSS, and show its implementation. The architecture supports separate solver, model, and data bases and uses mappings to integrate them. Computationally-equivalent solvers support portability, while non-computationally-equivalent solvers allow a model to be used without modification for different purposes (what if, goal seeking, optimization). The implementation integrates an SQL database system with a mathematical modeling language.",
keywords = "Data independence, Decision support systems, Linear programming, Model management, Structured modeling",
author = "Ramirez, {Richard G.} and Chee Ching and {St Louis}, Robert",
year = "1993",
doi = "10.1016/0167-9236(93)90067-D",
language = "English (US)",
volume = "10",
pages = "341--358",
journal = "Decision Support Systems",
issn = "0167-9236",
publisher = "Elsevier",
number = "3",

}

TY - JOUR

T1 - Independence and mappings in model-based decision support systems

AU - Ramirez, Richard G.

AU - Ching, Chee

AU - St Louis, Robert

PY - 1993

Y1 - 1993

N2 - Independence of applications from logical and physical data structures is one of the cornerstones of modern database systems. Similar concepts may be applied to model management in a decision support system (DSS) to facilitate model portability, sharing, and multi-purpose application. In this paper we define the concepts of model/data and model/ solver independence, present an extended architecture for DSS, and show its implementation. The architecture supports separate solver, model, and data bases and uses mappings to integrate them. Computationally-equivalent solvers support portability, while non-computationally-equivalent solvers allow a model to be used without modification for different purposes (what if, goal seeking, optimization). The implementation integrates an SQL database system with a mathematical modeling language.

AB - Independence of applications from logical and physical data structures is one of the cornerstones of modern database systems. Similar concepts may be applied to model management in a decision support system (DSS) to facilitate model portability, sharing, and multi-purpose application. In this paper we define the concepts of model/data and model/ solver independence, present an extended architecture for DSS, and show its implementation. The architecture supports separate solver, model, and data bases and uses mappings to integrate them. Computationally-equivalent solvers support portability, while non-computationally-equivalent solvers allow a model to be used without modification for different purposes (what if, goal seeking, optimization). The implementation integrates an SQL database system with a mathematical modeling language.

KW - Data independence

KW - Decision support systems

KW - Linear programming

KW - Model management

KW - Structured modeling

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

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

U2 - 10.1016/0167-9236(93)90067-D

DO - 10.1016/0167-9236(93)90067-D

M3 - Article

AN - SCOPUS:0027681466

VL - 10

SP - 341

EP - 358

JO - Decision Support Systems

JF - Decision Support Systems

SN - 0167-9236

IS - 3

ER -