Design of organizational decision support systems: the use of a data extraction scheme to facilitate model-database communication

The concept of organizational decision support and the criteria for designing such support systems (ODSS) have recently received a great deal of attention. While the organizational decision processes differ considerably from individual and group decision making, the requirements for securing data from the corporate database in an ODSS are not much different. The computer and communication technologies that integrate the subsystems of knowledge, data, and models are still essential for ODSS. The authors examine the issues of integrating models and databases through the use of a data extraction scheme. In particular, they describe certain aspects of the query generation algorithms that allow the user or model to view the database as a single relation. The generated query is then translated into TQUEL, a temporal query language reflecting the historical nature of corporate databases.<<ETX>>

[1]  Richard T. Snodgrass,et al.  A taxonomy of time databases , 1985, SIGMOD Conference.

[2]  John Leslie King,et al.  Conceptual foundations for the development of organizational decision support systems , 1990, Twenty-Third Annual Hawaii International Conference on System Sciences.

[3]  Robert W. Blanning,et al.  SoftCord: an intelligent agent for coordination in software development projects , 1986 .

[4]  Andrew B. Whinston,et al.  FUTURE DIRECTIONS FOR DEVELOPING DECISION SUPPORT SYSTEMS , 1980 .

[5]  Ronald Fagin,et al.  Degrees of acyclicity for hypergraphs and relational database schemes , 1983, JACM.

[6]  Ronald Fagin,et al.  A simplied universal relation assumption and its properties , 1982, TODS.

[7]  Andrew B. Whinston,et al.  The Information Jungle: A Quasi-Novel Approach to Managing Corporate Knowledge , 1988 .

[8]  Richard T. Watson,et al.  A design for an infrastructure to support organizational decision-making , 1990, Twenty-Third Annual Hawaii International Conference on System Sciences.

[9]  Robert W. Blanning,et al.  A relational framework for join implementation in model management systems , 1985, Decis. Support Syst..

[10]  Jeffrey D. Ullman,et al.  The U. R. strikes back , 1982, PODS.

[11]  Richard L. Daft,et al.  Message Equivocality, Media Selection, and Manager Performance: Implications for Information Systems , 1987, MIS Q..

[12]  Melanie L. Lenard.  Representing Models as Data , 1986, J. Manag. Inf. Syst..

[13]  Giora Slutzki,et al.  A polynomial time algorithm for testing implications of a join dependency and embodied functional dependencies , 1988, SIGMOD '88.

[14]  Marc Gyssens,et al.  A Decomposition Methodology for Cyclic Databases , 1982, Advances in Data Base Theory.

[15]  Joyce J. Elam,et al.  Model Management Systems: an Approach to Decision Support in Complex Organizations , 1980, ICIS.

[16]  Stefano Ceri,et al.  Distributed Databases: Principles and Systems , 1984 .

[17]  Robert W. Blanning,et al.  Conversing with management information systems in a natural language , 1984, CACM.

[18]  Robert P. Minch,et al.  Logic Programming as a Paradigm for Financial Modeling , 1989, MIS Q..

[19]  Joyce J. Elam,et al.  USING ARTIFICIAL INTELLIGENCE TECHNIQUES TO ENHANCE THE CAPABILITIES OF MODEL MANAGEMENT SYSTEMS , 1987 .

[20]  Ralph H. Sprague,et al.  A decision support system for banks , 1976 .

[21]  David Maier,et al.  Maximal objects and the semantics of universal relation databases , 1983, TODS.

[22]  Jeffrey D. Ullman,et al.  Principles of Database Systems , 1980 .

[23]  Robert W. Blanning.  An entity-relationship approach to model management , 1986, Decis. Support Syst..

[24]  George P. Huber,et al.  Organizational Information Systems: Determinants of Their Performance and Behavior , 1982 .

[25]  David Maier,et al.  The Theory of Relational Databases , 1983 .

[26]  Leslie L. Miller,et al.  Testing arbitrary subhypergraphs for the lossless join property , 1990, Inf. Sci..

[27]  C. O'Reilly.  The use of information in organizational decision making: A model and some propositions. , 1983 .

[28]  Robert W. Blanning.  Model-based and data-based planning systems , 1981 .

[29]  Ting-Peng Liang,et al.  User interface design for decision support systems: A self-adaptive approach , 1987, Inf. Manag..

[30]  Gary Klein,et al.  Developing Model Strings for Model Managers , 1986, J. Manag. Inf. Syst..

[31]  Houston H. Carr,et al.  Organizing for Decision Support System Support: The End-User Services Alternative , 1987, J. Manag. Inf. Syst..

[32]  Daniel R. Dolk,et al.  Model management and structured modeling: the role of an information resource dictionary system , 1988, CACM.

[33]  David Y. Y. Yun,et al.  An Agent for Intelligent Model Management , 1990, J. Manag. Inf. Syst..

[34]  Benn R. Konsynski,et al.  Problem Management: Neglected Elements in Decision Support Systems , 1987, J. Manag. Inf. Syst..

[35]  D.A. Adams,et al.  GMMS: global model management system-a conceptual design framework for model management systems for distributed decision support systems , 1988, [1988] Proceedings of the Twenty-First Annual Hawaii International Conference on System Sciences. Volume III: Decision Support and Knowledge Based Systems Track.

[36]  Jay F. Nunamaker,et al.  PLEXSYS-84: An Integrated Development Environment for Informational Systems , 1984, J. Manag. Inf. Syst..

[37]  James F. Courtney,et al.  A Field Study of Organizational Factors Influencing DSS Success , 1985, MIS Q..

[38]  Leslie L. Miller,et al.  Query Translation Based on Hypergraph Models , 1988, Comput. J..

[39]  Hugh J. Watson,et al.  Organizational Support for Decision Support Systems , 1989, J. Manag. Inf. Syst..

[40]  Daniel R. Dolk,et al.  Knowledge Representation for Model Management Systems , 1984, IEEE Transactions on Software Engineering.

[41]  Ming-Syan Chen,et al.  Using join operations as reducers in distributed query processing , 1990, DPDS '90.

[42]  Ting-Peng Liang,et al.  META‐DESIGN CONSIDERATIONS IN DEVELOPING MODEL MANAGEMENT SYSTEMS* , 1988 .

[43]  George P. Huber,et al.  exploiting information technologies to design more effective organizations , 1986 .