This Article 
 Bibliographic References 
 Add to: 
Heterogeneous Databases: Proliferations, Issues, and Solutions
March 1989 (vol. 1 no. 1)
pp. 45-62

The authors characterize the notion of heterogeneous databases as the inevitable consequence of replacing the traditional data processing practice with modern database management. They articulate the current problems and future issues connected with the great proliferation and overwhelming use of heterogeneous databases and their DBMS (database management systems). They survey available DBMS solutions to these problems and issues. The limitations and advantages of various DBMS solutions are examined. To this end, a taxonomy of DBMS solutions to the problems and issues of heterogeneous databases is presented. Some of the current research and proposals on the heterogeneous-database solutions are discussed in the context of the taxonomy.

[1] M. M. Astrahanet al., "System R: Relational approach to database management,"Trans. Database Syst., vol. 1, no. 1, pp. 97-137, 1976.
[2] E. F. Codd, "A relational model of data for large shared data banks,"Commun. ACM, pp. 377-387, June 1970.
[3] D. C. Tsichritzis and F. H. Lochovsky, "Hierarchical data base management: A survey,"ACM Comput. Surveys, vol. 8, Mar. 1976.
[4] D. Djorner and H. Louengreen, "Formalization of database systems-And a formal definition of IMS," inProc. 8th Int. Conf. Very Large Data Bases, Sept. 1982.
[5] T.W. Olle,The CODASYL Approach to Database Management, John Wiley&Sons, New York, N.Y., 1978.
[6] Cullinet Corporation,IDMS/R Systems Overview, Cullinet Corp., Westwood, MA, 1986.
[7] Datamation, "The new era of DBMS intergration," Aug. 15, 1988.
[8] E. H. Shortliffe,Computer-Based Medical Consultation: MYCIN. New York: Elsevier, 1976.
[9] M. L. Brodie, "Knowledge base management systems: Discussions from the working group," inProc. 1st Int. Workshop on Expert Database Syst., Oct. 1984.
[10] D. Shipman, "The functional model and the data language daplex,"ACM Trans. Database Syst., vol. 6, no. 1, Mar. 1981.
[11] C. Zanioloet al., "Object oriented database systems and knowledge systems," inProc. 1st Int. Workshop on Expert Database Syst., Oct. 1984.
[12] O. P. Buneman and R. E. Frankel, "FQL-A functional query language," inProc. 1979 ACM SIGMOD Int. Conf. Management of Data, Boston, MA, May 1979.
[13] R. King, "A database management system based on an object-oriented model," inProc. 1st Int. Workshop on Expert Database Syst., Oct. 1984.
[14] O. P. Buneman and R. Nikhil, "The functional data model and its uses for interaction with databases," inOn Conceptual Modelling. New York: Springer-Verlag, 1984.
[15] IBM Corporation, IBM database 2 SQL usage guide," IBM Document GC 24-1583, 1983.
[16] D. Kapp and J. F. Leben,IMS Programming Techniques, 2nd ed. New York: Van Nostrand, 1986.
[17] CODASYL, ACM Conf. Data Syst. Languages, New York, CODASYL Data Base Task Group Rep., 1971.
[18] T. Wu and D. K. Hsiao, "Implementation of an object oriented data language: GLAD," inProc. IFIP WG2.6 Visual Database Conf., Tokyo, Japan, Apr. 1989.
[19] M. Stonebraker,et al., "The design and implementation of INGRES,"ACM Trans. Database Syst., vol. 1, no. 3, Sept. 1976.
[20] R. H. Katz and E. Wong, "Decompiling CODASYL DML into relational queries,"ACM Trans. Database Syst., vol. 7, no. 1, Mar. 1982.
[21] G. D. Demo, "An elementary system for decompiling CODASYL operations with ambiguous interpretation," Dipartimento di Informatica, Univ. di Torino, Torino, Italy, Tech. Rep., 1985.
[22] G. B. Demo and S. Kundu, "Analysis of the context dependency of CODASYL find-statements with application to database program conversion," inProc. 1985 ACM SIGMOD Int. Conf. Management of Data, 1985.
[23] J. A. Larson, "Bridging the gap between network and relational database management systems,"Computer, vol. 16, Sept. 1983.
[24] BYTE (A hierarchical to relational software package),User's Guide, Washington, DC.
[25] R. L. Rosenberg and T. Landers, "An overview of MULTIBASE," inDistributed Data Bases, H. J. Schneider, Ed. Amsterdam, The Netherlands: North-Holland, 1982.
[26] M. Templetonet al., "Mermaid-Experiences with network operation," inProc. 1986 2nd Int. Conf. Data Engineering, Los Angeles, CA, Feb. 1986.
[27] S.R. Kimbleton, "Applications and Protocols,"Distributed Systems -- Architecture and Implementation, Springer-Verlag, 1981, pp. 308-370.
[28] S. A. Demurjian and D. K. Hsiao, "New directions in database-systems research and development," inProc. Int. Symp. New Directions in Comput., Trondheim, Norway, Aug. 1985.
[29] D. K. Hsiao and F. Harary, "A formal system for information retrieval from files,"Commun. ACM, vol. 13, no. 2, Feb. 1970; Corrigenda, vol. 13, no. 4, Apr. 1970.
[30] J. Banerjee and D. K. Hsiao, "DBC software requirements for supporting relational databases," Ohio State Univ., Tech. Rep. OSU-CISRC-TR-77-7, Nov. 1977.
[31] S. A. Demurjian and D. K. Hsiao, "Towards a better understanding of data models through the multilingual database system,"IEEE Trans. Software Eng., vol. 14, July 1988.
[32] S. A. Demurjian and D. K. Hsiao, "The multi-lingual database system," inProc. Third Int. Conf. Data Engineering, Los Angeles, CA, Feb. 1987.
[33] A. F. Cardenas, "Heterogeneous distributed database management: The HD-DBMS,"Proc. IEEE, vol. 75, May 1987.
[34] Britton Lee, Inc.,Intelligent Database Machine Product Description, 1983.
[35] S. Y. W. Suet al., "The architectural features and implementation techniques of the multicell CASSM,"IEEE Trans. Comput., vol. C- 28, June 1979.
[36] R. E. Canadayet al., "A back-end computer for data base management,"Commun. ACM, vol. 17, no. 10, Oct. 1974.
[37] Teradata Corp.,User's Guide, Los Angeles, CA.

Index Terms:
heterogeneous databases; DBMS; database management systems; database management systems
D.K. Hsiao, M.N. Kamel, "Heterogeneous Databases: Proliferations, Issues, and Solutions," IEEE Transactions on Knowledge and Data Engineering, vol. 1, no. 1, pp. 45-62, March 1989, doi:10.1109/69.43403
Usage of this product signifies your acceptance of the Terms of Use.