Supercharge Your Innovation With Domain-Expert AI Agents!

SQL (structured query language) Statement performance optimizing method and device based on Oracle database

A technology of an optimization device and an optimization method, applied in the computer field, can solve the problems of inconsistent optimization principles, reduce the efficiency of optimizing SQL statements, etc., and achieve the effect of improving efficiency

Active Publication Date: 2017-10-13
CHINA UNITED NETWORK COMM GRP CO LTD
View PDF5 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Generally speaking, 80% of database performance problems are caused by inefficient structured query language (StructuredQuery Language, referred to as SQL). The optimization of the database is mainly to optimize the inefficient SQL statement, and each SQL requires a database administrator. Participate in optimization, DBA due to individual differences, resulting in inconsistent optimization principles, reducing the efficiency of optimizing SQL statements

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
  • SQL (structured query language) Statement performance optimizing method and device based on Oracle database
  • SQL (structured query language) Statement performance optimizing method and device based on Oracle database
  • SQL (structured query language) Statement performance optimizing method and device based on Oracle database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] figure 1 It is a flowchart of a method for optimizing the performance of SQL statements based on an Oracle database provided by an embodiment of the present invention. The embodiment of the present invention provides the SQL statement performance optimization method based on Oracle database, and the method steps are as follows:

[0024] Step S101, collecting SQL statements being executed within a preset period.

[0025] Step S102, generating a data flow including identification information of the SQL statement and an optimal execution plan.

[0026] Step S103, parsing the data stream, and obtaining the identification information of the SQL statement.

[0027] Step S104 , taking the identification information of the SQL statement as an input parameter, and generating programs corresponding to all execution plans of the identification information of the SQL statement that can be bound to the execution plan.

[0028] Step S105 , analyzing the data stream, obtaining the ...

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

An embodiment of the invention provides an SQL (structured query language) statement performance optimizing method and device based on Oracle database; the method comprises: acquiring an SQL statement that is being executed in a preset period; generating identifier information including the SQL statement and a data stream of an optimal execution plan; analyzing the data stream to acquire the identifier information of the SQL statement; using the identifier information of the SQL statement as an incoming parameter, and generating bindable execution plan programs corresponding to all execution plans for the identifier information of the SQL statement; analyzing the data stream to obtain the identifier information of the SQL statement and the optimal execution plan; acquiring a binding program matching with the optimal execution plan to generate an optimizing program; optimizing the SQL statement. The method and device according to the embodiment optimize low-efficiency SQL statements, participating of database managers is not required, optimization rules are uniformized, and SQL statement optimizing efficiency is improved.

Description

technical field [0001] The embodiment of the present invention relates to the field of computer technology, in particular to a method and device for optimizing the performance of SQL statements based on an Oracle database. Background technique [0002] Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system developed by Oracle Corporation. It is a product that has always been in a leading position in the database field. It is widely used in various industries, such as government, transportation, public security, telecommunications, finance, energy and other departments, and has gradually become an important database platform for enterprise information construction. However, with the expansion of the Oracle database scale and the increase in the number of database users, Database performance problems are becoming more and more prominent, so Oracle database performance optimization has become one of the most important t...

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): G06F17/30
CPCG06F16/24542G06F16/284
Inventor 伍军张晖陈静林晨王延军王东
Owner CHINA UNITED NETWORK COMM GRP CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com