An empirically-driven clustering framework for NoSQL data warehouse conversion: Optimizing column family design from relational big data using HDBSCAN

Mohamed Mouhiha; Abdelfettah Mabrouk

doi:10.1016/j.infsof.2026.108117

journal article Jul 01, 2026

An empirically-driven clustering framework for NoSQL data warehouse conversion: Optimizing column family design from relational big data using HDBSCAN

Mohamed Mouhiha

Abdelfettah Mabrouk

Information and Software Technology Vol. 195 pp. 108117 · Elsevier BV

View at Publisher Save 10.1016/j.infsof.2026.108117

Topics

No keywords indexed for this article. Browse by subject →

References

35

[1]

Paliwal "Approaches of data warehousing and their applications: A review" Int. J. Innov. Res. Comput. Sci. Technol. (2022) 10.55524/ijircst.2022.10.1.21

[2]

Chandra "Comprehensive survey on data warehousing research" Int. J. Inf. Technol. (2018)

[3]

Santos "Enhancing big data warehousing for efficient, integrated and advanced analytics: visionary paper" (2019)

[4]

Ng "CLARANS: A method for clustering objects for spatial data mining" IEEE Trans. Knowl. Data Eng. (2002) 10.1109/tkde.2002.1033770

[5]

Thareja (2009)

[6]

V. Nebot, R. Berlanga, Building data warehouses with semantic data, in: Proceedings of the 2010 EDBT/ICDT Workshops, 2010, pp. 1–8. 10.1145/1754239.1754250

[7]

Boumlik "Smart-Etl-MR: Novel Etl Framework for Building data WarehoUSe from big data Source USing Mapreduce" J. Theor. Appl. Inf. Technol. (2020)

[8]

Huang "Developing an active data warehouse system" Heterog. Inf. Exch. Organ. Hubs (2002)

[9]

Barkhordari "Atrak: a MapReduce-based data warehouse for big data" J. Supercomput. (2017) 10.1007/s11227-017-2037-3

[10]

Kunda "A comparative study of nosql and relational database" Zamb. ICT J. (2017) 10.33260/zictjournal.v1i1.8

[11]

Yangui "Towards data warehouse schema design from social networks-dynamic discovery of multidimensional concepts" (2015)

[12]

Mouhiha "NoSQL data warehouse optimizing models: A comparative study of column-oriented approaches" Big Data Res. (2025) 10.1016/j.bdr.2025.100523

[13]

Uddin "A review of implementing AI-powered data warehouse solutions to optimize big data management and utilization" Acad. J. Bus. Adm. Innov. Sustain. (2024)

[14]

Zhao "Research on efficient data warehouse construction methods for big data applications" Appl. Math. Nonlinear Sci. (2024)

[15]

Dinesh "An efficient hybrid optimization of ETL process in data warehouse of cloud architecture" J. Cloud Comput. (2024) 10.1186/s13677-023-00571-y

[16]

N. Bruno, C. Galindo-Legaria, M. Joshi, E. Calvo Vargas, K. Mahapatra, S. Ravindran, G. Chen, E. Cervantes Juárez, B. Sezgin, Unified Query Optimization in the Fabric Data Warehouse, in: Companion of the 2024 International Conference on Management of Data, 2024, pp. 18–30. 10.1145/3626246.3653369

[17]

Chevalier "Implementation of multidimensional databases in column-oriented NoSQL systems" (2015)

[18]

Yangui "Automatic transformation of data warehouse schema to NoSQL data base: comparative study" Procedia Comput. Sci. (2016) 10.1016/j.procs.2016.08.138

[19]

Dehdouh "Big data warehouse: Building columnar nosql OLAP cubes" Int. J. Decis. Support. Syst. Technol. (IJDSST) (2020) 10.4018/ijdsst.2020010101

[20]

over HBase "Physical data warehouse design on NoSQL databases" ICEIS 2016 (2016)

[21]

Prakash "NOSOLAP: Moving from data warehouse requirements to NoSQL databases." (2019)

[22]

Boussahoua "Logical schema for data warehouse on column-oriented NoSQL databases" (2017)

[23]

Boussahoua "A data partitioning optimization approach for distributed data warehouses on column family NoSQL systems" (2018)

[24]

Chang "Bigtable: A distributed storage system for structured data" ACM Trans. Comput. Syst. (TOCS) (2008) 10.1145/1365815.1365816

[25]

Soussi "Optimization of columnar NoSQL data warehouse model with clarans clustering algorithm" Comput. Inform. (2023) 10.31577/cai_2023_3_762

[26]

Mpinda "From relational database to column-oriented NoSQL database: Migration process" Int. J. Eng. Res. Technol. (IJERT) (2015)

[27]

Zaidi "An efficient schema transformation technique for data migration from relational to column-oriented databases." Comput. Syst. Sci. Eng. (2022)

[28]

Zhang "A survey of evidential clustering: Definitions, methods, and applications" Inf. Fusion (2025) 10.1016/j.inffus.2024.102736

[29]

Enhanced discontinuity characterization in hard rock pillars using point cloud completion and DBSCAN clustering

Chuanqi Li, Jian Zhou, Kun Du et al.

International Journal of Rock Mechanics and Mining... 2025 10.1016/j.ijrmms.2024.106005

[30]

Xiao (2025)

[31]

Ma "sOPTICS: a modified density-based algorithm for identifying galaxy groups/clusters and brightest cluster galaxies" Mon. Not. R. Astron. Soc. (2025) 10.1093/mnras/staf115

[32]

Wu "Adaptive subarray partitioning for large-scale phased arrays using ISODATA" Electron. Lett. (2025) 10.1049/ell2.70212

[33]

Yu "Front end component adaptation based on X-Means algorithm" (2024)

[34]

Su "Massive data HBase storage method for electronic archive management" Int. J. Netw. Manage. (2025) 10.1002/nem.2308

[35]

Derrar "An objective function for evaluation of fragmentation schema in data warehouse" (2015)

Metrics

0

Citations

35

References

Details

Published: Jul 01, 2026
Vol/Issue: 195
Pages: 108117
License: View

Authors

Cite This Article

Mohamed Mouhiha, Abdelfettah Mabrouk (2026). An empirically-driven clustering framework for NoSQL data warehouse conversion: Optimizing column family design from relational big data using HDBSCAN. Information and Software Technology, 195, 108117. https://doi.org/10.1016/j.infsof.2026.108117

An empirically-driven clustering framework for NoSQL data warehouse conversion: Optimizing column family design from relational big data using HDBSCAN

You May Also Like