Supercharge Your Innovation With Domain-Expert AI Agents!

Method and system for database index optimization based on virtual index

A virtual index and optimization method technology, applied in the database field, can solve the problems of unguaranteed query efficiency and inability to match the existing environment, so as to achieve the effect of improving actual query speed, improving query performance, and reducing overhead

Pending Publication Date: 2021-11-26
E-SURFING DIGITAL LIFE TECH CO LTD
View PDF2 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The method of this patent analyzes the SQL statement input by the developer to obtain index optimization suggestions, which can help create or optimize the index before the SQL goes online; but when the data volume of the database table changes or the distribution of the table data changes in the actual environment, it is necessary to create the index before going online. The index does not match the existing environment, and the query efficiency cannot be guaranteed

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 database index optimization based on virtual index
  • Method and system for database index optimization based on virtual index
  • Method and system for database index optimization based on virtual index

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] The present invention will be described in detail below in conjunction with the accompanying drawings, and the features of the present invention will be further revealed in the following detailed description.

[0056] figure 1 is an example architecture diagram of a virtual index-based database index optimization system 100 according to an embodiment of the present invention. like figure 1 As shown in , the system 100 of the present invention includes a production module 101 , a replication module 102 and a self-analysis module 103 .

[0057] The production module 101 includes a timing unit 104 , an anomaly detection unit 105 , a user log unit 106 and a production database 107 . The production database 107 is a database that actually runs business. The user log unit 106 is responsible for recording and counting the user query situation in the preset time period, including the original file of the slow query log, and the slow query SQL statement (sql_text) generated b...

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 method and a system for database index optimization based on a virtual index. The method comprises the following steps: in response to an index updating request, synchronizing a production database and log information; creating a virtual index set based on analysis of corresponding query statements in the log; selecting one or more optimal indexes based on the actual query execution time of each virtual index in the virtual index set and automatically updating to a production database; and re-selecting one or more optimal indices and automatically updating to the production database based on a virtual index evaluation value reflecting improvement for query execution time before and after each index is created.

Description

technical field [0001] The invention relates to the field of databases, and more specifically, to a virtual index-based database index optimization method and system. Background technique [0002] Databases are ubiquitous in software systems. Whether it is a web application or a mobile app, it is inseparable from the database. Among them, MySQL is one of the most popular relational database management systems. It is favored by developers and has gradually become a mainstream database solution. It is widely used in various business fields. [0003] An index is a structure that sorts the values ​​of one or more columns in a database table, and provides pointers to the data values ​​stored in the specified columns of the table. A good index can greatly reduce the execution time of SQL statements and improve the performance of applications. Data query efficiency. [0004] The creation of current indexes mainly depends on the experience of developers. When developers 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): G06F16/22G06F16/2453G06F16/25
CPCG06F16/2228G06F16/2453G06F16/256
Inventor 曹靖城张继东王猛德王培才
Owner E-SURFING DIGITAL LIFE TECH 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