Declarative and unified data transition

Abstract

Described are computer-based methods and apparatuses, including computer program products, for declarative and unified data transition. In some embodiments, a computer implemented method includes determining an unified configuration for a knowledge domain. The unified configuration can include one or more predicates for one or more system objects, and/or one or more relationships between the one or more system objects. The method can include generating one or more transformation rules based on the one or more predicates. The one or more transformations can enable transformation of input data. The input data can include information associated with the one or more system objects and/or the one or more relationships between the one or more system objects. The method can include generating one or more reconciliation rules based on the one or more predicates. The one or more reconciliation rules can be associated with a destination database and can enable reconciliation of the transformed data with the destination database.

1 . A computer implemented method for declarative and unified data transition, the method comprising:
 determining a unified configuration for a knowledge domain, the unified configuration comprising one or more predicates for one or more relationships between one or more system objects;   generating one or more transformation rules based on the one or more predicates;   transforming input data based on the one or more transformation rules, the input data comprising information associated with the one or more system objects, the one or more relationships between the one or more system objects, or any combination thereof;   generating one or more reconciliation rules based on the one or more predicates, the one or more reconciliation rules associated with a destination database; and   reconciling the transformed data with the destination database based on the one or more reconciliation rules.   
     
     
         2 . The method of  claim 1 , further comprising:
 transforming second input data based on the one or more transformation rules, the second input data comprising information associated with the one or more system objects, the one or more relationships between the one or more system objects, or any combination thereof; and   reconciling the second transformed data with the destination database based on the one or more reconciliation rules.   
     
     
         3 . The method of  claim 1 , further comprising:
 generating one or more validation rules based on the one or more predicates; and   validating the input data based on the one or more validation rules.   
     
     
         4 . The method of  claim 3 , further comprising automatically modifying the input data based on the validation of the input data to remove at least one validation error associated with the input data. 
     
     
         5 . The method of  claim 1 , further comprising extracting the input data from one or more source databases based on one or more extraction rules. 
     
     
         6 . The method of  claim 5 , further comprising generating the one or more extraction rules based on the one or more predicates. 
     
     
         7 . The method of  claim 5 , wherein the extracting the input data from the one or more source databases and the reconciling the transformed data with the destination database occur relative to each other in real-time or substantially in real-time. 
     
     
         8 . The method of  claim 1 , further comprising:
 generating one or more second reconciliation rules based on the one or more predicates, the one or more second reconciliation rules associated with a second destination database; and   reconciling the transformed data with the second destination database based on the one or more second reconciliation rules.   
     
     
         9 . The method of  claim 1 , wherein the transforming the input data further comprises joining at least one part of the input data with at least one other part of the input data based on the one or more transformation rules. 
     
     
         10 . The method of  claim 1 , wherein the transforming the input data further comprises merging at least one part of the input data with at least one other part of the input data based on the one or more transformation rules. 
     
     
         11 . The method of  claim 1 , further comprising:
 generating one or more post-transformation validation rules based on the one or more predicates; and   validating the transformed data based on the one or more post-transformation validation rules.   
     
     
         12 . The method of  claim 1 , further comprising merging the reconciled data with data stored on the destination database. 
     
     
         13 . The method of  claim 1 , further comprising appending the reconciled data with data stored on the destination database. 
     
     
         14 . The method of  claim 1 , wherein the input data comprises one or more table sets, one or more tables, one or more table fields, or any combination thereof. 
     
     
         15 . The method of  claim 1 , wherein the destination database comprises an operational support system database, a healthcare system database, an information technology database, or any combination thereof. 
     
     
         16 . The method of  claim 1 , further comprising:
 generating one or more second transformation rules based on the one or more predicates;   transforming second input data based on the one or more second transformation rules, the second input data comprising information associated with the one or more system objects, the one or more relationships between the one or more system objects, of any combination thereof;   generating one or more combined transformation rules based on the one or more predicates; and   transforming the first and second transformed input data based on the one or more combined transformation rules, the first and second transformed input data comprising information associated with the one or more system objects, the one or more relationships between the one or more system objects, or any combination thereof.   
     
     
         17 . The method of  claim 16 , further comprising:
 generating one or more combined reconciliation rules based on the one or more predicates, the one or more combined reconciliation rules associated with one or more destination databases; and   reconciling the first and second combined transformed input data with the one or more destination database based on the one or more combined reconciliation rules.   
     
     
         18 . A computer implemented method for declarative and unified data transition, the method comprising:
 determining a unified configuration for a knowledge domain, the unified configuration comprising one or more predicates for one or more relationships between one or more system objects;   generating one or more transformation rules based on the one or more predicates, the one or more transformations enabling transformation of input data, the input data comprising information associated with the one or more system objects, the one or more relationships between the one or more system objects, or any combination thereof; and   generating one or more reconciliation rules based on the one or more predicates, the one or more reconciliation rules associated with a destination database and enabling reconciliation of the transformed data with the destination database.   
     
     
         19 . A computer program product, tangibly embodied in an information carrier, the computer program product including instructions being operable to cause a data processing apparatus to:
 determine a unified configuration for a knowledge domain, the unified configuration comprising one or more predicates for one or more relationships between one or more system objects;   generate one or more transformation rules based on the one or more predicates;   transform input data based on the one or more transformation rules, the input data comprising information associated with the one or more system objects, the one or more relationships between the one or more system objects, or any combination thereof;   generate one or more reconciliation rules based on the one or more predicates, the one or more reconciliation rules associated with a destination database; and   reconcile the transformed data with the destination database based on the one or more reconciliation rules.   
     
     
         20 . A system for declarative and unified data transition, the system comprising:
 a unified configuration module configured to determine a unified configuration for knowledge domain, the unified configuration comprising one or more predicates one or more relationships between one or more system objects;   a transformation rules engine configured to generate one or more transformation rules based on the one or more predicates;   a transformation module configured to transform input data based on the one or more transformation rules, the input data comprising information associated with the one or more system objects, the one or more relationships between the one or more system objects, or any combination thereof;   a reconciliation rules engine configured to generate one or more reconciliation rules based on the one or more predicates, the one or more reconciliation rules associated with a destination database; and   a reconciliation module configured to reconcile the transformed data with the destination database based on the one or more reconciliation rules.   
     
     
         21 . The system of  claim 20 , further comprising:
 the transformation module further configured to transform second input data based on the one or more transformation rules, the second input data comprising information associated with the one or more system objects, the one or more relationships between the one or more system objects, or any combination thereof; and   the reconciliation module further configured to reconcile the second transformed data with the destination database based on the one or more reconciliation rules.   
     
     
         22 . The system of  claim 20 , further comprising:
 a validation rules engine configured to generate one or more validation rules based on the one or more predicates; and   a validation module configured to validate the input data based on the one or more validation rules.   
     
     
         23 . The system of  claim 22 , wherein the validation module is further configured to automatically modify the input data based on the validation of the input data to remove at least one validation error associated with the input data. 
     
     
         24 . The system of  claim 20 , further comprising a source extraction module configured to extract the input data from one or more source databases based on one or more extraction rules. 
     
     
         25 . The system of  claim 24 , further comprising a source extraction rule engine configured to generate the one or more extraction rules based on the one or more predicates. 
     
     
         26 . The system of  claim 20 , wherein:
 the reconciliation rules engine is further configured to generate one or more second reconciliation rules based on the one or more predicates, the one or more second reconciliation rules associated with a second destination database; and   the reconciliation module is further configured to reconcile the transformed data with the second destination database based on the one or more second reconciliation rules.   
     
     
         27 . The system of  claim 20 , wherein the transformation module is further configured to join at least one part of the input data with at least one other part of the input data based on the one or more transformation rules. 
     
     
         28 . The system of  claim 20 , wherein the transformation module is further configured to merge at least one part of the input data with at least one other part of the input data based on the one or more transformation rules. 
     
     
         29 . The system of  claim 20 , wherein the transformation module is further configured to modify at least one part of the input data based on the one or more transformation rules. 
     
     
         30 . The system of  claim 20 , further comprising:
 a validation rules engine configured to generate one or more post-transformation validation rules based on the one or more predicates; and   a validation module configured to validate the transformed data based on the one or more post-transformation validation rules.   
     
     
         31 . The system of  claim 20 , wherein the reconciliation module is further configured to merge the reconciled data with data stored on the destination database. 
     
     
         32 . The system of  claim 20 , wherein the reconciliation module is further configured to append the reconciled data with data stored on the destination database. 
     
     
         33 . The system of  claim 20 , wherein:
 the transformation rules engine is further configured to generate one or more second transformation rules based on the one or more predicates;   the transformation module is further configured to transform second input data based on the one or more second transformation rules, the second input data comprising information associated with the one or more system objects, the one or more relationships between the one or more system objects, or any combination thereof;   the transformation rules engine is further configured to generate one or more combined transformation rules based on the one or more predicates; and   the transformation module is further configured to transform the first and second transformed input data based on the one or more combined transformation rules, the first and second transformed input data comprising information associated with the one or more system objects, the one or more relationships between the one or more system objects, or any combination thereof.   
     
     
         34 . The system of  claim 33 , wherein:
 the reconciliation rules engine is further configured to generate one or more combined reconciliation rules based on the one or more predicates, the one or more combined reconciliation rules associated with one or more destination databases; and   the reconciliation module is further configured to reconcile the first and second combined transformed input data with the one or more destination database based on the one or more combined reconciliation rules.   
     
     
         35 . A system for declarative and unified data transition, the system comprising:
 a unified configuration module configured to determine a unified configuration for a knowledge domain, the unified configuration comprising one or more predicates for one or more relationships between one or more system objects;   a transformation rules engine configured to generate one or more transformation rules based on the one or more predicates, the one or more transformations enabling transformation of input data, the input data comprising information associated with the one or more system objects, the one or more relationships between the one or more system objects, or any combination thereof; and   a reconciliation rules engine configured to generate one or more reconciliation rules based on the one or more predicates, the one or more reconciliation rules associated with a destination database and enabling reconciliation of the transformed data with the destination database.   
     
     
         36 . A system for declarative and unified data transition, the system comprising:
 means for determining a unified configuration for a knowledge domain, the unified configuration comprising one or more predicates for one or more relationships between one or more system objects;   means for generating one or more transformation rules based on the one or more predicates;   means for transforming input data based on the one or more transformation rules, the input data comprising information associated with the one or more system objects, the one or more relationships between the one or more system objects, or any combination thereof;   means for generating one or more reconciliation rules based on the one or more predicates, the one or more reconciliation rules associated with a destination database; and   means for reconciling the transformed data with the destination database based on the one or more reconciliation rules.   
     
     
         37 . A system for declarative and unified data transition, the system comprising:
 means for determining a unified configuration for a knowledge domain, the unified configuration comprising one or more predicates for one or more relationships between one or more system objects;   means for generating one or more transformation rules based on the one or more predicates, the one or more transformations enabling transformation of input data, the input data comprising information associated with the one or more system objects, the one or more relationships between the one or more system objects, or any combination thereof; and   means for generating one or more reconciliation rules based on the one or more predicates, the one or more reconciliation rules associated with a destination database and enabling reconciliation of the transformed data with the destination database.