Independence and mappings in model-based decision support systems

Richard G. Ramirez, Chee Ching, Robert St Louis

Research output: Contribution to journalArticlepeer-review

9 Scopus citations


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
Issue number3
StatePublished - Oct 1993


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

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 'Independence and mappings in model-based decision support systems'. Together they form a unique fingerprint.

Cite this