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

Method and system for monitoring SQL operation process

An operation process, the only technology, applied in the information field, can solve problems such as inability to perform record and analysis, and achieve the effect of being conducive to post-maintenance, convenient processing, and improving accuracy

Inactive Publication Date: 2016-10-12
北京思特奇信息技术股份有限公司
View PDF8 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The technical problem to be solved by the present invention is to provide a method and system for monitoring the running process of SQL, which is used to solve the problem that the execution situation cannot be recorded and analyzed during the execution of the SQL program by the traditional SHELL script

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 system for monitoring SQL operation process
  • Method and system for monitoring SQL operation process
  • Method and system for monitoring SQL operation process

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0039] Such as figure 1 As shown, it is a schematic flow diagram of a method for monitoring SQL running process of the present invention, comprising the following steps:

[0040] Step 1, define the SQL statement to be executed and the execution phase of the SQL statement;

[0041] Step 2, define the execution format and execution parameters of the SQL execution function;

[0042] Step 3, calling the SQL execution function, putting the SQL statement into the ORACLE database for execution through the SQL execution function, generating an execution log, and returning an execution result;

[0043] Step 4, according to the return value format of the ORACLE database, use the log analysis function to analyze the executio...

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 particularly relates to a method and system for monitoring an SQL operation process. The method includes the following steps: defining an executed SQL statement and an execution phase of the executed SQL statement; defining an execution format and an execution parameter of an SQL execution function; calling the SQL execution function, putting the SQL statement in an ORACLE database to be executed through the SQL execution function, generating an execution log, and returning an execution result; using a log analysis function to analyze the execution result according to a return value format of the ORACLE database, and generating an analysis result; recording analysis data generated during the analysis process of a step 4, and forming a data table; and displaying the execution result, the analysis result and / or the data table. The method and system performs dynamic monitoring and detailed recording on the execution process of the SQL statement, can analyze the SQL execution result, is convenient in processing, can provide a basis for later program optimizing, facilitate later maintenance, and can improve the accuracy of data processing and the maintainability of the programs.

Description

technical field [0001] The invention relates to the field of information technology, in particular to a method and system for monitoring the running process of SQL. Background technique [0002] With the popularization of business in the telecommunications industry and the acceleration of business expansion, the volume of business data has become an explosive growth model, making it more difficult to process data. As a result, the monitoring requirements for the data processing process are getting higher and higher. It has the ability to analyze after the event, so as to provide a basis for the optimization and maintenance of the program. The existing technology has the following problems: first, the execution process cannot be recorded in detail, and the data processing program and SQL statement execution cannot be paid attention to in real time during the program execution process; second, the program execution cannot be detailed afterwards. thirdly, there is no implement...

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): G06F11/32G06F11/30
CPCG06F11/328G06F11/302
Inventor 侯波
Owner 北京思特奇信息技术股份有限公司
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