Title
MF-Retarget: Aggregate Awareness in Multiple Fact Table Schema Data Warehouses
Abstract
Performance is a critical issue in Data Warehouse systems (DWs), due to the large amounts of data manipulated, and the type of analysis performed. A common technique used to improve performance is the use of pre-computed aggregate data, but the use of aggregates must be transparent for DW users. In this work, we present MF-Retarget, a query retargeting mechanism that deals with both conventional star schemas and multiple fact table (MFT) schemas. This type of multidimensional schema is often used to implement a DW using distinct, but interrelated Data Marts. The paper presents the retargeting algorithm and initial performance tests.
Year
Venue
Keywords
2002
ADBIS Research Communications
data warehouse
Field
DocType
Citations 
SQL,Data warehouse,Data structure,Data mining,Fact table,Star schema,Computer science,Data mart,Drill down,Online analytical processing
Conference
0
PageRank 
References 
Authors
0.34
9
3
Name
Order
Citations
PageRank
Karin Becker18817.22
Duncan Dubugras A. Ruiz2475.82
Kellyne Santos300.34