在非關聯式資料庫上實作預存性的資料庫查詢語言

SQL/PSM Design and Implement on NoSQL Database

陳志賢(Chen, Chih Hsien)

指導教授 ： 鍾葉青

國立清華大學/電機資訊學院/資訊工程學系/碩士(2015年)

摘要

本篇論文的重點在於在Phoenix上實作SQL/Persistent Stored Module, 其中包括Stored Procedure, User-Defined Function, Trigger的實作來完成HBase上面的SQL邏輯操作, 藉由Phoenix我們可以使用SQL操作HBase的Table, 藉由先把邏輯寫入Persistent Stored Module存入資料庫, 減少重複寫邏輯的時間

關鍵字

資料庫 ； 程序 ； 預儲模組

並列摘要

In recent years, the size of datasets grows rapidly. Many NoSQL databases for storing big data started to appear. In relational database, they provides persistent stored module functionality for users to write module and store in database dictionary.
This feature makes users reduce time to rewrite a program. Users just call the module. In NoSQL database, lots of communities makes SQL back on NoSQL, for example, Phoenix. But they don’t provides these functionalities. In this paper, we implement these functionalities for users to enjoy benefits of persistent stored module.
Apache HBase is a NoSQL database. It is on the top of HDFS and has good Scalability, and Fault Tolerance for storing big data. It provides flexible API, Java API and Restful API, for users to access. It’s a data concurrency and partition tolerance type system. We choose HBase as our storage. We use Apache phoenix as our SQL query interface. Apache Phoenix is a JDBC and queries for HBase.
Finally, we make user can use NoSQL database for processing big data and reduce time to rewrite a program.

參考文獻

16. Lam C, Warren J: Hadoop in Action. Manning Publications; 2010.

1. Apache Phoenix – Apache Software Foundation project, https://phoenix.apache.org

3. Hive – Apache Software Foundation project, http://hive.apache.org/

18. White T: Hadoop: The Definitive Guide, 4th Edition

21. Dean J, Ghemawat S: MapReduce: A Flexible Data Processing Tool.