{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,4]],"date-time":"2026-03-04T16:51:34Z","timestamp":1772643094004,"version":"3.50.1"},"reference-count":31,"publisher":"Association for Computing Machinery (ACM)","issue":"5","license":[{"start":{"date-parts":[[2014,9,17]],"date-time":"2014-09-17T00:00:00Z","timestamp":1410912000000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["SIGSOFT Softw. Eng. Notes"],"published-print":{"date-parts":[[2014,9,17]]},"abstract":"<jats:p>In recent years, Data Warehouses have become essential for researchers and organizations due to their ability to model the near future. For making strategic decisions, the information stored in a data warehouse must be of good quality. The information quality of a data warehouse can be enhanced by determining the data-model quality used for developing the data warehouse. Multidimensional models have been widely accepted as the foundation of data-modeling. Therefore, we believe that improving multi-dimensional model quality could improve the data warehouse quality. Several quality features (such as understandability, simplicity, maintainability, analyzability, coupling, cohesion etc.) have been defined by researchers for measuring the quality of data models. To judge Multidimensional model quality, metrics can be used as they provide a way for evaluating quality in an objective and consistent manner. A few researchers have proposed metrics for the data warehouse multidimensional model. Though, along with the proposal of metrics, they must be validated (theoretically and empirically) to prove their reliability and practical usefulness. This paper focuses on empirical validation of data warehouse logical model metrics using the data-mining machine-learning technique known as decision tree analysis. The results obtained indicate that a few of the proposed metrics are useful in judging the quality of the multidimensional logical model in terms of understandability.<\/jats:p>","DOI":"10.1145\/2659118.2659131","type":"journal-article","created":{"date-parts":[[2014,9,19]],"date-time":"2014-09-19T12:27:17Z","timestamp":1411129637000},"page":"1-6","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":12,"title":["Assessing the understandability of a data warehouse logical model using a decision-tree approach"],"prefix":"10.1145","volume":"39","author":[{"given":"Hunny","family":"Gaur","sequence":"first","affiliation":[{"name":"Ambedkar Institute of Advanced Communication Technologies &amp; Research, Delhi, India"}]},{"given":"Manoj","family":"Kumar","sequence":"additional","affiliation":[{"name":"Ambedkar Institute of Advanced Communication Technologies &amp; Research, Delhi, India"}]}],"member":"320","published-online":{"date-parts":[[2014,9,17]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/319757.319776"},{"key":"e_1_2_1_2_1","volume-title":"IEE Proceedings.","volume":"149","author":"Serrano M."},{"key":"e_1_2_1_3_1","volume-title":"Proceedings of the international workshop on design and management of data warehouses","author":"Calero C."},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.infsof.2006.09.008"},{"key":"e_1_2_1_5_1","first-page":"506","article-title":"Empirical validation of metrics for conceptual models of data warehouses","volume":"3084","author":"Serrano M.","year":"2004","journal-title":"CAiSE LNCS"},{"key":"e_1_2_1_6_1","unstructured":"Boman M. Bubenko J. Johannesson P. and B. Wangler. 1997. Conceptual modelling. Prantice Hall.   Boman M. Bubenko J. Johannesson P. and B. Wangler. 1997. Conceptual modelling. Prantice Hall."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1109\/32.6178"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1109\/32.481535"},{"key":"e_1_2_1_9_1","doi-asserted-by":"crossref","volume-title":"A Framework of Software Measurement","author":"Zuse H.","DOI":"10.1515\/9783110807301"},{"key":"e_1_2_1_10_1","volume-title":"Proceedings of the 36th Hawaii international conference on system science. DOI: 10","author":"Serrano M.","year":"2003"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1007\/s11219-007-9030-7"},{"key":"e_1_2_1_12_1","volume-title":"Proceedings of international conference on advances in computer science. ACEEE.","author":"Gosain A."},{"key":"e_1_2_1_13_1","first-page":"384","article-title":"Analysis of Data warehouse quality metrics using LR. ICT","volume":"101","author":"Gupta R.","year":"2010","journal-title":"CCIS"},{"key":"e_1_2_1_14_1","first-page":"320","article-title":"Empirical validation of object oriented data warehouse design quality metrics. ACITY","volume":"198","author":"Gupta J.","year":"2011","journal-title":"CCIS"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-27872-3_25"},{"key":"e_1_2_1_16_1","article-title":"Predicting the quality of object oriented multidimensional (OOMD) model of data warehouse using fuzzy logic technique","volume":"2","author":"Ali K.B.","year":"2012","journal-title":"International Journal of Engineering Science & Advanced Technology"},{"key":"#cr-split#-e_1_2_1_17_1.1","doi-asserted-by":"crossref","unstructured":"Gosain A. Nagpal S. and Sabharwal S. 2013. Validating dimension hierarchy metrics for the understandability of multidimensional models for data warehouse. IET software. Volume 7 Issue 2 93--103. DOI: 10.1049\/iet-sen.2012.0095. 10.1049\/iet-sen.2012.0095","DOI":"10.1049\/iet-sen.2012.0095"},{"key":"#cr-split#-e_1_2_1_17_1.2","doi-asserted-by":"crossref","unstructured":"Gosain A. Nagpal S. and Sabharwal S. 2013. Validating dimension hierarchy metrics for the understandability of multidimensional models for data warehouse. IET software. Volume 7 Issue 2 93--103. DOI: 10.1049\/iet-sen.2012.0095.","DOI":"10.1049\/iet-sen.2012.0095"},{"key":"#cr-split#-e_1_2_1_18_1.1","doi-asserted-by":"crossref","unstructured":"Kumar M. Gosain A. and Singh Y. 2013. Empirical validation of structural metrics for predicting understandability of conceptual schemas for data warehouse. International Journal of System Assurance Engineering & Management Springer. DOI: 10.1007\/s13198-013-0159-4. 10.1007\/s13198-013-0159-4","DOI":"10.1007\/s13198-013-0159-4"},{"key":"#cr-split#-e_1_2_1_18_1.2","doi-asserted-by":"crossref","unstructured":"Kumar M. Gosain A. and Singh Y. 2013. Empirical validation of structural metrics for predicting understandability of conceptual schemas for data warehouse. International Journal of System Assurance Engineering & Management Springer. DOI: 10.1007\/s13198-013-0159-4.","DOI":"10.1007\/s13198-013-0159-4"},{"key":"#cr-split#-e_1_2_1_19_1.1","doi-asserted-by":"crossref","unstructured":"Gosain A. and Mann S. 2013. Empirical validation of metrics for object oriented multidimensional model for data warehouse. International Journal of System Assurance Engineering & Management Springer. DOI: 10.1007\/s13198-013-0155-8. 10.1007\/s13198-013-0155-8","DOI":"10.1007\/s13198-013-0155-8"},{"key":"#cr-split#-e_1_2_1_19_1.2","doi-asserted-by":"crossref","unstructured":"Gosain A. and Mann S. 2013. Empirical validation of metrics for object oriented multidimensional model for data warehouse. International Journal of System Assurance Engineering & Management Springer. DOI: 10.1007\/s13198-013-0155-8.","DOI":"10.1007\/s13198-013-0155-8"},{"key":"#cr-split#-e_1_2_1_20_1.1","doi-asserted-by":"crossref","unstructured":"Nagpal S. Gosain A. and Sabharwal S. 2013. Theoretical and empirical validation of comprehensive complexity metric for multidimensional models for data warehouse. International Journal of System Assurance Engineering & Management. 193--204 Springer. DOI: 10.1007\/s13198-013-0158-5. 10.1007\/s13198-013-0158-5","DOI":"10.1007\/s13198-013-0158-5"},{"key":"#cr-split#-e_1_2_1_20_1.2","doi-asserted-by":"crossref","unstructured":"Nagpal S. Gosain A. and Sabharwal S. 2013. Theoretical and empirical validation of comprehensive complexity metric for multidimensional models for data warehouse. International Journal of System Assurance Engineering & Management. 193--204 Springer. DOI: 10.1007\/s13198-013-0158-5.","DOI":"10.1007\/s13198-013-0158-5"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.1984.5010301"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1109\/32.6156"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/1988997.1989015"},{"key":"e_1_2_1_24_1","unstructured":"El Emamk. Benlarbi S. Goel N. and Rai S.1999. A validation of object oriented metrics NRC Technical report ERB-1063.  El Emamk. Benlarbi S. Goel N. and Rai S.1999. A validation of object oriented metrics NRC Technical report ERB-1063."},{"key":"e_1_2_1_25_1","volume-title":"Data Mining: Concepts and Techniques","author":"Han J.","year":"2006"},{"key":"e_1_2_1_26_1","doi-asserted-by":"crossref","unstructured":"Witten IH. and Frank E. 2011. Data mining: practical machine learning tools and techniques with java implementations. Morgan Kaufman\/Addison-Wesley San Francisco.  Witten IH. and Frank E. 2011. Data mining: practical machine learning tools and techniques with java implementations. Morgan Kaufman\/Addison-Wesley San Francisco.","DOI":"10.1016\/B978-0-12-374856-0.00006-7"},{"key":"e_1_2_1_27_1","volume-title":"A methodology for validating software product metrics","author":"Emam K.E."}],"container-title":["ACM SIGSOFT Software Engineering Notes"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2659118.2659131","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/2659118.2659131","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T06:13:26Z","timestamp":1750227206000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2659118.2659131"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2014,9,17]]},"references-count":31,"journal-issue":{"issue":"5","published-print":{"date-parts":[[2014,9,17]]}},"alternative-id":["10.1145\/2659118.2659131"],"URL":"https:\/\/doi.org\/10.1145\/2659118.2659131","relation":{},"ISSN":["0163-5948"],"issn-type":[{"value":"0163-5948","type":"print"}],"subject":[],"published":{"date-parts":[[2014,9,17]]},"assertion":[{"value":"2014-09-17","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}