skip to main content
10.1145/1500676.1500733acmotherconferencesArticle/Chapter ViewAbstractPublication PagesafipsConference Proceedingsconference-collections
research-article
Free access

Database-oriented decision support systems

Published: 16 May 1983 Publication History

Abstract

Decision support systems represent a new challenge for computer technology experts, management science specialists, and organizational theorists. This paper examines the related topics on the database design for decision support systems. The major emphasis is on the global conceptual model and the unified approach for database design. The entity-relationship model is used for illustrating the unified approach, and the various translation processes are also discussed. A practical example is given. Throughout the paper, the interfaces among the user, the model, and the database are stressed.

References

[1]
Adiba, M., C. Delobel, and M. Leonard. "A Unified Approach for Modeling Data in Logical Data Base Design." In G. M. Nijssen (ed.), Modeling in Data Base Management Systems. Amsterdam: North-Holland, 1976.
[2]
Adiba, M., and C. Delobel. "The Problem of the Cooperation Between Different D.B.M.S." In G. M. Nijssen (ed.). Architecture and Models in Data Base Management Systems. Amsterdam: North-Holland, 1977.
[3]
Alter, Steven L. "Decision Support Systems: Current Practice and Continuing Changes." Addison-Wesley Series on Decision Support. Reading, Mass.: Addison-Wesley, 1980.
[4]
"ANSI-X3-SPARC/DBMS, Study Group Report." Washington, D.C.: American National Standards Institute, 1975.
[5]
Beeri, Catriel. "On the Membership Problem for Functional and Multivalued Dependencies in Relational Databases." ACM Transactions on Database Systems, 5, (1980).
[6]
Bernstein, Philip A. "Synthesizing Third Normal Form Relations from Functional Dependencies." ACM Transactions on Database Systems, 1 (1976).
[7]
Bonczek, Robert H., et al. "Aiding Decision Makers with A Generalized Data Base Management System: An Application to Inventory Management." Decision Sciences, 9 (1978).
[8]
Bonczek, Robert H., Clyde W. Holsapple, and Andrew B. Whinston. "The Evolving Roles of Models in Decision Support Systems." Decision Sciences, 11, No. 2 (1980).
[9]
Chamberlin, D. D., et al. "Support for Repetitive Transactions and Ad Hoc Queries in System R." ACM Transactions on Database Systems, 6 (1981).
[10]
Chen, Peter Pin-shan. "The Entity-Relationship Model---Toward a Unified View of Data." ACM Transactions on Database Systems, 1 (1976).
[11]
Chen, Peter Pin-shan. "The Entity-Relationship Approach to Logical Data Base Design." Q.E.D. Monograph Series, No. 6, 1977, Q.E.D. Information Sciences, Inc., 141 Linden St., Wellesley, MA 02181.
[12]
"CODASYL Data Base Task Group Report, 1971." CODASYL, Association for Computing Machinery, New York, April 1971.
[13]
CODASYL Data Description Language Committee, Proposed Revision of the 1971 DBTG Report, February 1973.
[14]
CODASYL Data Base Language Task Group, Proposed Revisions of the 1971 DBTG Report, June 1973.
[15]
Codd, E. F. "A Relational Model of Data For Large Shared Data Banks." Communications of the Association for Computing Machinery, 13 (1970).
[16]
Courtney, James F., et al. "SLIM: A Management Simulation System for Teaching MIS and DSS," Interface, The Computer Education Quarterly, Vol. 2/Issue 2 (1980).
[17]
Date, C. J. "An Introduction to Database Systems." 3rd ed. Reading, Mass.: Addison-Wesley, 1981.
[18]
De, Prabuddha, and Arun Sen. "Logical Data Base Design in Decision Support Systems." Journal of Systems Management (1981).
[19]
Deen, S. M. "A Canonical Schema for a Generalized Data Model with Local Interfaces." The Computer Journal, 23, No. 3 (1980).
[20]
"Education Data Base System," User's Guide. Department of Computer Services, the University of Calgary, Alberta, Canada, September 1977.
[21]
Fagin, Ronald. "Multivalued Dependencies and a New Normal Form for Relational Databases." ACM Transactions on Database Systems, 2 (1977).
[22]
Gardarin, G., et al. "An Approach Towards a Virtual Data Base Protocol for Computer Networks." Proceedings, AICA, 1977.
[23]
Haseman, W. D., et al. "Automatic Application Program Interface to A Data Base." The Computer Journal, May 1977.
[24]
Haseman, William D. "GPLAN: An Operational DSS." School of Urban and Public Affairs, Carnegie-Mellon University, Pittsburgh, Pa., 1977.
[25]
Kalinichenko, L. A. "Relational-Network Data Structure Mapping." In G. M. Nijssen (ed.), Modeling in Data Base Management Systems. Amsterdam: North-Holland, 1976.
[26]
Keen, Peter G. W. and Michael S. Scott Morton. "Decision Support Systems: An Organizational Perspective." Addison-Wesley Series on Decision Support. Reading, Mass.: Addison-Wesley, 1978.
[27]
Keen, Peter G. W. "Decision Support Systems: Translating Analytic Techniques into Useful Tools." Sloan Management Review, 21 (Spring 1980).
[28]
Keen, Peter G. W., et al. "Building a Decision Support System: The Mythical Man-Month Revisited." In J. F. Bennett (ed.), Building Decision Support Systems. Addison-Wesley Series on Decision Support. Reading, Mass.: Addison-Wesley, 1980.
[29]
Kerschberg, L., A. Klug, and D. Tsichritzis. "A Taxonomy of Data Models." In P. C. Lockemann and F. J. Neuhold (eds.), Systems for Large Data Bases. Amsterdam: North-Holland Publishing Company, 1976.
[30]
Lee, D. T., et al. "Quintary Tree: A File Structure for Multidimensional Database Systems." ACM Transactions on Database Systems, 5 (1980).
[31]
Lien, Edmund Y., et al. "Design of a Distributed Entity-Relationship Database system." Proceedings of COMPSAC, 1978.
[32]
Line, Y. Edmund. "Hierarchical Schema for Relational Databases." ACM Transactions on Database Systems, Vol. 6, No. 1, March 1981.
[33]
Ling, Tok-Wang, et al. "An Improved Third Normal Form for Relational Databases." ACM Transactions on Database Systems, 6 (1981).
[34]
Martin, James. Computer Data-Base Organization (2nd ed). Englewood Cliffs, N.J.: Prentice-Hall, 1977.
[35]
McCarthy, W. E. "An Entity-Relationship View of Accounting Models." The Accounting Review, 54, No. 4 (1979).
[36]
Mercz, Iaszlo I. "Issues in Building a Relational Interface on A CODASYL DBMS." In Braechi/Nijssen (eds.), Data Base Architecture. Amsterdam: North-Holland, 1979.
[37]
Michaels, Ann S. "A Comparison of the Relational and CODASYL Approaches to Data-Base Management." ACM Computing Surveys 8 (1976).
[38]
Morton, Scott M. S. "Management Decision Systems: Computer Based Support for Decision Making." Division of Research, Harvard University, 1971.
[39]
Nahouraii, E., L. O. Brooks, and A. F. Cardenas. "An Approach to Data Communication Between Different Generalized Data Base Management Systems." In P. C. Lockemann and E. J. Neuhold (eds.), Systems for Large Data Bases. Amsterdam: North-Holland, 1976.
[40]
Olle, T. William. The CODASYL Approach to Data Base Management. New York: John Wiley & Sons, 1978.
[41]
Sprague, R. H., Jr., and H. J. Watson. "MIS Concepts---Part II." Journal of Systems Management, 26, No. 2 (1975).
[42]
Sprague, Ralph H., Jr., et al. "A Decision Support System for Banks." Omega---The International Journal of Management Science, 4, No. 6 (1976).
[43]
Sprague, Ralph H. "A Framework for the Development of Decision Support Systems." MIS Quarterly, December 1980.
[44]
Stohr, Edward A., et al. "A Database for Operations Research Models." International Journal of Policy Analysis and Information Systems, 4, No. 1 (1980).
[45]
Su, Stanley Y. W. "A Semantic Association Model for Conceptual Database Design." In Peter P. Chen (ed.), Entity-Relationship Approach to Systems Analysis and Design. Amsterdam: North-Holland, 1980.
[46]
Su, Stanley Y. W., Herman Lam, and Der Her Lo. "Transformation of Data Traversals and Operations in Application Programs to Account for Semantic Changes of Databases." ACM Transactions on Database Systems, 6 (1981).
[47]
Ullman, Jeffrey D. Principles of Database Systems. Computer Science Press, 1980.
[48]
Vetter, M. and R. N. Maddison. Database Design Methodology. Englewood Cliffs, N.J.: Prentice-Hall, 1981.
[49]
Wagner, G. R. "Decision Support Systems: The Real Substance." Interfaces, 11, No. 2 (1981).
[50]
Zaniolo, Carlo. "Multimodel External Schemas for CODASYL Data Base Management Systems." In Bracchi/Nijssen (eds.), Data Base Architecture. Amsterdam: North-Holland Publishing Company, 1979.
[51]
Zaniolo, Carlo. "On the Design of Relational Database Schemata." ACM Transactions on Database Systems, 6 (1981).

Cited By

View all
  • (1984)Decision support in a distributed environmentProceedings of the July 9-12, 1984, national computer conference and exposition10.1145/1499310.1499373(477-488)Online publication date: 9-Jul-1984

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences
AFIPS '83: Proceedings of the May 16-19, 1983, national computer conference
May 1983
808 pages
ISBN:0882830392
DOI:10.1145/1500676
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

  • AFIPS: American Federation of Information Processing Societies

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 16 May 1983

Permissions

Request permissions for this article.

Check for updates

Qualifiers

  • Research-article

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)77
  • Downloads (Last 6 weeks)14
Reflects downloads up to 07 Mar 2025

Other Metrics

Citations

Cited By

View all
  • (1984)Decision support in a distributed environmentProceedings of the July 9-12, 1984, national computer conference and exposition10.1145/1499310.1499373(477-488)Online publication date: 9-Jul-1984

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Login options

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media