Skip to main content
SpringerLink
Log in

Investigating Requirements Completeness Metrics for Requirements Schemas Using Requirements Engineering Approach of Data Warehouse: A Formal and Empirical Validation

  • Research Article-Computer Engineering and Computer Science
  • Published:
Arabian Journal for Science and Engineering Aims and scope Submit manuscript

Abstract

These days it is essential to maintain the information quality of data warehouse which is used by managers at different levels to take business decisions in organizations. Also, the information quality is assessed by its data models (requirements, conceptual, logical and physical). Various authors have proposed different metrics which were validated formally and empirically to assess the quality of its respective data models. However, no formal and empirical investigation of requirements completeness metrics was witnessed in the literature. Therefore, in this paper, we thoroughly validate the completeness metrics formally and empirically to evaluate the requirements data model quality. As a preliminary step, formal validation using Briand’s framework is carried out on completeness metrics which proves that out of ten metrics, five metrics are size measure, two metrics are cohesion measure, another two metrics are complexity measure and rest one metric is coupling measure. Further, empirical validation includes correlation analysis to ascertain whether completeness metrics are correlated with understandability of requirements schemas. The results illustrate that the eight metrics have positive and strong significant correlation with understandability of requirements schemas. Moreover, linear regression is employed in this study to evaluate the model quality in an objective manner by predicting the understandability of requirements schemas using requirements engineering approach. On the basis of linear regression results, except two metrics, all other eight metrics can build the accurate requirements model.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6

Similar content being viewed by others

References

  1. Jarke, M.; Lenzerini, M.; Vassiliou, Y.; Vassiliadis, P.: Fundamentals of Data Warehouses. Springer, Berlin (2002)

    MATH  Google Scholar 

  2. English, L.: Information Quality Improvement: Principles, Methods and Management. Information Impact International, Inc., Brentwood (1996)

    Google Scholar 

  3. Rizzi, S.; Abelló, A.; Lechtenbörger, J.; Trujillo, J.: Research in data warehouse modeling and design: dead or alive? In: Proceedings of the 9th ACM International Workshop on Data Warehousing and OLAP, pp. 3–10 (2006)

  4. Serrano, M.; Trujillo, J.; Calero, C.; Piattini, M.: Metrics for data warehouse conceptual models understandability. Inf. Softw. Technol. 49, 851–870 (2007)

    Article  Google Scholar 

  5. Kumar, M.; Gosain, A.; Singh, Y.: Quality-oriented requirements engineering approach for data warehouse. Int. J. Comput. Syst. Eng. 1, 127–138 (2012)

    Article  Google Scholar 

  6. Salinesi, C.; Gam, I.: How specific should requirements engineering be in the context of decision information systems? In: Third International Conference on Research Challenges in Information Science, pp. 247–254. IEEE (2009)

  7. Cabibbo, L.; Torlone, R.: A logical approach to multidimensional databases. In: International Conference on Extending Database Technology, pp. 183–197. Springer, Berlin (1998)

  8. Lehner, W.; Albrecht, J.; Wedekind, H.: Normal forms for multidimensional databases. In: Proceedings of Tenth International Conference on Scientific and Statistical Database Management, Cat. No. 98TB100243, pp. 63–72. IEEE (1998)

  9. Vassiliadis, P.: Gulliver in the land of data warehousing: practical experiences and observations of a researcher. In: DMDW, p. 12 (2000)

  10. Schiefer, J.; List, B.; Bruckner, R.: A holistic approach for managing requirements of data warehouse systems. AMCIS Proc. 13 (2002)

  11. Frendi, M.; Salinesi, C.: Requirements engineering for data warehousing. In: Proceedings of the 9th International Workshop on Requirements Engineering: Foundations of Software Quality (2003)

  12. Mazón, J.N.; Pardillo, J.; Trujillo, J.: A model-driven goal-oriented requirement engineering approach for data warehouses. In: International Conference on Conceptual Modeling, pp. 255–264. Springer, Berlin (2007)

  13. Winter, R.; Strauch, B.: A method for demand-driven information requirements analysis in data warehousing projects. In: 36th Annual Hawaii International Conference on System Sciences Proceedings of the IEEE, p. 9 (2003)

  14. Winter, R.; Strauch, B.: Information requirements engineering for data warehouse systems. In: Proceedings of the ACM Symposium on Applied Computing, pp. 1359–1365 (2004)

  15. Fenton, N.E.; Melton, A.: Measurement theory and software measurement. In: Software Measurement, pp. 27–38 (1996)

  16. Fenton, N.; Bieman, J.: Software Metrics: A Rigorous and Practical Approach. CRC Press, Boca Raton (2014)

    Book  Google Scholar 

  17. Serrano, M.: Definition of a Set of Metrics for Assuring Data Warehouse Quality. Univeristy of Castilla, La Mancha (2004)

    Google Scholar 

  18. Gaur, H.; Kumar, M.: Assessing the understandability of a data warehouse logical model using a decision-tree approach. ACM SIGSOFT Softw. Eng. Notes 39, 1–6 (2014)

    Article  Google Scholar 

  19. Labio, W.J.; Quass, D.; Adelberg, B.: Physical database design for data warehouses. In: Proceedings 13th International Conference on Data Engineering, pp. 277–288. IEEE (1997)

  20. Inmon, W.H.: Building the Data Warehouse. Wiley, Hoboken (2005)

    Google Scholar 

  21. Kimball, R.; Ross, M.: The Data Warehouse Lifecycle Toolkit, 2nd edn. Wiley, New York (2002)

    Google Scholar 

  22. Nagpal, S.; Gosain, A.; Sabharwal, S.: Complexity metric for multidimensional models for data warehouse. In: Proceedings of the CUBE International Information Technology Conference, pp. 360–365 (2012)

  23. Nagpal, S.; Gosain, A.; Sabharwal, S.: Theoretical and empirical validation of comprehensive complexity metric for multidimensional models for data warehouse. Int. J. Syst. Assur. Eng. Manag. 4, 193–204 (2013)

    Article  Google Scholar 

  24. Kumar, M.; Gosain, A.; Singh, Y.: Empirical validation of structural metrics for predicting understandability of conceptual schemas for data warehouse. Int. J. Syst. Assur. Eng. Manag. 5, 291–306 (2014)

    Article  Google Scholar 

  25. Gosain, A.; Singh, J.: Comprehensive complexity metric for data warehouse multidimensional model understandability. IET Softw. 14, 275–282 (2020)

    Article  Google Scholar 

  26. Kumar, M.; Gosain, A.; Singh, Y.: Stakeholders driven requirements engineering approach for data warehouse development. J. Inf. Process. Syst. 6, 385–402 (2010)

    Article  Google Scholar 

  27. Kumar, M.; Gosain, A.; Singh, Y.: Quality-oriented requirements engineering for a data warehouse. ACM SIGSOFT Softw. Eng. Not. 36, 1–4 (2011)

    Google Scholar 

  28. Kumar, M.; Gosain, A.; Singh, Y.: On completeness and traceability metrics for data warehouse requirements engineering. Int. J. Comput. Syst. Eng. 1, 229–237 (2013)

    Article  Google Scholar 

  29. Kumar, M.: Validation of data warehouse requirements-model traceability metrics using a formal framework. In: 2nd International Conference on Computing for Sustainable Global Development (INDIACom), pp. 216–221. IEEE (2015)

  30. Singh, T.; Kumar, M.: Empirical validation of requirements traceability metrics for requirements model of data warehouse using SVM. In: 17th India Council International Conference (INDICON), pp. 1–5. IEEE, New Delhi (2020)

  31. Singh, T.; Kumar, M.: Formally investigating traceability metrics of data warehouse requirements model using Briand's framework. In: 5th International Conference on Intelligent Computing and Control Systems (ICICCS), pp. 1203–1209. IEEE (2021)

  32. Briand, L.C.; Morasca, S.; Basili, V.R.: Property-based software engineering measurement. IEEE Trans. Softw. Eng. 22, 68–86 (1996)

    Article  Google Scholar 

  33. Schneidewind, N.F.: Methodology for validating software metrics. IEEE Trans. Softw. Eng. 18, 410–422 (1992)

    Article  Google Scholar 

  34. Inmon, W.H.: Building the Data Warehouse. Wiley, New York (1996)

    Google Scholar 

  35. Golfarelli, M.; Rizzi, S.: Designing the data warehouse: Key steps and crucial issues. J. Comput. Sci. Inf. Manag. 2, 88–100 (1999)

    Google Scholar 

  36. Yu, E.; Mylopoulos, J.: Why goal-oriented requirements engineering. In: Proceedings of the 4th International Workshop on Requirements Engineering: Foundations of Software Quality, pp. 15–22 (1998)

  37. Bresciani, P.; Donzelli, P.: REF: a practical agent-based requirement engineering framework. In: International Conference on Conceptual Modeling, pp. 217–228. Springer, Berlin (2003)

  38. Donzelli, P.; Bresciani, P.: Improving requirements engineering by quality modelling-a quality-based requirements engineering framework. J. Res. Pract. Inf. Technol. 36, 277 (2004)

    Google Scholar 

  39. Berenbach, B.; Borotto, G.: Metrics for model driven requirements development. In: Proceedings of the 28th International Conference on Software Engineering, pp. 445–451 (2006)

  40. Giorgini, P.; Rizzi, S.; Garzetti, M.: GRAnD: a goal-oriented approach to requirement analysis in data warehouses. Decis. Support Syst. 45, 4–21 (2008)

    Article  Google Scholar 

  41. Gosain, A.; Singh, J.: Achieving data warehouse quality using gdi approach. In: First International Conference on the Applications of Digital Information and Web Technologies, pp. 494–499. IEEE (2008)

  42. Van Lamsweerde, A.: Goal-oriented requirements engineering: a guided tour. In: Proceedings Fifth IEEE International Symposium on Requirements Engineering, pp. 249–262. IEEE (2001)

  43. Mazón, J.N.; Trujillo, J.; Lechtenbörger, J.: A set of QVT relations to assure the correctness of data warehouses by using multidimensional normal forms. In: International Conference on Conceptual Modeling, pp. 385–398. Springer, Berlin (2006)

  44. Prakash, N.; Gosain, A.: An approach to engineering the requirements of data warehouses. Requir. Eng. 13, 49–72 (2008)

    Article  Google Scholar 

  45. Kumar, M.; Gosain, A.; Singh, Y.: Agent oriented requirements engineering for a data warehouse. ACM SIGSOFT Softw. Eng. Notes 34, 1–4 (2009)

    Google Scholar 

  46. Kumar, M.; Gosain, A.; Singh, Y.: A novel requirements engineering approach for designing data warehouses. Int. J. Syst. Assur. Eng. Manag. 7, 205–221 (2016)

    Article  Google Scholar 

  47. Prakash, D.; Prakash, N.: A multifactor approach for elicitation of Information requirements of data warehouses. Requir. Eng. 24, 103–117 (2019)

    Article  Google Scholar 

  48. Calero, C.; Piattini, M.; Genero, M.: Metrics for controlling database complexity. In: Developing Quality Complex Database Systems: Practices, Techniques and Technologies, pp. 48–68. IGI Global (2001)

  49. Zuse, H.: A Framework of Software Measurement. Walter de Gruyter, Berlin (1998)

    Book  Google Scholar 

  50. Serrano, M.; Calero, C.; Trujillo, J.; Luján-Mora, S.; Piattini, M.: Empirical validation of metrics for conceptual models of data warehouses. In: International Conference on Advanced Information Systems Engineering, pp. 506–520. Springer, Berlin (2004)

  51. Serrano, M.; Calero, C.; Piattini, M.: An experimental replication with data warehouse metrics. Int. J. Data Warehous. Min. (IJDWM) 1, 1–21 (2005)

    Article  Google Scholar 

  52. Serrano, M.A.; Calero, C.; Sahraoui, H.A.; Piattini, M.: Empirical studies to assess the understandability of data warehouse schemas using structural metrics. Softw. Qual. J. 16, 79–106 (2008)

    Article  Google Scholar 

  53. Gosain, A.; Singh, J.: Quality metrics emphasizing dimension hierarchy sharing in multidimensional models for data warehouse: a theoretical and empirical evaluation. Int. J. Syst. Assur. Eng. Manag. 8, 1672–1688 (2017)

    Article  Google Scholar 

  54. Aggarwal, G.; Sabharwal, S.; Nagpal, S.: Theoretical and empirical validation of coupling metrics for object-oriented data warehouse design. Arab. J. Sci. Eng. 43, 675–691 (2018)

    Article  Google Scholar 

  55. Gosain, A.; Singh, J.: Empirical investigation of dimension hierarchy sharing-based metrics for multidimensional schema understandability. Int. J. Intell. Eng. Inform. 7, 141–163 (2019)

    Google Scholar 

  56. Prakash, N.; Gosain, A.: Requirements driven data warehouse development. In: CAiSE Short Paper Proceedings (2003)

  57. Fenton, N.: Software measurement: a necessary scientific basis. IEEE Trans. Softw. Eng. 20, 199–206 (1994)

    Article  Google Scholar 

  58. Weyuker, E.J.: Evaluating software complexity measures. IEEE Trans. Softw. Eng. 14, 1357–1365 (1988)

    Article  MathSciNet  Google Scholar 

  59. Wohlin, C.; Runeson, P.; Höst, M.; Ohlsson, M.C.; Regnell, B.; Wesslén, A.: Experimentation in Software Engineering. Springer, Berlin (2012)

    Book  Google Scholar 

  60. Carver, J.; Jaccheri, L.; Morasca, S.; Shull, F.: Using empirical studies during software courses. In: Empirical Methods and Studies in Software Engineering, pp. 81–103. Springer, Berlin (2003)

  61. Kitchenham, B.A.; Pfleeger, S.L.; Pickard, L.M.; Jones, P.W.; Hoaglin, D.C.; El Emam, K.; Rosenberg, J.: Preliminary guidelines for empirical research in software engineering. IEEE Trans. Softw. Eng. 28, 721–734 (2002)

    Article  Google Scholar 

  62. Charness, G.; Gneezy, U.; Kuhn, M.A.: Experimental methods: Between-subject and within-subject design. J. Econ. Behav. Organ. 81, 1–8 (2012)

    Article  Google Scholar 

  63. Briand, L.C.; Wüst, J.; Ikonomovski, S.V.; Lounis, H.: Investigating quality factors in object-oriented designs: an industrial case study. In: Proceedings of the 21st International Conference on Software Engineering, pp. 345–354 (1999)

  64. Hauke, J.; Kossowski, T.: Comparison of values of Pearson’s and Spearman’s correlation coefficients on the same sets of data. Quaest. Geogr. 30, 87–93 (2011)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. University School of Information and Communication Technology, Guru Gobind Singh Indraprastha University, New Delhi, Delhi, 110078, India

    Tanu Singh

  2. Department of Computer Science and Engineering, Netaji Subhas University of Technology, East Campus (Ambedkar Institute of Advanced Communication Technologies & Research), New Delhi, Delhi, 110031, India

    Manoj Kumar

Authors
  1. Tanu Singh
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Manoj Kumar
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Tanu Singh.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Singh, T., Kumar, M. Investigating Requirements Completeness Metrics for Requirements Schemas Using Requirements Engineering Approach of Data Warehouse: A Formal and Empirical Validation. Arab J Sci Eng 47, 9527–9546 (2022). https://doi.org/10.1007/s13369-021-06269-0

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s13369-021-06269-0

Keywords

Search

Navigation