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

Automated database index creation method and system

A technology of automatic creation and database, applied in the field of database, can solve the problems such as difficult to save index validity and low efficiency, and achieve the effect of improving validity, efficiency and overall performance

Active Publication Date: 2014-05-21
ALIBABA GRP HLDG LTD
View PDF5 Cites 38 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The establishment of indexes generally depends on the database maintenance personnel’s understanding and experience of the statements to be audited and the business, which is not only inefficient, but also difficult to preserve the validity of the established indexes

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
  • Automated database index creation method and system
  • Automated database index creation method and system
  • Automated database index creation method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0068] In order to make the purpose, technical solutions, and advantages of the present application clearer, the embodiments of the present application will be described in detail below in conjunction with the accompanying drawings. It should be noted that the embodiments in this application and the features in the embodiments can be combined with each other arbitrarily if there is no conflict.

[0069] Such as figure 1 As shown, the method for automatically creating a database index in this embodiment includes:

[0070] Step 110: Obtain the data source corresponding to the database operation sentence to be audited, and instantiate the database connection according to the data source, and the database information containing the sample data is stored in the data source;

[0071] The above data source can directly use the database operation statement to be audited, such as the data source used after the SQL statement goes online, or the corresponding test data source. The distribution ...

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 an automated database index creation method and system. The method comprises the steps: obtaining a data source corresponding to a database operation statement to be approved and instantiating the database connection; processing each database operation statement to be approved in a way of determining a database table used in the database operation statement and an index related field used in each database table; obtaining a field combination of an existing index of the database table from the data source; for each database table, creating a database index when a set formed by the index related fields in the database table is not a sub-set or a superset of the combination of each existing index of the database table and a corresponding database index is not created yet. The invention also provides the corresponding system. According to the automated database index creation method and system, automatic creation of indexes is realized according to the database operation statement to be approved and sample data, and the efficiency of the index creation is improved.

Description

Technical field [0001] This application relates to database technology, and more specifically, to a method for creating a database index and a corresponding system. Background technique [0002] The index is like a directory index in a dictionary, helping users find the corresponding information faster. The amount of data in the tables of the online database is very large. It is necessary to establish an efficient index to increase the speed of query and modification. The slow response of the large database table operation will also affect the front-end business. If there is no suitable index when performing table operations for business requirements, the efficiency of query and modification will be low, and the business will be seriously affected. [0003] When a new function is launched or the logic of an existing function is modified, the database maintainer should review the database operation statements that will be used online, such as SQL (Structured Query Language) stateme...

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/2228
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