Method of Assisting Users In Detection and Correction of Errors In Complex Databases

• US 20080208882A1
• Filed: 01/22/2008
• Published: 08/28/2008
• Est. Priority Date: 02/28/2007
• Status: Abandoned Application

• Current Assignee: Honeywell International Inc.
• Original Assignee: Honeywell International Inc.
• Inventors: Zhang, Kang, Felke, Timothy J., van der Zweep, Jeff J.
• Application Number:
  US12/017,443
• Publication Number:
  US 20080208882A1
• Time in Patent Office: Days
• US Class Current: 707/101
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors

Abstract

A method and system for conflict detection during construction of complex databases, such as a data model for driving or modeling a complex system. Components of a data model may be defined in rules that specify objects of various types and containing various elements. The rules are declarative, and may be stored on a computer-readable storage medium. Rule declarations or assertions include element definitions, values or ranges of values, inclusion requirements, and severity level conditions in the event that conflicts or errors are detected. Conflict checking takes account of compliance with type definitions, as well as a user identity and a phase of construction of the data model.

Claims

1. A computer-implemented method of constructing a data model for modeling a complex system, the data model comprising a plurality of objects and being stored on a computer-readable storage medium, the method comprising the steps of:

specifying parametric data of a parameter-driven rule, the parametric data being stored on the computer-readable storage medium;

rendering a first object of a defined type by a user, the first object including a particular identifier and containing information used by the data model, and the defined type being specified in the parameter-driven rule in accordance with the parametric data;

applying the parameter-driven rule to the first object to determine a build state of the first object, the build state of the first object depending on (i) a state of compliance of the first object with the parameter-driven rule, (ii) an identity of the user, and (iii) a state of the data model; and

responsive to determining that the build state of the first object corresponds to a requisite build state, modifying the data model stored on the computer-readable storage medium by integrating the first object into the data model.

2. The method of claim 1, wherein rendering the first object of the defined type comprises creating a new object of the defined type.

3. The method of claim 1, wherein rendering the first object of the defined type comprises modifying an existing object of the defined type.

4. The method of claim 1, wherein applying the parameter-driven rule to the first object comprises determining the state of compliance of the first object with the parameter-driven rule by validating the first object against the defined type specified in the parameter-driven rule.

5. The method of claim 4, wherein the parameter-driven rule comprises a requirement that objects of the defined type must include a requisite number of object elements of a defined object-element type, and validating the first object against the defined type specified in the parameter-driven rule comprises:

specifying the state of compliance as compliant upon a determination that the first object includes the requisite number of object elements of the defined object-element type; and

specifying the state of compliance as non-compliant upon a determination that the first object fails to include the requisite number of object elements of the defined object-element type.

6. The method of claim 1, wherein applying the parameter-driven rule to the first object comprises:

in accordance with information contained in at least a second object, revising the defined type specified in the parameter-driven rule; and

determining the state of compliance of the first object with the parameter-driven rule by validating the first object against the revised defined type specified in the parameter-driven rule.

7. The method of claim 6, wherein the parameter-driven rule comprises a requirement that objects of the defined type must include a data element having a value between a minimum value and a maximum value, and revising the defined type specified in the parameter-driven rule comprises revising at least one of the minimum value and the maximum value.

8. The method of claim 1, wherein:

the parameter-driven rule is implemented as computer-executable software that (i) is stored separately from the parametric data on the computer-readable storage medium, and (ii) comprises machine-language instructions for carrying out logical steps in accordance with information contained in the parametric data, and

applying the parameter-driven rule to the first object comprises executing the software on a computer, wherein executing the software comprises accessing and using the parametric data to carry out the logical steps.

9. The method of claim 1, wherein applying the parameter-driven rule to the first object comprises determining the build state of the first object by using both the state of the data model and the identity of the user to further specify the state of compliance of the first object with the parameter-driven rule.

10. The method of claim 1, wherein the data model includes a list of requisite build states for objects in the data model, and integrating the first object into the data model comprises:

upon a determination (i) that the build state of the first object matches at least one of the requisite build states, and (ii) that the data model includes an existing object with the particular identifier, updating the data model by replacing the existing object with the first object in the data model;

upon a determination (i) that the build state of the first object matches at least one of the requisite build states, and (ii) that the data model does not include an existing object with the particular identifier, updating the data model by adding the first object to the data model;

upon a determination that the build state of the first object fails to match at least one of the requisite build states, refusing to update the data model with the first object; and

issuing a message indicating both the build state of the first object and whether the data model was updated.

11. A computer-implemented method of constructing a data model for modeling a complex system, the data model comprising a plurality of objects and being stored on a computer-readable storage medium, the method comprising the steps of:

defining a parameter-driven rule for determining a build state of objects of a given type, the given type being specified in the parameter-driven rule in accordance with parametric data, and the parameter-driven rule (i) being implemented as computer-executable software stored on the computer-readable storage medium, and (ii) comprising machine-language instructions for carrying out logical steps in accordance with information contained in the parametric data, the parametric data being stored separately from the computer-executable software on the computer-readable storage medium;

a user applying the parameter-driven rule to a first object of the given type to determine the build state of the first object, the build state of the first object depending on (i) a state of compliance of the object with the parameter-driven rule, (ii) an identity of the user, and (iii) a state of the data model; and

responsive to determining that the build state of the first object corresponds to a requisite build state, modifying the data model stored on the computer-readable storage medium by integrating the first object into the data model.

12. The method of claim 11, wherein an existing parameter-driven rule includes a specification of the given type, and defining the parameter-driven rule comprises, in accordance with information contained in at least a second object, redefining the existing parameter-driven rule by revising the specification of the given type.

13. The method of claim 11, wherein applying the parameter-driven rule to the first object comprises:

determining the state of compliance of the first object with the parameter-driven rule by validating the first object against the given type specified in the parameter-driven rule; and

determining the build state of the first object by using both the state of the data model and the identity of the user to further specify the state of compliance of the first object with the parameter-driven rule.

14. The method of claim 11, wherein the data model includes a list of requisite build states for objects in the data model, and integrating the first object into the data model comprises:

upon a determination (i) that the build state of the first object matches at least one of the requisite build states, and (ii) that the data model includes an existing object with the particular identifier, updating the data model by replacing the existing object with the first object in the data model;

upon a determination (i) that the build state of the first object matches at least one of the requisite build states, and (ii) that the data model does not include an existing object with the particular identifier, updating the data model by adding the first object to the data model;

upon a determination that the build state of the first object fails to match at least one of the requisite build states, refusing to update the data model with the first object; and

issuing a message indicating both the build state of the first object and whether the data model was updated.

15. In a computer system for constructing a data model for modeling a complex system, wherein the computer system comprises a processor and a computer-readable storage medium, and the data model comprises a plurality of objects and is stored on the computer-readable storage medium, an improvement comprising:

means for specifying parametric data of a parameter-driven rule for determining a build state of objects of a given type, the parametric data being stored on the computer-readable storage medium;

means for defining the parameter-driven rule, the given type being specified in the parameter-driven rule in accordance with the parametric data, and the parameter-driven rule (i) being implemented as computer-executable software stored separately from the parametric data on the computer-readable storage medium, and (ii) comprising machine-language instructions for carrying out logical steps in accordance with information contained in the parametric data;

means for rendering a first object of the given type by a user, the first object including a particular identifier and containing information used by the data model;

means for applying the parameter-driven rule to the first object to determine a build state of the first object, the build state of the first object depending on (i) a state of compliance of the first object with the parameter-driven rule, (ii) an identity of the user, and (iii) a state of the data model; and

means making a determination that the build state of the first object corresponds to a requisite build state, and responsive to making the determination, modifying the data model stored on the computer-readable storage medium by integrating the first object into the data model.

16. The improvement of claim 15, wherein an existing parameter-driven rule includes a specification of the given type, and the means for defining the parameter-driven rule comprises means for redefining the existing parameter-driven rule by revising the specification of the given type in accordance with information contained in at least a second object.

17. The improvement of claim 15, wherein the means for rendering the first object of the defined type comprises:

means for creating a new object of the given type; and

means for modifying an existing object of the given type.

18. The improvement of claim 15, wherein the means for applying the parameter-driven rule to the first object comprises:

means for determining the state of compliance of the first object with the parameter-driven rule by validating the first object against the given type specified in the parameter-driven rule; and

means determining the build state of the first object by using both the state of the data model and the identity of the user to further specify the state of compliance of the first object with the parameter-driven rule.

19. The improvement of claim 18, wherein the parameter-driven rule comprises (i) a first requirement that objects of the given type must include a requisite number of object elements of a defined object-element type, and (ii) a second requirement that objects of the given type must include a data element having a value between a minimum value and a maximum value, and wherein the means for determining the state of compliance of the first object with the parameter-driven rule by validating the first object against the given type specified in the parameter-driven rule comprises:

means for making a first determination that the first object includes the requisite number of object elements of the defined object-element type, and responsive to making the first determination, specifying the state of compliance as compliant;

means for making a second determination that the first object fails to include the requisite number of object elements of the defined object-element type, and responsive to making the second determination, specifying the state of compliance as non-compliant;

means for revising at least one of the minimum value and the maximum value in accordance with information contained in at least a second object;

means for making a third determination that the first object includes a data element having a value between the minimum value and the maximum value, and responsive to making the third determination, specifying the state of compliance as compliant; and

means for making a fourth determination that the first object fails to include a data element having a value between the minimum value and the maximum value, and responsive to making the fourth determination, specifying the state of compliance as non-compliant.

20. The improvement of claim 15, where the means for integrating the first object into the data model comprises:

means for making a first determination (i) that the build state of the first object matches at least one of the requisite build states, and (ii) that the data model includes an existing object with the particular identifier, and responsive to making the first determination, updating the data model by replacing the existing object with the first object in the data model;

means for making a second determination (i) that the build state of the first object matches at least one of the requisite build states, and (ii) that the data model does not include an existing object with the particular identifier, and responsive to making the second determination, updating the data model by adding the first object to the data model;

means for making a third determination that the build state of the first object fails to match at least one of the requisite build states, and responsive to making the third determination, refusing to update the data model with the first object; and

means for issuing a message indicating both the build state of the first object and whether the data model was updated.