NoSQL data warehouse optimizing models: A comparative study of column-oriented approaches
There is a great challenge when building an efficient Big Data Warehouse (DW) from the traditional data warehouse which used to handle the large datasets. Several presented solutions concentrate on the conversion of a standard DW to an columnar model, especially for direct and traditional data sourc...
Saved in:
| Published in: | Big data research Vol. 40; p. 100523 |
|---|---|
| Main Authors: | , |
| Format: | Journal Article |
| Language: | English |
| Published: |
Elsevier Inc
28.05.2025
|
| Subjects: | |
| ISSN: | 2214-5796 |
| Online Access: | Get full text |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| Abstract | There is a great challenge when building an efficient Big Data Warehouse (DW) from the traditional data warehouse which used to handle the large datasets. Several presented solutions concentrate on the conversion of a standard DW to an columnar model, especially for direct and traditional data sources. Though there have been many successful algorithms that apply data clustering methods, these approaches also come with their fair share of limitations. This paper provides a comprehensive review of the existing methods, both tuned and out-of-the box, exposing their strengths and weaknesses. Further, a comparative study of the different options is always conducted to compare and assess them. |
|---|---|
| AbstractList | There is a great challenge when building an efficient Big Data Warehouse (DW) from the traditional data warehouse which used to handle the large datasets. Several presented solutions concentrate on the conversion of a standard DW to an columnar model, especially for direct and traditional data sources. Though there have been many successful algorithms that apply data clustering methods, these approaches also come with their fair share of limitations. This paper provides a comprehensive review of the existing methods, both tuned and out-of-the box, exposing their strengths and weaknesses. Further, a comparative study of the different options is always conducted to compare and assess them. |
| ArticleNumber | 100523 |
| Author | Mabrouk, Abdelfettah Mouhiha, Mohamed |
| Author_xml | – sequence: 1 givenname: Mohamed orcidid: 0009-0001-9070-812X surname: Mouhiha fullname: Mouhiha, Mohamed email: mouhihamohamed@gmail.com – sequence: 2 givenname: Abdelfettah surname: Mabrouk fullname: Mabrouk, Abdelfettah |
| BookMark | eNp9kMtOwzAQRb0oEqX0A9j5B1L8SuLAqqp4SREIAQtWlmOPqasmjuy0qHw9qcqa1dVc6Yx0zwWadKEDhK4oWVBCi-vNorFxwQjLx5vkjE_QlDEqsrysinM0T2lDCKFc5lzKKfp8Dm-vNbZ60PhbR1iHXQIc-sG3_sd3X7gNFrbpBi-xCW2vox78HnAadvaAgxvL7a7tshA9dANYrPs-Bm3WkC7RmdPbBPO_nKGP-7v31WNWvzw8rZZ1ZmhZDZmTRlSCNdpZ6_LCCFmJkkhelk40hAOpoKigYU47IU2Rc1EYyXVOjTUNd4LPED39NTGkFMGpPvpWx4OiRB2VqI0alaijEnVSMjK3J2acBnsPUSUzDjBgfQQzKBv8P_QvGS9uXA |
| Cites_doi | 10.1109/TKDE.2002.1033770 10.33260/zictjournal.v1i1.8 10.1007/978-94-017-1769-4_7 10.4018/IJDSST.2020010101 10.1145/1773912.1773922 10.1007/s11227-017-2037-3 10.32985/ijeces.14.2.10 10.55524/ijircst.2022.10.1.21 10.1016/j.procs.2016.08.138 10.1145/3588703 10.54097/hset.v16i.2498 10.3390/data7080113 |
| ContentType | Journal Article |
| Copyright | 2025 Elsevier Inc. |
| Copyright_xml | – notice: 2025 Elsevier Inc. |
| DBID | AAYXX CITATION |
| DOI | 10.1016/j.bdr.2025.100523 |
| DatabaseName | CrossRef |
| DatabaseTitle | CrossRef |
| DatabaseTitleList | |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Computer Science |
| ExternalDocumentID | 10_1016_j_bdr_2025_100523 S2214579625000188 |
| GroupedDBID | --M .~1 0R~ 1~. 4.4 457 4G. 7-5 8P~ AAEDT AAEDW AAIKJ AAKOC AALRI AAOAW AAQFI AATTM AAXKI AAXUO AAYFN AAYWO ABBOA ABJNI ABMAC ACDAQ ACGFS ACRLP ACVFH ADBBV ADCNI ADEZE AEBSH AEIPS AEKER AEUPX AFJKZ AFPUW AFTJW AFXIZ AGCQF AGHFR AGRNS AGUBO AIALX AIEXJ AIGII AIIUN AIKHN AITUG AKBMS AKRWK AKYEP ALMA_UNASSIGNED_HOLDINGS AMRAJ ANKPU AOUOD APXCP AXJTR BKOJK BLXMC BNPGV EBS EFJIC FDB FIRID FNPLU FYGXN GBLVA KOM M41 O9- OAUVE P-8 P-9 PC. ROL SPC SPCBC SSH SSV SSZ T5K ~G- AAYXX ABXDB ACLOT CITATION EFKBS EFLBG EJD |
| ID | FETCH-LOGICAL-c179t-f8c4942bafddf56c4894708377f4b03e09e69eb2faf48c65346c83a51cdcb3f43 |
| ISICitedReferencesCount | 1 |
| ISICitedReferencesURI | http://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=Summon&SrcAuth=ProQuest&DestLinkType=CitingArticles&DestApp=WOS_CPL&KeyUT=001455308900001&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D |
| ISSN | 2214-5796 |
| IngestDate | Thu Nov 13 04:38:08 EST 2025 Sat Jul 05 17:12:03 EDT 2025 |
| IsPeerReviewed | true |
| IsScholarly | true |
| Keywords | Big data Column-oriented NoSQL database Optimization Big data warehouse |
| Language | English |
| LinkModel | OpenURL |
| MergedId | FETCHMERGED-LOGICAL-c179t-f8c4942bafddf56c4894708377f4b03e09e69eb2faf48c65346c83a51cdcb3f43 |
| ORCID | 0009-0001-9070-812X |
| ParticipantIDs | crossref_primary_10_1016_j_bdr_2025_100523 elsevier_sciencedirect_doi_10_1016_j_bdr_2025_100523 |
| PublicationCentury | 2000 |
| PublicationDate | 2025-05-28 |
| PublicationDateYYYYMMDD | 2025-05-28 |
| PublicationDate_xml | – month: 05 year: 2025 text: 2025-05-28 day: 28 |
| PublicationDecade | 2020 |
| PublicationTitle | Big data research |
| PublicationYear | 2025 |
| Publisher | Elsevier Inc |
| Publisher_xml | – name: Elsevier Inc |
| References | de Oliveira, de Carvalho Victorino, Holanda (br0160) 2021 Paliwal, Saraswat (br0010) 2022; 10 Abdelhedi, Jemmali, Zurfluh (br0140) 2022 Khalil, Belaissaoui (br0200) 2021 Khine, Wang (br0150) 2018; vol. 17 Z. Senwei, Relational database-based method and system for forming hive data warehouse, 2016. Twitter Engineering (br0390) M. Ghaffarzadeh, M. Behartash, M. Azimi, S. Eyvazzade, Evolution and development of decision support systems, 2014. Barkhordari, Niamanesh (br0040) 2017; 73 Al-Ghifari, Azizah (br0110) 2022 Feng, Lin, Wang (br0120) 2022; 16 Thakare, Tembhurne, Thakare, Reddy (br0190) 2023; 14 Yangui, Nabli, Gargouri (br0240) 2016; 96 Lakshman (br0360) 2010; 44 Borthakur (br0370) 2007 Dhaouadi, Bousselmi, Gammoudi, Monnet, Hammoudi (br0090) 2022; 7 Boussahoua, Boussaid, Bentayeb (br0280) 2017; vol. 28 DBPedias.com (br0310) Farrell (br0330) 2011; 15 Yuan Qiao, Yao (br0380) 2013 Ng, Han (br0070) 2002; 14 Thorub (br0340) 2011 Huang, Hung, Kwan, Hung (br0030) 2002 Dehdouh, Boussaid, Bentayeb (br0250) 2020; 12 Prakash (br0270) 2019 Fang, Song, Guan, Huang, Wang, Wang (br0210) 2023; 1 Fay Chang, Dean (br0350) 2008; 26 Khalil, Belaïssaoui (br0180) 2020 Boussahoua, Bentayeb, Boussaid, Kabachi (br0290) 2018 O.Q.P. over HBase (br0260) 2016 Kunda, Phiri (br0050) 2017; 1 Chevalier, Malki, Kopliku, Teste, Tournier (br0230) 2015; vol. 19 Boussahoua, Boussaid, Bentayeb (br0300) 2017 Yusuf (br0100) 2016 D.K. Pande, Data warehouse techniques in traditional knowledge systems, 2005. Thareja (br0020) 2009 Bouaziz, Nabli, Gargouri (br0170) 2020 Swari, Akbar, Martoni (br0130) 2019; 3 Muthukkaruppan (br0320) 2011 Yangui (10.1016/j.bdr.2025.100523_br0240) 2016; 96 Lakshman (10.1016/j.bdr.2025.100523_br0360) 2010; 44 Yusuf (10.1016/j.bdr.2025.100523_br0100) 2016 Prakash (10.1016/j.bdr.2025.100523_br0270) 2019 DBPedias.com (10.1016/j.bdr.2025.100523_br0310) Thareja (10.1016/j.bdr.2025.100523_br0020) 2009 Dehdouh (10.1016/j.bdr.2025.100523_br0250) 2020; 12 Borthakur (10.1016/j.bdr.2025.100523_br0370) Swari (10.1016/j.bdr.2025.100523_br0130) 2019; 3 Boussahoua (10.1016/j.bdr.2025.100523_br0280) 2017; vol. 28 Al-Ghifari (10.1016/j.bdr.2025.100523_br0110) 2022 Ng (10.1016/j.bdr.2025.100523_br0070) 2002; 14 Farrell (10.1016/j.bdr.2025.100523_br0330) 2011; 15 Kunda (10.1016/j.bdr.2025.100523_br0050) 2017; 1 Thorub (10.1016/j.bdr.2025.100523_br0340) 2011 Khalil (10.1016/j.bdr.2025.100523_br0200) 2021 Yuan Qiao (10.1016/j.bdr.2025.100523_br0380) Fay Chang (10.1016/j.bdr.2025.100523_br0350) 2008; 26 Khalil (10.1016/j.bdr.2025.100523_br0180) 2020 Twitter Engineering (10.1016/j.bdr.2025.100523_br0390) O.Q.P. over HBase (10.1016/j.bdr.2025.100523_br0260) 2016 Fang (10.1016/j.bdr.2025.100523_br0210) 2023; 1 Bouaziz (10.1016/j.bdr.2025.100523_br0170) 2020 Chevalier (10.1016/j.bdr.2025.100523_br0230) 2015; vol. 19 Boussahoua (10.1016/j.bdr.2025.100523_br0290) 2018 Boussahoua (10.1016/j.bdr.2025.100523_br0300) 2017 Thakare (10.1016/j.bdr.2025.100523_br0190) 2023; 14 10.1016/j.bdr.2025.100523_br0060 Muthukkaruppan (10.1016/j.bdr.2025.100523_br0320) 2011 Paliwal (10.1016/j.bdr.2025.100523_br0010) 2022; 10 Dhaouadi (10.1016/j.bdr.2025.100523_br0090) 2022; 7 10.1016/j.bdr.2025.100523_br0080 Abdelhedi (10.1016/j.bdr.2025.100523_br0140) Barkhordari (10.1016/j.bdr.2025.100523_br0040) 2017; 73 Khine (10.1016/j.bdr.2025.100523_br0150) 2018; vol. 17 Feng (10.1016/j.bdr.2025.100523_br0120) 2022; 16 Huang (10.1016/j.bdr.2025.100523_br0030) 2002 de Oliveira (10.1016/j.bdr.2025.100523_br0160) 2021 10.1016/j.bdr.2025.100523_br0220 |
| References_xml | – volume: 96 start-page: 255 year: 2016 end-page: 264 ident: br0240 article-title: Automatic transformation of data warehouse schema to nosql data base: comparative study publication-title: Procedia Computer Science – reference: M. Ghaffarzadeh, M. Behartash, M. Azimi, S. Eyvazzade, Evolution and development of decision support systems, 2014. – year: 2011 ident: br0320 article-title: Case study: Facebook's messaging system publication-title: Proceedings of the 2011 ACM SIGMOD International Conference on Management of Data – volume: 15 start-page: 1 year: 2011 end-page: 9 ident: br0330 article-title: Nosql: database choices in cloud computing publication-title: Network Computing – volume: vol. 19 start-page: 79 year: 2015 end-page: 91 ident: br0230 article-title: Implementation of multidimensional databases in column-oriented nosql systems publication-title: Advances in Databases and Information Systems: 19th East European Conference, Proceedings – volume: 7 start-page: 113 year: 2022 ident: br0090 article-title: Data warehousing process modeling from classical approaches to new trends: main features and comparisons publication-title: Data – reference: D.K. Pande, Data warehouse techniques in traditional knowledge systems, 2005. – reference: Z. Senwei, Relational database-based method and system for forming hive data warehouse, 2016. – year: 2022 ident: br0140 article-title: Relational databases ingestion into a nosql data warehouse – volume: 26 start-page: 4 year: 2008 ident: br0350 article-title: Bigtable: a distributed storage system for structured data publication-title: ACM Transactions on Computer Systems (TOCS) – year: 2013 ident: br0380 article-title: Espresso: a nosql database for linkedin's real-time applications – start-page: 217 year: 2016 end-page: 222 ident: br0100 article-title: A design comparison: data warehouse schema versus conventional relational database schema publication-title: OcRI – year: 2009 ident: br0020 article-title: Data Warehousing – start-page: 111 year: 2016 ident: br0260 article-title: Physical data warehouse design on nosql databases publication-title: ICEIS 2016 – start-page: 1 year: 2021 end-page: 6 ident: br0160 article-title: Data warehouse based on nosql: a literature mapping publication-title: 2021 16th Iberian Conference on Information Systems and Technologies (CISTI) – year: 2007 ident: br0370 article-title: The hadoop distributed file system: architecture and design – start-page: 179 year: 2021 end-page: 191 ident: br0200 article-title: Implementing big olap cubes using a nosql-based approach: cube models and aggregation operators publication-title: Enabling Machine Learning Applications in Data Science: Proceedings of Arab Conference for Emerging Technologies 2020 – volume: 10 start-page: 117 year: 2022 end-page: 121 ident: br0010 article-title: Approaches of data warehousing and their applications: a review publication-title: International Journal of Innovative Research in Computer Science & Technology – volume: 44 start-page: 35 year: 2010 end-page: 40 ident: br0360 article-title: Cassandra: a decentralized structured storage system publication-title: ACM SIGOPS Operating Systems Review – volume: 14 start-page: 1003 year: 2002 end-page: 1016 ident: br0070 article-title: Clarans: a method for clustering objects for spatial data mining publication-title: IEEE Transactions on Knowledge and Data Engineering – volume: 14 start-page: 207 year: 2023 end-page: 216 ident: br0190 article-title: Nosql databases: modern data systems for big data analytics-features, categorization and comparison publication-title: International Journal of Electrical and Computer Engineering Systems – start-page: 30 year: 2022 end-page: 35 ident: br0110 article-title: Development of application for entity-relationship diagram conversion to logical schema of nosql column oriented publication-title: 2022 International Conference on Data and Software Engineering (ICoDSE) – start-page: 392 year: 2020 end-page: 401 ident: br0170 article-title: Nosql big data warehouse: review and comparison publication-title: International Conference on Intelligent Systems Design and Applications – start-page: 105 year: 2002 end-page: 122 ident: br0030 article-title: Developing an active data warehouse system publication-title: Heterogeneous Information Exchange and Organizational Hubs – volume: vol. 28 start-page: 247 year: 2017 end-page: 256 ident: br0280 article-title: Logical schema for data warehouse on column-oriented nosql databases publication-title: Database and Expert Systems Applications: 28th International Conference, Proceedings, Part II – start-page: 69 year: 2017 end-page: 80 ident: br0300 article-title: Optimisation des performances dans les entrepôts de données nosql orientés colonnes publication-title: 17ème Journées Francophones Extraction et Gestion des Connaissances, EGC 2017 – volume: 1 start-page: 1 year: 2017 end-page: 4 ident: br0050 article-title: A comparative study of nosql and relational database publication-title: Zambia ICT Journal – start-page: 54 year: 2018 end-page: 60 ident: br0290 article-title: A data partitioning optimization approach for distributed data warehouses on column family nosql systems publication-title: Proceedings of the International Conference on Parallel and Distributed Processing Techniques and Applications (PDPTA), the Steering Committee of the World Congress in Computer Science, Computer … – volume: 12 start-page: 1 year: 2020 end-page: 24 ident: br0250 article-title: Big data warehouse: building columnar nosql olap cubes publication-title: International Journal of Decision Support System Technology (IJDSST) – year: 2011 ident: br0340 article-title: Implementing high availability with riak: a case study from the Danish department of health publication-title: ACM Queue – volume: 16 start-page: 168 year: 2022 end-page: 177 ident: br0120 article-title: Researches advanced in clustering algorithms publication-title: Highlights in Science, Engineering and Technology – start-page: 1 year: 2020 end-page: 6 ident: br0180 article-title: New approach for implementing big datamart using nosql key-value stores publication-title: 2020 5th International Conference on Cloud Computing and Artificial Intelligence: Technologies and Applications (CloudTech) – volume: 3 start-page: 135 year: 2019 end-page: 142 ident: br0130 article-title: Data warehouse implementation techniques in data processing (case study data sales at pt spirit sejahtera bersama): data warehouse implementation techniques in data processing (case study data sales at pt spirit sejahtera bersama) publication-title: Jurnal Mantik – ident: br0310 article-title: Facebook's messaging system architecture – volume: 1 start-page: 1 year: 2023 end-page: 26 ident: br0210 article-title: Grouping time series for efficient columnar storage publication-title: Proceedings of the ACM on Management of Data – volume: 73 start-page: 4596 year: 2017 end-page: 4610 ident: br0040 article-title: Atrak: a mapreduce-based data warehouse for big data publication-title: Journal of Supercomputing – volume: vol. 17 start-page: 03025 year: 2018 ident: br0150 article-title: Data Lake: a New Ideology in Big Data Era publication-title: ITM Web of Conferences – ident: br0390 article-title: Flockdb: Twitter's distributed graph database – start-page: 452 year: 2019 end-page: 458 ident: br0270 article-title: Nosolap: moving from data warehouse requirements to nosql databases publication-title: ENASE – volume: 26 start-page: 4 issue: 2 year: 2008 ident: 10.1016/j.bdr.2025.100523_br0350 article-title: Bigtable: a distributed storage system for structured data publication-title: ACM Transactions on Computer Systems (TOCS) – ident: 10.1016/j.bdr.2025.100523_br0390 – year: 2009 ident: 10.1016/j.bdr.2025.100523_br0020 – start-page: 1 year: 2020 ident: 10.1016/j.bdr.2025.100523_br0180 article-title: New approach for implementing big datamart using nosql key-value stores – start-page: 179 year: 2021 ident: 10.1016/j.bdr.2025.100523_br0200 article-title: Implementing big olap cubes using a nosql-based approach: cube models and aggregation operators – ident: 10.1016/j.bdr.2025.100523_br0080 – start-page: 217 year: 2016 ident: 10.1016/j.bdr.2025.100523_br0100 article-title: A design comparison: data warehouse schema versus conventional relational database schema – volume: 14 start-page: 1003 issue: 5 year: 2002 ident: 10.1016/j.bdr.2025.100523_br0070 article-title: Clarans: a method for clustering objects for spatial data mining publication-title: IEEE Transactions on Knowledge and Data Engineering doi: 10.1109/TKDE.2002.1033770 – start-page: 69 year: 2017 ident: 10.1016/j.bdr.2025.100523_br0300 article-title: Optimisation des performances dans les entrepôts de données nosql orientés colonnes – year: 2011 ident: 10.1016/j.bdr.2025.100523_br0340 article-title: Implementing high availability with riak: a case study from the Danish department of health publication-title: ACM Queue – ident: 10.1016/j.bdr.2025.100523_br0370 – volume: 1 start-page: 1 issue: 1 year: 2017 ident: 10.1016/j.bdr.2025.100523_br0050 article-title: A comparative study of nosql and relational database publication-title: Zambia ICT Journal doi: 10.33260/zictjournal.v1i1.8 – start-page: 54 year: 2018 ident: 10.1016/j.bdr.2025.100523_br0290 article-title: A data partitioning optimization approach for distributed data warehouses on column family nosql systems – start-page: 30 year: 2022 ident: 10.1016/j.bdr.2025.100523_br0110 article-title: Development of application for entity-relationship diagram conversion to logical schema of nosql column oriented – start-page: 105 year: 2002 ident: 10.1016/j.bdr.2025.100523_br0030 article-title: Developing an active data warehouse system publication-title: Heterogeneous Information Exchange and Organizational Hubs doi: 10.1007/978-94-017-1769-4_7 – volume: 12 start-page: 1 issue: 1 year: 2020 ident: 10.1016/j.bdr.2025.100523_br0250 article-title: Big data warehouse: building columnar nosql olap cubes publication-title: International Journal of Decision Support System Technology (IJDSST) doi: 10.4018/IJDSST.2020010101 – volume: 15 start-page: 1 issue: 3 year: 2011 ident: 10.1016/j.bdr.2025.100523_br0330 article-title: Nosql: database choices in cloud computing publication-title: Network Computing – ident: 10.1016/j.bdr.2025.100523_br0140 – start-page: 452 year: 2019 ident: 10.1016/j.bdr.2025.100523_br0270 article-title: Nosolap: moving from data warehouse requirements to nosql databases – volume: 44 start-page: 35 issue: 2 year: 2010 ident: 10.1016/j.bdr.2025.100523_br0360 article-title: Cassandra: a decentralized structured storage system publication-title: ACM SIGOPS Operating Systems Review doi: 10.1145/1773912.1773922 – volume: 73 start-page: 4596 issue: 10 year: 2017 ident: 10.1016/j.bdr.2025.100523_br0040 article-title: Atrak: a mapreduce-based data warehouse for big data publication-title: Journal of Supercomputing doi: 10.1007/s11227-017-2037-3 – volume: vol. 17 start-page: 03025 year: 2018 ident: 10.1016/j.bdr.2025.100523_br0150 article-title: Data Lake: a New Ideology in Big Data Era – start-page: 1 year: 2021 ident: 10.1016/j.bdr.2025.100523_br0160 article-title: Data warehouse based on nosql: a literature mapping – volume: 3 start-page: 135 issue: 3 year: 2019 ident: 10.1016/j.bdr.2025.100523_br0130 article-title: Data warehouse implementation techniques in data processing (case study data sales at pt spirit sejahtera bersama): data warehouse implementation techniques in data processing (case study data sales at pt spirit sejahtera bersama) publication-title: Jurnal Mantik – year: 2011 ident: 10.1016/j.bdr.2025.100523_br0320 article-title: Case study: Facebook's messaging system – volume: 14 start-page: 207 issue: 2 year: 2023 ident: 10.1016/j.bdr.2025.100523_br0190 article-title: Nosql databases: modern data systems for big data analytics-features, categorization and comparison publication-title: International Journal of Electrical and Computer Engineering Systems doi: 10.32985/ijeces.14.2.10 – start-page: 111 year: 2016 ident: 10.1016/j.bdr.2025.100523_br0260 article-title: Physical data warehouse design on nosql databases – volume: 10 start-page: 117 issue: 1 year: 2022 ident: 10.1016/j.bdr.2025.100523_br0010 article-title: Approaches of data warehousing and their applications: a review publication-title: International Journal of Innovative Research in Computer Science & Technology doi: 10.55524/ijircst.2022.10.1.21 – volume: 96 start-page: 255 year: 2016 ident: 10.1016/j.bdr.2025.100523_br0240 article-title: Automatic transformation of data warehouse schema to nosql data base: comparative study publication-title: Procedia Computer Science doi: 10.1016/j.procs.2016.08.138 – ident: 10.1016/j.bdr.2025.100523_br0060 – start-page: 392 year: 2020 ident: 10.1016/j.bdr.2025.100523_br0170 article-title: Nosql big data warehouse: review and comparison – volume: 1 start-page: 1 issue: 1 year: 2023 ident: 10.1016/j.bdr.2025.100523_br0210 article-title: Grouping time series for efficient columnar storage publication-title: Proceedings of the ACM on Management of Data doi: 10.1145/3588703 – ident: 10.1016/j.bdr.2025.100523_br0380 – ident: 10.1016/j.bdr.2025.100523_br0220 – volume: vol. 28 start-page: 247 year: 2017 ident: 10.1016/j.bdr.2025.100523_br0280 article-title: Logical schema for data warehouse on column-oriented nosql databases – ident: 10.1016/j.bdr.2025.100523_br0310 – volume: 16 start-page: 168 year: 2022 ident: 10.1016/j.bdr.2025.100523_br0120 article-title: Researches advanced in clustering algorithms publication-title: Highlights in Science, Engineering and Technology doi: 10.54097/hset.v16i.2498 – volume: vol. 19 start-page: 79 year: 2015 ident: 10.1016/j.bdr.2025.100523_br0230 article-title: Implementation of multidimensional databases in column-oriented nosql systems – volume: 7 start-page: 113 issue: 8 year: 2022 ident: 10.1016/j.bdr.2025.100523_br0090 article-title: Data warehousing process modeling from classical approaches to new trends: main features and comparisons publication-title: Data doi: 10.3390/data7080113 |
| SSID | ssj0001385388 |
| Score | 2.3200953 |
| Snippet | There is a great challenge when building an efficient Big Data Warehouse (DW) from the traditional data warehouse which used to handle the large datasets.... |
| SourceID | crossref elsevier |
| SourceType | Index Database Publisher |
| StartPage | 100523 |
| SubjectTerms | Big data Big data warehouse Column-oriented NoSQL database Optimization |
| Title | NoSQL data warehouse optimizing models: A comparative study of column-oriented approaches |
| URI | https://dx.doi.org/10.1016/j.bdr.2025.100523 |
| Volume | 40 |
| WOSCitedRecordID | wos001455308900001&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| journalDatabaseRights | – providerCode: PRVESC databaseName: Elsevier SD Freedom Collection Journals 2021 issn: 2214-5796 databaseCode: AIEXJ dateStart: 20140801 customDbUrl: isFulltext: true dateEnd: 99991231 titleUrlDefault: https://www.sciencedirect.com omitProxy: false ssIdentifier: ssj0001385388 providerName: Elsevier |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtV3Nb9MwFLdKx4EL34iND_nAiSpT69iJw61CQwxtFYiByilyHJt2YsnUptvEX8_zVxKqTWIHLlYUJY7ln_Xy3s_v_YzQGyoToYQuIqV4GVGpskgoyaJSMl5SGHpsqYvvR-lsxufz7PNgcBhqYS5-pVXFr66y8_8KNdwDsE3p7C3gbjuFG3ANoEMLsEP7T8DP6q9fjkYm83N0KVZqAaG9GtVgGc6Wvw0vYM--WbuKdNnT_l4HeWlpDFYV1UYB2fijQXbcZxuGHeDlT_cRLxfU0srH9WaxdNtIx_VCnPnqKct6F6t6Y83vtIBBaNU0no72vANhZsuc9EwlIRMamUrWvi110kveGE4s53ytnXaUwel-URpNVsL2u2f_1sTe-le1GYQhOe00hy5y00XuuriDdkjKMj5EO9PDg_mnjnCLwTOx55C2Iw-73Dbfb2so1_spPd_j5CG674MGPHVgP0IDVT1GD8KBHNjb5yfoh8UeG1hwiz3usMcO-3d4invIY4s8rjXeQh53yD9F3z4cnLz_GPmzMyIJJraJNJc0o6QQuiw1SyTlGU3B3U5TTYtxrMaZSjJVEC005TJhMU0kjwWbyFIWsabxMzSs6ko9R5hDhCqUopqVAqJxLsBphF_oeCwhHCWZ3EVvw0zl504iJb8Rnl1Ew1zm3sdzvlsOS-Pm1_Zu840X6F63YF-iYbPaqFforrxoluvVa78u_gAejXNc |
| linkProvider | Elsevier |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=NoSQL+data+warehouse+optimizing+models%3A+A+comparative+study+of+column-oriented+approaches&rft.jtitle=Big+data+research&rft.au=Mouhiha%2C+Mohamed&rft.au=Mabrouk%2C+Abdelfettah&rft.date=2025-05-28&rft.issn=2214-5796&rft.volume=40&rft.spage=100523&rft_id=info:doi/10.1016%2Fj.bdr.2025.100523&rft.externalDBID=n%2Fa&rft.externalDocID=10_1016_j_bdr_2025_100523 |
| thumbnail_l | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=2214-5796&client=summon |
| thumbnail_m | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=2214-5796&client=summon |
| thumbnail_s | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=2214-5796&client=summon |