面向OceanBase的存储过程实现技术研究

Study on stored procedure implementation oriented to OceanBase

存储过程是一段被命名后保存在数据库服务器端,并预先编译好的代码,可以减少前台应用程序和后台数据库间的网络传输量.本文主要研究基于静态语言和动态语言,两种典型的存储过程实现方法,来阐述存储过程实现的基本原理.并基于此,进一步探讨了在OceanBase主存数据库服务器中添加存储过程模块的解决方案和技术难点.

A stored procedure is a pre-compiled subroutine stored in database server, which im-proves the efficiency of applications database access. This paper discussed the implementation ofstored procedure based on both static language and dynamic language. Besides, we gave a prima-ry design for implementing stored procedures in OceanBase.