Methods and systems for staging and propagating data
View Patent ↗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.
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 records and determining which record changes in the table of record changes are duplicative and not implemented; 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, wherein the user-selected set of database records includes records associated with a product and an advertisement that are to be publically accessible on the second database.
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 is operatively coupled 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 records and determines which record changes in the table of record changes are duplicative and not implemented; 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, wherein the user-selected set of database records includes records associated with a product and an advertisement that are to be accessible by the public user.
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.