Creating and processing a data rule for data quality
AssigneeInternational Business Machines Corporation
InventorsSebastian Nelke, Martin Oberhofer, Yannick Saillet, Jens Seifert
Life of this patent
Estimating the term…
Abstract
A data rule is created and processed by receiving an expression defining a logic of a rule and at least one logical variable, creating a rule definition including the expression and the at least one logical variable for binding each logical variable of the rule with at least one column, associating a characteristic enabling comparison of columns with a first logical variable of the rule definition, and storing the characteristic as part of the rule definition.
Claims18
A computer-implemented method of creating and processing a data rule using an electronic computing device, the method comprising:
- receiving an expression defining a logic of a rule and at least one logical variable;
- creating a rule definition including the expression and the at least one logical variable for binding each logical variable of the rule with at least one column;
- associating a characteristic enabling comparison of columns with a logical variable of the rule definition;
- and
- storing the characteristic as part of the rule definition.
A system for creating and processing a data rule comprising:
- a processor configured to perform the operations of:
- providing a user interface to manage I/O functions of the system, including a rule editor configured to create a plurality of rule definitions including an expression defining a logic of a rule and at least one logical variable for binding each logical variable of the rule with at least one column;
- storing within a rule repository the plurality of rule definitions;
- and
- providing a data processing engine in electronic communication with the user interface and the rule repository to associate a characteristic enabling comparison of columns with a logical variable of the rule definition, and to store the characteristic as part of the rule definition in the rule repository.
A computer program product for creating and processing a data rule comprising:
- a computer readable storage device having computer-readable program code embodied therewith, the computer readable program code configured to perform operations of:
- receiving an expression defining a logic of a rule and at least one logical variable;
- creating a rule definition including the expression and the at least one logical variable for binding each logical variable of the rule with at least one column;
- associating a characteristic enabling comparison of columns with a logical variable of the rule definition;
- and
- storing the characteristic as part of the rule definition.
Dependencies are inferred from the claim text.