A database system and database access method

A database and data technology, applied in the database field, can solve the problems of high cancellation rate, decreased tps, low concurrency and low conflict throughput, etc., and achieve the effect of low conflict throughput and low concurrency

Active Publication Date: 2021-07-16
HUAWEI TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] An embodiment of the present invention provides a database system. The database system calculates the heat of the data of the operation transaction through the switching unit in the self-adaptive module, and selects the corresponding parallel control unit according to the heat, so as to solve the problem that the high cancellation rate causes the overall failure The problem of the tps drop of the execution transaction does not affect the throughput of low concurrency and low conflict at the same time

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
  • A database system and database access method
  • A database system and database access method
  • A database system and database access method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0058] The technical solutions of the present invention will be described in further detail below with reference to the accompanying drawings and embodiments.

[0059] figure 2 It is a schematic structural diagram of a database system in the prior art, such as figure 2 As shown, the database system includes a structured query language (structured query language, SQL) engine 210, a transaction management module 220, a storage engine 230, a log management 240, a buffer 250 and a recovery management module 260.

[0060] The SQL engine 210 is used for parsing and executing SQL statements corresponding to operations such as adding, deleting, modifying, and checking. Syntactic analysis and semantic analysis of SQL statements are all completed in the SQL engine 210, and finally an execution plan will be generated.

[0061] The transaction management module 210 is configured to judge conflicts and ACID attribute guarantees of different transactions in the process of executing the p...

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 present invention discloses a database system and a database access method. The database system includes: a SQL engine for receiving a first transaction, the first transaction includes corresponding first data; a switching unit for determining the first data The heat of the segment; the first data segment is the database data segment where the first data falls when the first transaction is executed, and the heat of the first data segment is the number of transactions canceled per unit time in the history of the first data segment accounting for all operations The ratio of the number of transactions; the concurrency control selection unit, when the heat of the first data segment is greater than the first threshold, select the first concurrency control unit; the first concurrency control unit, used to determine whether there is a second transaction, when there is no second During the transaction, the first transaction is executed; wherein, the data read by the first transaction is the data written by the second transaction, and the time when the second transaction writes data is later than the time when the first transaction reads data.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database system and a database access method. Background technique [0002] Database (Database) is a warehouse built on computer storage devices that organizes, stores and manages data according to the data structure. It is an organized and shareable data collection stored in the computer for a long time. Transaction (Transaction) is a program execution unit (unit) that accesses and may update various data items in the database. It is the basic unit of recovery and concurrency control, and has four attributes: atomicity, consistency, isolation, and persistence. sex. These four attributes are usually called ACID characteristics. In order to ensure the ACID attributes of the database, during the concurrent execution of transactions, a concurrency control mechanism is required to ensure the correct execution of transactions. Concurrency control is mainly used to solve how to e...

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/25G06F9/46
CPCG06F9/466G06F16/25
Inventor 郭志建朱建峰智雅楠
Owner HUAWEI TECH 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