Research And Implementation Of GKD-Base PL/SQL Stored Procedure And Package

With the wide application of computer in military affairs field, information has become an important factor of war victory in high technology environment. As the kernel of information system, Database Management System (DBMS) is charged with information storage and management and is playing more and more important role in information war. GKD-Base is a native Security Database Management System. Compared with commercial DBMS, GKD-Base has many limitations for lack of some important functions, It needs extending and upgrade. This project's intention is to solve the key technique in GKD-Base's function extending.Firstly, this paper designs the GKD-Base PL/SQL engine's application mode and whole structure, and then discusses some key technology in implementation. Secondly, this paper lucubrates ORACLE PL/SQL stored procedure and package mechanism based on GKD-Base, and carries out the implementation scheme of the stored procedure and package mechanism. And finally, the stored procedure and package are implemented on the GKD-Base PL/SQL engine.In the forepart of this project, PL/SQL engine's basic function is implemented. In the implementation of stored procedure, stored procedure's intermediate code of stored procedure is expressed by syntax tree. Function manager and execution state stack is designed to solve the execution of intermediate code and function recursion. In the implementation of package, intermediate code after package's being precompiled is stored in package manager. Effective memory mode is designed and execution of function in the package is implemented.GKD-Base PL/SQL engine and stored procedure and package is compatible with ORACLE PL/SQL V2.3.