loading
Documents

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Maurizio Pighin and Lucio Ieronutti

Affiliation: University of Udine, Italy

ISBN: 978-972-8865-88-7

ISSN: 2184-4992

Keyword(s): Datawarehouse, design quality, data quality.

Related Ontology Subjects/Areas/Topics: Data Warehouses and OLAP ; Databases and Information Systems Integration ; Enterprise Information Systems

Abstract: Data warehousing provides tools and techniques for collecting, integrating and storing a large number of transactional data extracted from operational databases, with the aim of deriving accurate management information that can be effectively used for supporting decision processes. However, the choice of which attributes have to be considered as dimensions and which as measures heavily influences the effectiveness of a data warehouse. Since this is not a trivial task, especially for databases characterized by a large number of tables and attributes, an expert is often required for correctly selecting the most suitable attributes and assigning them the correct roles. In this paper, we propose a methodology based on the analysis of statistical and syntactical aspects that can be effectively used (i) during the data warehouse design process for supporting the selection of database tables and attributes, and (ii) then for evaluating the quality of data warehouse design choices. We also pr esent the results of an experiment demonstrating the effectiveness of our methodology. (More)

PDF ImageFull Text

Download
CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 3.238.190.82

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Pighin, M. and Ieronutti, L. (2007). FROM DATABASE TO DATAWAREHOUSE - A Design Quality Evaluation.In Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 3: ICEIS, ISBN 978-972-8865-88-7, pages 178-185. DOI: 10.5220/0002344601780185

@conference{iceis07,
author={Maurizio Pighin and Lucio Ieronutti},
title={FROM DATABASE TO DATAWAREHOUSE - A Design Quality Evaluation},
booktitle={Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 3: ICEIS,},
year={2007},
pages={178-185},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002344601780185},
isbn={978-972-8865-88-7},
}

TY - CONF

JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 3: ICEIS,
TI - FROM DATABASE TO DATAWAREHOUSE - A Design Quality Evaluation
SN - 978-972-8865-88-7
AU - Pighin, M.
AU - Ieronutti, L.
PY - 2007
SP - 178
EP - 185
DO - 10.5220/0002344601780185

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.