Question: What are the issues for query processing in a heterogeneous database
1

Subject: Distributed Database

Topic: Heterogeneous Database

Difficulty: High

ADD COMMENTlink
modified 20 months ago by gravatar for Juilee Juilee2.3k written 2.6 years ago by gravatar for Barkha Barkha750
2

There are several issues for query processing in a heterogenous database.

• Schema translation

Write a wrapper for each data source to translate data to a global schema. Wrappers must also translate updates on global schema to update on local schema • Limited query capabilities

Some data sources allow only restricted forms of selection e.g. web forms, flat file data sources.

Quires have to be broken up and processed partly at the source and partly at a different site.

• Removal of duplicate information when sites have overlapping information

Decide which sites to execute query.

• Global query optimization

ADD COMMENTlink
written 2.6 years ago by gravatar for Barkha Barkha750
Please log in to add an answer.