{"id":"https://openalex.org/W4399366867","doi":"https://doi.org/10.3390/bdcc8060064","title":"Integrating OLAP with NoSQL Databases in Big Data Environments: Systematic Mapping","display_name":"Integrating OLAP with NoSQL Databases in Big Data Environments: Systematic Mapping","publication_year":2024,"publication_date":"2024-06-05","ids":{"openalex":"https://openalex.org/W4399366867","doi":"https://doi.org/10.3390/bdcc8060064"},"language":"en","primary_location":{"id":"doi:10.3390/bdcc8060064","is_oa":true,"landing_page_url":"https://doi.org/10.3390/bdcc8060064","pdf_url":"https://www.mdpi.com/2504-2289/8/6/64/pdf?version=1717635818","source":{"id":"https://openalex.org/S4210238752","display_name":"Big Data and Cognitive Computing","issn_l":"2504-2289","issn":["2504-2289"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Big Data and Cognitive Computing","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.mdpi.com/2504-2289/8/6/64/pdf?version=1717635818","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5031836050","display_name":"Diana Mart\u00ednez-Mosquera","orcid":"https://orcid.org/0000-0002-0573-8640"},"institutions":[{"id":"https://openalex.org/I70764802","display_name":"National Polytechnic School","ror":"https://ror.org/01gb99w41","country_code":"EC","type":"education","lineage":["https://openalex.org/I70764802"]}],"countries":["EC"],"is_corresponding":true,"raw_author_name":"Diana Martinez-Mosquera","raw_affiliation_strings":["Department of Informatics and Computer Science, Escuela Polit\u00e9cnica Nacional, Quito 170525, Ecuador"],"affiliations":[{"raw_affiliation_string":"Department of Informatics and Computer Science, Escuela Polit\u00e9cnica Nacional, Quito 170525, Ecuador","institution_ids":["https://openalex.org/I70764802"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001578519","display_name":"Rosa Navarrete","orcid":"https://orcid.org/0000-0002-1435-5000"},"institutions":[{"id":"https://openalex.org/I70764802","display_name":"National Polytechnic School","ror":"https://ror.org/01gb99w41","country_code":"EC","type":"education","lineage":["https://openalex.org/I70764802"]}],"countries":["EC"],"is_corresponding":false,"raw_author_name":"Rosa Navarrete","raw_affiliation_strings":["Department of Informatics and Computer Science, Escuela Polit\u00e9cnica Nacional, Quito 170525, Ecuador"],"affiliations":[{"raw_affiliation_string":"Department of Informatics and Computer Science, Escuela Polit\u00e9cnica Nacional, Quito 170525, Ecuador","institution_ids":["https://openalex.org/I70764802"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088265373","display_name":"Sergio Luj\u00e1n\u2010Mora","orcid":"https://orcid.org/0000-0001-5000-864X"},"institutions":[{"id":"https://openalex.org/I130194489","display_name":"University of Alicante","ror":"https://ror.org/05t8bcz72","country_code":"ES","type":"education","lineage":["https://openalex.org/I130194489"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Sergio Luj\u00e1n-Mora","raw_affiliation_strings":["Department of Software and Computing Systems, University of Alicante, 03690 Alicante, Spain"],"affiliations":[{"raw_affiliation_string":"Department of Software and Computing Systems, University of Alicante, 03690 Alicante, Spain","institution_ids":["https://openalex.org/I130194489"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087620247","display_name":"Lorena Recalde","orcid":"https://orcid.org/0000-0002-4949-3278"},"institutions":[{"id":"https://openalex.org/I70764802","display_name":"National Polytechnic School","ror":"https://ror.org/01gb99w41","country_code":"EC","type":"education","lineage":["https://openalex.org/I70764802"]}],"countries":["EC"],"is_corresponding":false,"raw_author_name":"Lorena Recalde","raw_affiliation_strings":["Department of Informatics and Computer Science, Escuela Polit\u00e9cnica Nacional, Quito 170525, Ecuador"],"affiliations":[{"raw_affiliation_string":"Department of Informatics and Computer Science, Escuela Polit\u00e9cnica Nacional, Quito 170525, Ecuador","institution_ids":["https://openalex.org/I70764802"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5099025819","display_name":"Andres Andrade-Cabrera","orcid":"https://orcid.org/0009-0002-5080-9126"},"institutions":[{"id":"https://openalex.org/I70764802","display_name":"National Polytechnic School","ror":"https://ror.org/01gb99w41","country_code":"EC","type":"education","lineage":["https://openalex.org/I70764802"]}],"countries":["EC"],"is_corresponding":false,"raw_author_name":"Andres Andrade-Cabrera","raw_affiliation_strings":["Department of Informatics and Computer Science, Escuela Polit\u00e9cnica Nacional, Quito 170525, Ecuador"],"affiliations":[{"raw_affiliation_string":"Department of Informatics and Computer Science, Escuela Polit\u00e9cnica Nacional, Quito 170525, Ecuador","institution_ids":["https://openalex.org/I70764802"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5031836050"],"corresponding_institution_ids":["https://openalex.org/I70764802"],"apc_list":{"value":1400,"currency":"CHF","value_usd":1515},"apc_paid":{"value":1400,"currency":"CHF","value_usd":1515},"fwci":3.0927,"has_fulltext":true,"cited_by_count":4,"citation_normalized_percentile":{"value":0.92452427,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"8","issue":"6","first_page":"64","last_page":"64"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9983999729156494,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9983999729156494,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9973999857902527,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12761","display_name":"Data Stream Mining Techniques","score":0.9894000291824341,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.9843572378158569},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.9318759441375732},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7758370637893677},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.7215957045555115},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.6010062098503113},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.5888431668281555},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.5184240341186523},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.41384077072143555},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.3764357566833496},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.25603461265563965},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.1647835373878479}],"concepts":[{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.9843572378158569},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.9318759441375732},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7758370637893677},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7215957045555115},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.6010062098503113},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.5888431668281555},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.5184240341186523},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.41384077072143555},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.3764357566833496},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.25603461265563965},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.1647835373878479}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.3390/bdcc8060064","is_oa":true,"landing_page_url":"https://doi.org/10.3390/bdcc8060064","pdf_url":"https://www.mdpi.com/2504-2289/8/6/64/pdf?version=1717635818","source":{"id":"https://openalex.org/S4210238752","display_name":"Big Data and Cognitive Computing","issn_l":"2504-2289","issn":["2504-2289"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Big Data and Cognitive Computing","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:43eb49f02d5b46b8858f1d5677c3f65a","is_oa":true,"landing_page_url":"https://doaj.org/article/43eb49f02d5b46b8858f1d5677c3f65a","pdf_url":null,"source":{"id":"https://openalex.org/S112646816","display_name":"SHILAP Revista de lepidopterolog\u00eda","issn_l":"0300-5267","issn":["0300-5267","2340-4078"],"is_oa":true,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Big Data and Cognitive Computing, Vol 8, Iss 6, p 64 (2024)","raw_type":"article"},{"id":"pmh:oai:rua.ua.es:10045/143660","is_oa":true,"landing_page_url":"http://hdl.handle.net/10045/143660","pdf_url":null,"source":{"id":"https://openalex.org/S4306400416","display_name":"Repositorio Institucional de la Universidad de Alicante (Universidad de Alicante)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I130194489","host_organization_name":"University of Alicante","host_organization_lineage":["https://openalex.org/I130194489"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"doi:10.3390/bdcc8060064","is_oa":true,"landing_page_url":"https://doi.org/10.3390/bdcc8060064","pdf_url":"https://www.mdpi.com/2504-2289/8/6/64/pdf?version=1717635818","source":{"id":"https://openalex.org/S4210238752","display_name":"Big Data and Cognitive Computing","issn_l":"2504-2289","issn":["2504-2289"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Big Data and Cognitive Computing","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.49000000953674316,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320327633","display_name":"Escuela Polit\u00e9cnica Nacional","ror":"https://ror.org/01gb99w41"}],"has_content":{"grobid_xml":false,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4399366867.pdf"},"referenced_works_count":35,"referenced_works":["https://openalex.org/W77020168","https://openalex.org/W196250997","https://openalex.org/W1486446617","https://openalex.org/W1968888566","https://openalex.org/W2015584533","https://openalex.org/W2034094825","https://openalex.org/W2036260704","https://openalex.org/W2072764742","https://openalex.org/W2150700078","https://openalex.org/W2200206354","https://openalex.org/W2293806838","https://openalex.org/W2296255490","https://openalex.org/W2381748642","https://openalex.org/W2485014323","https://openalex.org/W2518094867","https://openalex.org/W2584404883","https://openalex.org/W2617290843","https://openalex.org/W2625096722","https://openalex.org/W2774610177","https://openalex.org/W2899303423","https://openalex.org/W2914265602","https://openalex.org/W2969994762","https://openalex.org/W2972908700","https://openalex.org/W2981077025","https://openalex.org/W2981807200","https://openalex.org/W3000459084","https://openalex.org/W3031095837","https://openalex.org/W3124887203","https://openalex.org/W3132212484","https://openalex.org/W4225376644","https://openalex.org/W4233500893","https://openalex.org/W4285124172","https://openalex.org/W4385586805","https://openalex.org/W6732617355","https://openalex.org/W6856168049"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W2363019959","https://openalex.org/W6138692","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W2382180329","https://openalex.org/W2375394542"],"abstract_inverted_index":{"The":[0,212],"growing":[1,119],"importance":[2,120],"of":[3,64,86,93,111,121,189,215,227,244],"data":[4,12,22,133],"analytics":[5,134],"is":[6],"leading":[7],"to":[8,56,61,131,233,259],"a":[9,51,83,108,182],"shift":[10],"in":[11,69,90,107,129,208],"management":[13],"strategy":[14],"at":[15],"many":[16],"companies,":[17],"moving":[18],"away":[19],"from":[20,79],"simple":[21],"storage":[23],"towards":[24],"adopting":[25],"Online":[26,158,164],"Analytical":[27,159,165],"Processing":[28,160,166],"(OLAP)":[29],"query":[30,127],"analysis.":[31],"Concurrently,":[32],"NoSQL":[33,67,123,142,231],"databases":[34,68,124,143,232],"are":[35],"gaining":[36],"ground":[37],"as":[38,147,156],"the":[39,62,91,97,118,138,187,225],"preferred":[40],"choice":[41],"for":[42,125,171,184],"storing":[43],"and":[44,149,162,168,173,198,205,221,239],"querying":[45],"analytical":[46],"data.":[47],"This":[48,115,242],"article":[49],"presents":[50],"comprehensive,":[52],"systematic":[53],"mapping,":[54],"aiming":[55],"consolidate":[57],"research":[58,77,180,245],"efforts":[59,246],"related":[60],"integration":[63,188,226],"OLAP":[65,126,152,190,228],"with":[66,144,191,230],"Big":[70,209],"Data":[71,210],"environments.":[72],"After":[73],"identifying":[74,137],"1646":[75],"initial":[76],"studies":[78,103],"scientific":[80],"digital":[81],"repositories,":[82],"thorough":[84],"examination":[85],"their":[87],"content":[88],"resulted":[89],"acceptance":[92],"22":[94],"studies.":[95],"Utilizing":[96],"snowballing":[98],"technique,":[99],"an":[100],"additional":[101],"three":[102],"were":[104],"selected,":[105],"culminating":[106],"final":[109],"corpus":[110],"twenty-five":[112],"relevant":[113],"articles.":[114],"review":[116,217],"addresses":[117],"leveraging":[122],"analysis":[128],"response":[130],"increasing":[132],"demands.":[135],"By":[136],"most":[139],"commonly":[140],"used":[141],"OLAP,":[145],"such":[146,155],"column-oriented":[148],"document-oriented,":[150],"prevalent":[151],"modeling":[153],"methods,":[154],"Relational":[157],"(ROLAP)":[161],"Multidimensional":[163],"(MOLAP),":[167],"suggested":[169],"models":[170],"batch":[172],"real-time":[174],"processing,":[175],"among":[176],"other":[177],"results,":[178],"this":[179,216],"provides":[181],"roadmap":[183],"organizations":[185],"navigating":[186],"NoSQL.":[192],"Additionally,":[193],"exploring":[194],"computational":[195],"resource":[196],"requirements":[197],"performance":[199],"benchmarks":[200],"facilitates":[201],"informed":[202],"decision":[203],"making":[204],"promotes":[206,249],"advancements":[207],"analytics.":[211],"main":[213],"findings":[214],"provide":[218],"valuable":[219],"insights":[220],"updated":[222],"information":[223],"regarding":[224],"cubes":[229],"benefit":[234],"future":[235],"research,":[236],"industry":[237],"practitioners,":[238],"academia":[240],"alike.":[241],"consolidation":[243],"not":[247],"only":[248],"innovative":[250],"solutions":[251],"but":[252],"also":[253],"promises":[254],"reduced":[255],"operational":[256],"costs":[257],"compared":[258],"traditional":[260],"database":[261],"systems.":[262]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1}],"updated_date":"2026-04-02T15:55:50.835912","created_date":"2025-10-10T00:00:00"}