{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,26]],"date-time":"2025-03-26T15:55:32Z","timestamp":1743004532290,"version":"3.40.3"},"publisher-location":"Cham","reference-count":18,"publisher":"Springer Nature Switzerland","isbn-type":[{"type":"print","value":"9783031683220"},{"type":"electronic","value":"9783031683237"}],"license":[{"start":{"date-parts":[[2024,1,1]],"date-time":"2024-01-01T00:00:00Z","timestamp":1704067200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2024,1,1]],"date-time":"2024-01-01T00:00:00Z","timestamp":1704067200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2024]]},"DOI":"10.1007\/978-3-031-68323-7_22","type":"book-chapter","created":{"date-parts":[[2024,8,17]],"date-time":"2024-08-17T07:02:18Z","timestamp":1723878138000},"page":"269-283","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Creating and\u00a0Querying Data Cubes in\u00a0Python Using PyCube"],"prefix":"10.1007","author":[{"ORCID":"https:\/\/orcid.org\/0009-0006-4146-6482","authenticated-orcid":false,"given":"Sigmundur","family":"Vang","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-0862-0509","authenticated-orcid":false,"given":"Christian","family":"Thomsen","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-1615-777X","authenticated-orcid":false,"given":"Torben Bach","family":"Pedersen","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2024,8,18]]},"reference":[{"key":"22_CR1","unstructured":"ActiveViam: atoti\u2019s. https:\/\/atoti.io. Accessed 15 Sept 2023"},{"issue":"2","key":"22_CR2","doi-asserted-by":"publisher","first-page":"39","DOI":"10.4018\/jdwm.2013040103","volume":"9","author":"CD de Aguiar Ciferri","year":"2013","unstructured":"de Aguiar Ciferri, C.D., et al.: Cube algebra: a generic user-centric model and query language for OLAP cubes. Int. J. Data Warehous. Min. 9(2), 39\u201365 (2013). https:\/\/doi.org\/10.4018\/jdwm.2013040103","journal-title":"Int. J. Data Warehous. Min."},{"key":"22_CR3","doi-asserted-by":"publisher","unstructured":"Armbrust, M., et\u00a0al.: Spark SQL: relational data processing in spark. In: Sellis, T.K., Davidson, S.B., Ives, Z.G. (eds.) Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data, pp. 1383\u20131394. ACM (2015). https:\/\/doi.org\/10.1145\/2723372.2742797","DOI":"10.1145\/2723372.2742797"},{"key":"22_CR4","unstructured":"Bayer, M.: Sqlalchemy. In: Brown, A., Wilson, G. (eds.) The Architecture of Open Source Applications Volume II: Structure, Scale, and a Few More Fearless Hacks. aosabook.org (2012). http:\/\/aosabook.org\/en\/sqlalchemy.html"},{"key":"22_CR5","unstructured":"Cube: Cube\u2019s. https:\/\/cube.dev\/. Accessed 15 Sept 2023"},{"key":"22_CR6","unstructured":"Databrewery: Databrewery\u2019s cubes. http:\/\/cubes.databrewery.org\/. Accessed 15 Sept 2023"},{"issue":"10","key":"22_CR7","doi-asserted-by":"publisher","first-page":"1737","DOI":"10.14778\/3401960.3401970","volume":"13","author":"H Kim","year":"2020","unstructured":"Kim, H., So, B., Han, W., Lee, H.: Natural language to SQL: where are we today? Proc. VLDB Endow. 13(10), 1737\u20131750 (2020). https:\/\/doi.org\/10.14778\/3401960.3401970","journal-title":"Proc. VLDB Endow."},{"key":"22_CR8","unstructured":"Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd. edn. Wiley, Hoboken (2002). https:\/\/www.worldcat.org\/oclc\/49284159"},{"key":"22_CR9","doi-asserted-by":"publisher","unstructured":"Ma, P., Wang, S.: MT-Teql: evaluating and augmenting neural NLIDB on real-world linguistic and schema variations. Proc. VLDB Endow. 15(3), 569\u2013582 (2021). https:\/\/doi.org\/10.14778\/3494124.3494139. http:\/\/www.vldb.org\/pvldb\/vol15\/p569-ma.pdf","DOI":"10.14778\/3494124.3494139"},{"key":"22_CR10","unstructured":"Microsoft: XMLA reference. https:\/\/learn.microsoft.com\/en-us\/analysis-services\/xmla\/xml-for-analysis-xmla-reference?view=asallproducts-allversions. Accessed 17 Mar 2024"},{"key":"22_CR11","first-page":"50","volume":"200","author":"PE O\u2019Neil","year":"2007","unstructured":"O\u2019Neil, P.E., O\u2019Neil, E.J., Chen, X.: The star schema benchmark (SSB). Pat 200, 50 (2007)","journal-title":"Pat"},{"key":"22_CR12","unstructured":"Pandas: Pandas user guide. https:\/\/pandas.pydata.org\/docs\/user_guide\/index.html. Accessed 01 Oct 2023"},{"key":"22_CR13","unstructured":"SAS, A.: Olapy\u2019s documentation. https:\/\/olapy.readthedocs.io\/en\/latest\/. Accessed 17 Mar 2024"},{"key":"22_CR14","doi-asserted-by":"publisher","unstructured":"Team pandas\u00a0development: pandas-dev\/pandas: Pandas (2020). https:\/\/doi.org\/10.5281\/zenodo.3509134","DOI":"10.5281\/zenodo.3509134"},{"key":"22_CR15","unstructured":"TinyOlap: Tinyolap. https:\/\/tinyolap.com\/. Accessed 18 Mar 2024"},{"key":"22_CR16","doi-asserted-by":"publisher","unstructured":"Vang, S., Thomsen, C., Pedersen, T.B.: Creating and querying data cubes in python using pyCube. Technical report (2023). https:\/\/doi.org\/10.48550\/arXiv.2312.08557","DOI":"10.48550\/arXiv.2312.08557"},{"key":"22_CR17","doi-asserted-by":"publisher","first-page":"68","DOI":"10.1016\/J.IS.2019.03.011","volume":"85","author":"P Vassiliadis","year":"2019","unstructured":"Vassiliadis, P., Marcel, P., Rizzi, S.: Beyond roll-up\u2019s and drill-down\u2019s: an intentional analytics model to reinvent OLAP. Inf. Syst. 85, 68\u201391 (2019). https:\/\/doi.org\/10.1016\/J.IS.2019.03.011","journal-title":"Inf. Syst."},{"key":"22_CR18","doi-asserted-by":"publisher","DOI":"10.1007\/1-84628-182-2","volume-title":"Fast track to MDX","author":"M Whitehorn","year":"2006","unstructured":"Whitehorn, M., Zare, R., Pasumansky, M.: Fast track to MDX, 2nd edn. Springer, Cham (2006). https:\/\/doi.org\/10.1007\/1-84628-182-2","edition":"2"}],"container-title":["Lecture Notes in Computer Science","Big Data Analytics and Knowledge Discovery"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-031-68323-7_22","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,8,17]],"date-time":"2024-08-17T07:05:16Z","timestamp":1723878316000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-031-68323-7_22"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024]]},"ISBN":["9783031683220","9783031683237"],"references-count":18,"URL":"https:\/\/doi.org\/10.1007\/978-3-031-68323-7_22","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2024]]},"assertion":[{"value":"18 August 2024","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"DaWaK","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"International Conference on Big Data Analytics and Knowledge Discovery","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Naples","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Italy","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2024","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"26 August 2024","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"28 August 2024","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"26","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"dawak2024","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/www.dexa.org\/dawak2024\/","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}}]}}