Database system and database access method

Abstract

The embodiment of the invention discloses a database system and a database access method. The database system comprises: an SQL engine used for receiving a first transaction, wherein the first transaction comprises corresponding first data; a switching unit which is used for determining the heat degree of the first data segment, wherein the first data segment is a database data segment in which first data falls when the first transaction is executed, and the heat degree of the first data segment is the transaction number of all operations occupied by the transaction number cancelled in unit time on the history of the first data segment; a concurrency control selection unit which is used for selecting the first concurrency control unit when the heat degree of the first data segment is greater than a first threshold value; a first concurrency control unit which is used for determining whether a second transaction exists or not, and executing the first transaction when the second transaction does not exist, wherein the data read by the first transaction is the data written by the second transaction, and the data writing time of the second transaction is later than the data reading time of the first transaction.

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...

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

Images