{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,3]],"date-time":"2026-02-03T20:45:50Z","timestamp":1770151550107,"version":"3.49.0"},"reference-count":56,"publisher":"Springer Science and Business Media LLC","issue":"1","license":[{"start":{"date-parts":[[2020,4,11]],"date-time":"2020-04-11T00:00:00Z","timestamp":1586563200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2020,4,11]],"date-time":"2020-04-11T00:00:00Z","timestamp":1586563200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Requirements Eng"],"published-print":{"date-parts":[[2021,3]]},"DOI":"10.1007\/s00766-020-00331-3","type":"journal-article","created":{"date-parts":[[2020,4,11]],"date-time":"2020-04-11T16:02:26Z","timestamp":1586620946000},"page":"43-65","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":15,"title":["Requirements-driven data warehouse design based on enhanced pivot tables"],"prefix":"10.1007","volume":"26","author":[{"given":"Sandro","family":"Bimonte","sequence":"first","affiliation":[]},{"given":"Leandro","family":"Antonelli","sequence":"additional","affiliation":[]},{"given":"Stefano","family":"Rizzi","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2020,4,11]]},"reference":[{"key":"331_CR1","unstructured":"Arnold D, Corriveau J, Shi W (2010) Modeling and validating requirements using executable contracts and scenarios. In: Proceedings eighth ACIS international conference on software engineering research, management and applications, pp 311\u2013320"},{"key":"331_CR2","first-page":"54","volume":"2012","author":"T Benker","year":"2012","unstructured":"Benker T, J\u00fcrck C (2012) A case study on model-driven data warehouse development. Proc DaWaK 2012:54\u201364","journal-title":"Proc DaWaK"},{"key":"331_CR3","doi-asserted-by":"crossref","unstructured":"Bimonte S, Edoh-Alove E, Nazih H, Kang M, Rizzi S (2013) ProtOLAP: rapid OLAP prototyping with on-demand data supply. In: Proceedings of the sixteenth international workshop on data warehousing and OLAP, ACM, pp 61\u201366","DOI":"10.1145\/2513190.2513199"},{"key":"331_CR4","unstructured":"Bimonte S, Sakka A, Sautot L (2018) A new methodology for elicitation of datawarehouse requirements based on the pivot table formalism. In: Proceedings of 14eme edition de la conference EDA, pp 263\u2013272"},{"key":"331_CR5","unstructured":"Bimonte S, Rizzi S, Sautot L, Fontaine B (2019) Volunteered multidimensional design to the test: The farmland bio-diversity VGI4Bio project\u2019s experiment. In: Proceedings of the 21st international workshop on design, optimization, languages and analytical processing of big data"},{"issue":"4","key":"331_CR6","doi-asserted-by":"publisher","first-page":"452","DOI":"10.1145\/384189.384190","volume":"10","author":"A Bonifati","year":"2001","unstructured":"Bonifati A, Cattaneo F, Ceri S, Fuggetta A, Paraboschi S (2001) Designing data marts for data warehouses. ACM Trans Softw Eng Methodol 10(4):452\u2013483","journal-title":"ACM Trans Softw Eng Methodol"},{"key":"331_CR7","doi-asserted-by":"publisher","first-page":"113","DOI":"10.1016\/j.csi.2014.06.004","volume":"38","author":"K Boulil","year":"2015","unstructured":"Boulil K, Bimonte S, Pinet F (2015) Conceptual model for spatial data cubes: a UML profile and its automatic implementation. Comput Stand Interfaces 38:113\u2013132","journal-title":"Comput Stand Interfaces"},{"issue":"3","key":"331_CR8","doi-asserted-by":"publisher","first-page":"203","DOI":"10.1023\/B:AGNT.0000018806.20944.ef","volume":"8","author":"P Bresciani","year":"2004","unstructured":"Bresciani P, Perini A, Giorgini P, Giunchiglia F, Mylopoulos J (2004) Tropos: an agent-oriented software development methodology. Auton Agent Multi Agent Syst 8(3):203\u2013236","journal-title":"Auton Agent Multi Agent Syst"},{"key":"331_CR9","unstructured":"Bruckner R, List B, Schiefer J (2001) Developing requirements for data warehouse systems with use cases. In: Proceedings 7th Americas conference on information systems, pp 329\u2013335"},{"issue":"3","key":"331_CR10","doi-asserted-by":"publisher","first-page":"103","DOI":"10.1016\/S0378-7206(99)00042-7","volume":"37","author":"L Chen","year":"2000","unstructured":"Chen L, Soliman K, Mao E, Frolick M (2000) Measuring user satisfaction with data warehouses: an exploratory study. Inf Manag 37(3):103\u2013110","journal-title":"Inf Manag"},{"key":"331_CR11","doi-asserted-by":"publisher","first-page":"44","DOI":"10.1016\/j.is.2017.11.004","volume":"79","author":"ML Chouder","year":"2019","unstructured":"Chouder ML, Rizzi S, Chalal R (2019) EXODuS: exploratory OLAP over document stores. Inf Syst 79:44\u201357","journal-title":"Inf Syst"},{"issue":"4","key":"331_CR12","doi-asserted-by":"publisher","first-page":"360","DOI":"10.1016\/j.infsof.2011.11.004","volume":"54","author":"F Di Tria","year":"2012","unstructured":"Di Tria F, Lefons E, Tangorra F (2012) Hybrid methodology for data warehouse conceptual design by UML schemas. Inf Softw Technol 54(4):360\u2013379","journal-title":"Inf Softw Technol"},{"key":"331_CR13","doi-asserted-by":"crossref","unstructured":"Diamantini C, Genga L, Potena D, Storti E (2014) Collaborative building of an ontology of key performance indicators. In: Proceedings conference on the move to meaningful internet systems, pp 148\u2013165","DOI":"10.1007\/978-3-662-45563-0_9"},{"key":"331_CR14","doi-asserted-by":"crossref","unstructured":"Elamin E, Alshomrani S, Feki J (2017) SSReq: a method for designing star schemas from decisional requirements. In: Proceedings international conference on communication, control, computing and electronics engineering, pp 1\u20137","DOI":"10.1109\/ICCCCEE.2017.7867645"},{"key":"331_CR15","doi-asserted-by":"publisher","first-page":"86","DOI":"10.1016\/j.is.2018.06.004","volume":"77","author":"E Gallinucci","year":"2018","unstructured":"Gallinucci E, Golfarelli M, Rizzi S, Abell\u00f3 A, Romero O (2018) Interactive multidimensional modeling of linked data for exploratory OLAP. Inf Syst 77:86\u2013104","journal-title":"Inf Syst"},{"issue":"1","key":"331_CR16","doi-asserted-by":"publisher","first-page":"4","DOI":"10.1016\/j.dss.2006.12.001","volume":"45","author":"P Giorgini","year":"2008","unstructured":"Giorgini P, Rizzi S, Garzetti M (2008) GRAnD: a goal-oriented approach to requirement analysis in data warehouses. Decis Support Syst 45(1):4\u201321","journal-title":"Decis Support Syst"},{"issue":"2\u20133","key":"331_CR17","doi-asserted-by":"publisher","first-page":"215","DOI":"10.1142\/S0218843098000118","volume":"7","author":"M Golfarelli","year":"1998","unstructured":"Golfarelli M, Maio D, Rizzi S (1998) The dimensional fact model: a conceptual model for data warehouses. Int J Coop Inf Syst 7(2\u20133):215\u2013247","journal-title":"Int J Coop Inf Syst"},{"issue":"11","key":"331_CR18","doi-asserted-by":"publisher","first-page":"1183","DOI":"10.1016\/j.infsof.2011.04.002","volume":"53","author":"M Golfarelli","year":"2011","unstructured":"Golfarelli M, Rizzi S (2011) Data warehouse testing: a prototype-based methodology. Inf Softw Technol 53(11):1183\u20131198","journal-title":"Inf Softw Technol"},{"key":"331_CR19","doi-asserted-by":"crossref","unstructured":"Golfarelli M, Rizzi S, Turricchia E (2011b) Modern software engineering methodologies meet data warehouse design: 4WD. In: Proceedings of 13th international conference on data warehousing and knowledge discovery, Springer, pp 66\u201379","DOI":"10.1007\/978-3-642-23544-3_6"},{"key":"331_CR20","doi-asserted-by":"crossref","unstructured":"Gosain A, Heena (2015) Literature review of data model quality metrics of data warehouse. In: Proceedings international conference on intelligent computing, communication & convergence, pp 236\u2013243","DOI":"10.1016\/j.procs.2015.04.176"},{"key":"331_CR21","doi-asserted-by":"crossref","unstructured":"Guo Y, Tang S, Tong Y, Yang D (2006) Triple-driven data modeling methodology in data warehousing: a case study. In: Proceedings 9th international workshop on data warehousing and OLAP, pp 59\u201366","DOI":"10.1145\/1183512.1183524"},{"key":"331_CR22","doi-asserted-by":"publisher","first-page":"285","DOI":"10.1007\/s00766-015-0221-7","volume":"21","author":"J Hassine","year":"2016","unstructured":"Hassine J, Amyot D (2016) A questionnaire-based survey methodology for systematically validating goal-oriented models. Requir Eng 21:285\u2013308","journal-title":"Requir Eng"},{"key":"331_CR23","doi-asserted-by":"publisher","first-page":"133","DOI":"10.1007\/s00766-017-0280-z","volume":"24","author":"J Horkoff","year":"2019","unstructured":"Horkoff J et al (2019) Goal-oriented requirements engineering: an extended systematic mapping study. Requir Eng 24:133\u2013160","journal-title":"Requir Eng"},{"key":"331_CR24","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1016\/S0167-9236(02)00191-4","volume":"37","author":"H-G Hwang","year":"2004","unstructured":"Hwang H-G, Ku C-Y, Yen DC, Cheng C-C (2004) Critical factors influencing the adoption of data warehouse technology: a study of the banking industry in Taiwan. Decis Support Syst 37:1\u201321","journal-title":"Decis Support Syst"},{"key":"331_CR25","first-page":"1","volume":"2","author":"MI Hwang","year":"2007","unstructured":"Hwang MI, Xu H (2007) The effect of implementation factors on data warehousing success : an exploratory study. J Inf Inf Technol Org 2:1\u201316","journal-title":"J Inf Inf Technol Org"},{"issue":"4","key":"331_CR26","doi-asserted-by":"publisher","first-page":"377","DOI":"10.2498\/cit.1001920","volume":"18","author":"N Jukic","year":"2010","unstructured":"Jukic N, Nicholas J (2010) A framework for collecting and defining requirements for data warehousing projects. CIT 18(4):377\u2013384","journal-title":"CIT"},{"key":"331_CR27","doi-asserted-by":"crossref","unstructured":"Kaldeich C, e S\u00e1 JO (2004) Data warehouse methodology: a process driven approach. In: Proceedings 16th international conference on advanced information systems engineering, Springer, pp 536\u2013549","DOI":"10.1007\/978-3-540-25975-6_38"},{"key":"331_CR28","doi-asserted-by":"crossref","unstructured":"Kamalrudin M, Grundy J (2011) Generating essential user interface prototypes to validate requirements. In: Proceedings 26th IEEE\/ACM international conference on automated software engineering, pp 564\u2013567","DOI":"10.1109\/ASE.2011.6100126"},{"key":"331_CR29","volume-title":"The data warehouse toolkit: the complete guide to dimensional modeling","author":"R Kimball","year":"2002","unstructured":"Kimball R, Ross M (2002) The data warehouse toolkit: the complete guide to dimensional modeling, 2nd edn. Wiley, Hoboken","edition":"2"},{"issue":"3","key":"331_CR30","first-page":"385","volume":"6","author":"M Kumar","year":"2010","unstructured":"Kumar M, Gosain A, Singh Y (2010) Stakeholders driven requirements engineering approach for data warehouse development. JIPS 6(3):385\u2013402","journal-title":"JIPS"},{"issue":"5","key":"331_CR31","doi-asserted-by":"publisher","first-page":"415","DOI":"10.1016\/S0306-4379(02)00024-8","volume":"28","author":"L Lechtenb\u00f6rger","year":"2003","unstructured":"Lechtenb\u00f6rger L (2003) Vossen G (2003) Multidimensional normal forms for data warehouse design. Inf Syst 28(5):415\u2013434","journal-title":"Inf Syst"},{"key":"331_CR32","volume-title":"Advanced data warehouse design\u2014from conventional to spatial and temporal applications. Data-centric systems and applications","author":"M Malinowski","year":"2008","unstructured":"Malinowski M, Zim\u00e1nyi E (2008) Advanced data warehouse design\u2014from conventional to spatial and temporal applications. Data-centric systems and applications. Springer, Berlin"},{"key":"331_CR33","unstructured":"Martinez A, Pastor O, Mylopoulos J, Giorgini P (2006) From early to late requirements: a goal-based approach. In: Proceedings workshop on agent-oriented information systems, pp 123\u2013142"},{"issue":"2","key":"331_CR34","doi-asserted-by":"publisher","first-page":"12","DOI":"10.1145\/1815918.1815920","volume":"38","author":"J Maz\u00f3n","year":"2009","unstructured":"Maz\u00f3n J, Trujillo J (2009) A hybrid model driven development framework for the multidimensional modeling of data warehouses. SIGMOD Record 38(2):12\u201317","journal-title":"SIGMOD Record"},{"issue":"3","key":"331_CR35","doi-asserted-by":"publisher","first-page":"725","DOI":"10.1016\/j.datak.2007.04.004","volume":"63","author":"J Maz\u00f3n","year":"2007","unstructured":"Maz\u00f3n J, Trujillo J, Lechtenboerger J (2007) Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms. Data Knowl Eng 63(3):725\u2013751","journal-title":"Data Knowl Eng"},{"key":"331_CR36","unstructured":"Maz\u00f3n J, Trujillo J, Serrano MA, Piattini M (2005) Designing data warehouses: From business requirement analysis to multidimensional modeling. In: Proceedings of 1st international workshop on requirements engineering for business need and IT alignment, pp 44\u201353"},{"key":"331_CR37","doi-asserted-by":"crossref","unstructured":"Nabli A, Feki J, Gargouri F (2005) Automatic construction of multidimensional schema from OLAP requirements. In: Proceedings of international conference on computer systems and applications, p 28","DOI":"10.1109\/AICCSA.2005.1387025"},{"key":"331_CR38","first-page":"141","volume":"25","author":"R Nair","year":"2007","unstructured":"Nair R, Campbell W, Srinivasan B (2007) A conceptual query-driven design framework for data warehouse. World Acad Sci Eng Technol 25:141\u2013146","journal-title":"World Acad Sci Eng Technol"},{"key":"331_CR39","doi-asserted-by":"crossref","unstructured":"Niemi T, Nummenmaa J, Thanisch P (2001) Constructing OLAP cubes based on queries. In: Proceedings international workshop on data warehousing and OLAP, pp 9\u201315","DOI":"10.1145\/512236.512238"},{"key":"331_CR40","unstructured":"Paim FRS, Castro J (2002) Enhancing data warehouse design with the NFR framework. In: Proceedings of workshop emengenharia de requisitos, pp 40\u201357"},{"key":"331_CR41","volume-title":"Requirements engineering\u2014fundamentals, principles, and techniques","author":"K Pohl","year":"2010","unstructured":"Pohl K (2010) Requirements engineering\u2014fundamentals, principles, and techniques. Springer, Berlin"},{"key":"331_CR42","doi-asserted-by":"publisher","first-page":"103","DOI":"10.1007\/s00766-017-0283-9","volume":"24","author":"N Prakash","year":"2019","unstructured":"Prakash N, Prakash D (2019) A multifactor approach for elicitation of information requirements of data warehouses. Requir Eng 24:103\u2013117","journal-title":"Requir Eng"},{"key":"331_CR43","unstructured":"Prat N, Si-Said Cherfi S (2003) Multidimensional schemas quality assessment. In: Proceedings conference on advanced information systems engineering, pp 341\u2013352"},{"issue":"1","key":"331_CR44","first-page":"17","volume":"4","author":"F Ravat","year":"2008","unstructured":"Ravat F, Teste O, Tournier R, Zurfluh G (2008) Algebraic and graphic languages for OLAP manipulations. IJDWM 4(1):17\u201346","journal-title":"IJDWM"},{"key":"331_CR45","doi-asserted-by":"crossref","unstructured":"Romero O, Abell\u00f3 A (2006) Multidimensional design by examples. In: Proceedings international conference on data warehousing and knowledge discovery, pp 85\u201394","DOI":"10.1007\/11823728_9"},{"issue":"2","key":"331_CR46","first-page":"1","volume":"5","author":"O Romero","year":"2009","unstructured":"Romero O, Abell\u00f3 A (2009) A survey of multidimensional modeling methodologies. IJDWM 5(2):1\u201323","journal-title":"IJDWM"},{"key":"331_CR47","doi-asserted-by":"crossref","unstructured":"Sakka A, Bimonte S, Sautot L, Camilleri G, Zarat\u00e9 P, Besnard A (2018) A volunteer design methodology of data warehouses. In: Proceedings of 37th international conference on conceptual modeling, Springer, pp 286\u2013300","DOI":"10.1007\/978-3-030-00847-5_21"},{"key":"331_CR48","unstructured":"Salinesi C, Gam I (2006) A requirement-driven approach for designing data warehouses. In: Proceedings of requirements engineering: foundations for software quality"},{"key":"331_CR49","doi-asserted-by":"publisher","first-page":"851","DOI":"10.1016\/j.infsof.2006.09.008","volume":"49","author":"M Serrano","year":"2007","unstructured":"Serrano M, Trujillo J, Calero C, Piattini M (2007) Metrics for data warehouse conceptual models understandability. Inf Softw Technol 49:851\u2013870","journal-title":"Inf Softw Technol"},{"key":"331_CR50","unstructured":"Shimomura T, Ikeda K, Chen QL, Lang NS, Takahashi M (2007). Visual pivot-table components for web application development. In: Proceedings of the third conference on IASTED international conference: advances in computer science and technology (ACST\u201907). ACTA Press, Anaheim, CA, USA, pp 90\u201395"},{"key":"331_CR51","doi-asserted-by":"crossref","unstructured":"Suranto B (2015) Software prototypes: enhancing the quality of requirements engineering process. In: Proceedings international symposium on technology management and emerging technologies, pp 148\u2013153","DOI":"10.1109\/ISTMET.2015.7359019"},{"key":"331_CR52","unstructured":"Vaisman AA (2006) Requirements elicitation for decision support systems: a data quality approach. In: Proceedings of eighth international conference on enterprise information systems: databases and information systems integration, pp 316\u2013321"},{"key":"331_CR53","doi-asserted-by":"crossref","DOI":"10.1007\/978-3-642-54655-6","volume-title":"Data warehouse systems\u2014design and implementation. Data-centric systems and applications","author":"AA Vaisman","year":"2014","unstructured":"Vaisman AA, Zimanyi E (2014) Data warehouse systems\u2014design and implementation. Data-centric systems and applications. Springer, Berlin"},{"key":"331_CR54","doi-asserted-by":"crossref","unstructured":"Vrdoljak B, Banek M, Rizzi S (2003)\u00a0Designing web warehouses from XML schemas. In: Proceedings international conference on data warehousing and knowledge discovery, pp 89\u201398","DOI":"10.1007\/978-3-540-45228-7_10"},{"key":"331_CR55","doi-asserted-by":"crossref","unstructured":"Winter R, Strauch B (2003) A method for demand-driven information requirements analysis in data warehousing projects. In: Proceedings 36th Hawaii international conference on system science, p 231","DOI":"10.1109\/HICSS.2003.1174602"},{"issue":"3","key":"331_CR56","first-page":"23","volume":"50","author":"W Yeoh","year":"2010","unstructured":"Yeoh W, Koronios A (2010) Critical success factors for business intelligence systems. JCIS 50(3):23\u201332","journal-title":"JCIS"}],"container-title":["Requirements Engineering"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s00766-020-00331-3.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s00766-020-00331-3\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s00766-020-00331-3.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,9,29]],"date-time":"2023-09-29T20:57:51Z","timestamp":1696021071000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s00766-020-00331-3"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020,4,11]]},"references-count":56,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2021,3]]}},"alternative-id":["331"],"URL":"https:\/\/doi.org\/10.1007\/s00766-020-00331-3","relation":{},"ISSN":["0947-3602","1432-010X"],"issn-type":[{"value":"0947-3602","type":"print"},{"value":"1432-010X","type":"electronic"}],"subject":[],"published":{"date-parts":[[2020,4,11]]},"assertion":[{"value":"8 August 2019","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"28 March 2020","order":2,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"11 April 2020","order":3,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}}]}}