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
CN106021071AInactive Publication Date: 2016-10-12北京思特奇信息技术股份有限公司
8 Cites 13 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
北京思特奇信息技术股份有限公司
Publication Date
2016-10-12
Estimated Expiration
Not applicable · inactive patent

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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