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
View PDF 2 Cites 0 Cited by

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
    Figure CN119003573A_ABST
Patent Text Reader

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