Alan R. Hevner
Abstract
Local area networks are becoming widely used as the database communication framework for sophisticated information systems. Databases can be distributed among stations on a network to achieve the advantages of performance, reliability, availability, and modularity. Efficient distributed query optimization algorithms are presented here for two types of local area networks: address ring networks and broadcast networks. Optimal algorithms are designed for simple queries. Optimization principles from these algorithms guide the development of effective heuristic algorithms for general queries on both types of networks. Several examples illustrate distributed query processing on local area networks.
- 1 APERS, P.M.G., HEVNER, A.R., AND YAO, S.B. Algorithms for distributed query optimization. IEEE Trans. Softw. Eng. SE-9, 1 (Jan. 1983), 57-68.Google Scholar
- 2 BERNSTEIN, P., AND CHIU, D.W. Using semijoins to solve relational queries. J. ACM 28, 1 (Jan. 1981), 25-40. Google Scholar
- 3 BERNSTEIN, P., GOODMAN, N., WONG, E., REEVE, C.L., AND ROTHNIE, J.B., JR. Query processing in a system for distributed databases (SDD-1). ACM Trans. Database Syst. 6, 4 (Dec. 1981 ), 602-625. Google Scholar
- 4 CERI, S., AND PELAGATTI, G. Distributed Databases: Principles and Systems. McGraw-Hill, New York, 1984. Google Scholar
- 5 CODD, E. A relational model of data for large shared data banks. Commun. ACM 13, 6 (Jun. 1970), 377-387. Google Scholar
- 6 DATE, C. An Introduction to Database Systems, 3rd ed. Addison-Wesley, Reading, Mass., 1981. Google Scholar
- 7 DWYER, P. A study of materialization and access planning. Tech. Rep. CSC-84-10, Computer Sciences Cent., Honeywell, Inc., Bloomington, Minn., Feb. 1984.Google Scholar
- 8 GOUDA, M., AND DAYAL, U. Optimal semijoin schedules for query processing in local distributed database systems. Proceedings of the International Conference on Management of Data (Ann Arbor, Mich., Apr. 29-May 1), ACM, New York, 1981. Google Scholar
- 9 HEVNER, A.R. The optimization of query processing on distributed database systems. Ph.D. dissertation, Computer Science Dept., Purdue Univ., West Lafayette, Ind., Dec. 1979. Google Scholar
- 10 HEVNER, A.R. A complexity analysis of the distributed query optimization problem. Working paper, Coll. of Business and Management, Univ. of Maryland, Feb. 1985.Google Scholar
- 11 HEVNER, A.R., AND YAO, S.B. Query processing in distributed database systems. IEEE Trans. Softw. Eng. SE-5, 3 (May 1979), 177-187.Google Scholar
- 12 KERSCHBERG, L., TING, P.D., AND YAO, S.B. Query optimization in Star computer networks. ACM Trans. Database Syst. 7, 4 (Dec. 1982), 678-711. Google Scholar
- 13 KIN(}, J.C. Centralized versus decentralized computing: Organizational considerations and management options. ACM Comput. Surv. 15, 4 (Dec. 1983), 319-349. Google Scholar
- 14 SACCO, G. Distributed query evaluation in local area networks. In Proceedings of the International Conference on Data Engineering (Los Angeles, Calif., Apr.) 1984, pp. 510-516. Google Scholar
- 15 TANENBAUM, A. Computer Networks. Prentice-Hall, Englewood Cliffs, N.J., 1981. Google Scholar
- 16 WAH, B. AND LIEN, Y. The file-assignment and query-processing problems in local multiaccess networks. In Proceedings of the International Conference on Data Engineering (Los Angeles, Calif., Apr.). 1984, pp. 228-235. Google Scholar
Index Terms
- Query optimization on local area networks
Recommendations
Query optimization in multidatabase systems
CASCON '92: Proceedings of the 1992 conference of the Centre for Advanced Studies on Collaborative research - Volume 2A multidatabase system (MDBS) integrates information from autonomous local databases managed by heterogeneous database management systems (DBMS) in a distributed environment. For a query involving more than one database, global query optimization should ...
Query decomposition in an object-oriented database system distributed on a local area network
RIDE '95: Proceedings of the 5th International Workshop on Research Issues in Data Engineering-Distributed Object Management (RIDE-DOM'95)Several issues are discussed concerning query processing in the framework of COMANDOS. COMANDOS is an object-oriented system supporting the development of distributed advanced applications. We first summarize the data model and the query language. Then ...
Reviews
David Gary Hill
This paper derives algorithms for query optimization for databases which are distributed on stations of a Local Area Network (LAN). A query must satisfy a request for retrieving data, which may be located on multiple sites in a network. The method by which this is done is called distributed query processing. The query optimization algorithm specifies the approach by which a query is actually executed on the network. The efficiency of the query optimization algorithm has a major impact on the overall performance of a distributed database system. Prior research has focused primarily on point-to-point networks. This paper extends the work to address ring and broadcast LANs. Using as a basis strategies which can be proved optimal for simple queries, heuristic optimization algorithms for both types of LANs for general distributed queries are derived. Data transmission and local processing costs were both taken into account in the algorithms. The algorithms are accompanied by examples of their use. The paper is a useful technical reference for those who are involved in the internals of distributed query processing.
Access critical reviews of Computing literature here
Become a reviewer for Computing Reviews.
Comments