US 12,169,517 B2
Time-series analytics for database management systems
Yehonatan Mazar, Tel Aviv (IL); Ori Yankelev, Tel Aviv (IL); Roi Dover, Petah Tikva (IL); and Adrian Kunzle, New York, NY (US)
Assigned to OWN DATA COMPANY LTD., Tel Aviv (IL)
Filed by OwnBackup Ltd., Tel Aviv (IL)
Filed on Sep. 18, 2023, as Appl. No. 18/468,759.
Application 18/468,759 is a continuation of application No. 16/950,963, filed on Nov. 18, 2020, granted, now 11,797,600.
Prior Publication US 2024/0004919 A1, Jan. 4, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/51 (2019.01); G06F 16/538 (2019.01); G06Q 10/0631 (2023.01); G06Q 10/10 (2023.01); G06Q 30/016 (2023.01); G06Q 40/12 (2023.01); H04L 67/06 (2022.01); G06Q 30/01 (2023.01)
CPC G06F 16/51 (2019.01) [G06F 16/538 (2019.01); G06Q 10/06315 (2013.01); G06Q 10/10 (2013.01); G06Q 30/016 (2013.01); G06Q 40/12 (2013.12); H04L 67/06 (2013.01)] 19 Claims
OG exemplary drawing
 
1. A method for retrospective data analysis, comprising:
capturing, by a hardware processor at predefined intervals over a period of time, a series of point-in-time images of a database including tables containing data in multiple fields of multiple records, the point-in-time images comprising archived copies of the data stored in one or more of the tables of the database;
storing, by the hardware processor, the data from the captured series of point-in-time images to a corresponding series of data files on a storage device;
generating and maintaining a unified schema of the database, the unified schema identifying respective field names and respective data types of the fields in the tables and identifying at least one of an addition, a deletion, or a change in a data type or format of one or more of the fields over the period of time;
following the period of time, receiving, from a user, a retrospective query with respect to a variation of at least one field in at least one of the tables of the database over the period of time;
analyzing, by the hardware processor, the data stored in the data files on the storage device, using the unified schema, in order to extract the variation of the at least one field in the at least one of the tables over the period of time; and
presenting the extracted variation to the user.