Check patentability & draft patents in minutes with Patsnap Eureka AI!

Method and system for processing data operation request of database

A technology of data manipulation and processing method, applied in the database field, it can solve the problem of slow response speed and achieve the effect of improving the response speed

Active Publication Date: 2019-03-22
BOYAA ONLINE GAME DEV SHENZHEN
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the response speed of the database to the user's data operation request is extended as the amount of data stored in the database increases, especially when the database has to process a large number of data operation requests, the response speed is even slower

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 and system for processing data operation request of database
  • Method and system for processing data operation request of database
  • Method and system for processing data operation request of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0067] like figure 1 As shown, in one embodiment, a method for processing a data operation request of a database includes the following steps:

[0068] Step S102, receiving a data write request for a specified data table, where the data write request includes keywords and update content corresponding to the keywords.

[0069] The request for writing data may be a request for adding, deleting or modifying data.

[0070] The update content can include specific column names and column value pairs. If the update content includes column name and column value pairs, each column name and column value pair can indicate a request to set the value corresponding to the keyword in the column corresponding to the column name as the column value . For example, the update content includes (name, "Zhang San"), (birthday, 2014-6-10) and other column name and column value pairs, which can indicate that the corresponding value of the keyword in the name column is set to "Zhang San", and the T...

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 processing method for a data operation request of a database. The processing method comprises the following steps of receiving a data writing request for a specified data table, wherein the data writing request comprises a keyword and update content corresponding to the keyword; searching for the keyword contained in the data writing request in a Hash table stored in a memory and corresponding to the data table; if the keyword contained in the data writing request is found in the Hash table, modifying a record corresponding to the keyword contained in the data writing request according to the update content in the Hash table; generating an SQL statement capable of realizing operation on the Hash table, and inserting the SQL statement into an update statement queue of the data table; and returning a processing result to a requester sending the data writing request. The method can greatly increase the response speed of the data operation request of the database. In addition, the invention provides a processing system for the data operation request of the database.

Description

【Technical field】 [0001] The invention relates to the technical field of databases, in particular to a method and system for processing data operation requests of a database. 【Background technique】 [0002] A database is a warehouse that organizes, stores and manages data according to the data structure. With the development of information technology and market, data management is no longer just storing and managing data, but has transformed into various data management methods required by users. There are many types of databases, from the simplest databases storing various data tables to large database systems capable of storing massive amounts of data, which have been widely used in various aspects. According to the organizational form of stored data, the types of databases can be divided into hierarchical databases, network databases and relational databases. Currently widely used databases include DB2, Oracle Informix, Sybase, SQL Server, and mySQL. [0003] Users can...

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 Patents(China)
IPC IPC(8): G06F16/22G06F16/242
Inventor 史岳斌刘仕尧
Owner BOYAA ONLINE GAME DEV SHENZHEN
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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