{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,3]],"date-time":"2025-03-03T05:46:19Z","timestamp":1740980779910,"version":"3.38.0"},"reference-count":50,"publisher":"IGI Global","issue":"1","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2011,1,1]]},"abstract":"<p>To customize a data warehouse, many organizations develop concrete data marts focused on a particular department or business process. However, the integrated development of these data marts is an open problem for many organizations due to the technical and organizational challenges involved during the design of these repositories as a complete solution. In this article, the authors present a design approach that employs user requirements to build both corporate data warehouses and data marts in an integrated manner. The approach links information requirements to specific data marts elicited by using goal-oriented requirement engineering, which are automatically translated into the implementation of corresponding data repositories by means of model-driven engineering techniques. The authors provide two UML profiles that integrate the design of both data warehouses and data marts and a set of QVT transformations with which to automate this process. The advantage of this approach is that user requirements are captured from the early development stages of a data-warehousing project to automatically translate them into the entire data-warehousing platform, considering the different data marts. Finally, the authors provide screenshots of the CASE tools that support the approach, and a case study to show its benefits.<\/p>","DOI":"10.4018\/jdm.2011010103","type":"journal-article","created":{"date-parts":[[2011,2,15]],"date-time":"2011-02-15T20:26:52Z","timestamp":1297801612000},"page":"43-68","source":"Crossref","is-referenced-by-count":2,"title":["An MDA Approach and QVT Transformations for the Integrated Development of Goal-Oriented Data Warehouses and Data Marts"],"prefix":"10.4018","volume":"22","author":[{"given":"Jes\u00fas","family":"Pardillo","sequence":"first","affiliation":[{"name":"University of Alicante, Spain"}]},{"given":"Jose-Norberto","family":"Maz\u00f3n","sequence":"additional","affiliation":[{"name":"University of Alicante, Spain"}]},{"given":"Juan","family":"Trujillo","sequence":"additional","affiliation":[{"name":"University of Alicante, Spain"}]}],"member":"2432","reference":[{"key":"jdm.2011010103-0","doi-asserted-by":"crossref","unstructured":"Abell\u00f3, A., Samos, J., & Saltor, F. (2002, November 8). On relationships offering new drill-across possibilities. In Proceedings of the ACM Fifth International Workshop on Data Warehousing and OLAP, McLean, VA (pp. 7-13).","DOI":"10.1145\/583890.583892"},{"key":"jdm.2011010103-1","doi-asserted-by":"publisher","DOI":"10.1016\/j.is.2004.12.002"},{"key":"jdm.2011010103-2","doi-asserted-by":"publisher","DOI":"10.1016\/0378-7206(95)00017-Q"},{"key":"jdm.2011010103-3","doi-asserted-by":"crossref","unstructured":"B\u00e9zivin, J. (2006, July 4-8). Model Driven Engineering: An Emerging Technical Space. In Proceedings of the Generative and Transformational Techniques in Software Engineering, International Summer School, Braga, Portugal (LNCS 4143, pp. 36-64).","DOI":"10.1007\/11877028_2"},{"key":"jdm.2011010103-4","doi-asserted-by":"publisher","DOI":"10.1145\/384189.384190"},{"issue":"1","key":"jdm.2011010103-5","first-page":"6","article-title":"Data Warehousing Battle of the Giants: Comparing the Basics of the Kimball and Inmon Models.","volume":"9","author":"M.Breslin","year":"2004","journal-title":"Business Intelligence Journal"},{"key":"jdm.2011010103-6","doi-asserted-by":"publisher","DOI":"10.1142\/S0218843001000394"},{"key":"jdm.2011010103-7","doi-asserted-by":"crossref","unstructured":"Cabibbo, L., & Torlone, R. (2004, June 21-23). On the Integration of Autonomous Data Marts. In Proceedings of the 16th International Conference on Scientific and Statistical Database Management, Santorini Island, Greece (pp. 223-231). Washington, DC: IEEE Computer Society.","DOI":"10.1109\/SSDM.2004.1311214"},{"key":"jdm.2011010103-8","doi-asserted-by":"publisher","DOI":"10.1145\/248603.248616"},{"issue":"4","key":"jdm.2011010103-9","doi-asserted-by":"crossref","first-page":"21","DOI":"10.4018\/jdm.2008100102","article-title":"Evaluation of mde tools from a metamodeling perspective.","volume":"19","author":"J.De Sousa Saraiva","year":"2008","journal-title":"Journal of Database Management"},{"issue":"3","key":"jdm.2011010103-10","doi-asserted-by":"crossref","first-page":"55","DOI":"10.4018\/jdm.2008070104","article-title":"Theories of meaning in schema matching: A review.","volume":"19","author":"J.Evermann","year":"2008","journal-title":"Journal of Database Management"},{"key":"jdm.2011010103-11","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2006.12.001"},{"key":"jdm.2011010103-12","doi-asserted-by":"publisher","DOI":"10.1142\/S0218843098000118"},{"key":"jdm.2011010103-13","doi-asserted-by":"crossref","unstructured":"Horner, J., Song, I. Y., & Chen, P. P. (2004, November 12-13). An analysis of additivity in OLAP systems. In Proceedings of the ACM Seventh International Workshop on Data Warehousing and OLAP, Washington, DC (pp. 83-91).","DOI":"10.1145\/1031763.1031779"},{"key":"jdm.2011010103-14","doi-asserted-by":"crossref","unstructured":"Hurtado, C. A., Mendelzon, A. O., & Vaisman, A. A. (1999, November 6). Updating OLAP Dimensions. In Proceedings of the ACM Second International Workshop on Data Warehousing and OLAP, Kansas City, MO (pp. 60-66).","DOI":"10.1145\/319757.319791"},{"key":"jdm.2011010103-15","unstructured":"H\u00fcsemann, B., Lechtenb\u00f6rger, J., & Vossen, G. (2000). Conceptual Data Warehouse Modeling. In Proceedings of the 2nd International Workshop on Design and Management of Data Warehouses (DMDW\u201900), Stockholm, Sweden (pp. 6.1-6.11)."},{"journal-title":"Building the Data Warehouse","year":"2005","author":"W. H.Inmon","key":"jdm.2011010103-16"},{"key":"jdm.2011010103-17","doi-asserted-by":"publisher","DOI":"10.1016\/S0306-4379(99)00017-4"},{"key":"jdm.2011010103-18","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2006.12.004"},{"key":"jdm.2011010103-19","doi-asserted-by":"publisher","DOI":"10.1145\/1121949.1121952"},{"journal-title":"The Soul of the Data Warehouse, Part Two: Drilling Across","year":"2003","author":"R.Kimball","key":"jdm.2011010103-20"},{"journal-title":"The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling","year":"2002","author":"R.Kimball","key":"jdm.2011010103-21"},{"issue":"2","key":"jdm.2011010103-22","first-page":"12","article-title":"Applying the UML and the Unified Process to the design of Data Warehouses.","volume":"17","author":"S.Luj\u00e1n-Mora","year":"2006","journal-title":"Journal of Computer Information Systems"},{"issue":"2","key":"jdm.2011010103-23","doi-asserted-by":"crossref","first-page":"12","DOI":"10.4018\/jdm.2006040102","article-title":"Physical modeling of data warehouses using uml component and deployment diagrams: Design and implementation issues.","volume":"17","author":"S.Luj\u00e1n-Mora","year":"2006","journal-title":"Journal of Database Management"},{"key":"jdm.2011010103-24","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2005.11.004"},{"key":"jdm.2011010103-25","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2005.08.003"},{"key":"jdm.2011010103-26","doi-asserted-by":"crossref","unstructured":"Maz\u00f3n, J. N., Pardillo, J., & Trujillo, J. (2006, September 4-8). Applying Transformations to Model Driven Data Warehouses. In Proceedings of the 8th International Conference on Data Warehousing and Knowledge Discovery, Krakow, Poland (LNCS 4081, pp. 13-22).","DOI":"10.1007\/11823728_2"},{"key":"jdm.2011010103-27","doi-asserted-by":"crossref","unstructured":"Maz\u00f3n, J. N., Pardillo, J., & Trujillo, J. (2007, November 5-9). A Model-Driven Goal-Oriented Requirement Engineering Approach for Data Warehouses. In Proceedings of the International Workshop on Requirements, Intentions and Goals in Conceptual Modelling, Auckland, New Zealand (LNCS 4802, pp. 255-264).","DOI":"10.1007\/978-3-540-76292-8_31"},{"key":"jdm.2011010103-28","doi-asserted-by":"crossref","unstructured":"Maz\u00f3n, J. N., & Trujillo, J. (2007, November 5-9). A Model Driven Modernization Approach for Automatically Deriving Multidimensional Models in Data Warehouses. In Proceedings of the 26th International Conference on Conceptual Modeling (ER 2007), Auckland, New Zealand (LNCS 4801, pp. 56-71).","DOI":"10.1007\/978-3-540-75563-0_6"},{"key":"jdm.2011010103-29","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2006.12.003"},{"key":"jdm.2011010103-30","doi-asserted-by":"publisher","DOI":"10.1145\/1815918.1815920"},{"key":"jdm.2011010103-31","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2007.04.004"},{"key":"jdm.2011010103-32","unstructured":"Moody, D. L., & Kortink, M. A. R. (2000). From enterprise models to dimensional models: a methodology for data warehouse and data mart design. In Proceedings of the 2nd International Workshop on Design and Management of Data Warehouses (DMDW\u201900), Stockholm, Sweden (pp. 5.1-5.11)."},{"key":"jdm.2011010103-33","doi-asserted-by":"crossref","unstructured":"Niemi, T., Nummenmaa, J., & Thanisch, P. (2001, November 9). Constructing OLAP Cubes Based on Queries. In Proceedings of the Fourth International Workshop on Data Warehousing and OLAP, Atlanta, GA (pp. 9-11).","DOI":"10.1145\/512236.512238"},{"key":"jdm.2011010103-34","unstructured":"Object Management Group (OMG). (2008). Model Driven Architecture (MDA), Unified Modeling Language (UML), Common Warehouse Metamodel (CWM), Query\/View\/Transformation Language (QVT), MOF Model to Text Transformation Language (Mof2Text). Retrieved from http:\/\/www.omg.org"},{"key":"jdm.2011010103-35","unstructured":"Paim, F. R. S., & Castro, J. (2002). Enhancing Data Warehouse Design with the NFR Framework. In Proceedings of the Workshop em Engenharia de Requisitos (WER), Valencia, Spain (pp. 40-57)."},{"key":"jdm.2011010103-36","unstructured":"Pardillo, J., Maz\u00f3n, J. N., & Trujillo, J. (2008, July 7-10). Model-driven OLAP Metadata for Data Warehouses. In Proceedings of the 25th British National Conference on Databases, BNCOD 25, Cardiff, UK (LNCS 5071, pp. 203-206)."},{"key":"jdm.2011010103-37","doi-asserted-by":"crossref","unstructured":"Pardillo, J., & Trujillo, J. (2008, October 20-24). Integrated Model-Driven Development of Goal-Oriented Data Warehouses and Data Marts. In Proceedings of the 27th International Conference on Conceptual Modeling (ER 2008), Barcelona, Spain (LNCS 52I31, pp. 426-439).","DOI":"10.1007\/978-3-540-87877-3_31"},{"key":"jdm.2011010103-38","doi-asserted-by":"crossref","unstructured":"Pedersen, T. B. (2004, September 1-3). How Is BI Used in Industry?: Report from a Knowledge Exchange Network. In Proceedings of the 6th International Conference on Data Warehousing and Knowledge Discovery, Zaragoza, Spain (LNCS 3181, pp. 179-188).","DOI":"10.1007\/978-3-540-30076-2_18"},{"key":"jdm.2011010103-39","doi-asserted-by":"publisher","DOI":"10.1007\/s00766-007-0057-x"},{"key":"jdm.2011010103-40","doi-asserted-by":"crossref","unstructured":"Samos, J., Saltor, F., Sistac, J., & Bard\u00e9s, A. (1998, August 24-28). Database Architecture for Data Warehousing: An Evolutionary Approach. In Proceedings of the 9th International Conference on Database and Expert Systems Applications (DEXA), Vienna, Austria (LNCS 1460, pp. 746-756).","DOI":"10.1007\/BFb0054530"},{"key":"jdm.2011010103-41","doi-asserted-by":"publisher","DOI":"10.1145\/1047671.1047673"},{"key":"jdm.2011010103-42","doi-asserted-by":"crossref","unstructured":"Serrano, M., Trujillo, J., Calero, C., Luj\u00e1n, S., & Piattini, M. (2004, June 7-11). Empirical Validation of Metrics for Conceptual Models of Data Warehouses. In Proceedings of the 16th International Conference on Advanced Information Systems Engineering (CAiSE 2004), Riga, Latvia (LNCS 3084, pp. 506-520).","DOI":"10.1007\/978-3-540-25975-6_36"},{"key":"jdm.2011010103-43","doi-asserted-by":"publisher","DOI":"10.1016\/j.infsof.2006.09.008"},{"issue":"1","key":"jdm.2011010103-44","doi-asserted-by":"crossref","first-page":"26","DOI":"10.4018\/jdm.2001010103","article-title":"Unified modeling language: A complexity analysis.","volume":"12","author":"K.Siau","year":"2001","journal-title":"Journal of Database Management"},{"issue":"1","key":"jdm.2011010103-45","first-page":"33","article-title":"Balancing Strategy and Tactics in Project Implementation.","volume":"29","author":"D. P.Slevin","year":"1987","journal-title":"Sloan Management Review"},{"key":"jdm.2011010103-46","unstructured":"Vassiliadis, P. (2000). Gulliver in the land of data warehousing: practical experiences and observations of a researcher. In Proceedings of the 2nd International Workshop on Design and Management of Data Warehouses (DMDW\u201900), Stockholm, Sweden (pp. 12.1-12.11)."},{"key":"jdm.2011010103-47","doi-asserted-by":"publisher","DOI":"10.1201\/1078\/43194.18.1.20010101\/31264.6"},{"key":"jdm.2011010103-48","doi-asserted-by":"crossref","unstructured":"Yu, E. S. K., & Mylopoulos, J. (1994, May 16-21). Understanding \u201cWhy\u201d in Software Process Modelling, Analysis, and Design. In Proceedings of the 16th International Conference on Software Engineering (ICSE), Sorrento, Italy (pp. 159-168).","DOI":"10.1109\/ICSE.1994.296775"},{"issue":"3","key":"jdm.2011010103-49","doi-asserted-by":"crossref","first-page":"69","DOI":"10.4018\/jdm.2007070104","article-title":"Information mediation using metamodels: An approach using XML and Common Warehouse Metamodel.","volume":"18","author":"L.Zhao","year":"2007","journal-title":"Journal of Database Management"}],"container-title":["Journal of Database Management"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=49723","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,3,2]],"date-time":"2025-03-02T16:52:57Z","timestamp":1740934377000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/jdm.2011010103"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2011,1,1]]},"references-count":50,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2011,1]]}},"URL":"https:\/\/doi.org\/10.4018\/jdm.2011010103","relation":{},"ISSN":["1063-8016","1533-8010"],"issn-type":[{"type":"print","value":"1063-8016"},{"type":"electronic","value":"1533-8010"}],"subject":[],"published":{"date-parts":[[2011,1,1]]}}}