Deriving the Conceptual Model of a Data Warehouse from Information Requirements

Natalija Kozmina, Laila Niedrite, Maksims Golubs

Abstract

Business requirements are essential for developing any information system, including a data warehouse. However, requirements written in natural language may be imprecise. This paper offers a model for business requirement formalization according to certain peculiarities of elements of multidimensional models, e.g. the distinction between quantifying and qualifying data. We also propose an algorithm that generates candidate data warehouse schemas and is based on distinguishing data warehouse schema elements in formal requirements. Then, resulting schemas are processed by a semi-automated procedure in order to obtain a data warehouse schema that matches business requirements best of all.

References

  1. Giorgini P., Rizzi S., Garzetti M. 2005. Goal-oriented requirement analysis for data warehouse design. In: Proc. of 8th ACM Int. workshop on Data Warehousing and OLAP (DOLAP'05), ACM Press, New York, pp 47-56
  2. Golfarelli M., Maio D., Rizzi S. 1998. Conceptual design of data warehouses from E/R schemes. In: Proc. of 31st Annual Hawaii Int. Conf. on System Sciences (HICSS'98), Kona, Hawaii, IEEE, USA, 7:334-343
  3. Inmon W.H. 2002. Building the data warehouse. 3rd edn., Wiley Computer Publishing
  4. Jones M. E., Song I. 2005. Dimensional modeling: identifying, classifying and applying patterns. In: Proc. of 8th ACM Int. workshop on Data Warehousing and OLAP (DOLAP'05), ACM Press, New York, pp 29-38
  5. Kaldeich C., Oliveira J. 2004. Data warehouse methodology: a process driven approach. LNCS 3084. Springer, Heidelberg, pp 536-549
  6. List B., Machaczek K. 2004. Towards a corporate Performance Measurement System. In: Proc. of ACM symposium on Applied Computing (SAC'04), ACM Press, New York, pp 1344-1350
  7. Niedritis, A., Niedrite, L., Kozmina, N. 2011. Performance Measurement Framework with Formal Indicator Definitions. In: Grabis, J., Kirikova, M. (eds.) BIR 2011. Springer, Heidelberg, LNBIP, 90:44- 58
  8. Parmenter D. 2010. Key Performance Indicators: developing, implementing, and using winning KPIs. 2nd edn., Jon Wiley & Sons, Inc.
  9. Poe V. 1996. Building a data warehouse for decision support. Prentice Hall
  10. Rizzi S. 2009. Conceptual Modeling Solutions for the Data Warehouse. In: Erickson, J. (ed.) Database Technologies: Concepts, Methodologies, Tools, and Applications, IGI Global, pp 86-104
  11. Rizzi S., Abell├│ A., Lechtenb├Ârger J., Trujillo J. 2006. Research in data warehouse modeling and design: dead or alive? In: Proc. of 9th ACM Int. workshop on Data Warehousing and OLAP (DOLAP'06), ACM Press, New York, pp 3-10
  12. Romero O., Abello A. 2010. A framework for multidimensional design of data warehouses from ontologies. Data and Knowledge Engineering 69:1138-1157
  13. Solodovnikova, D. 2008. Metadata to support data warehouse evolution. In: Proc. of 17th Int. Conf. on Information Systems Development (ISD'08), Paphos, Cyprus, 2008, pp 627-635
  14. Westerman P. 2001. Data warehousing using the WalMart model. Morgan Kaufmann
  15. Winter R., Strauch B. 2003. A method for demand-driven information requirements analysis in data warehousing projects. In: Proc. of 36th Annual Hawaii Int. Conf. on System Sciences (HICSS'03), Waikoloa, Hawaii, IEEE, USA, pp 1359-1365
Download


Paper Citation


in Harvard Style

Kozmina N., Niedrite L. and Golubs M. (2013). Deriving the Conceptual Model of a Data Warehouse from Information Requirements . In Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8565-59-4, pages 136-144. DOI: 10.5220/0004426301360144


in Bibtex Style

@conference{iceis13,
author={Natalija Kozmina and Laila Niedrite and Maksims Golubs},
title={Deriving the Conceptual Model of a Data Warehouse from Information Requirements},
booktitle={Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2013},
pages={136-144},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0004426301360144},
isbn={978-989-8565-59-4},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - Deriving the Conceptual Model of a Data Warehouse from Information Requirements
SN - 978-989-8565-59-4
AU - Kozmina N.
AU - Niedrite L.
AU - Golubs M.
PY - 2013
SP - 136
EP - 144
DO - 10.5220/0004426301360144