skip to main content
research-article

Quality-oriented requirements engineering for a data warehouse

Published: 30 September 2011 Publication History

Abstract

Due to the increasing complexity of Data Warehouses (DW), continuous attention must be paid for evaluation of their quality throughout their design and development. DW quality depends on the quality of all requirements, conceptual, logical and physical models used for DW design. Various authors have proposed metrics to assure the quality of conceptual, logical and physical models for DW. However, there is no significant work in the DW literature to assure the quality of a requirements model. A good quality requirements model may lead to a good quality DW. In this paper, we propose a qualityoriented requirements model for a DW. In the proposed model, the notion of perspective is introduced to capture the intention of the agents (stakeholders) associated with their goals. The agent may view a soft goal from two perspectives: decisional and quality perspective. In the former, the agent may refine a soft goal into the goal having well defined criteria for its achievement and termed as decisional goal, whereas in the later the agent may define the various constraint (timing constraint, budgetary constraint etc.) associated with the decisional goals. The agents suggest the decisions for achieving their decisional goals considering these constraints. Thus, the decisional goals and the constraints specified in the decisional and quality perspective respectively should be maintained as meta-data of the DW. In this way, the quality of DW requirements model will be enhanced, which may lead to enhance the quality of conceptual, logical and physical model of DW.

References

[1]
Bouzeghoub, M., Kedad, Z. 2002. Information and database quality, chapter 8, quality in data warehousing (pp.163--198), Kluwer Academic Publishers.
[2]
English, L. 1996. Information Quality Improvement: Principles, Methods and Management, Brentwood, Information Impact International, Inc.
[3]
Fenton, N., Pfleeger, S. 1997. Software Metrics: A Rigorous Approach (2nd ed.). London: Chapman & Hall.
[4]
Harinarayan, V., Rajaraman, A., Ullman, J.D. 1996. Implementing data cubes efficiently. In proceedings of the 1996 ACM SIGMOD International Conference on management of data, 205--216.
[5]
Inmon, W.H. 1997. Building the data warehouse (2nd ed.). John Wiley and Sons.
[6]
ISO.2001. Software product evaluation quality characteristics and guidelines for their use. Geneva: ISO/IEC Standard 9126.
[7]
Jarke, M., Lenzerini, M., Vassiliou, Y., Vassiliadis, P. 2002. Fundamentals of data warehouses, Springer-Verlag.
[8]
Jeusfield, M., Quix, C., Jarke, M. 1998. Design and Analysis of Quality Information for Data Warehouses. In proceedings of 17th International Conference on Conceptual Modeling (ER'98), Singapore.
[9]
Kumar, M., Gosain, A., Singh, Y. 2009. Agent oriented requirements engineering for a data warehouse. ACM SIGSOFT Software Engineering Notes, 34(5), 1--4.
[10]
Kumar, M., Gosain, A., Singh, Y. 2010. Stakeholders driven requirements engineering approach for data warehouse development. Journal of Information Processing Systems, 6(3), 385--402.
[11]
Labio, W., Quass, D., Adelberg, B.1997. Physical database design for data warehouses, in: Thirteen International Conference on Data Engineering, IEEE Computer Society, Bermingham, 277--288, 1997.
[12]
Lechtenborger, J., Vossen, G. 2003. Multidimensional Normal Forms for Data Warehouse Design, Information Systems, 28, 415--434.
[13]
Lehner, W., Albretch, J., Wedekind, H. 1998. Normal forms for multidimensional databases, International conference on scientific and statistical database management, IEEE Press, 63--72.
[14]
Piattini, M., Genero, M., Calero, C., Polo, M. & Ruiz, F. 2000. Database quality. In Diaz, O. Piattini, M. (Eds.), Advanced Database Technology and Design. London: Artech House.
[15]
Prakash, N., Gosain, A. 2003. Requirements driven data warehouse development. Paper presented at the CAiSE Short Paper Proceedings.
[16]
Prakash, N., Gosain, A. 2007. An approach to engineering the requirements of data warehouses. Springer-Verlag, Requirements Eng. Journal.
[17]
Serrano, M. 2004Definition of a set of metrics for assuring data warehouse quality, University of Castilla, La Mancha (Spain).
[18]
Serrano, M., Calero, C., Piattini, M. 2002.Validating metrics for data warehouses, IEE Proceedings SOFTWARE, 149(5), 161--166.
[19]
Serrano, M., Trujillo, J., Calero, C., Piattini, M. (2007): Metrics for data warehouse conceptual models understandability, Information and Software Technology, 49, 851--870
[20]
Serrano, M.A., Calero, C., Sahraoui, H.A., Piattini, M. 2008. Empirical studies to assess the understandability of data warehouse schemas using structural metrics.
[21]
Si-Said, S., Prat, N. 2003. Multidimensional Schemas Quality: Assessing and Balancing Analyzability and Simplicity, ER 2003 Workshops, 140--151.
[22]
Van, L.A. 2001. Goal-oriented requirements engineering: a guided tour. Invited paper, In: Proceedings of 5th IEEE international symposium on requirements engineering, 249--263.

Cited By

View all
  • (2018)Queries-based requirements imprecision study for data warehouse update structural approachProceedings of the 8th International Conference on Information Systems and Technologies10.1145/3200842.3200851(1-10)Online publication date: 16-Mar-2018
  • (2016)Goal Oriented Approaches in Data Warehouse Requirements Engineering: A ReviewSmart Trends in Information Technology and Computer Communications10.1007/978-981-10-3433-6_30(244-253)Online publication date: 27-Dec-2016
  • (2015)Incorporating business intelligence and analytics into performance management for the public sector issues and challenges2015 International Conference on Electrical Engineering and Informatics (ICEEI)10.1109/ICEEI.2015.7352549(484-489)Online publication date: Aug-2015

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM SIGSOFT Software Engineering Notes
ACM SIGSOFT Software Engineering Notes  Volume 36, Issue 5
September 2011
160 pages
ISSN:0163-5948
DOI:10.1145/2020976
Issue’s Table of Contents

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 30 September 2011
Published in SIGSOFT Volume 36, Issue 5

Check for updates

Author Tags

  1. conceptual model quality
  2. data warehouse
  3. logical model quality
  4. requirements engineering
  5. requirements model quality

Qualifiers

  • Research-article

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)9
  • Downloads (Last 6 weeks)1
Reflects downloads up to 03 Mar 2025

Other Metrics

Citations

Cited By

View all
  • (2018)Queries-based requirements imprecision study for data warehouse update structural approachProceedings of the 8th International Conference on Information Systems and Technologies10.1145/3200842.3200851(1-10)Online publication date: 16-Mar-2018
  • (2016)Goal Oriented Approaches in Data Warehouse Requirements Engineering: A ReviewSmart Trends in Information Technology and Computer Communications10.1007/978-981-10-3433-6_30(244-253)Online publication date: 27-Dec-2016
  • (2015)Incorporating business intelligence and analytics into performance management for the public sector issues and challenges2015 International Conference on Electrical Engineering and Informatics (ICEEI)10.1109/ICEEI.2015.7352549(484-489)Online publication date: Aug-2015

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media