Supercharge Your Innovation With Domain-Expert AI Agents!

Database optimization method, database optimization device, electronic equipment and storage medium

An optimization method and database technology, which is applied in the database field and the financial field, can solve problems affecting user experience and system availability, slow speed, and long query time, so as to ensure practicality, improve use efficiency, and reduce labor costs.

Active Publication Date: 2021-10-22
工银科技有限公司 +1
View PDF6 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the process of realizing the concept of the present invention, the inventor found that when querying data from the database, some query statements take a long time and are slow, which greatly affects the user experience and system usability

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 optimization method, database optimization device, electronic equipment and storage medium
  • Database optimization method, database optimization device, electronic equipment and storage medium
  • Database optimization method, database optimization device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] Hereinafter, embodiments of the present disclosure will be described with reference to the drawings. It should be understood, however, that these descriptions are exemplary only, and are not intended to limit the scope of the present disclosure. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the present disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. Also, in the following description, descriptions of well-known structures and techniques are omitted to avoid unnecessarily obscuring the concepts of the present disclosure.

[0024] The terminology used herein is for the purpose of describing particular embodiments only, and is not intended to be limiting of the present disclosure. The terms "comprising", "comprising", etc. used herein indicate the existence of the above-menti...

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 provides a database optimization method which can be used in the database field, the financial field or other fields, and the method comprises the following steps: obtaining a query instruction aiming at a database, the query instruction comprising at least one query statement; determining whether the query statement is a slow query statement based on an anomaly detection model; under the condition that the query statement is determined to be a slow query statement, analyzing the slow query statement to determine an abnormal reason of the slow query statement; and selecting an optimization scheme corresponding to the abnormal reason from the relation list to optimize the slow query statement. In addition, the invention further provides a database optimization device, electronic equipment, a readable storage medium and a computer program product.

Description

technical field [0001] The present disclosure relates to the database field and the financial field, and more specifically, to a database optimization method, a database optimization device, an electronic device, a readable storage medium, and a computer program product. Background technique [0002] With the popularization of information technology, all aspects of life are inseparable from information systems, and most of the data in information systems are stored in databases. [0003] In the process of implementing the concept of the present invention, the inventors found that when querying data from the database, some query statements take a long time and are slow, which greatly affects user experience and system availability. Contents of the invention [0004] In view of this, the present disclosure provides a database optimization method, a database optimization device, an electronic device, a readable storage medium and a computer program product. [0005] One aspe...

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): G06F16/2453G06F16/242
CPCG06F16/2453G06F16/2433
Inventor 王宝松
Owner 工银科技有限公司
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