Time-series analytics for database management systems
AssigneeOwnbackup Ltd.
InventorsYehonatan Mazar, Ori Yankelev, Roi Dover, Adrian Kunzle
Life of this patent
Estimating the term…
Abstract
Methods, apparatuses and computer program products implement embodiments of the present invention that include capturing a series of point-in-time images of a database including one or more tables, each of the tables including one or more fields. Upon receiving, from a user, a query with respect to a variation of a given field over a specified period of time, the point-in-time images are analyzed in order to extract the variation; and the extracted variation is presented to the user.
Claims19
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.
An apparatus for data analysis, comprising:
- a storage device;
- and
- at least one hardware processor configured:
- to capture 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;
- to store the data from the captured series of point-in-time images to a corresponding series of data files on the storage device;
- to generate and maintain 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, to receive, 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;
- to analyze 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
- to present the extracted variation to the user.
A computer software product comprising a non-transitory computer-readable medium, in which program instructions are stored, which instructions, when read by a computer, cause the computer:
- to capture 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;
- to store the data from the captured series of point-in-time images to a corresponding series of data files on a storage device;
- to generate and maintain 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;
- to receive from a user, following the period of time, 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;
- to analyze 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
- to present the extracted variation to the user.
Dependencies are inferred from the claim text.