Issue No.09 - September (2005 vol.17)
Zhiyong Peng , IEEE
Qing Li , IEEE
Ling Feng , IEEE
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/TKDE.2005.154
Providing integrated access to multiple, distributed, heterogeneous databases and other information sources has become one of the leading issues in database research and the industry. One of the most effective approaches is to extract and integrate information of interest from each source in advance and store them in a centralized repository (known as a data warehouse). When a query is posed, it is evaluated directly at the warehouse without accessing the original information sources. One of the techniques that this approach uses to improve the efficiency of query processing is materialized view(s). Essentially, materialized views are used for data warehouses, and various methods for relational databases have been developed. In this paper, we will first discuss an object deputy approach to realize materialized object views for data warehouses which can also incorporate object-oriented databases. A framework has been developed using Smalltalk to prepare data for data warehousing, in which an object deputy model and database connecting tools have been implemented. The object deputy model can provide an easy-to-use way to resolve inconsistency and conflicts while preparing data for data warehousing, as evidenced by our empirical study.
Index Terms- Data preparation, data warehousing, data fusion/integration, object deputy model, conflict resolution, duplicate handling.
Zhiyong Peng, Qing Li, Ling Feng, Xuhui Li, Junqiang Liu, "Using Object Deputy Model to Prepare Data for Data Warehousing", IEEE Transactions on Knowledge & Data Engineering, vol.17, no. 9, pp. 1274-1288, September 2005, doi:10.1109/TKDE.2005.154