Unlock instant, AI-driven research and patent intelligence for your innovation.

Database management system external function calling method, device and equipment and medium

A technology for external functions and management systems, applied in the database field, which can solve the problems of robbing system resources and affecting the operation of database servers.

Active Publication Date: 2018-06-29
SHANGHAI DAMENG DATABASE
View PDF5 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] At present, most database management systems allow external functions (dll / so files or jar packages) to be called. There are two methods: one is to use sub-processes to execute, and the database management system will start an external function as long as it receives a request for an external function. Sub-processes execute their respective responses separately. The disadvantage is that if a large number of external functions are executed concurrently, a corresponding number of sub-processes needs to be started, and the sub-processes will rob each other of system resources; the second is to use plug-ins To execute, register the shared file (dll / so file or jar package) into an assembly as a plug-in of the database server, and reference this plug-in resource during the running process. The disadvantage is that once there is a problem with the shared file, it will affect to the entire database server running

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database management system external function calling method, device and equipment and medium
  • Database management system external function calling method, device and equipment and medium
  • Database management system external function calling method, device and equipment and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0027] This embodiment provides a method for calling an external function by a database management system. The method can be executed by the device for calling an external function provided by the database management system provided by the embodiment of the present invention. The device can be implemented in the form of software and / or hardware, and Generally can be integrated in the processor. Such as Figure 1A As shown, the method of this embodiment specifically includes:

[0028] S110. If the database server process determines that the external function execution request sent by the client is received, send the external function execution task to the AP auxiliary process through the database server process.

[0029] The database server process is a database executor used in the database management system to receive external function execution requests from clients. AP auxiliary process (Assistant Process) is an auxiliary process used to execute external function calls in ...

Embodiment 2

[0049] In this embodiment, based on the above embodiments, the communication mode between the database server process and the AP auxiliary process is selected as the pipeline communication mode, and the method for calling external functions by the above-mentioned database management system is explained in detail.

[0050] Wherein, the external function execution task will be sent to the AP auxiliary process through the database server process, specifically:

[0051] After the database server process acquires an idle dedicated pipeline from the pre-created pipeline pool or creates a new dedicated pipeline, an external function execution task message is generated, wherein the external function execution task message includes the pipeline of the dedicated pipeline name, task language type, and task information; if it is determined that the database server process opens the monitoring pipeline client, the database server process sends the external function execution task message to...

Embodiment 3

[0092] This embodiment provides a device for calling an external function by a database management system. The device can be implemented in software and / or hardware, and can generally be integrated into a processor. Such as image 3 As shown, the device includes: an external function execution task sending module 310, an external function execution task receiving module 320, an external function execution task execution module 330 and an external function execution result feedback module 340, wherein:

[0093] The external function execution task sending module 310 is configured to send the external function execution task to the AP auxiliary process through the database server process if it is determined through the database server process that the external function execution request sent by the client is received, wherein the AP auxiliary process The process is an auxiliary process used by the database management system to execute the external function call function;

[009...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a database management system external function calling method, device and equipment and a medium. The method comprises the steps that if it is determined that an external function execution request sent by a client is received in the database server process, an external function execution task is sent to an AP auxiliary process through the database server process, wherein the AP auxiliary process is used for executing the external function calling function; the external function executing task is received through the AP auxiliary process; a third party sharing library is loaded through the AP auxiliary process, the external function executing task is executed, the execution result is obtained, and the execution result is returned back to the database server process;the execution result returned by the AP auxiliary process is received through the database server process, and the executing result is sent to the client. According to the method, the database management system external function calling method in the prior art is optimized, and the database server stability and the external function execution efficiency are improved.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of databases, and in particular to a method, device, equipment and medium for a database management system to call external functions. Background technique [0002] The external function is a function written in C language or JAVA language, compiled outside the database and stored in a third-party shared library, and called by the user through PL / SQL (Procedural Language / SQL, procedural SQL language). Among them, the C language environment The shared files under the JAVA language environment are jar packages as dll files (Windows system) and so files (Linux system). The user-defined function outside the database is executed in the database, which becomes an external function. The way the database uses external functions greatly expands the stored procedures or execution methods of the SQL language to meet the needs of users. [0003] At present, most database management systems al...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30G06F9/445G06F9/48G06F9/54
CPCG06F9/44521G06F9/4843G06F9/544G06F9/546G06F16/25
Inventor 王家贤刘静
Owner SHANGHAI DAMENG DATABASE