Systems, methods, and apparatuses for simultaneously running parallel databases
Embodiments herein relate to replacing a legacy Pick environment with a modern microservice architecture. A legacy database and a modern database may be operated in parallel for data validation. During the validation process, the legacy database may be used as the master copy of the data. After verifying that the modern database satisfies the data needs of a system, the system can switch to using the new modern database as the master copy.
1. A method for creating a replacement database, the method comprising:
migrating legacy data from a Pick database to a microservice database, the migrating including making a copy of the data currently on the Pick database and sending it to the microservice database;
sending a data update from a service to both the Pick database and the microservice database such that both databases are concurrently updated, including updated data on the microservice database and current data on the Pick database, based on a single action from the service;
comparing the updated data on the microservice database against the current data on the Pick database, wherein the Pick database is considered a master copy during the comparison;
verifying that the updated data on the microservice database is equivalent to the current data on the Pick database, the verifying comprising:
compiling a list of updated business objects associated with the microservice database and a corresponding data path for each updated business object,
comparing the updated business objects and their corresponding data paths to a master list associated with a dealer management system, and
validating that changes to the current data on the Pick database are captured by the updated data on the microservice database; and
based on the validation, switching to using the microservice database as the master copy.
2. The method of claim 1 , further comprising identifying paths by which the data update is sent.
3. The method of claim 1 , wherein switching to using the microservice database as the master copy occurs after all data needs are verified.
4. The method of claim 1 , wherein switching to using the microservice database as the master copy occurs in segments such that data controlled by a service of the microservice database is the master copy after the service has been verified.
5. The method of claim 1 , further comprising generating an alert and remediating a data failure when there is a discrepancy between the Pick database and the microservice database.
6. The method of claim 1 , further comprising verifying the microservice database, wherein verification occurs after a target period of time with no discrepancies between the Pick database and the microservice database.
7. The method of claim 1 , wherein the Pick database is part of the dealer management system, and wherein the dealer management system is a centralized dealer management system.
8. A system comprising:
a dealer management system comprising a Pick database;
a modern microservice system comprising a microservice database;
a database interface configured to send data updates from a service to both the Pick database and the microservice database such that both databases are concurrently updated based on a single action from the service;
a database verification system comprising:
a processor; and
a memory storing instructions that, when executed by the processor, configure the database verification system to:
migrate legacy data from the Pick database to the microservice database, including making a copy of data currently on the Pick database and sending it to the microservice database;
detect a data update on the Pick database or the microservice database;
after the data update is detected, compare updated data on the microservice database against current data on the Pick database, wherein the Pick database is considered a master copy during the comparison;
verify that the updated data on the microservice database is equivalent to the current data on the Pick database, the verifying comprising:
compiling a list of updated business objects associated with the microservice database and a corresponding data path for each updated business object,
comparing the updated business objects and their corresponding data paths to a master list associated with a dealer management system, and
validating that changes made to the current data on the Pick database are captured by the updated data on the microservice database; and
based on the validation, modify the database interface to only send new data updates to the microservice database, wherein the microservice database is considered the master copy.
9. The computing apparatus of claim 8 , wherein the instructions further configure the database verification system to identify paths by which the data update is sent.
10. The computing apparatus of claim 8 , wherein modifying the database interface occurs after all data needs are verified.
11. The computing apparatus of claim 8 , wherein modifying the database interface occurs in segments such that data controlled by a service of the microservice database is the master copy after the service has been verified.
12. The computing apparatus of claim 8 , wherein the instructions further configure the database verification system to generate an alert and remediate a data failure when there is a discrepancy between the Pick database and the microservice database.
13. The computing apparatus of claim 8 , wherein the instructions further configure the database verification system to verify the microservice database, wherein verification occurs after a target period of time with no discrepancies between the Pick database and the microservice database.
14. The computing apparatus of claim 8 , wherein the Pick database is part of the dealer management system, and wherein the dealer management system is a centralized dealer management system.
15. A non-transitory computer-readable storage medium, the computer-readable storage medium including instructions that when executed by a computer, cause the computer to:
migrate legacy data from a Pick database to a microservice database, the migrating including making a copy of data currently on the Pick database and sending it to the microservice database;
send a data update from a service to both the Pick database and the microservice database such that both databases are concurrently updated based on a single action from the service, including updated data on the microservice database and current data on the Pick database;
compare the updated data on the microservice database against the current data on the Pick database, wherein the Pick database is considered a master copy during the comparison;
verify that the updated data on the microservice database is equivalent to the current data on the Pick database, the verifying comprising:
compiling a list of updated business objects associated with the microservice database and a corresponding data path for each updated business object,
comparing the updated business objects and their corresponding data paths to a master list associated with a dealer management system, and
validating that changes to the current data on the Pick database are captured by the updated data on the microservice database; and
based on the validation, switch to using the microservice database as the master copy.
16. The computer-readable storage medium of claim 15 , wherein the instructions further configure the computer to identify paths by which the data update is sent.
17. The computer-readable storage medium of claim 15 , wherein switching to using the microservice database as the master copy occurs after all data needs are verified.
18. The computer-readable storage medium of claim 15 , wherein switching to using the microservice database as the master copy occurs in segments such that data controlled by a service of the microservice database is the master copy after the service has been verified.
19. The computer-readable storage medium of claim 15 , wherein the instructions further configure the computer to generate an alert and remediate a data failure when there is a discrepancy between the Pick database and the microservice database.
20. The computer-readable storage medium of claim 15 , wherein the instructions further configure the computer to verify the microservice database, wherein verification occurs after a target period of time with no discrepancies between the Pick database and the microservice database.