FROM DATABASE TO DATAWAREHOUSE - A Design Quality Evaluation

Maurizio Pighin, Lucio Ieronutti

2007

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 present the results of an experiment demonstrating the effectiveness of our methodology.

References

  1. Ballau, D.P, Wang, R.Y., Pazer, H.L., Tayi G.K., 1998. Modelling information manufacturing systems to determine information product quality. Management Science, 44(4).
  2. Ballou, D.P., Pazer, H.L., 1985. Modeling data and process quality in multi-input, multi-output information systems. Management Science, 31(2), 150-162.
  3. Chengalur-Smith, I.N., Ballou, D.P., Pazer H.L., 1999. The Impact of Data Quality Information on Decision Making: An Exploratory Analysis. IEEE Transactions on Knowledge and Data Engineering, 11(6), 853-864.
  4. Golfarelli, M., Maio, D., Rizzi, S., 1998. The dimensional fact model: a conceptual model for data warehouses. International Journal of Cooperative Information Systems, 7(2-3), 215-247.
  5. English, L.P., 1999. Improving Data Warehouse & Business Information Quality: Methods for Reducing Costs and Increasing Profits. Wiley and Sons.
  6. Karr, A.F., Sanil, A.P., Banks, D.L., 2006. Data Quality: A Statistical Perspective. Statistical Methodology, 3(2), 137-173.
  7. Kriebel, C.H., 1978. Evaluating the quality of information systems. Proceedings of the BIFOA Symposium.
  8. Phipps, C., Davis, K., 2002. Automating Data Warehouse Conceptual Schema Design and Evaluation. Proceeding of DMDW, 23-32.
  9. Pighin, M., Ieronutti, L., 2006. Quality of Operational Data: a Challenge for Datawarehouse Design. Proceedings of IBIMA Conference, 143-147.
  10. Redman, T.C., 1996. Data Quality for the Information Age. Artech House.
  11. Scannapieco, M., Virgillito, A., Marchetti, C., Mecella, M., Baldoni, R., 2004. The DaQuinCIS architecture: a platform for exchanging and improving data quality in cooperative information systems. Information Systems, 29(7), 551-582.
  12. Wang, R.Y., Strong D.M., 1996a. Beyond Accuracy: What Data Quality Means to Data Consumers. Journal of Management Information Systems, 12(4).
  13. Wang, R.Y., Strong D.M., 1996b. Data quality systems evaluation and implementation. Cambridge Market Intelligence Ltd., London.
  14. Wang, R.Y., Storey, V.C., Firth, C.P., 1995. A framework for analysis of data quality research. IEEE Transactions on Knowledge and Data Engineering, 7(4), 623-640.
Download


Paper Citation


in Harvard Style

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 1: ICEIS, ISBN 978-972-8865-88-7, pages 178-185. DOI: 10.5220/0002344601780185


in Bibtex Style

@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 1: ICEIS,},
year={2007},
pages={178-185},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002344601780185},
isbn={978-972-8865-88-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: 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