Publicación: DATA WAREHOUSE FIXER: FIXING INCONSISTENCIES IN DATA WAREHOUSES
Fecha
2011
Título de la revista
ISSN de la revista
Título del volumen
Editor
30TH INTERNATIONAL CONFERENCE OF THE CHILEAN COMPUTER SCIENCE SOCIETY
Resumen
DIMENSIONS IN DATA WAREHOUSES (DWS) ARE SET OF ELEMENTS CONNECTED BY A HIERARCHICAL RELATIONSHIP. USUALLY, DIMENSIONS ARE REQUIRED TO BE STRICT AND COVERING TO SUPPORT SUMMARIZATIONS AT DIFFERENT LEVELS OF GRANULARITY. A DIMENSION IS STRICT IF ALL THEY ROLLUP RELATIONS ARE FUNCTIONS, AND IS COVERING IF EVERY ELEMENT IN A CATEGORY IS CONNECTED WITH AN ELEMENT IN ITS ANCESTOR CATEGORIES. WE PRESENT THE DATA WAREHOUSE FIXER (DWF), A SYSTEM THAT RESTORES CONSISTENCY OF DIMENSIONS THAT FAIL TO SATISFY THEIR STRICTNESS CONSTRAINTS. THE SYSTEM CHECKS CONSISTENCY, COMPUTES MINIMAL REPAIRS FOR INCONSISTENT DIMENSIONS BY IMPLEMENTING DATALOG PROGRAMS WITH NEGATION AND WEAK CONSTRAINTS, AND ALSO FIXES INCONSISTENT DIMENSIONS.
