Declarative and unified data transition

A non-transitory computer readable storage medium including instructions, which when executed by a data processing apparatus causes the 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, the unified configuration being a single configuration file, the one or more predicates identifying a first system object and a second system object, a multiplicity of the relationship between the first system object and the second system object and one of a plurality of predetermined directions indicating a direction of input data between the first system object and the second system object, each system object including a primary key attribute that uniquely identifies the system object, the unified configuration further including one or more validation rules, transformation rules, reconciliation rules and the one or more predicates;
• generate the one or more validation rules based on the one or more predicates of the unified configuration;
• validate the input data based on the one or more validation rules;
• generate the one or more transformation rules based on the one or more predicates of the unified configuration;
• transform first input data based on the one or more transformation rules, the first 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 defined by the unified configuration;
• generate the one or more reconciliation rules based on the one or more predicates of the unified configuration, the one or more reconciliation rules associated with a destination database defined by the unified configuration;
• reconciling the transformed data with the destination database based on the one or more reconciliation rules;
• generate one or more second transformation rules based on the one or more predicates of the unified configuration;
• 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 defined by the unified configuration;
• generate one or more combined transformation rules based on the one or more predicates of the unified configuration;
• 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 defined by the unified configuration;
• generate one or more combined reconciliation rules based on the one or more predicates of the unified configuration, the one or more combined reconciliation rules associated with one or more destination databases defined by the unified configuration;
• and
• 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.

A system for declarative and unified data transition, the system comprising:

• at least one processor and a memory storing instructions that, when executed by the at least one processor, causes the at least one processor 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, the unified configuration being a single configuration file, the one or more predicates identifying a first system object and a second system object, a multiplicity of the relationship between the first system object and the second system object and one of a plurality of predetermined directions indicating a direction of input data between the first system object and the second system object, each system object including a primary key attribute that uniquely identifies the system object, the unified configuration further including one or more validation rules, transformation rules, reconciliation rules and the one or more predicates;
• generate the one or more validation rules based on the one or more predicates of the unified configuration;
• validate the input data based on the one or more validation rules;
• generate the one or more transformation rules based on the one or more predicates of the unified configuration;
• transform first input data based on the one or more transformation rules, the first 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 defined by the unified configuration;
• generate the one or more reconciliation rules based on the one or more predicates of the unified configuration, the one or more reconciliation rules associated with a destination database defined by the unified configuration;
• reconciling the transformed data with the destination database based on the one or more reconciliation rules;
• generate one or more second transformation rules based on the one or more predicates of the unified configuration;
• 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 defined by the unified configuration;
• generate one or more combined transformation rules based on the one or more predicates of the unified configuration;
• 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 defined by the unified configuration;
• generate one or more combined reconciliation rules based on the one or more predicates of the unified configuration, the one or more combined reconciliation rules associated with one or more destination databases defined by the unified configuration;
• and
• 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.