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