Gathering Formalized Information Requirements of a Data Warehouse

Natalija Kozmina, Laila Niedrite, Janis Zemnickis


Information requirements of a data warehouse (DW) captured in natural language often have a common issue of being ambiguous, inaccurate, or repeating. We offer an approach to formalize DW information requirements based on our experience of using demand-driven methodology for DW conceptual design and distinction between quantifying and qualifying data. In this paper we demonstrate a working prototype of the iReq tool implemented for the purpose of collecting DW information requirements. Graphical user interface (GUI) of the iReq tool conforms to the requirement formalization metamodel acquired as a result of our previous research studies, is intuitive and user-friendly, and allows to define an unlimited number of requirement counterpart elements. The functionality of the iReq tool is wide; it allows deriving a conceptual model of a DW in a semi-automatic manner from gathered information requirements. Due to space limitations, in this paper we cover only such components as GUI for input of the information requirements illustrated with application examples, its underlying formal requirement repository, and a graph database (DB) to represent a glossary of terms for requirement definition.


  1. Cravero Leal, A., Mazón, J.-N., Trujillo, J., 2013. A business-oriented approach to data warehouse development. Ingenieria e Investigación, 33(1):59-65.
  2. Inmon, W.H., 2002. Building the Data Warehouse, Wiley Computer Publishing, 3rd edition.
  3. Kozmina, N., Niedrite, L., 2014. Extending a Metamodel for Formalization of Data Warehouse Requirements. In: Johansson, B. et al. (eds.) Perspectives in Business Informatics Research (BIR'14), LNBIP 194, Springer, Berlin, pp. 362-374.
  4. Kozmina, N., Niedrite, L., Golubs, M., 2013. Deriving the Conceptual Model of a Data Warehouse from Information Requirements. In: Proc. of the 15th Int. Conf. on Enterprise Information Systems (ICEIS'13), vol. 1, pp. 136-144.
  5. Nasiri, A., Zimányi, E., Wrembel, R., 2015. Requirements Engineering for Data Warehouses. Revue des Nouvelles Technologies de l'Information (EDA), RNTI-B-11:49-64.
  6. Niedritis, A., Niedrite, L., Kozmina, N., 2011. Performance Measurement Framework with Formal Indicator Definitions. In: J. Grabis, M. Kirikova (eds.) Perspectives in Business Informatics Research (BIR'11), LNBIP 90, Springer, Berlin, pp. 44-58.
  7. OMG, The Business Motivational Model, 2015. Available online:
  8. Pardillo, J., Mazón, J.-N., 2011. Using Ontologies for the Design of Data Warehouses. Int. Journal of Database Management Systems (IJDMS), 3(2):73-87.
  9. Parmenter, D., 2010. Key Performance Indicators: Developing, Implementing, and Using Winning KPIs, Jon Wiley & Sons, Inc., 2nd edition.
  10. Prakash, D., 2016. Eliciting Information Requirements for DW Systems. In: Proc. of 28th Int. Conf. on Advanced Information Systems Engineering (CAiSE'16, Doctoral Consortium). Available online:
  11. Solodovnikova, D., Niedrite, L., Kozmina, N., 2015. Handling Evolving Data Warehouse Requirements. In: Communications in Computer and Information Science, vol. 539, pp. 334-345.
  12. Thenmozhi, M.; Vivekanandan, K. A Tool for Data Warehouse Multidimensional Schema Design using Ontology. International Journal of Computer Science Issues (IJCSI), 10(2):161-168, March 2013.
  13. Winter, R., Strauch, B., 2003. A Method for Demanddriven Information Requirements Analysis in Data Warehousing Projects. In: Proc. of 36th Annual Hawaii Int. Conf. on System Sciences (HICSS'03), USA, IEEE, pp. 1359-1365.

Paper Citation

in Harvard Style

Kozmina N., Niedrite L. and Zemnickis J. (2017). Gathering Formalized Information Requirements of a Data Warehouse . In Proceedings of the 19th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-758-247-9, pages 217-224. DOI: 10.5220/0006276802170224

in Bibtex Style

author={Natalija Kozmina and Laila Niedrite and Janis Zemnickis},
title={Gathering Formalized Information Requirements of a Data Warehouse},
booktitle={Proceedings of the 19th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},

in EndNote Style

JO - Proceedings of the 19th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - Gathering Formalized Information Requirements of a Data Warehouse
SN - 978-989-758-247-9
AU - Kozmina N.
AU - Niedrite L.
AU - Zemnickis J.
PY - 2017
SP - 217
EP - 224
DO - 10.5220/0006276802170224