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

fYear

2015

Firstpage

81

Lastpage

89

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;

fLanguage

English

Publisher

ieee

Conference_Titel

Cloud Computing (CLOUD), 2015 IEEE 8th International Conference on

Conference_Location

New York City, NY

Print_ISBN

978-1-4673-7286-2

Type

conf

DOI

10.1109/CLOUD.2015.21

Filename

7214031