A statistical and syntactical approach to datawarehouse design quality. (18th January 2008)

• Record Type: Journal Article
• Authors: Pighin, Maurizio; Ieronutti, Lucio
• Is Part Of: International journal of information quality. Volume 1:Number 4(2007)
• Page Start: 368
• Page End: 391
• Publication Date: 2008-01-18
• Subjects: data warehouse design -- quantitative quality measurements -- data warehouse evaluation -- data warehousing -- attributes selection; Information resources management -- Periodicals; Information retrieval -- Periodicals; Knowledge management -- Periodicals; 658.4038
• Languages: English
• ISSNs: 1751-0457

Abstract

Data warehousing allows analysts and managers to interactively study transactional data for deriving information suitable to support decision processes. However, the effectiveness of such tools strongly depends on taken design choices and quality of initial data. The selection of proper measures and dimensions is not a trivial task, especially in the case of large transactional databases. We propose an approach based on statistical and syntactical aspects that can be effectively used for: guiding the attributes selection during the datawarehouse design; evaluating the quality of taken design choices. We tested on three commercial databases the effectiveness of our proposal.