Database record bit

Patent metadata

Field	Value
Publication number	US-12443577-B2
Application number	US-202217572759-A
Country	US
Kind code	B2
Filing date	Jan 11, 2022
Priority date	Jan 11, 2022
Publication date	Oct 14, 2025
Grant date	Oct 14, 2025

Abstract

A method includes receiving, by a computing device, a first transaction from a user device for a first version of a database record; generating, by the computing device, a bit for the database record; receiving, by the computing device, a second transaction from a second user device for a second version of the database record; locking, by the computing device, the database record; determining, by the computing device, a modification between the first version of the database record and the second version of the database record; and updating, by the computing device, the bit in response to the modification.

First claim

What is claimed is:

1. A method, comprising:
receiving, by a computing device, a first transaction from a first user device for a first version of a database record;
generating, by the computing device, a bit for the database record;
receiving, by the computing device, a second transaction from a second user device for a second version of the database record;
locking, at the computing device, the database record, wherein:
the locking occurs upon receiving two active transactions comprising the first transaction from the first user device that modifies the first version of the database record and the second transaction from the second user device that modifies the second version of the database record,
the first transaction modifies the first version of the database record, and the second transaction modifies the second version of the database record while the database record is locked, and
the database record remains locked while the first transaction modifies the first version of the database record and while the second transaction modifies the second version of the database record;
determining, by the computing device, a modification between the first version of the database record and the second version of the database record; and
updating, by the computing device while the database record is locked, the bit based on the determined modification.

2. The method of claim 1 , wherein the first transaction comprises a first Structured Query Language (SQL) query from the first user device, and wherein the second transaction comprises a second SQL query from the second user device.

3. The method of claim 2 , further comprising displaying the first version of the database record on a data management page on the first user device.

4. The method of claim 2 , further comprising displaying the second version of the database record on a second data management page on the second user device.

5. The method of claim 1 , further comprising deleting the first version of the database record after a time period lapses.

6. The method of claim 1 , further comprising adding pointer from the bit to the second version of the database record.

7. The method of claim 1 , further comprising unlocking the database record when the first transaction stops modifying the first version of the database record or when the second transaction stops modifying the second version of the database record.

8. The method of claim 1 , wherein the modification is selected from a group consisting of insertion of syntax within the database record, deletion of syntax within the database record, and an update to the syntax within the database record.

9. The method of claim 1 , wherein the determining the modification between the first version of the database record and the second version of the database record includes comparing syntax in rows and columns of the first version of the database record to syntax in rows and columns in the second version of the database record.

10. The method of claim 1 , wherein the computing device includes software provided as a service in a cloud environment.

11. The method of claim 1 , wherein the locking the database record prevents a third user device from modifying the database record but allows the third user device to read the database record.

12. A computer program product comprising one or more computer readable storage media having program instructions collectively stored on the one or more computer readable storage media, the program instructions executable to:
receive a first transaction from a user device for a first version of a database record;
generate a bit for the database record;
receive a second transaction from a second user device for a second version of the record;
lock the database record, wherein:
the lock occurs upon receiving two active transactions comprising the first transaction from the user device that modifies the first version of the database record and the second transaction from the second user device that modifies the second version of the database record,
the first transaction is allowed to modify the first version of the database record and the second transaction is allowed to modify the second version of the database record while the database record is locked, and
the database record remains locked while the first transaction modifies the first version of the database record and while the second transaction modifies the second version of the database record;
determine a modification between the first version of the database record and the second version of the database record;
update the bit based on the determined modification while the database record is locked; and
delete the first version of the database record.

13. The computer program product of claim 12 , wherein the bit includes metadata which includes a transaction identification for the first transaction and a description of the transaction of the first transaction.

14. The computer program product of claim 12 , wherein the lock comprises a Readview lock.

15. The computer program product of claim 12 , wherein the determining the modification between the first version of the database record and the second version of the database record includes comparing syntax in rows and columns of the first version of the database record to syntax in rows and columns in the second version of the database record.

16. A system comprising:
a processor, a computer readable memory, one or more computer readable storage media, and program instructions collectively stored on the one or more computer readable storage media, the program instructions executable to:
receive a first transaction from a user device for a first version of a database record;
generate a bit for the database record;
receive a second transaction from a second user device for a second version of the record;
lock the database record, wherein:
the lock occurs upon receiving two active transactions comprising the first transaction from the user device that modifies the first version of the database record and the second transaction from the second user device that modifies the second version of the database record,
the first transaction is allowed to modify the first version of the database record and the second transaction is allowed to modify the second version of the database record while the database record is locked, and
the database record remains locked while the first transaction modifies the first version of the database record and while the second transaction modifies the second version of the database record;
determine a modification between the first version of the database record and the second version of the record;
update the bit based on the determined modification while the database record is locked; and
add a pointer extending from the bit to the second version of the database record.

17. The system of claim 16 , wherein the modification comprises an update to syntax in the second version of the database record.

18. The system of claim 16 , wherein the second transaction comprises an update action which updates syntax in the second version of the database record.

19. The system of claim 16 , wherein the bit includes metadata which includes a transaction identification for the first transaction and a description of the transaction of the first transaction.

Assignees

• IBM

Inventors

• Li Shuo
• Wang Xiaobo
• Sun sheng yan
• Zhong jia tian
• Shen Xing Xing

Classifications

• G06F16/24

  Querying · CPC title

• G06F16/2343

  Locking methods, e.g. distributed locking or locking implementation details · CPC title

• G06F16/2358

  Change logging, detection, and notification (replication G06F16/27) · CPC title

• G06F16/2433

  Query languages · CPC title

• G06F16/219 Primary

  Managing data history or versioning (querying versioned data G06F16/2474; querying temporal data G06F16/2477) · CPC title