PSM compiler optimizer and method for processing bulk DML
A PSM complier optimizer analyzes a pattern of the PSM program to generate instruction codes, which will be subjected to a bulk operation and makes the instruction codes for the bulk operation in a form of an array of bind parameters to perform a bulk cursor. Accordingly, the bulk DML processing improves the performance of the PSM program.
1. A PSM compiler optimizer comprising:
a code generator configured to analyze the pattern of a PSM program to pick out instruction codes that will be subjected to a bulk operation from the PSM program and produce codes for the bulk operation with respect to the instruction codes that will be subjected to the bulk operation;
a virtual machine configured to interpret the bulk operation codes to produce DMLs depending on the bulk operation;
a query executor configured to process the DMLs produced by the virtual machine,
wherein the virtual machine is configured to maintain the DMLs stored in a memory if the number of the DMLs is less than or equal to a predetermined value and forward the DMLs stored in the memory to the query executor when the number of the DMLs reaches the predetermined value; and
wherein the query executor is configured to batch-process the DMLs forwarded from the virtual machine.
2. The PSM complier optimizer of claim 1 , wherein when a DML statement and other statement different from the DML statement are mixed in the bulk operation codes, the virtual machine is configured to add TCL information to the bind parameters included in the other statements so that the query executor identifies that the DML statement and the other statement different from the DML statement are mixed in the bulk operation codes.
3. The PSM complier optimizer of claim 2 , wherein the query executor is configured to check whether the DML statement and the other statement different from the DML statement are mixed in the bulk operation codes using the TCL information and perform a procedure adapted for the other statement different from the DML statement when the other statement is mixed with the DML statement in the bulk operation codes.
4. A method for processing a bulk DML, the method comprising:
analyzing, in a PSM optimizer, the pattern of a PSM program to pick out instruction codes that will be subjected to a bulk operation from the PSM program;
producing, in a virtual machine, bulk operation codes with respect to the instruction codes that will be subjected to the bulk operation;
interpreting, in the virtual machine, the bulk operation codes to produce DMLs depending on the bulk operation;
forwarding, in the virtual machine, the DMLs to a query executor when the number of the DMLs reaches a predetermined value; and
performing a batch-process on the DMLs forwarded from the virtual machine.
5. The method of claim 4 , said forwarding the DMLs to the query executor comprises:
counting the number of the DMLs produced by the virtual machine;
storing the DMLs in a memory when the number of the DMLs is less than or equal to the predetermined value;
forwarding the DMLs stored in the memory to the query executor when the number of the DMLs reaches the predetermined value.
6. The method of claim 4 , said performing the batch-process on the DMLs comprises:
checking whether a DML statement and other statement different from the DML statement are mixed in the DMLs produced by the virtual machine;
batch-processing the DMLs when there exists only the DML statements; and
performing a procedure adapted for the other statement different from the DML statement when the other statement is mixed with the DML statement.
7. The method of claim 6 , said checking whether a DML statement and other statement different from the DML statement are mixed in the DMLs comprises identifying whether the TCL information exists in the DML statement to check whether the other statement is mixed with the DML statement in the DMLs.