Index creation method and device, electronic equipment and storage medium

An index and statement technology, applied in the database field, can solve problems such as copy blocking from the database, long time-consuming, etc.

Pending Publication Date: 2020-10-09
NETEASE (HANGZHOU) NETWORK CO LTD
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present disclosure is to provide an index creation method, an index creation device, an electronic device, and a computer-readable storage medium, so as to overcome at least to a certain extent the slave library copy blocking and the master library and the It takes a long time to complete the index creation from the library as a whole, etc.

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
  • Index creation method and device, electronic equipment and storage medium
  • Index creation method and device, electronic equipment and storage medium
  • Index creation method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0093] The principle and spirit of the present disclosure will be described below with reference to several exemplary embodiments. It should be understood that these embodiments are given only to enable those skilled in the art to better understand and implement the present disclosure, rather than to limit the scope of the present disclosure in any way. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.

[0094] Those skilled in the art know that the embodiments of the present disclosure may be implemented as a system, device, device, method or computer program product. Therefore, the present disclosure may be embodied in the form of complete hardware, complete software (including firmware, resident software, microcode, etc.), or a combination of hardware and software.

[0095] The technical terms involved in this disclosure are explained as follows:

[0...

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 embodiment of the invention provides an index creation method and device, electronic equipment and a storage medium, and relates to the technical field of databases. The method comprises the stepsof obtaining a database index creation statement, and writing the database index creation statement into a first system table; writing the database index creation statement into the first log file, and sending log information corresponding to the database index creation statement in the first log file to a slave library so that the slave library plays back the log information; and reading the database index creation statement from the first system table, and executing the database index creation statement. According to the invention, the time for a master library and a slave library to integrally complete index creation can be shortened.

Description

technical field [0001] Embodiments of the present disclosure relate to the technical field of databases, and more specifically, relate to an index creation method, an index creation device, electronic equipment, and a computer-readable storage medium. Background technique [0002] This section is intended to provide a background or context for implementations of the disclosure that are recited in the claims. The descriptions herein are not admitted to be prior art by inclusion in this section. [0003] The MySQL database is currently a relatively popular open source database and has been widely used. In daily operation and maintenance, database administrators can perform necessary DDL (Data Definition Language, Data Definition Language) operations, such as adding a column to a table, modifying the properties of a column, adding indexes to certain / some columns, etc. [0004] Currently, database administrators can perform DDL operations through the online DDL commands native...

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/17G06F16/22G06F16/28
CPCG06F16/2228G06F16/284G06F16/1734
Inventor 余利华温正湖蒋鸿翔冯森
Owner NETEASE (HANGZHOU) NETWORK CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap