Data currency quality satisfaction in the design of a data warehouse

Theodoratos, D; Bouzeghoub, M

dc.contributor.author	Theodoratos, D	en
dc.contributor.author	Bouzeghoub, M	en
dc.date.accessioned	2014-03-01T01:51:08Z
dc.date.available	2014-03-01T01:51:08Z
dc.date.issued	2001	en
dc.identifier.issn	0218-8430	en
dc.identifier.uri	https://dspace.lib.ntua.gr/xmlui/handle/123456789/26229
dc.subject	data warehousing	en
dc.subject	date warehouse design	en
dc.subject	materialized views	en
dc.subject	quality goals	en
dc.subject	currency constraints	en
dc.subject.classification	Computer Science, Information Systems	en
dc.subject.other	MULTIPLE-QUERY OPTIMIZATION	en
dc.title	Data currency quality satisfaction in the design of a data warehouse	en
heal.type	journalArticle	en
heal.language	English	en
heal.publicationDate	2001	en
heal.abstract	A Data Warehouse (DW) is a large collection of data integrated from multiple distributed autonomous databases and other information sources. A DW can be seen as a set of materialized views defined over the remote source data. Until now research work on DW design is restricted to quantitatively selecting view sets for materialization. However, quality issues in the DW design are neglected. In this paper we suggest a novel statement of the DW design problem that takes into account quality factors. We design a DW system architecture that supports performance and data consistency quality goals. In this framework we present a high level approach that allows to check whether a view selection guaranteeing a data completeness quality goal also satisfies a data currency quality goal. This approach is based on an AND/OR dag representation for multiple queries and views. It also allows determining the minimal change propagation frequencies that satisfy the data currency quality goal along with the optimal query evaluation and change propagation plans. Our results can be directly used for a quality driven design of a DW.	en
heal.publisher	WORLD SCIENTIFIC PUBL CO PTE LTD	en
heal.journalName	INTERNATIONAL JOURNAL OF COOPERATIVE INFORMATION SYSTEMS	en
dc.identifier.isi	ISI:000169851800004	en
dc.identifier.volume	10	en
dc.identifier.issue	3	en
dc.identifier.spage	299	en
dc.identifier.epage	326	en