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 |
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.
|