research-article

Free access

Local query translation and optimization in a distributed system

Authors:

Emmanuel Onuegbe,

Alan R. HevnerAuthors Info & Claims

AFIPS '83: Proceedings of the May 16-19, 1983, national computer conference

Pages 229 - 239

https://doi.org/10.1145/1500676.1500705

Published: 16 May 1983 Publication History

Abstract

A new query translation and optimization algorithm is presented. The algorithm is being implemented as the local query translation and optimization technique of Honeywell's Distributed Database Testbed System (DDTS). The algorithm translates local queries expressed in representational schemas (relational) to their equivalent internal schemas (network). The technique is new in that it does not translate each relational command in isolation, but rather attempts to find a collection of relational commands for which an optimized sequence of CODASYL DML commands can be generated. The optimization minimizes the number of disk accesses by taking advantage of the access paths available to the CODASYL local database management systems and the relationship information of the variables used in the relational commands.

References

[1]

Tsichritzis, D., and A. Klug (eds.). "The ANSI/X3/SPARC DBMS Framework Report of the Study Group on Data Base Management Systems." AFIPS Press, Montvale, N.J.: AFIPS Press, 1977.

[2]

Devor, C., and J. Weeldreyer. "DDTS: A Testbed for Distributed Database Research." Technical Report HR-80-268, Honeywell CCSC, Bloomington, Minnesota, August 1980.

[3]

Wong, E. "The Design of Representation Schemas." Technical Report HR-80-265, Honeywell CCSC, Bloomington, Minnesota, July 1980.

[4]

Elmasri, R. "GORDAS: A Data Definition, Query and Update Language for the Entity-Category-Relationship Model of Data." Technical Report HR-81-250, Honeywell CCSC, Bloomington, Minnesota, January 1981.

[5]

Hevner, A. "Transaction Optimization Techniques in a Distributed Database System." Technical Report HR-81-259, Honeywell CCSC, Bloomington, Minnesota, June 1981.

[6]

Devor, C. "Experience with Distributed System Design in DDTS." Proceedings of IEEE Third International Conference on Distributed Computing Systems, Fort Lauderdale, Florida, October 1982.

[7]

Elmasri, R., Devor, C., and Rahimi, S. "Notes on DDTS: An Apparatus for Experimental Research in Distributed Database Systems." ACM SIGMOD Record, July 1981.

Digital Library

[8]

Codd, E. "Extending the Relational Model to Capture More Meaning." ACM Transactions on Database Systems, Volume 4, Number 4, December 1979, pp. 397--434.

Digital Library

[9]

Dayal, U. and N. Goodman. "Query Optimization for CODASYL Database Systems." Proceedings of the International Conference on the Management of Data, ACM SIGMOD 1982, Orlando, Florida, pp. 138--150.

Digital Library

[10]

Honeywell Information Systems. Integrated Data Store (IDS) Reference Manual, Wellesley, Massachusetts, 1972.

[11]

Vassiliou, Y., and F. Lochovsky. "DBMS Transaction Translation." Proceedings of IEEE COMPSAC '80, Chicago, 1980, pp. 89--96.

[12]

Zaniolo, C. "Design of Relational Views Over Network Schemas," Proceedings of the International Conference on the Management of Data, ACM SIGMOD '79, Boston, June 1979.

Digital Library

[13]

Astrahan, M., and D. Chamberlain. "Implementation of a Structured English Query Language." CACM, Volume 18, Number 10, 1975.

Digital Library

[14]

Committee on Data Systems Languages. CODASYL Data Base Task Group Revised Report, ACM, 1978.

[15]

Hoffman, C., and J. O'Donnell. "Pattern Matching in Trees," JACM, Vol. 29, No. 1, January 1982.

Digital Library

Cited By

Bodorik PRiordon JUrban J(2000)Heuristic algorithms for distributed query processingProceedings of the first international symposium on Databases in parallel and distributed systems10.5555/62597.62614(144-155)Online publication date: 1-Jan-2000
https://dl.acm.org/doi/10.5555/62597.62614
Bodorik PRiordan JPyra J(1992)Deciding to Correct Distributed Query ProcessingIEEE Transactions on Knowledge and Data Engineering10.1109/69.1420164:3(253-265)Online publication date: 1-Jun-1992
https://dl.acm.org/doi/10.1109/69.142016
Bodorik PPyra JRiordon J(1990)Correcting execution of distributed queriesProceedings of the second international symposium on Databases in parallel and distributed systems10.1145/319057.319098(192-201)Online publication date: 1-Jul-1990
https://dl.acm.org/doi/10.1145/319057.319098
Show More Cited By

Local query translation and optimization in a distributed system
1. Information systems
  1. Data management systems
2. Theory of computation
  1. Theory and algorithms for application domains
    1. Database theory

Recommendations

A parallel Data Base Machine for query translation in a distributed database system
SAC '86: Proceedings of the 1986 workshop on Applied computing

A special purpose Data Base Machine (DBM) designed to translate queries between data models is examined. The DBM will provide a means of direct communication between different DBMSs in a distributed database system. The design utilizes the concept of ...
Multidatabase Query Optimization

A multidatabase system (MDBS) allows the users to simultaneously access heterogeneous, and autonomous databases using an integrated schema and a single global query language. The query optimization problem in MDBSs is quite different from the query ...
On the query translation in federative relational databases
DEXA '96: Proceedings of the 7th International Workshop on Database and Expert Systems Applications

The authors address the problem of query translation in a federative relational database system, and present a new method to specify semantic correspondences and data mappings. Several algorithms are described and discussed in detail, which can be used ...

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences

AFIPS '83: Proceedings of the May 16-19, 1983, national computer conference

May 1983

808 pages

ISBN:0882830392

DOI:10.1145/1500676

Copyright © 1983 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

AFIPS: American Federation of Information Processing Societies

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 16 May 1983

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Research-article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

8
Total Citations
View Citations
185
Total Downloads

Downloads (Last 12 months)66
Downloads (Last 6 weeks)9

Reflects downloads up to 07 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

Bodorik PRiordon JUrban J(2000)Heuristic algorithms for distributed query processingProceedings of the first international symposium on Databases in parallel and distributed systems10.5555/62597.62614(144-155)Online publication date: 1-Jan-2000
https://dl.acm.org/doi/10.5555/62597.62614
Bodorik PRiordan JPyra J(1992)Deciding to Correct Distributed Query ProcessingIEEE Transactions on Knowledge and Data Engineering10.1109/69.1420164:3(253-265)Online publication date: 1-Jun-1992
https://dl.acm.org/doi/10.1109/69.142016
Bodorik PPyra JRiordon J(1990)Correcting execution of distributed queriesProceedings of the second international symposium on Databases in parallel and distributed systems10.1145/319057.319098(192-201)Online publication date: 1-Jul-1990
https://dl.acm.org/doi/10.1145/319057.319098
Bodorik PPyra JRiordon J(1990)Correcting execution of distributed queries[1990] Proceedings. Second International Symposium on Databases in Parallel and Distributed Systems10.1109/DPDS.1990.113710(192-201)Online publication date: 1990
https://doi.org/10.1109/DPDS.1990.113710
Bodorik PRiordon JJacob CRiehl A(1989)Dynamic distributed query processing techniquesProceedings of the 17th conference on ACM Annual Computer Science Conference10.1145/75427.75474(348-357)Online publication date: 21-Feb-1989
https://dl.acm.org/doi/10.1145/75427.75474
Bodorik P(1988)Heuristic Algorithms For Distributed Query ProcessingProceedings [1988] International Symposium on Databases in Parallel and Distributed Systems10.1109/DPDS.1988.675011(144-155)Online publication date: 1988
https://doi.org/10.1109/DPDS.1988.675011
Bodorik PRiordon J(1988)Evaluation dynamic processing of distributed queries[1988] Proceedings. The 8th International Conference on Distributed10.1109/DCS.1988.12554(510-519)Online publication date: 1988
https://doi.org/10.1109/DCS.1988.12554
Lohman GDaniels DHaas LKistler RSelinger P(1984)Optimization of Nested Queries in a Distributed Relational DatabaseProceedings of the 10th International Conference on Very Large Data Bases10.5555/645912.671299(403-415)Online publication date: 27-Aug-1984
https://dl.acm.org/doi/10.5555/645912.671299

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

Figures

Tables

Media

View Table of Conten