Handling inconsistencies in data warehouses

被引:0
|
作者
Caniupán, M [1 ]
机构
[1] Carleton Univ, Sch Comp Sci, Ottawa, ON K1S 5B6, Canada
关键词
D O I
暂无
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Data warehouses (DWs) can become inconsistent when some dimensional constraints are not satisfied by the dimension instances. In this paper, we present preliminary results about the effects of the violation of partitioning constraints in homogeneous dimension instances over aggregation queries, and in particular over the summarizability property (SUMM) of the DWs. We are interested in finding ways to retrieve consistent answers even when the DW is inconsistent. We give a notion of repair for inconsistent instances based on a notion of prioritized minimization. We also describe a notion of consistent answer in DWs.
引用
收藏
页码:166 / 176
页数:11
相关论文
共 50 条
  • [21] Handling Revision Inconsistencies: Creating Useful Explanations
    Schmidt, Fabian
    Gebhardt, Joerg
    Kruse, Rudolf
    2015 48TH HAWAII INTERNATIONAL CONFERENCE ON SYSTEM SCIENCES (HICSS), 2015, : 3712 - 3718
  • [22] Handling inconsistencies in tables with nulls and functional dependencies
    Dominique Laurent
    Nicolas Spyratos
    Journal of Intelligent Information Systems, 2022, 59 : 285 - 317
  • [23] Stonebraker on Data Warehouses
    Stonebraker, Michael
    COMMUNICATIONS OF THE ACM, 2011, 54 (05) : 10 - 11
  • [24] PHILIPS DATA WAREHOUSES
    DALY, J
    PROCEEDINGS : SEAS ANNIVERSARY MEETING 1989, VOLS 1 AND 2: THE CORPORATE NETWORK, 1989, : 1099 - 1105
  • [25] Designing data warehouses
    Theodoratos, Dimitri
    Sellis, Timos
    Data and Knowledge Engineering, 1999, 31 (03): : 279 - 301
  • [26] Mobility Data Warehouses
    Vaisman, Alejandro
    Zimanyi, Esteban
    ISPRS INTERNATIONAL JOURNAL OF GEO-INFORMATION, 2019, 8 (04)
  • [27] Complements for data warehouses
    Laurent, D
    Lechtenbörger, J
    Spyratos, N
    Vossen, G
    15TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 1999, : 490 - 499
  • [28] Caring for data warehouses
    Strategic Systems, 1997, 10 (02):
  • [29] Designing data warehouses
    Theodoratos, D
    Sellis, T
    DATA & KNOWLEDGE ENGINEERING, 1999, 31 (03) : 279 - 301
  • [30] Deductive Data Warehouses
    Rabuzin, Kornelije
    INTERNATIONAL JOURNAL OF DATA WAREHOUSING AND MINING, 2014, 10 (01) : 16 - 31