Database operation processing method and apparatus

一种操作处理、数据库的技术，应用在数据库领域，能够解决多用户操作相互干扰、查询结果不准确等问题，达到避免干扰、避免相互干扰的效果

Inactive Publication Date: 2016-01-27
ZTE CORP
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The statistical report is generally generated from the temporary table and the result table used in the query process. When multiple users query concurrently, the temporary table and the result table will be used at the same time, resulting in mutual interference between the operations of multiple users, which further leads to The query result is inaccurate

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment approach

[0040] Step 101: Detect the user's operation on the database.

[0041] In the above steps, the user's operation on the database includes the user's query, statistics, analysis, etc. on the database.

[0042] Step 102: Generate a unique identifier for the user's current operation.

[0043] In the above steps, a unique identifier is generated for a single user operation such as data query, data statistics, and data analysis, and the identifier is used to distinguish multiple users. More specifically, the identifier may be an identifier set in the name field, or an identifier set in the serial number field, or an identifier set corresponding to other fields in the result record table.

[0044] More specifically, when the unique identifier is set in the name field, it may be an identifier that includes alphabetic symbols, or an identifier that includes numeric symbols, or an identifier that includes other symbols. When the unique identifier is set in the serial number field, it ...

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 present invention provides a database operation processing method and apparatus. The method at least comprises the following steps: detecting an operation performed on a database by a user; generating a unique identifier for the operation of the user; and recording a result of the operation of the user and the unique identifier in a result record table corresponding to the unique identifier. According to the database operation processing method and apparatus provided by the present invention, the unique identifier is generated for the operation of the user, so that multiple users, who use the database at the same time, individually apply for and possess different unique identifiers, and multiple users that simultaneously perform query operations or other operations can be distinguished; and furthermore, the result of the operation of the user and the unique identifier are recorded in the result record table corresponding to the unique identifier, so that records of operation results of multiple users can be distinguished by means of the unique identifiers, thereby avoiding mutual interference among the operation result records of multiple users.

Description

technical field [0001] The invention relates to a database, and particularly designs a database operation processing method and device. Background technique [0002] The use of statistical reporting systems and data warehouse systems for managing business records is increasing. These systems involve the query, statistics and analysis of data in the database, and generate statistical reports for easy reference. The statistical report is generally generated from the temporary table and the result table used in the query process. When multiple users query concurrently, the temporary table and the result table will be used at the same time, resulting in mutual interference between the operations of multiple users, which further leads to The query result is inaccurate. Contents of the invention [0003] In view of this, the present invention provides a database operation processing method and device. The device can effectively prevent mutual interference caused by multiple 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): G06F17/30
CPCG06F16/00
Inventor 程文超
Owner ZTE CORP
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