关键词: 数据库迁移, SQL Server, HBase, 分布式数据库模式

Abstract: Nowadays, the large amount of information generated in Internet makes the entire applications become larger in the scale of data and have higher visit capacity. And it requires better performance in the database layer of an application which bears enormous loads, while the distributed database HBase can solve this problem. Based on HBase which is a very popular distributed database, this paper proposes the methods to design a tool to migrate database which is on the huge amounts of data from the relational database to HBase, and realizes this semi-automated migration tool according to the four ways of converting table patterns mentioned here. Then this paper chooses the HouseDIY which is a typical E-commerce Web application as an example, shows how this tool works in detail, and demonstrates that this tool can do migration from the original SQL Server database of an application to HBase easily and quickly. Finally, this paper compares the tool with Kettle and explains that the tool has high performance in joins query.

Key words: database migration, SQL Server, HBase, distributed database pattern