Transforming relational database into HBase: A case study

With the development of distributed system and cloud computing, more and more applications might be migrated to the cloud to exploit its computing power and scalability, where the first task is data migration. In this paper, we propose a novel approach that transforms a relational database into HBas...

Full description

Saved in:
Bibliographic Details
Published in2010 IEEE International Conference on Software Engineering and Service Sciences pp. 683 - 687
Main Author Chongxin Li
Format Conference Proceeding
LanguageEnglish
Published IEEE 01.07.2010
Subjects
Clouds
data transformation
Electronic mail
HBase
Information services
Internet
Relational databases
schema mapping
Web sites
Online AccessGet full text
ISBN1424460549
9781424460540
ISSN2327-0586
DOI10.1109/ICSESS.2010.5552465

Cover

More Information
Summary:With the development of distributed system and cloud computing, more and more applications might be migrated to the cloud to exploit its computing power and scalability, where the first task is data migration. In this paper, we propose a novel approach that transforms a relational database into HBase, which is an open-source distributed database similar to BigTable. Our method is comprised of two phases. In the first phase, relational schema is transformed into HBase schema based on the data model of HBase. We present three guidelines in this phase, which could be further utilized to develop an HBase application. In the second phase, relationships between two schémas are expressed as a set of nested schema mappings, which would be employed to create a set of queries or programs that transform the source relational data into the target representation automatically.
ISBN:1424460549
9781424460540
ISSN:2327-0586
DOI:10.1109/ICSESS.2010.5552465