Title :
From Relations to Multi-dimensional Maps: Towards an SQL-to-HBase Transformation Methodology
Author :
Serrano, Diego ; Dan Han ; Stroulia, Eleni
Author_Institution :
Dept. of Comput. Sci., Univ. of Alberta Edmonton, Edmonton, AB, Canada
Abstract :
In this paper, we describe a method for transforming and migrating data schemas developed for RDBMS to HBase. The method consists of a set of HBase-organization guidelines and a four-step data-schema transformation process that HBase application developers may follow during the migration of their application data from RDBMSs to HBase. The method also considers data-access paths extracted from query logs, in order to improve the quality of the transformation and the eventual access efficiency of the HBase repository. We illustrate and validate the method with a case study.
Keywords :
query processing; relational databases; HBase application developers; HBase repository; HBase-organization guidelines; RDBMS; SQL-to-HBase transformation methodology; access efficiency improvement; application data migration; data schema migration; data-access path extraction; four-step data-schema transformation process; multidimensional maps; query logs; transformation quality improvement; DVD; Data models; Encoding; Indexes; Merging; Spatial databases; HBase; migration; schema transformation;
Conference_Titel :
Cloud Computing (CLOUD), 2015 IEEE 8th International Conference on
Conference_Location :
New York City, NY
Print_ISBN :
978-1-4673-7286-2
DOI :
10.1109/CLOUD.2015.21
