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

Database index creation method and device

A database and index technology, applied in the database field, can solve problems such as database indexes occupying DBA time, DBA cannot understand business, and affect the normal operation of online business applications, etc., to achieve the effect of improving efficiency.

Active Publication Date: 2017-08-04
ALIBABA GRP HLDG LTD
View PDF6 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

As the scale of business scenarios continues to expand, it is impossible for DBAs to understand all businesses, so that the establishment of database indexes will be out of touch with actual business needs, resulting in inefficient creation of database indexes, which will affect the normal operation of online business applications at any time
At the same time, the establishment and maintenance of database indexes also take up a lot of DBA time
[0004] In the prior art, a scheme for automatically creating database indexes based on effective data distribution is proposed. However, in this scheme, the establishment of database indexes needs to be based on the effective data distribution in the database, and it is required to simulate the online data distribution as realistically as possible. Then in the new When the database or new business goes online, because there is no task business data to write and the effective data distribution of the database is lacking, this database index establishment scheme based on effective data distribution has some defects. The contradiction between the two is that the database index needs to be processed before the business goes online Established, and the establishment of the database index depends on the effective data distribution in the business

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 index creation method and device
  • Database index creation method and device
  • Database index creation method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] In order to make the purpose, technical solutions, and advantages of the embodiments of the present application clearer, the embodiments of the present application will be further described in detail below in conjunction with the accompanying drawings. Here, the exemplary embodiments of the application and their descriptions are used to explain the application, but not to limit the application.

[0057] The inventor found through research that the automatic creation of SQL statement database indexes is an inevitable trend in the development of large-scale databases and application operation and maintenance, and that the creation of database indexes without valid data is a blank spot in automatic SQL statement optimization technology. The existing Oracle and The optimization tools of SqlServer are based on the online real data operating environment for SQL analysis, but online debugging will inevitably affect the application, so it is a more suitable and lower cost soluti...

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 discloses a database index creation method and device. The method comprises the steps that according to the following steps, a database index is created for each structured query language (SQL) statement in a database; historical metadata of each query condition field in the SQL statement is determined; according to the historical metadata of each query condition field, the weight function of each query condition field is determined; according to the weight function of each query condition field, the database index is created for the SQL statement. According to the database index creation method and device, in an automatic database index creation process, the influence on the database index creation caused by business scenarios and no valid data distribution in the database can be avoided.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a database index creation method and device. Background technique [0002] Database (Database) organizes, stores and manages data according to the data structure. A database index sorts the values ​​of one or more columns in a database table and establishes a directory. Using a database index, you can quickly access specific information in a database table. [0003] The creation and maintenance of database indexes are irreplaceable tasks in the daily business of a DBA (Database Administrator). One of the main daily tasks of a DBA is SQL (Structured Query Language, Structured Query Language) tuning. One of the important means of SQL tuning is to build appropriate database indexes for slow SQL queries. The establishment of database indexes requires a certain understanding of business scenarios and database experience. The degree of understanding of business scenarios ...

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/2228G06F16/2433
Inventor 王明叶正盛
Owner ALIBABA GRP HLDG LTD
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

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

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