Sökning: onr:"swepub:oai:DiVA.org:his-14741" >
A Systematic Approa...
A Systematic Approach to Selecting Maintenance Policies in a Data Warehouse Environment
-
- Engström, Henrik, 1968- (författare)
- Högskolan i Skövde,Institutionen för datavetenskap,Interaction lab
-
- Chakravarthy, Sharma (författare)
- Computer Science and Engineering Department, University of Texas at Arlington, USA
-
- Lings, Brian (författare)
- Department of Computer Science, University of Exeter, UK
-
(creator_code:org_t)
- Springer Berlin/Heidelberg, 2002
- 2002
- Engelska.
-
Ingår i: Advances in Database Technology - EDBT 2002. - : Springer Berlin/Heidelberg. - 9783540433248 - 9783540458760 ; , s. 317-335
- Relaterad länk:
-
https://urn.kb.se/re...
-
visa fler...
-
https://doi.org/10.1...
-
visa färre...
Abstract
Ämnesord
Stäng
- Most work on data warehousing addresses aspects related to the internal operation of a data warehouse server, such as selection of views to materialise, maintenance of aggregate views and performance of OLAP queries. Issues related to data warehouse maintenance, i.e. how changes to autonomous sources should be detected and propagated to a warehouse, have been addressed in a fragmented manner. Although data propagation policies, source database capabilities, and user requirements have been addressed individually, their co-dependencies and relationships have not been explored. In this paper, we present a comprehensive framework for evaluating data propagation policies against data warehouse requirements and source capabilities. We formalize data warehouse specification along the dimensions of staleness, response time, storage, and computation cost, and classify source databases according to their data propagation capabilities. A detailed cost-model is presented for a representative set of policies. A prototype tool has been developed to allow an exploration of the various trade-offs.
Ämnesord
- NATURVETENSKAP -- Data- och informationsvetenskap -- Datavetenskap (hsv//swe)
- NATURAL SCIENCES -- Computer and Information Sciences -- Computer Sciences (hsv//eng)
Publikations- och innehållstyp
- ref (ämneskategori)
- kon (ämneskategori)
Hitta via bibliotek
Till lärosätets databas