loading...
Multidatabase global query optimization
Hawaii, USA January 04-January 07
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/HICSS.1995.37555528th Hawaii International Conference ...
 This Article 
 
PURCHASE ARTICLE: $0
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
P. Ram, Dept. of Comput. Sci., North Dakota Univ., Grand Forks, ND, USA
W. Perrizo, Dept. of Comput. Sci., North Dakota Univ., Grand Forks, ND, USA
Data requests to multidatabases are posed through non-procedural languages such as SQL and, for a global data request, optimization must be performed to achieve good system performance. However, the issues are often complicated in multidatabases, due to additional issues arising because of the autonomy and heterogeneity restrictions of the independent local DBMSs. The data translation problem between various local systems can be observed at the schema level and at the instance level. We have identified the need for a domain translation table in multidatabase query processing, and we discuss methods of implementing it. Some observations about multidatabase inter-site joins are made, and four methods by which multidatabase global queries can be processed are introduced and analytically compared.
Index Terms:
distributed databases; query processing; multidatabase global query optimization; global data requests; nonprocedural languages; SQL; system performance; autonomy restrictions; heterogeneity restrictions; independent local DBMS; data translation; schema level; instance level; domain translation table; multidatabase inter-site joins
Citation:
P. Ram, W. Perrizo, "Multidatabase global query optimization," hicss, pp.253, 28th Hawaii International Conference on System Sciences (HICSS'95), 1995
Usage of this product signifies your acceptance of the Terms of Use.