Database tuple searching method and device, computer equipment and storage medium
By recording transaction identifiers and time slots for allocating time in the database transaction page directory, the problem of not being able to allocate time based on transaction identifiers is solved, and an efficient tuple search and simplified development process is realized.
CN119003573AActive Publication Date: 2024-11-22PING AN TECH (SHENZHEN) CO LTD
Patent Information
- Application Number
- CN202410942573.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-12
- Publication Date
- 2024-11-22
- Estimated Expiration
- 2044-07-12
Smart Images

Figure CN119003573A_ABST
Abstract
The invention relates to the field of data query, and discloses a database tuple searching method and device, computer equipment and a storage medium so as to solve the problem that database tuples cannot be searched according to the allocation time of transaction identifiers. The method comprises the following steps: executing a to-be-processed transaction to obtain a first tuple corresponding to the to-be-processed transaction; writing a transaction identifier corresponding to the to-be-processed transaction into the first tuple to obtain a second tuple; initializing a transaction page directory corresponding to the to-be-processed transaction; adding a data page corresponding to the transaction identifier in the transaction page directory, and storing the transaction identifier in the data page; obtaining the time when the transaction identifier is written into the second tuple, and obtaining the distribution time; adding a time slot containing the distribution time at the end of the data page to obtain a target page directory; when an instruction of searching the tuple corresponding to the expected time is received, traversing the time slot in the target page directory, screening out target allocation time consistent with the expected time in the time slot, and obtaining a target transaction identifier corresponding to the target allocation time; and in the second tuple, screening out a transaction identifier corresponding to the target transaction identifier to obtain a target tuple.
Need to check novelty before this filing date? Find Prior Art
Citation Information
Patent Citations
Database transaction control method and device and related equipment
CN115858554A
Transaction processing method and apparatus, computing device, and storage medium
US20230418811A1
