The invention relates generally to a system and method for repairing data synchronization links between different data repositories.
Many computer software applications and development projects store a wide variety of data in multiple locations commonly referred to as “data repositories”. In such independent data repositories, data linkages are used to determine similar data for the purpose of data synchronization. Synchronizing similar data stored in different data repositories requires either a synchronization system to store and maintain links between similar data records on different data repositories or requires each individual data repository to store links to similar data on other repositories. When a synchronization system stores links between similar data, a user of one data repository may have difficulty establishing a link to similar data on another data repository. When links are stored in individual data repositories, user and data errors can cause correspondences between similar data to be specified incorrectly, leading to synchronization errors. Consequently, a system and method for repairing data synchronization errors is needed.
In some aspects, embodiments of the invention relate to a system for detecting and repairing errors in synchronization links for data records, comprising: a first data repository (R1) containing a first data record (DR1), where DR1 maintains a data field (FieldA) that links to associated data records and a self-reference record (SelfRefA) to detect any errors; a second data repository (R2) contain a second data record (DR2), where DR2 maintains a data field (FieldB) that links to associated data records and a self-reference record (SelfRefB) to detect any errors; a synchronizer that maintains a data table containing, the addresses of DR1 and DR2, and the status of any previous synchronization activity; where DR1 is associated with DR2; and where upon a change in DR1, the system, checks FieldA to determine the association with DR2, uses the entry in the data table to determine the address of DR2, checks FieldB of DR2 to determine if DR2 is linked with DR1, and corrects FieldB of DR2 if no link exists with DR1 by writing an address of DR2 that includes FieldA of DR1 into Field B of DR2.
In other aspects, embodiments of the invention relate to a method for detecting and repairing errors in synchronization links for data records, comprising: detecting a change in a first data record (DR1) located in a first data repository (R1), where DR1 maintains a data field (FieldA) that links to associated data records and a self-reference record (SelfRefA) to detect any errors; determining an association between DR1 with a second data record (DR2) located in a second data repository (R2), where DR2 maintains a data field (FieldB) that links to associated data records and a self-reference record (SelfRefB) to detect any errors; determining the address of DR2 by checking a data table located in a synchronizer, where the synchronizer that maintains the data table containing, the addresses of DR1 and DR2; checking FieldB of DR2 to determine if DR2 is linked with DR1; and correcting FieldB of DR2 if no link exists with DR1 by writing FieldA and the self-reference of DR2 into Field B of DR2.
Other aspects and advantages of various embodiments of the invention will be apparent from the following description and the appended claims.
It should be noted that identical features in different drawings are shown with the same reference numeral.
A system and method for repairing data synchronization links has been developed. The embodiments of the present invention provide a system and method for repairing synchronization of similar data records stored in different data repositories when synchronization links are stored as part of data to be synchronized in each data repository.
Embodiments of the present invention include multiple data repositories and a synchronizer that serves to synchronize the data links between the repositories.
In one example embodiment of the present invention, the synchronizer maintains a “table” of URLs of similar data to be synchronized between two different data repositories. The table includes any number of rows. Each row of the table has two URLs identifying data records to be synchronized, the types of data repositories in which the data records are stored, a timestamp of the last time the data was synchronized and a state indicating the status of the last synchronization (e.g., OK or ERROR). In other embodiments, other types of data addresses or identification may be used instead of URLs. URLs are used where communication between different data repositories is across the internet or other network that could reference a URL to locate the appropriate data record. For embodiments using multiple data repositories, the rows of addresses will list all of the repositories containing similar data to be linked with each individual linkage having its own row. For example, if a first data record is linked to two other separate data records, two rows will be used: one row for the first and second data record; and a second row for the first and third data record.
In some example embodiments of the present invention, each data record on each data repository participating in synchronization has one or more fields (e.g., “FieldA” on Data Records in Repository #1 and “FieldB” on data records in Repository #2 as referenced in
However, if data is present on the link field of DR1, the data in FieldA is examined to determine if it is well formed. “Well-formed” data will have: a self-reference field; a URL; and an identifier to indicate the type of data repository on which similar data resides. If the data is not well-formed, an error state is set and the process ends. If the data is well formed, the self-reference of FieldA is checked to determine if it is correct by double checking to ensure the URL in the self-reference field refers back to the same data record. If the self-reference field is not correct, R1 is checked to see if there is a table entry for DR1. If no entry is present, the method will proceed to the procedures (“B”) described in
Referring now to
However, if FieldB has data, the self-reference of FieldB is examined to determine if it is correct by double checking to ensure the URL refers back to the same data record. Also, FieldB is examined to determine if it links to DR1. If it does not link to DR1, an error state is set and the process ends. If FieldB's self-reference is correct and Field B links to DR1, the FieldA data and information is written into DR1 with data and information from the corresponding record in DR2. An “OK” state is set for the data records and the process ends. However, if FieldB's self-reference is not correct and Field B links to DR1, FieldB's self-reference is corrected to link to DR2 and the FieldA data and information is written into DR1 with data and information from the location of FieldB in DR2, the type of data repository on which DR2 resides and a self-reference to DR1. An “OK” state is set in the synchronizer for the data records and the process ends.
Referring now to
Embodiments of the present invention can be implemented across a wide variety of applications and uses. For example, embodiments of the invention could be used with Application Lifecycle Management (ALM) records, project portfolio management (PPM), tickets in an IT help or support system (ITSM), and contact management systems for personal use such as between a mobile device and an email account. It is also possible this approach could be used to synchronize wikis stored in two different wiki systems if pages in the wiki system were treated as data records with fields including meta data about the page.
In another example, embodiments of the invention could be used by a software development team to record bugs that are reported about the applications they produce. For example, the team may use one software system to record bugs that are reported and use a second software system in which to record tests that are used to determine if the applications are executing as desired. To help track tests used to determine if a bug is fixed, the team wants to represent recorded bugs from the first system as recorded defects in the second system. By synchronizing the bugs to defects, both programmers and testers can work with the same information.
Embodiments of the present invention may be used synchronize bugs to defects between the systems. When the synchronization system sees a new bug, the synchronization system presents the change in the bug data record to the system. If this is the first time the bug has been seen for synchronization, the field indicated as providing link data is empty. As part of synchronization, a new defect is created in the second system and the field indicated as providing link data in the second system record is set for the new defect to be the new bug.
An important advantage to the embodiments of the present invention is the ability to synchronize and repair data links across different platforms for all data. Neither repository nor computer system is considered a master record. Instead data records in every platform are analyzed for correctness. If an error is found, the linked data record is repaired without regard to the status or designation of its repository or computer system.
While the invention has been described with respect to a limited number of embodiments, those skilled in the art, having benefit of this disclosure, will appreciate that other embodiments can be devised which do not depart from the scope of the invention as disclosed here. Accordingly, the scope of the invention should be limited only by the attached claims.
Number | Name | Date | Kind |
---|---|---|---|
5301320 | McAtee et al. | Apr 1994 | A |
5706509 | Man-Hak Tso | Jan 1998 | A |
5970501 | Hunkins et al. | Oct 1999 | A |
6393434 | Huang et al. | May 2002 | B1 |
6397192 | Notani et al. | May 2002 | B1 |
6460051 | LaRue et al. | Oct 2002 | B1 |
6477545 | LaRue | Nov 2002 | B1 |
6505200 | Ims et al. | Jan 2003 | B1 |
7013315 | Boothby | Mar 2006 | B1 |
7424477 | Martin | Sep 2008 | B1 |
7480907 | Marolia et al. | Jan 2009 | B1 |
7496606 | Hind et al. | Feb 2009 | B2 |
7516167 | Selman et al. | Apr 2009 | B2 |
7565381 | Oswalt | Jul 2009 | B2 |
7607130 | Singh et al. | Oct 2009 | B2 |
7693888 | Urscheler et al. | Apr 2010 | B2 |
7962448 | Creamer et al. | Jun 2011 | B2 |
8131672 | Hind et al. | Mar 2012 | B2 |
8315976 | Multer et al. | Nov 2012 | B2 |
20010056420 | Steele, Jr. | Dec 2001 | A1 |
20020059299 | Spaey | May 2002 | A1 |
20040148299 | Teegan et al. | Jul 2004 | A1 |
20060259517 | Urscheler et al. | Nov 2006 | A1 |
20070282802 | Wilhelm | Dec 2007 | A1 |
20080212616 | Augustine et al. | Sep 2008 | A1 |
20090037452 | Baitalmal et al. | Feb 2009 | A1 |
20090077076 | Berger | Mar 2009 | A1 |
20100011337 | Young et al. | Jan 2010 | A1 |
20100017792 | Young et al. | Jan 2010 | A1 |
20100145910 | Zhao et al. | Jun 2010 | A1 |
20100153423 | Lu | Jun 2010 | A1 |
20110047126 | Vargas et al. | Feb 2011 | A1 |
20120271849 | Lesser et al. | Oct 2012 | A1 |
Number | Date | Country |
---|---|---|
2 169 552 | Mar 2010 | EP |
2160689 | Mar 2010 | EP |
Entry |
---|
Golbeck et al., “System and Method for Synchronizing States in Associated Data Records,” U.S. Appl. No. 13/833,901, filed Mar. 15, 2013, 14 pages. |
Golbeck et al., “System and Method for Synchronizing States in Associated Data Records,” Preliminary Amendment filed Apr. 7, 2014, for U.S. Appl. No. 13/833,901, 20 pages. |
Golbeck et al., “System and Method for Synchronizing States in Associated Data Records”, Office Action mailed Mar. 25, 2015, for U.S. Appl. No. 13/833,901, 21 pages. |
Kisynski et al., “Systems and Methods to Synchronize Artifact Relationships Across a Plurality of Repositories,” U.S. Appl. No. 14/571,113, filed Dec. 15, 2014, 63 pages. |