The Design And Implementation Of SQL Access Interface To HBase

Nowadays, people have entered the information age. Mobile communication and Internet are becoming more and more important in people's production and life. Information age requires the support of massive data. Gradually, the traditional relational database is not suitable for large data storage and management. Based on this background,NoSQL database is born at the right moment. Especially, HBase receives more attention. HBase greatly improves the storage efficiency of large amounts of data. However, compared with traditional relational databases,HBase does not have SQL queries. Therefore, a support SQL access interface for HBase is achieved in this paper.In this paper, the SQL access interface of HBase is investigated and some essential issues are solved. In this paper, the hierarchical design structure is used to divide the access layer into two layers: SQL parsing layer and pattern matching layer. JSQLParser tools are used to complete the SQL lexical and syntax analysis to achieve a higher analytical efficiency. In order to solve the problem that relational database table model does not correspond with HBase table mode, a table schema mapping is designed. The access interface has achieved the basic functions of most of the SQL statement and greatly simplified the difficulty of application development.This paper first analyzes the overall requirements of the SQL access interface, including the functional requirements and non-functional requirements of the interface. Then the interface design is analyzed, and the detailed design and implementation of each module in the interface are given. The key problems and solutions in the interface design and development process are also described in detail. At last, the test of interface is introduced in detail, and the work of the paper is summarized and forecasted.