Abstract
Trigger technology is an important part of database design and development. It is an important function module of database management system. It is a special type of stored procedure. The implicit implementation of the trigger makes it an effective way to ensure data integrity in the database. OceanBase is a new type of mass distributed database system, but the existing OceanBase open-source version does not support the trigger function, affecting the system to promote and use. Based on the deep analysis of the working principle of traditional database triggers and the overall architecture of OceanBase, this paper designs and implements the trigger function of OceanBase.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Plattner, H.: A common database approach for OLTP and OLAP using an in-memory column database. In: Proceedings of the 2009 ACM SIGMOD International Conference on Management of Data, pp. 1–2. ACM (2009)
OceanBase [EB/OL]. https://github.com/alibaba/oceanbase. Accessed 05 July 2016, 03 Jan 2017
Stonebraker, M., Weisberg, A.: The VoltDB main memory DBMS. IEEE Data Eng. Bull. 36(2), 21–27 (2013)
Chang, F., Dean, J., Ghemawat, S., et al.: Bigtable: a distributed storage system for structured data. ACM Trans. Comput. Syst. (TOCS) 26(2), 4 (2008)
Corbett, J.C., Dean, J., Epstein, M., et al.: Spanner: Google’s globally distributed database. ACM Trans. Comput. Syst. (TOCS) 31(3), 8 (2013)
Yang, Z.: The architecture of OceanBase relational database system. J. East China Normal Univ. (Nat. Sci.) (5), 141–148 (2014)
Wei-xue, L.I.U.: Further study on trigger of SQL server database. Comput. Technol. Dev. 23(10), 48–51 (2013)
Silberschatz, A., Korth, H.F., Sudarshan, S.: Database System Concepts. McGraw-Hill, New York (1997)
Zuo, W.: Research on Active Database Theory. Jilin University (2005)
IBM [EB/OL]. https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/apsg/src/tpc/db2z_triggercascade.html. Accessed 03 Jan 2017
Zhu, T., Zhou, M., Zhang, Z.: Study on stored procedure implementation oriented to OceanBase. J. East China Normal Univ. (Nat. Sci.) (5), 281–289 (2014)
Zhu, J., Liu, B., Yu, S., Gong, X., Zhou, M.: Design and implementations of stored procedure in OceanBase. J. East China Normal Univ. (Nat. Sci.) (5), 144–152 (2016)
Aho, A.V., Sethi, R., Ullman, J.D.: Compilers, Principles, Techniques. Addison Wesley (1986)
Shen, Y.J., Yang, H.Q.: The realization of teaching case design database integrity by using triggers in SQLSever2005. In: Computer CD Software and Applications, vol. 5, no. 19, pp. 240–242 (2012)
Hu, H.N.: Application of SQL server triggers in database design. In: Computer Programming Skills and Maintenance, vol. 19, no. 8, pp. 37–38 (2012)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2019 Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Xu, Ly., Zhang, Xf., Zhang, Lj., Gao, Jt. (2019). Design and Implementation of Trigger on OceanBase. In: Bhatia, S., Tiwari, S., Mishra, K., Trivedi, M. (eds) Advances in Computer Communication and Computational Sciences. Advances in Intelligent Systems and Computing, vol 760. Springer, Singapore. https://doi.org/10.1007/978-981-13-0344-9_10
Download citation
DOI: https://doi.org/10.1007/978-981-13-0344-9_10
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-13-0343-2
Online ISBN: 978-981-13-0344-9
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)