Respected readers, authors and reviewers, you can add comments to this page on any questions about the contribution, review, editing and publication of this journal. We will give you an answer as soon as possible. Thank you for your support!
ZHU Jun, LIU Bai-zhong, YU Sheng-jun, GONG Xue-qing, ZHOU Min-qi. Designs and implementations of stored procedure in OceanBase[J]. Journal of East China Normal University (Natural Sciences), 2016, (5): 144-152. doi: 10.3969/j.issn.1000-5641.2016.05.016
Citation:
ZHU Jun, LIU Bai-zhong, YU Sheng-jun, GONG Xue-qing, ZHOU Min-qi. Designs and implementations of stored procedure in OceanBase[J]. Journal of East China Normal University (Natural Sciences), 2016, (5): 144-152. doi: 10.3969/j.issn.1000-5641.2016.05.016
ZHU Jun, LIU Bai-zhong, YU Sheng-jun, GONG Xue-qing, ZHOU Min-qi. Designs and implementations of stored procedure in OceanBase[J]. Journal of East China Normal University (Natural Sciences), 2016, (5): 144-152. doi: 10.3969/j.issn.1000-5641.2016.05.016
Citation:
ZHU Jun, LIU Bai-zhong, YU Sheng-jun, GONG Xue-qing, ZHOU Min-qi. Designs and implementations of stored procedure in OceanBase[J]. Journal of East China Normal University (Natural Sciences), 2016, (5): 144-152. doi: 10.3969/j.issn.1000-5641.2016.05.016
As an extension of standard SQL(Structured Query Language), the stored procedure is an important feature in modern databases. OceanBase is a new type of
distributed database system which supports massive data processing, but the open-sourced version OceanBase does not support stored procedure, which influences its adoption in enterprises. In this paper, we analyze the principle of stored procedure and the query processing mechinism of OceanBase in detail. Then, the complete design and implementation of stored procedure which supports PL/SQL are presented.