IP Library Granted Patent US 12,019,619
Granted Patent B2
US 12,019,619 · App. 18/094,481 · Granted Jun 25, 2024

Time-to-run column for database management systems

Inventors: Michael Kolesnik (Raanana, IL); Michel Peterson (Raanana, IL)
Assignee: Red Hat, Inc.
G06F16/2365G06F16/221G06F16/2282G06F16/2358
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12,019,619
App. No.
18/094,481
Granted
Jun 25, 2024
Kind
B2
Abstract

An apparatus and method of performing a time-based operation on a row in a database table includes receiving a function to be applied to a particular row in a table within the database management system. The method may also include, in response to receiving the function, adding a new column to the table. A new cell in the new column includes a timer indicating a time that the processing device will call the function, and the new cell references the function. The method may also include, upon expiration of the timer, determining that the database management system is available for execution of the function, and executing the function on the particular row in the table.

Claims (43)

1. A method, comprising:

receiving a function to be applied in association with a particular row in a table within the database management system;

adding, by a processing device, a new column to the table in response to receiving the function, wherein a new cell in the new column comprises a timer indicating a time that the processing device will call the function, and wherein the new cell references the function;

upon expiration of the timer, determining that the database management system is available for execution of the function based on operating resources of the database management system; and

executing the function on the particular row in the table by sending a notification to a client device that the information in the particular row requires one or more actions.

2. The method of claim 1 , wherein the function comprises instructions to delete, archive, move, or compress information in the particular row.

3. The method of claim 1 , wherein the function is to operate on a batch of rows whose respective timers have expired.

4. The method of claim 1 , wherein determining that the database management system is available for execution of the function comprises determining that the operating resources of the database management system are operating below a threshold level of operation.

5. The method of claim 4 , wherein determining that the database management system is available for execution of the function further comprises determining that the database management system is, at a time the timer expires, free from scheduled or unscheduled maintenance.

6. The method of claim 1 , wherein the new column is a first column, the function is a first function, and the timer is a first timer, further comprising:

adding a second column to the table, wherein a second cell in the second column comprises a second timer and a second function set, wherein the second timer is set to expire at a different time than the first timer;

upon expiration of the second timer, determining that the database management system is available for execution of the second function; and

executing the second function on the particular row in the table.

7. The method of claim 6 , wherein:

the second timer is set to expire at a later time than the first timer;

the first function comprises instructions to archive information in the particular row; and

the second function comprises instructions to delete the information in the particular row.

8. A system, comprising:

a memory; and

a processing device, operatively coupled to the memory, the processing device to:

receive a function to be applied to a particular row in a table within the database management system;

add a new column to the table in response to receiving the function, wherein a new cell in the new column comprises a timer indicating a time that the processing device will call the function, and wherein the new cell references the function;

upon expiration of the timer, determine that the database management system is available for execution of the function based on operating resources of the database management system; and

execute the function on the particular row in the table, wherein to execute the function the processing device is to send a notification to a client device that the information in the particular row requires one or more actions.

9. The system of claim 8 , wherein the function comprises instructions to delete, archive, move, or compress information in the particular row.

10. The system of claim 8 , wherein the function is to operate on a batch of rows whose respective timers have expired.

11. The system of claim 8 , wherein to determine that the database management system is available for execution of the function, the processing device is to determine that the operating resources of the database management system are operating below a threshold level of operation.

12. The system of claim 11 , wherein to determine that the database management system is available for execution of the function, the processing device is to further determine that the database management system is, at a time the timer expires, free from scheduled or unscheduled maintenance.

13. The system of claim 8 , wherein the new column is a first column, the function is a first function, and the timer is a first timer, the processing device further to:

add a second column to the table, wherein a second cell in the second column comprises a second timer and a second function set, wherein the second timer is set to expire at a different time than the first timer;

upon expiration of the second timer, determine that the database management system is available for execution of the second function; and

execute the second function on the particular row in the table.

14. The system of claim 13 , wherein:

the second timer is set to expire at a later time than the first timer;

the first function comprises instructions to archive information in the particular row; and

the second function comprises instructions to delete the information in the particular row.

15. A non-transitory computer-readable medium having instructions stored thereon that, when executed by a processing device, cause the processing device to:

receive, from a database management system, a function to be applied to a particular row in a table within the database management system;

add a new column to the table in response to receiving the function, wherein a new cell in the new column comprises a timer indicating a time that the processing device will call the function, and wherein the new cell references the function;

upon expiration of the timer, determine that the database management system is available for execution of the function based on operating resources of the database management system; and

execute the function on the particular row in the table, wherein to execute the function the processing device to send a notification to a client device that the information in the particular row requires one or more actions.

16. The non-transitory computer readable storage medium of claim 15 , wherein the function comprises instructions to delete, archive, move, or compress information in the particular row.

17. The non-transitory computer readable storage medium of claim 15 , wherein the function is to operate on a batch of rows whose respective timers have expired.

Assignments (2)
CHANGE OF NAME Recorded Mar 3, 2026
From: RED HAT, INC.
To: RED HAT, LLC
Reel/Frame 074913/0759 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 20, 2023
From: KOLESNIK, MICHAEL; PETERSON, MICHEL
To: RED HAT, INC.
Reel/Frame 065617/0459 →