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

Data processing method, device and apparatus for database and index updating method

A data update and data processing technology, applied in the database field, can solve the problem of high operation cost of reading the main table, and achieve the effect of solving data confusion, reducing costs, and realizing write throughput

Pending Publication Date: 2020-07-28
ALIBABA GRP HLDG LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The root cause of this problem is: the update operation on the main table row leads to the change of the primary key column of the index table, making it necessary to read the main table once to get the index data to be deleted
[0004] In addition, another scenario of database operation is the insert operation. Since the NoSQL (non-relational database) database system based on the LSM tree structure cannot distinguish whether the database write behavior is an update operation or an insert operation, even during an insert operation, a read operation is required. The operation of the main table of the database is used to determine whether it is an insert operation or an update operation, and the cost of reading the main table operation is relatively large

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
  • Data processing method, device and apparatus for database and index updating method
  • Data processing method, device and apparatus for database and index updating method
  • Data processing method, device and apparatus for database and index updating method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0076] In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention. However, the present invention can be implemented in many other ways different from those described here, and those skilled in the art can make similar extensions without violating the connotation of the present invention, so the present invention is not limited by the specific implementations disclosed below.

[0077] The first embodiment of the present application provides a data processing method for a database, the execution body of the method is a database server, and the following combines figure 1 Describe in detail.

[0078] Such as figure 1 As shown, in step S101, a data insertion request for a database is received.

[0079] The data insertion request may refer to a data insertion request sent by a database user to a database server through a client.

[0080] The database includes a NoSQL (non-relational database) datab...

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 data processing method for a database. The data processing method comprises: receiving a data insertion request for the database, obtaining a data insertion behavior constraint attribute according to the data insertion request, and inserting data into a main table of the database and an index table associated with the main table according to the data insertion behavior constraint attribute and the data insertion request. By adopting the method, the cost of the data insertion operation for the database is reduced.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a data processing method, device, electronic equipment and storage equipment for databases. The present application also relates to an index update method. Background technique [0002] In the database field, indexing is an important means to speed up queries, so in addition to the main table of the database, there will also be a database index table. In order to organize the index data, the database system must pay the corresponding operation cost. [0003] First of all, after introducing an index, the original database update operation will be "magnified" to four operations. The data update process of a typical database is as follows: 1. Read the main table to get the original index record; 2. Delete the original index record from the index table; 3. Insert a new record into the index table; 4. Replace the main table The records satisfying the conditions in are u...

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/23G06F16/22
CPCG06F16/235G06F16/2282
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