The design and implementation 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. In spite of major differences among the decision processes at the organizational, group, and individual levels, the requirements for securing data from the corporate database in an ODSS still remains a significant issue. In addition, the computer and communication technologies that integrate the subsystems of knowledge, data, and models assume increased relevance in the ODSS. Indeed, the richness of problems of making the most of such technologies becomes even more important in the ODSS environment. In the present work, the issues of integrating models and databases through the use of a data extraction scheme are examined. In particular, certain aspects of the query generation algorithms that allow the user or model to view the database as a single relation are described. The generated query is then translated into TQUEL, resulting in a temporal query reflecting the historical nature of the corporate database.