Method for storing data indexes in engine and related device

A storage engine and data indexing technology, applied in the computer field, can solve problems affecting database indexing efficiency, high complexity, code redundancy, etc., to achieve code reuse, improve indexing efficiency, and reduce development complexity.

Active Publication Date: 2020-06-09
TENCENT TECH (SHENZHEN) CO LTD
View PDF15 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, in MySQL's plug-in architecture, the code of each storage engine is independent, and each time a new storage engine is developed, a complete set of data storage and transaction mechanisms needs to be developed separately; however, the complexity of the development process High, and it is easy to cause code redundancy, which affects the indexing efficiency of the database

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 for storing data indexes in engine and related device
  • Method for storing data indexes in engine and related device
  • Method for storing data indexes in engine and related device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] The embodiment of the present application provides a data indexing method and a related device, which can be applied to a system or program including a data indexing function in a terminal device, by obtaining the target transaction indicating the data indexing process, and determining the first storage engine according to the target transaction The target data in the target data is included in at least one first index table; then, according to the first index table, at least one second index table configured in the second storage engine is determined, and the second index table is based on the first index table. The row identifier is used to indicate the row data in the target data. The row data corresponds to the index column in the target data. The index column is obtained based on the target transaction. The second storage engine supports the execution of the target transaction; The index data corresponding to the data index condition in the first storage engine is d...

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 method for indexing data in a storage engine and a related device. Target affairs are indexed by acquiring indication data. Determining a first index table in a first storageengine according to the target transaction; determining at least one second index table configured in a second storage engine according to the first index table; and determining index data corresponding to the data index condition in the first storage engine from the second index table. Therefore, the cross-storage-engine data indexing process is achieved, due to the fact that the development complexity introduced by a new storage engine is reduced, code reuse of multiple storage engines is achieved, and the indexing efficiency of a database is improved.

Description

technical field [0001] The present application relates to the field of computer technology, and in particular to a method for indexing data in a storage engine and related devices. Background technique [0002] With the development of cloud technology, more and more applications appear in people's lives, and in cloud technology, the participation of database is required to realize data interaction. In short, the database can be regarded as an electronic file cabinet - a place where electronic files are stored. Users can add, query, update, delete and other operations on the data in the file. [0003] Generally, MySQL, a database management system that supports multiple storage engines, can be used in different application scenarios. Wherein, different storage engines may have different support capabilities for transactions. For example, the InnoDB storage engine implements complete transaction support and also supports the XA protocol for distributed transactions; the MyIS...

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/28
CPCG06F16/2282G06F16/284G06F16/2272G06F16/24564
Inventor 龙剑张文亮
Owner TENCENT TECH (SHENZHEN) 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