Data partition optimisation for column-family NoSQL databases. (2017)

• Record Type: Journal Article
• Authors: Hsieh, Meng-Ju; Ho, Li-Yung; Wu, Jan-Jan; Liu, Pangfeng
• Is Part Of: International journal of big data intelligence. Volume 4:Number 4(2017)
• Page Start: 263
• Page End: 275
• Publication Date: 2017
• Subjects: vertical partition -- column partition -- column family -- NoSQL database; Big data -- Periodicals; 005.705
• Languages: English
• ISSNs: 2053-1389

Abstract

Data conversion has become an emerging topic in BigData era. To face the challenge of rapid data growth, legacy or existing relational databases have the need to convert into NoSQL column-family database in order to achieve better scalability. The conversion from SQL to NoSQL databases requires combining small, normalised SQL data tables into larger NoSQL data tables; a process called denormalisation. A challenging issue in data conversion is how to group the denormalised columns in a large data table into 'families' in order to ensure the performance of query processing. In this paper, we propose an efficient heuristic algorithm, graph-based partition algorithm (GPA), to address this problem. We use TPC-C and TPC-H benchmarks to demonstrate that the column-families produced by GPA is very efficient for large-scale data processing.