Managing changes to collections of data

Patent metadata

Field	Value
Publication number	US-9418095-B2
Application number	US-201213350191-A
Country	US
Kind code	B2
Filing date	Jan 13, 2012
Priority date	Jan 14, 2011
Publication date	Aug 16, 2016
Grant date	Aug 16, 2016

Abstract

Managing changes to a collection of records includes storing a first set of records in a data storage system, the first set of records representing a first version of the collection of records, and validating a proposed change to the collection of records specified by an input received over a user interface. The data storage system is queried based on validation criteria associated with the proposed change, and a first result is received in response to the querying. A second set of records is processed representing changes not yet applied to the collection of records to generate a second result. The first result is updated based on the second result to generate a third result. The third result is processed to determine whether the proposed change is valid according to the validation criteria.

First claim

What is claimed is:

1. A method for managing a change to a collection of records, the method including:
maintaining the collection of records and a pending change to the collection of records in a data storage system, wherein at least some of the records each include a metadata map that maps one or more source values to one or more target values, and the pending change having been previously proposed and validated but not yet applied to the collection of records; and
validating a proposed change to the collection of records specified by an input received over a user interface, the validating including:
querying the data storage system based on one or more validation criteria associated with the proposed change;
receiving a first result in response to the querying indicating any records in the collection of records that include information that would be affected by the proposed change;
processing the pending change, the pending change being different from the proposed change;
determining a second result based on the processing indicating whether or not there are any conflicting records in the pending change that represent a potential conflict with the proposed change;
generating a third result based on the first result and the second result indicating any records in the collection of records or in the conflicting records that include information that would be affected by the proposed change; and
processing the third result to determine whether the proposed change is valid according to the one or more validation criteria.

2. The method of claim 1 , wherein processing the third result includes invalidating the proposed change if the same set of one or more source values is mapped by two or more different metadata maps to two or more different sets of one or more target values, or two or more different sets of one or more source values are mapped by two or more different metadata maps to the same set of one or more target values.

3. The method of claim 1 , wherein processing the third result includes identifying whether applying the proposed change would result in a creation of one or more duplicate records.

4. The method of claim 3 , wherein identifying whether applying the proposed change would result in a creation of one or more duplicate records includes identifying one or more duplicate rows.

5. The method of claim 3 , wherein the one or more duplicate rows are identified using one or more source values as the one or more validation criteria.

6. The method of claim 1 , wherein the pending change includes one or more changesets that represent proposed changes to the collection of records that have been entered into the user interface.

7. The method of claim 1 , wherein the input includes an instruction to apply changes associated with a previously-saved changeset to the collection of records.

8. The method of claim 1 , wherein validating the proposed change to the collection of records includes validating the proposed change against other proposed changes specified in the user interface by the input.

9. The method of claim 1 , wherein the user interface includes one or more filters to selectively display one or more subsets of sets of records.

10. The method of claim 1 , further including generating a notification if the proposed change is not validated.

11. The method of claim 10 , wherein the notification identifies a portion of the proposed change that violates the one or more validation criteria.

12. The method of claim 1 , wherein the pending change is stored in the data storage system prior to receiving the input specifying the proposed change to the collection of records.

13. The method of claim 1 , wherein querying the data storage system includes identifying one or more portions of the metadata map that are relevant to the proposed change.

14. The method of claim 13 , wherein a portion of the metadata map is relevant to the proposed change when a source value or a target value in the portion of the metadata map matches a source value or a target value identified in the proposed change.

15. The method of claim 1 , wherein the pending change includes a metadata map that maps one or more source values to one or more target values, and processing the pending change includes identifying one or more portions of the metadata map that are relevant to the proposed change.

16. The method of claim 15 , wherein a portion of the metadata map is relevant to the proposed change when a source value or a target value in the portion of the metadata map matches a source value or a target value identified in the proposed change.

17. The method of claim 1 , wherein the proposed change includes a metadata map that maps one or more source values to one or more target values.

18. A non-transitory computer-readable storage medium storing a computer program for managing a change to a collection of records, the computer program including instructions for causing a computing system to:
maintain the collection of records and a pending change to the collection of records in a data storage system, wherein at least some of the records each include a metadata map that maps one or more source values to one or more target values, and the pending change having been previously proposed and validated but not yet applied to the collection of records; and
validate a proposed change to the collection of records specified by an input received over a user interface, the validating including:
querying the data storage system based on one or more validation criteria associated with the proposed change;
receiving a first result in response to the querying indicating any records in the collection of records that include information that would be affected by the proposed change;
processing the pending change, the pending change being different from the proposed change;
determining a second result based on the processing indicating whether or not there are any conflicting records in the pending change that represent a potential conflict with the proposed change;
generating a third result based on the first result and the second result indicating any records in the collection of records or in the conflicting records that include information that would be affected by the proposed change; and
processing the third result to determine whether the proposed change is valid according to the one or more validation criteria.

19. The non-transitory computer-readable storage medium of claim 18 , wherein processing the third result includes invalidating the proposed change if the same set of one or more source values is mapped by two or more different metadata maps to two or more different sets of one or more target values, or two or more different sets of one or more source values are mapped by two or more different metadata maps to the same set of one or more target values.

20. The non-transitory computer-readable storage medium of claim 18 , wherein processing the third result includes identifying whether applying the proposed change would result in a creation of one or more duplicate records.

21. The non-transitory computer-readable storage medium of claim 20 , wherein identifying whether applying the proposed change would result in a creation of one or more duplicate records includes identifying one or more duplicate TOWS.

22. The non-transitory computer-readable storage medium of claim 20 , wherein the one or more duplicate rows are identified using one or more source values as the one or more validation criteria.

Assignees

• Gould Joel
• Perkins Timothy
• Weiss Adam
• Ab Initio Technology Llc

Inventors

• Gould Joel
• Perkins Timothy
• Weiss Adam

Classifications

• G06F16/2365 Primary

  Ensuring data consistency and integrity · CPC title

• G06F17/30371 Primary

  Physics · mapped topic