Annals of Operations Research

, Volume 16, Issue 1, pp 241–254 | Cite as

Transforming algebraic datastructures into relational datastructures in DSS

  • Adrie J. M. Beulens
Section III Quantitative Models, Data Structuring And Information Processing
  • 31 Downloads

Abstract

Many builders of DSS have probably experienced that they have to be able to use internal databases as well as data from external databases. We call the internal databases master- and scenario databases. Master databases are used to store data as a common source for all decision scenarios. A scenario database is used to store all data that are pertinent to a specific decision scenario. All databases may have different (types of) datamodels. This leads to a language problem for the user who has to use them. For the model part of a DSS we encounter a similar problem. In a Linear Programming model description we find an algebraic description of the necessary in- and output variables. If we have to create an interface for this model to the databases mentioned before we have another translation problem. For applications in which LP-models are used we have solved the translation problems in two ways. In one DSS we have transformed the algebraic data description into a so-called algebraic data model. This type of datamodel has been implemented for all components of the DSS. In a second DSS, with only relational data bases in it, another approach has been adopted. In model formulations the algebraic datamodel with statements specifying the relationship between algebraic datastructures and relations of the relational database has been implemented. The system takes care of the translation from one datamodel into the other. In this paper we will deal with the language problem just specified and the solutions implemented sofar.

Keywords

Output Variable Programming Model Model Description Data Description Relational Database 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. [1]
    J. Abbink, A. Beulens et al., Discussion paper: The construction of the interface between ORACLE and MGG, ORES bv. June 1985.Google Scholar
  2. [2]
    J.L. Bennett, Analysis and design of the user interface for decision support systems, in:Building Decision Support Systems, ed. J.L. Bennett (Addison Wesley, Reading, Ma, 1983).Google Scholar
  3. [3]
    A. Beulens and J. van Nunen, On using quantitative methods in decision support systems: design and implementation issues, in:Operations Research Proceedings 1984 (Springer Verlag, Berlin/Heidelberg 1985).Google Scholar
  4. [4]
    A. Beulens and J. van Nunen, Decision support systems and expert systems, Working Paper, Rotterdam School of Management, 1986.Google Scholar
  5. [5]
    C.J. Date,An Introduction to Database Systems, Vol. I, Fourth Edition (Addison Wesley, 1986).Google Scholar
  6. [6]
    A.M. Geoffrion, A guide to computer-assisted methods for distribution systems planning, Sloan Management Review 16 (1971) 17–41.Google Scholar
  7. [7]
    A.M. Geoffrion and G.W. Graves, Multicommodity distribution system design by Benders decomposition, Management Science 20 (1974) 822–844.Google Scholar
  8. [8]
    IBM, MPSX/ECL reference manual.Google Scholar
  9. [9]
    H. Mintzberg, D. Raisinghari and A. Theoret, The structure of “unstructured” decision processes, Administrative Science Quarterly 21, No. 2 (1976) 246–275.Google Scholar
  10. [10]
    J. van Nunen and J. Benders, A decision support system for location and allocation problems within a brewery,Operations Research Proceedings 1981 (Springer Verlag, Berlin/Heidelberg, 1982).Google Scholar
  11. [11]
    ORACLE corp., ORACLE user guides.Google Scholar
  12. [12]
    SCICON, MGG/VM and SCICONIC/VM user guide.Google Scholar
  13. [13]
    H. Simon,The New Science of Management Decision (Harper and Row, New York, New York, 1960).Google Scholar
  14. [14]
    R.H. Sprague, Jr., A framework for the development of decision support systems, MIS (Quarterly/December 1980).Google Scholar
  15. [15]
    R.H. Sprague Jr. and E.D. Carlson,Building Effective Decision Support Systems, (Prentice Hall, Inc., Englewood Cliffs, N.J. 07632, 1982).Google Scholar

Copyright information

© J.C. Baltzer AG, Scientific Publishing Company 1988

Authors and Affiliations

  • Adrie J. M. Beulens
    • 1
  1. 1.Rotterdam School of ManagementErasmus University RotterdamThe Netherlands

Personalised recommendations