METHODS AND SYSTEMS FOR STAGING AND PROPAGATING DATA

• US 20140052690A1
• Filed: 08/20/2012
• Published: 02/20/2014
• Est. Priority Date: 08/20/2012
• Status: Active Grant

• Current Assignee: Transform Sr Brands, LLC (ESL Investments, Inc.)
• Original Assignee: Sears Brands LLC (Sears Holdings Corporation)
• Inventors: Kamireddy, Nagaraja R., Soundarapandian, Dhinakaran, Rao Konduri, Sai Ramesh J., Kochuthresia, Prince V., Nair, Divya Gopalakrishnan
• Granted Patent: US 9,058,367 B2
• Time in Patent Office: Days
• US Class Current: 707/624
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/2386 Bulk updating operations data conversion details G06F16/258
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

A method and system for propagating database records from staging database to a production database so that the production database reflects record changes made in the staging database. The system of the present disclosure propagates record changes from the staging database to the production database in a flexible, customizable, and reliable way. The system consolidates database record changes to cull out any unnecessary record changes that do not need to be propagated. The system may also track the status of the database record changes, and send alerts related to the propagation status.

Claims

1. A computer-readable media having stored thereon computer executable instructions, wherein the instructions perform steps for providing a system for propagating database records from a first database to a second database via a computing device, comprising:

a first database containing a first set of database records;

a second database containing a second set of database records;

tracking changes made to the first set of database records and maintaining a table of record changes;

performing a consolidation process to determine a cumulative record change for each of the first set of database record and determining which record changes in the table of record changes are unnecessary; and

propagating a user-selected set of database records between the first database to the second database in accordance with the table of record changes and the consolidation process.

2. A computer-readable media as defined in claim 1, wherein the user-selected set of database records comprises a subset of the data contained in the table of record changes.

3. A computer-readable media as defined in claim 1, further comprising instructions for tracking and updating the status of each record of the user-selected set of database records.

4. A computer-readable media as defined in claim 1, further comprising instructions for tracking and updating the status of each record in the first set of database records.

5. A computer-readable media as defined in claim 1, further comprising instructions for determining whether any exceptions have occurred during the propagation of the user-selected set of database records.

6. A computer-readable media as defined in claim 5, further comprising instructions for tracking and updating the status of each record of the user-selected set of database records, including whether an exception occurred during propagation of each record.

7. A computer-readable media as defined in claim 6, further comprising instructions for sending one or more alerts to one or more users relating to the status of each record of the user-selected set of database records, including whether an exception occurred during propagation of each record.

8. A computer-readable media as defined in claim 5, further comprising instructions for tracking and updating the status of each record of the first set of database records, including whether an exception occurred during propagation of each record.

9. A computer-readable media as defined in claim 8, further comprising instructions for sending one or more alerts to one or more users relating to status of each record of the first set of database records, including whether an exception occurred during propagation of each record.

10. A computer-readable media as defined in claim 1, wherein the propagation of a user-selected set of database records is executed in a single-threaded process.

11. A computer-readable media as defined in claim 1, wherein the propagation of a user-selected set of database records is executed in a multi-threaded process.

12. A computer-readable media as defined in claim 1, wherein at least one of the first and second databases is a database for a website.

13. A system for propagating database records from a first database to a second database via a computing device, comprising:

a processor including a processing unit, and system memory which may be linked via a bus;

a first database associated with the processing unit containing a first set of database records, the first database being inaccessible to a public user;

a second database associated with the processing unit containing a second set of database records, the second database being accessible to a public user;

wherein the system tracks changes made to the first set of database records and maintains a table of record changes;

wherein the system performs a consolidation process to determine a cumulative record change for each of the first set of database record and determines which record changes in the table of record changes are unnecessary; and

wherein the system propagates a user-selected set of database records between the first database to the second database in accordance with the table of record changes and the consolidation process.

14. A system as defined in claim 13, wherein the user-selected set of database records comprises a subset of the data contained in the table of record changes.

15. A system as defined in claim 13, wherein the system further tracks and updates the status of each record of the user-selected set of database records.

16. A system as defined in claim 13, wherein the system further tracks and updates the status of each record in the first set of database records.

17. A system as defined in claim 13, wherein the system further determines whether any exceptions have occurred during the propagation of the user-selected set of database records.

18. A system as defined in claim 17, wherein the system further tracks and updates the status of each record of the user-selected set of database records, including whether an exception occurred during propagation of each record.

19. A system as defined in claim 18, wherein the system further sends one or more alerts to one or more users relating to the status of each record of the user-selected set of database records, including whether an exception occurred during propagation of each record.

20. A system as defined in claim 17, wherein the system further tracks and updates the status of each record of the first set of database records, including whether an exception occurred during propagation of each record.

21. A system as defined in claim 20, wherein the system further sends one or more alerts to one or more users relating to status of each record of the first set of database records, including whether an exception occurred during propagation of each record.

22. A system as defined in claim 13, wherein the propagation of a user-selected set of database records is executed in a single-threaded process.

23. A system as defined in claim 13, wherein the propagation of a user-selected set of database records is executed in a multi-threaded process.

24. A system as defined in claim 13, wherein at least one of the first and second databases is a database for a website.

25. A system as defined in claim 13, wherein at least one of the first and second databases is accessible via the Internet.

26. A system as defined in claim 13, wherein at least one of the first and second databases is a database for a retail website.

27. A system as defined in claim 13, wherein at least one of the first and second databases is a product database.

28. A system as defined in claim 13, wherein at least one of the first and second databases is a database containing information relating to products for sale on a retail website.