System for backing out data

Abstract

Some aspects disclosed herein are directed to, for example, a system and method of backing out data. The method may comprise determining one or more unique identifiers for data to be loaded from a source system to one or more databases. The method may comprise loading the data from the source system to the one or more databases, and the data may be loaded with the one or more unique identifiers. A computing device may determine that a subset of the data loaded to the one or more databases comprises invalid data. In response to determining that the subset of the data loaded to the one or more databases comprises invalid data, the computing device may determine one or more unique identifiers for the invalid data. The invalid data may be removed, from the one or more databases, based on the one or more unique identifiers for the invalid data.

What is claimed is: 
     
         1 . A method comprising:
 determining one or more unique identifiers for data to be loaded from a source system to one or more databases;   loading the data from the source system to the one or more databases, wherein the data is loaded with the one or more unique identifiers;   determining, by a computing device, that a subset of the data loaded to the one or more databases comprises invalid data;   in response to determining that the subset of the data loaded to the one or more databases comprises invalid data, determining, by the computing device, one or more unique identifiers for the invalid data; and   removing, from the one or more databases, the invalid data based on the one or more unique identifiers for the invalid data.   
     
     
         2 . The method of  claim 1 , wherein:
 loading the data comprises loading a portion of the data from the source system to the one or more databases at a first time, and loading the portion of the data from the source system to the one or more databases at a second time, and   determining the one or more unique identifiers comprises determining first one or more unique identifiers for the portion of the data loaded at the first time and determining second one or more unique identifiers for the portion of the data loaded at the second time.   
     
     
         3 . The method of  claim 1 , wherein determining that the subset of the data loaded to the one or more databases comprises invalid data comprises receiving, from a user device, an indication of the invalid data. 
     
     
         4 . The method of  claim 3 , further comprising:
 generating a user interface displayable by the user device, wherein the user interface comprises a data field for a user to provide the indication of the invalid data.   
     
     
         5 . The method of  claim 1 , wherein removing the invalid data is further based on one or more load date for the invalid data. 
     
     
         6 . The method of  claim 5 , wherein the one or more load date comprises a time period, and wherein removing the invalid data comprises removing the invalid data that was loaded to the one or more databases during the time period. 
     
     
         7 . The method of  claim 1 , further comprising:
 after removing the invalid data, determining new data to load to the one or more database, wherein the new data corresponds to the invalid data removed from the one or more databases; and   loading the new data to the one or more databases.   
     
     
         8 . An apparatus, comprising:
 a processor; and   memory storing computer-executable instructions that, when executed by the processor, cause the apparatus to:
 determine one or more unique identifiers for data to be loaded from a source system to one or more databases; 
 load the data from the source system to the one or more databases, wherein the data is loaded with the one or more unique identifiers; 
 determine that a subset of the data loaded to the one or more databases comprises invalid data; 
 in response to determining that the subset of the data loaded to the one or more databases comprises invalid data, determine one or more unique identifiers for the invalid data; and 
 remove, from the one or more databases, the invalid data based on the one or more unique identifiers for the invalid data. 
   
     
     
         9 . The apparatus of  claim 8 , wherein:
 loading the data comprises loading a portion of the data from the source system to the one or more databases at a first time, and loading the portion of the data from the source system to the one or more databases at a second time, and   determining the one or more unique identifiers comprises determining first one or more unique identifiers for the portion of the data loaded at the first time and determining second one or more unique identifiers for the portion of the data loaded at the second time.   
     
     
         10 . The apparatus of  claim 8 , wherein determining that the subset of the data loaded to the one or more databases comprises invalid data comprises receiving, from a user device, an indication of the invalid data. 
     
     
         11 . The apparatus of  claim 10 , wherein the memory stores additional computer-executable instructions that, when executed by the processor, cause the apparatus to:
 generate a user interface displayable by the user device, wherein the user interface comprises a data field for a user to provide the indication of the invalid data.   
     
     
         12 . The apparatus of  claim 8 , wherein removing the invalid data is further based on one or more load date for the invalid data. 
     
     
         13 . The apparatus of  claim 12 , wherein the one or more load date comprises a time period, and wherein removing the invalid data comprises removing the invalid data that was loaded to the one or more databases during the time period. 
     
     
         14 . The apparatus of  claim 8 , wherein the memory stores additional computer-executable instructions that, when executed by the processor, cause the apparatus to:
 after removing the invalid data, determine new data to load to the one or more database, wherein the new data corresponds to the invalid data removed from the one or more databases; and   load the new data to the one or more databases.   
     
     
         15 . One or more non-transitory computer-readable medium having instructions stored thereon that, when executed by one or more computing devices, cause the one or more computing devices to:
 determine one or more unique identifiers for data to be loaded from a source system to one or more databases;   load the data from the source system to the one or more databases, wherein the data is loaded with the one or more unique identifiers;   determine that a subset of the data loaded to the one or more databases comprises invalid data;   in response to determining that the subset of the data loaded to the one or more databases comprises invalid data, determine one or more unique identifiers for the invalid data; and   remove, from the one or more databases, the invalid data based on the one or more unique identifiers for the invalid data.   
     
     
         16 . The one or more non-transitory computer-readable medium of  claim 15 , wherein:
 loading the data comprises loading a portion of the data from the source system to the one or more databases at a first time, and loading the portion of the data from the source system to the one or more databases at a second time, and   determining the one or more unique identifiers comprises determining first one or more unique identifiers for the portion of the data loaded at the first time and determining second one or more unique identifiers for the portion of the data loaded at the second time.   
     
     
         17 . The one or more non-transitory computer-readable medium of  claim 15 , wherein determining that the subset of the data loaded to the one or more databases comprises invalid data comprises receiving, from a user device, an indication of the invalid data. 
     
     
         18 . The one or more non-transitory computer-readable medium of  claim 17 , having computer-readable instructions stored thereon that, when executed by the one or more computing devices, cause the one or more computing devices to:
 generate a user interface displayable by the user device, wherein the user interface comprises a data field for a user to provide the indication of the invalid data.   
     
     
         19 . The one or more non-transitory computer-readable medium of  claim 17 , wherein removing the invalid data is further based on one or more load date for the invalid data. 
     
     
         20 . The one or more non-transitory computer-readable medium of  claim 19 , wherein the one or more load date comprises a time period, and wherein removing the invalid data comprises removing the invalid data that was loaded to the one or more databases during the time period.