Data cleansing
First Claim
Patent Images
1. A computer-implemented method comprising:
- receiving, at one or more processors of a computer, an indication of a source instance of an object type wherein the source instance has one or more associated attribute values and is associated with one or more source referring instances, with each source referring instance having one or more associated attribute values;
receiving, at the one or more processors of the computer, an indication of a target instance of the object type, wherein the target instance i) has one or more associated attribute values, ii) corresponds to the source instance, and iii) is associated with one or more target referring instances, with each target referring instance having one or more associated attribute values;
accessing the source instance from electronic storage;
accessing the target instance from electronic storage;
displaying, on a display device of the computer, at least one attribute value of a source referring instance;
displaying, on the display device, at least one attribute value of a target referring instance, the displayed target referring instance corresponding to the displayed source referring instance;
receiving user input that identifies at least one attribute value associated with the displayed source referring instance that is to be associated with the displayed target referring instance; and
storing, in electronic storage, the identified at least one attribute value in association with the displayed target referring instance that is associated with the target instance.
2 Assignments
0 Petitions
Accused Products
Abstract
Data cleansing of a data management system involves merging two data objects by copying one or more attribute values associated with one a source object to a target data object and reassigning any instances that refer to the source object to the target object. The source object may be deleted. A user interface is developed that allows a user to select from a list of possible source objects and target objects, view attribute values for an object, view dependent relationships as dependency trees, indicate any attribute values that should be copied and any referring objects that should be reassigned to the target instance.
-
Citations
24 Claims
-
1. A computer-implemented method comprising:
-
receiving, at one or more processors of a computer, an indication of a source instance of an object type wherein the source instance has one or more associated attribute values and is associated with one or more source referring instances, with each source referring instance having one or more associated attribute values; receiving, at the one or more processors of the computer, an indication of a target instance of the object type, wherein the target instance i) has one or more associated attribute values, ii) corresponds to the source instance, and iii) is associated with one or more target referring instances, with each target referring instance having one or more associated attribute values; accessing the source instance from electronic storage; accessing the target instance from electronic storage; displaying, on a display device of the computer, at least one attribute value of a source referring instance; displaying, on the display device, at least one attribute value of a target referring instance, the displayed target referring instance corresponding to the displayed source referring instance; receiving user input that identifies at least one attribute value associated with the displayed source referring instance that is to be associated with the displayed target referring instance; and storing, in electronic storage, the identified at least one attribute value in association with the displayed target referring instance that is associated with the target instance. - View Dependent Claims (2, 3, 4, 5, 6, 8, 9, 10, 11)
-
-
7. The method of c aim 1 further comprising archiving the source instance.
-
12. A computer-implemented method comprising:
-
receiving instances of data elements, with each instance having one or more associated attribute values and an associated identification key; displaying the identification key associated with each instance; receiving a user-selected indication that identifies one of the displayed identification keys as the identification key of a source instance; receiving a user-selected indication that identifies one of the displayed identification keys as the identification key of a target instance; displaying the source instance and one or more associated attribute values; displaying the target instance; displaying a source dependency tree showing one or more source referring instances associated with the source instance; displaying a target dependency tree showing one or more target referring instances associated with the target instance; displaying at least one attribute value associated with at least one of the displayed source referring instances of the source instance and at least one attribute value associated with at least one of the displayed target referring instances of the target instance; receiving user input that identifies at least one attribute value associated with at least one of the displayed source referring instances of the source instance that is to be associated with a displayed target referring instance of the target instance; and associating the identified attribute values with the displayed target referring instance of the target instance.
-
-
13. A system comprising a processor connected to a storage device and one or more input/output devices, wherein the processor is executed to:
-
receive, at one or more processors of a computer, an indication of a source instance of an object type wherein the source instance has one or more associated attribute values and is associated with one or more source referring instances, with each source referring instance having one or more associated attribute values; receive, at the one or more processors of the computer, an indication of a target instance of the object type, wherein the target instance i) has one or more associated attribute values, ii) corresponds to the source instance, and iii) is associated with one or more target referring instances, with each target referring instance having one or more associated attribute values; access the source instance from electronic storage; access the target instance from electronic storage; display, on a display device of the computer, at least one attribute value of a source referring instance; display, on the display device, at least one attribute value of a target referring instance, the displayed target referring instance corresponding to the displayed source referring instance; receive user input that identifies at least one attribute value associated with the displayed source referring instance that is to be associated with the displayed target referring instance; and store, in electronic storage, the identified at least one attribute value in association with the displayed target referring instance that is associated with the target instance. - View Dependent Claims (14, 15, 16, 17, 18, 19, 20, 21, 22, 23)
-
-
24. A system comprising a processor connected to a storage device and one or more input/output devices, wherein the processor is executed to:
-
receive instances of data elements, with each instance having one or more associated attribute values and an associated identification key; display the identification key associated with each instance; receive a user-selected indication that identifies one of the displayed identification keys as the identification key of a source instance; receive a user-selected indication that identifies one of the displayed identification keys as the identification key of a target instance; display the source instance and one or more associated attribute values; display the target instance; receive a user-selected indication that identifies one or more attribute values associated with the source instance that we to be associated with the target instance; associate the identified attribute values with the target instance; display a source dependency tree showing one or more source referring instances associated with the source instance; display a target dependency tree showing one or more target referring instances associated with the target instance; display at least one attribute value associated with at least one of the displayed source referring instances of the source instance and at least one attribute value associated with at least one of the displayed target referring instances of the target instance; receive user input that identifies at least one attribute value associated with at least one of the displayed source referring instances of the source instance that is to be associated with a displayed target referring instance of the target instance; and associate the identified attribute values with the displayed target referring instance of the target instance.
-
Specification