Abstract
In most of today’s companies we find heterogeneous database systems containing redundant and inconsistent data. This threatens the ability to make coordinated, organization-wide responses to business problems. Although benefits of data integration need not dominate the costs, we argue that some kind of common understanding of data structures is an absolute must. Thus, data integration is necessary at least to some degree. In literature, only technical aspects of schema integration are treated. Also, the complexity issue (large schemata are hard to understand) is usually not treated explicitly. We present a business process oriented strategy for data integration. This method allows the determination of the order and the degree of integration. Complexity is reduced by schema clustering during the pre-integration phase.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Alchian, A. A.; Demsetz, H.: Production, Information Costs and Economic Organization. American Economic Review Vol. 62, 5, Dec. 1972, pp. 777–795.
Batini, G; Lenzerini, M; Navathe, S. B.: A Comparative Analysis of Methodologies for Database Schema Integration. ACM Computing Surveys, Vol. 18, 4, 1986, pp. 323–364.
Benbasat, L; Nault, B.: An Evaluation of Empirical Research in Managerial Support Systems. Decision Support Systems Vol. 6, 2, July 1990, pp. 439–449.
Chen, P.: The Entity-Relationship Model — Toward a Unified View of Data. TODS Vol. 1, 1, March 1976, pp. 9–36.
Cohen, D.; Larson, G.; Berke, L.: Role of Interoperability in Business Application Development. Proc. of the 1993 ACM SIGMOD International Conference on Management of Data. SIGMOD Record Vol. 22, 2, June 1993, pp. 487–490.
Coulson, C.J.: People Just Arent Using Data Dictionaries. Computerworld, August 16, 1982, pp. 15-22.
Elmasri, R.; Navathe, S.: Fundamentals of Database Systems. 2nd Ed., Redwood City, CA (1994).
Galbraith, J.: Designing Complex Organizations. Reading, MA. (1973).
Goodhue, D.L.; Kirsch, L.J.; Quillard, J.A.; Wybo, M.D.: Strategic Data Planning: Lessons From the Field. MIS Quaterly Vol. 16, 1, March 1992a, pp. 11–34.
Goodhue, D.L.; Wybo, M.D.; Kirsch, L.J.: The Impact of Data Integration on the Costs and Benefits of Information Systems. MIS Quaterly Vol. 16, 3, September 1992b, pp. 293–311.
Gurbaxani, V.; Whang, S.: The Impact of Information Systems on Organizations and Markets. Communications of the ACM Vol. 34, 1, Jan. 1991, pp. 59–73.
Huber, G.: A Theory of the Effects of Advanced Information Technology on Organizational Design, Intelligence, and Decision Making. Academy of Management Review Vol. 15, 1, 1990, pp. 47–71.
Johannesson, P.: Using Conceptual Graph Theory to Support Schema Integration. In: Elmasri, R., Kouramajian, V. (Eds.): Proc. of the 12th Interantional Conference on the Entity-Relationship Approach, Dallas, TX. 1993, pp. 277-288.
King, J.L.: Centralized versus Decentralized Computing: Organizational Considerations and Management Options. ACM Computing Surveys Vol. 15, 4, Dec. 1983, pp. 319–349.
Kühlmann, K.; Stichel, E.: Datenmodellierung als strategisches Instrument für Anbieter von Versicherungen und ergänzenden Finanzdienstleistungen; Zeitschrift für Versicherungswesen, 24, 1990, pp. 618–620.
Lederer, A.L.; Sethi, V.: Critical Dimensions of Strategic Information Systems Planning. Decision Sciences Vol. 22, 1, Winter 1991, pp. 104–119.
Lint, E.P.; Prabhakar, S.: Entity Identification in Database Integration. In: Proc. 9th Conference on Data Engineering, Vienna 1993, pp. 294-301.
Martin, J.: Information Engineering. Book I: Introduction. Englewood Cliffs, NJ. (1989).
Martin, J.: Information Engineering. Book II: Planning and Analysis. Englewood Cliffs, NJ. (1990).
Metais, E.; Meunier, J.-K.; Levreau, G.: Database Schema Design: A Perspective from natural Language Techniques to Validation and View Integration. In: Elmasri, R., Kouramajian, V. (Eds.): Proc. of the 12th Interantional Conference on the Entity-Relationship Approach, Dallas, TX. 1993, pp. 187-198.
O’Brien, J.A.: Management Information Systems: A Managerial End 1Jser Perspective. Homewood, Ill. (1990).
Ortmann, A.; Ortmann, J.; Stickel, E.: Implementierung von ETC. Fakultät für Wirtschaftswissenschaften der Europa-Universität Frankfurt (Oder), Arbeitsbericht 6, 1994.
Özsu, M.T.; Valduriez, P.: Principles of Distributed Database Systems. Englewood Cliffs, NJ (1991)
Rauh, O.; Stickel, E.: Entity Tree Clustering — A Method for Simplifying ER-Designs. In: Pernul, G., Tjoa, A. M. (Eds): Entity-Relationship Approach — ER’ 92. Proc. 11th International Conference on the Entity Relationship Approach, Karlsruhe 1992, LNCS 645, pp. 62-78, Berlin (1992).
Rauh, O., Stickel, E.: Searching for Compositions in ER Schemata. In: Elmasri, R., Kouramajian, V. (Eds.): Proceedings of the 12th International Conference on the Entity-Relationship Approach, Arlington, TX 1993, pp. 75-86.
Ross, S.: The Economic Theory of Agency: The Principal’s Problem. American Economic Review Vol. 63, 2, May 1973, pp. 134–139.
Seitz, J.; Stickel, E.: Data Structures for Product Design in Financial Institutions. In: SWIFT (Eds.): Proceedings of the BANKAI Workshop on Intelligent Information Access; Brüssel 1991, pp. 47-59, Amsterdam (1992).
Sharda, R.; Barr, S.H.; McDonnell, J.C: Decision Support Systems Effectiveness. A Review and Empirical Test. Management Science Vol. 43, 2, February 1988, pp. 139–159.
Sheth, A.; Larson, J.: Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases. ACM Computing Surveys Vol. 22, 3, Sept. 1990, pp. 183–236.
Sheth, A.: Semantic Issues in Multidatabase Systems. SIGMOD Record, Dec. 1991, pp. 5-9.
Sprague, R.H.; McNurlin, B.: Information Systems Management in Practice. Third Edition. Englewood Cliffs, NJ. (1993).
Stickelf E.: Information und Risiko. Fakultät für Wirtschaftswissenschaften der Europa-Universität Frankfurt (Oder), Arbeitsbericht 5, 1994.
Teorey, T.J.; Wei, G.; Bolton, D. L.; Koenig, J.A.: ER Model Clustering as an Aid for User Communication in Database Design and Documentation. Communications of the ACM Vol. 38, 8, 1989 pp. 975–987.
Todd, P.; Benbasat, I.: The Use of Information in Decision Making: An Experimental Investigation of the Impact of Computer Based Decision Aids. MIS Quaterly Vol. 16, 1, March 1992, pp. 11–34.
Tushman, M.; Nadler, D.: Information Processing as an Integrating Concept in Organizational Design. Academy of Management Review Vol. 3, 3, July 1978, pp. 613–624.
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1996 Springer-Verlag Berlin • Heidelberg
About this chapter
Cite this chapter
Stickel, E., Hunstock, J., Ortmann, A., Ortmann, J. (1996). A Business Process Oriented Approach to Data Integration. In: König, W., Kurbel, K., Mertens, P., Pressmar, D. (eds) Distributed Information Systems in Business. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-80216-4_3
Download citation
DOI: https://doi.org/10.1007/978-3-642-80216-4_3
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-80218-8
Online ISBN: 978-3-642-80216-4
eBook Packages: Springer Book Archive