Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and device for executing SQL script file in distributed system

A distributed system and script file technology, applied in the direction of multi-program devices, etc., can solve problems such as excessive occupation of memory resources and public resources, long server-side execution time, and server-side performance degradation, achieving less interaction costs and saving Memory space, the effect of improving efficiency

Active Publication Date: 2007-12-26
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF0 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For general small SQL script files, this process is basically not a big problem, but for relatively large SQL script files, there are big problems, mainly manifested in the excessive occupation of memory resources and public resources, which in turn leads to server end performance degradation
In addition, because the client has been waiting for the return of the execution of the SQL server, and the execution of the server takes a long time, the memory occupied by the client cannot be released, and it is always in the hang-up state, causing some other operations on the client. severe impact

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
  • Method and device for executing SQL script file in distributed system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] In order to make the above objects, features and advantages of the present invention more comprehensible, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0031] First of all, the inventor has carried out an in-depth analysis on the prior art, as follows:

[0032] (1) Since the client needs to temporarily store the read SQL script file, since the file is relatively large, it needs to apply for a large amount of memory to save the file; resulting in excessive occupation of client memory resources and affecting other data processing on the client process.

[0033] (2) Due to the large amount of data in the SQL script file, it is likely to cause blocking on the SQL server side, and in serious cases, it will affect the performance of various aspects of the SQL server. First of all, if the SQL server processes more scripts, the memory occupied will increase correspondingly; moreover, wh...

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

A method for executing SQL script file (SF) in distributed system includes using the first linear program to divide SQL SF to be multiple script block and placing each script block in sequence into preset buffer region (PBR), pausing the first linear program if PBR is full and executing the first linear program continuously till PBR is again to have space, using the second linear program to fetch one script block in buffer region and to release relevant storage space as well as to transmit content of said script block to server end, fetching next script block in buffer region after execution feedback information of server end is received repeating above steps till SQL SF is all executed.

Description

technical field [0001] The invention relates to the field of data online processing, in particular to a method and a device for executing SQL script files in a distributed system. Background technique [0002] Since the advent of computers, data has been stored, and the storage organization and management of data has become one of the most basic problems that computers need to solve. The initial data, fighting independently, is stored in the form of files. Different applications, different files and the same data cause a waste of resources and manpower. With the increasing amount of data stored in computers, the problem of data duplication is becoming more and more prominent, so people think of centralized storage and unified management of data, which evolves into a database management system and forms database technology. The research and development of database technology has become an important field with strong vitality in the modern information society. In most of the...

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
IPC IPC(8): G06F9/46
Inventor 徐锋
Owner KINGDEE SOFTWARE(CHINA) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products