This Article 
 Bibliographic References 
 Add to: 
A Theory of Translation From Relational Queries to Hierarchical Queries
April 1995 (vol. 7 no. 2)
pp. 228-245

Abstract—In a heterogeneous database system, a query for one type of database system (i.e., a source query) may have to be translated to an equivalent query (or queries) for execution in a different type of database system (i.e., a target query). Usually, for a given source query, there is more than one possible target query translation. Some of them can be executed more efficiently than others by the receiving database system. Developing a translation procedure for each type of database system is time-consuming and expensive. In this paper, we abstract a generic hierarchical database system (GHDBS) which has properties common to database systems whose schema contains hierarchical structures (e.g., System 2000, IMS, and some object-oriented database systems). We develop principles of query translation with GHDBS as the receiving database system. Translation into any specific system can be accomplished by a translation into the general system with refinements to reflect the characteristics of the specific system. We develop rules that guarantee correctness of the target queries, where correctness means that the target query is equivalent to the source query. We also provide rules that can guarantee a minimum number of target queries in cases when one source query needs to be translated to multiple target queries. Since the minimum number of target queries implies the minimum number of times the underlying system will be invoked, efficiency is taken into consideration.

[1] J. Banerjee, W. Kim, and K.C. Kim, "Queries in Object-Oriented Databases," Proc. IEEE Int'l Conf. Data Eng., pp. 31-38, 1988.
[2] Y. Breitbart, and L. Tieman,“ADDS: heterogeneous distributed database system,” Distributed Data Sharing Systems, F. Schreiber and W. Litwin, Eds. NorthHolland Pub. Co., 1985.
[3] Y. Breitbart and A. Silberschatz, “Multidatabase Update Issues,” Proc. ACM SIGMOD Conf. Management of Data, pp. 135-142, June 1988.
[4] Y. Breitbart, A. Silberschatz, and G. Thompson, “Reliable Transaction Management in a Multidatabase System,” Proc. ACM SIGMOD Conf. Management of Data,” pp. 215-224, May 1990.
[5] “BYTE (A hierarchical to relational software package),” User’s Guide,Washington, DC.
[6] C-W. Chung,“DATAPLEX: An access to heterogeneous distributed databases,” Communications of ACM, vol. 33, no. 1, pp. 70-80, Jan. 1990.
[7] C.J. Date, An Introduction to Database Systems, Volume 1.Reading, Mass.: Addison-Wesley, 1990.
[8] O. Dexu et al., "The Story of O2," IEEE Trans. Knowledge and Data Eng., pp. 91-108, Mar. 1990.
[9] W. Du and A.K. Elmagarmid, "Quasi Serializability: A Correctness Criterion for Global Concurrency Control in Interbase," Proc. Very Large Data Bases, pp. 347-355, 1989.
[10] P. Dwyer and J. Larson,“Some experiences with a distributed database testbed system,” Proc. IEEE, pp. 633-647, May 1987.
[11] P. Gray,Logic, Algebra, and Databases, Ellis Horwood Ltd., 1984.
[12] D.K. Hsiao and M.N. Kamel, "Heterogeneous Databases: Proliferations, Issues, and Solutions," IEEE Trans. Knowledge and Data Eng., vol. 1, no. 1, Mar. 1989.
[13] H.-Y. Hwang, and U. Dayal,“Using the entity-relationship model for implementing multi-model databasesystems,” 2nd Conf. on E-R Approach, pp. 237-258, 1981.
[14] “Information management system/virtual storage general informationmanual,” IBM Form No. GH20-1260, IBM Corporation.
[15] “IBM OS and CMS,” System 2000 DBMS COBOL PLEX, Document number 4220/R11.5, 1983.
[16] “IBM OS and CMS,” System 2000 DBMS Product Support, Document number 4216/R11.5, 1985.
[17] M. Kaul, K. Drosten, and E.J. Neuhold, ViewSystem: Integrating Heterogeneous Information Bases by Object-Oriented Views Proc. IEEE Int'l Conf. Data Eng., pp. 2-10, 1990.
[18] W. Kim, J. Garza, N. Ballou, and D. Woelk, "Architecture of the Orion Next-Generation Database System," IEEE Trans. Knowledge and Data Eng., vol. 2, no. 1, pp. 109-124 Mar. 1990.
[19] W. Kim, “On Optimizing an SQL-like Nested Query,” ACM Trans. Data Systems, Sept. 1982.
[20] J. Larson,“Bridging the gap between network and relational database managementsystems,” Computer, vol. 16, no. 9, Sept. 1983.
[21] P. Larson,“SQL-GATE: Providing SQL access to network and hierarchical databases,” Demonstration in SIGMOD 90,Atlantic City, May 1990.
[22] W. Litwin, L. Mark, and N. Roussopoulos, "Interoperability of Multiple Autonomous Databases," ACM Computing Surveys, vol. 22, no. 3, 1990, pp. 267-293.
[23] W. Litwin et al., “SIRIUS systems for distributed data management,” Distributed Databases, H.J. Schneider, Ed., NorthHolland, the Netherlands, pp.311-366, 1982.
[24] W. Litwin et al., "Multidatabase interoperability," IEEE Computer, vol. 12, 1986.
[25] W. Meng,G. Egan,C. Yu,, and W. Kim,“Transformation of relational queries to hierarchical queries,” Technical Report, Dept. of EECS, U. of Illinois at Chicago, 1991.
[26] W. Meng,C. Yu,, and W. Kim,“A theory of translation from relational queries to hierarchicalqueries,” Technical Report, Dept. of EECS, U. of Illinois at Chicago, 1992.
[27] M. Muralikrishna, “Improved Unnesting Algorithms for Join Aggregate SQL Queries,” Proc. Very Large Databases, 1992.
[28] S. Navathe,“An intuitive approach to normalize network structured data,” VLDB 1980.
[29] C. Pu,“Superdatabases for composition of heterogeneous databases,” IEEE Data Engineering Conf., 1988.
[30] A. Rosenthal, and D. Reiner,“Querying relational views of networks,” Query Processing in Database Systems, Edited by W. Kim, D.S. Reiner, and D.S. Batory, Springer-Verlag, 1985.
[31] R. Rosenberg and T. Landers,“An overview of MULTIBASE,” Distributed Data Bases, H. J. Schneider, Ed., North-HollandPub. Co., pp. 153-184, 1982.
[32] A.P. Seth and J.A. Larson,“Federated database systems for managing distributed, heterogeneous andautonomous databases,” ACM Computing Surveys, vol. 22, no. 3, pp. 184-236, September 1990.
[33] P. Stocker, et al., “PROTEUS: A heterogeneous distributed database project,” Databases—Role and Structure, P. Stocker, P. Gray, M. Atkinson, Eds, Cambridge University Press, 1984.
[34] W. Sun,W. Meng,, and C. Yu,“Query optimization in objected-oriented database systems,” Proc. of Dexa 90,Vienna, Austria, pp. 215-222, Aug. 1990.
[35] M. Templeton, et al., “Mermaid_A Front-end to Distributed Heterogeneous Databases,” Proc. IEEE, May 1987.
[36] T.J. Teorey, D. Yang, and J. Fry, "A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Mode," ACM Computing Surveys, vol. 18, no. 2, 1986, pp. 197-222.
[37] G. Thomas, et al., “Heterogeneous distributed database systems for production use,” ACM Computing Surveys, vol. 22, no. 3, pp. 237-266, September 1990.
[38] J.D. Ullman, Principles of Database Systems.Rockville, Md.: Computer Science Press, 1982.
[39] J. Veijalainen and A. Wolski, “Prepare and Commit Certification for Decentralized Transaction Management in Rigorous Heterogeneous Multidatabases,” Proc. Conf. Data Eng., 1992.
[40] C. Yu, et al., “Query processing in fragmented relational distributed system:mermaid,” IEEE Trans. on on Software Engineering vol. 11, no. 8, pp. 795-810, Aug. 1985
[41] C.T. Yu,K-C. Guh,D. Brill,, and A.L.P. Chen,“Partition strategy for distributed query processing in fast local area networks,” IEEE Trans. on Software Engineering, vol. 15, no. 6, pp. 780-793, June 1989.
[42] C. Zaniolo, “Design of Relational Views over Network Schemas,” Proc. 1979 ACM SIGMOD Int'l Conf. Management of Data (SIGMOD '79), May 1979.

Index Terms:
database, relational, hierarchical, query translation, heterogeneous system
Weiyi Meng, Clement Yu, Won Kim, "A Theory of Translation From Relational Queries to Hierarchical Queries," IEEE Transactions on Knowledge and Data Engineering, vol. 7, no. 2, pp. 228-245, April 1995, doi:10.1109/69.382294
Usage of this product signifies your acceptance of the Terms of Use.