Systems, methods, and apparatuses for scanning a legacy database
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. Part of the data validation may include scanning the legacy database for updates to items stored thereon. Embodiments herein may generate an update message by combining item keys from across the multiple files that correspond with a same business object.
1. A method for tracking updates to a legacy database, the method comprising:
operating a legacy database and a modern database in parallel;
requesting update information for multiple files on the legacy database for a specified time range;
receiving item keys for items that were updated within the multiple files during the specified time range;
filtering each of the item keys based at least on their associated business item and generating an update message by combining item keys from across the multiple files that correspond with a same business object and ignoring item keys not associated with the same business object;
sending the update message to the modern database; and
based on receipt of the update message, performing data validation at the modern database, wherein data validation comprises determining the updates to the legacy database are captured on the modern database operating in parallel.
2. The method of claim 1 , wherein the legacy database is a Pick environment and the modern database is a modern microservice architecture.
3. The method of claim 1 , wherein additional update messages are generated for additional business objects, and wherein each update message comprises all of the item keys associated with a corresponding business object during the specified time range.
4. The method of claim 1 , wherein the item keys comprise an item identifier and a timestamp of a last update.
5. The method of claim 1 , wherein the business objects comprise customer business objects, employee business objects, vendor business objects, and financial institution business objects.
6. The method of claim 1 , wherein the files are not homogenous with respect to business object content.
7. The method of claim 1 , wherein the update message comprises a single notification for all updates associated with a same customer account.
8. A computing apparatus comprising:
a processor; and
a memory storing instructions that, when executed by the processor, configure the apparatus to:
request update information for multiple files on a legacy database for a specified time range, wherein the legacy database is operating in parallel with a modern database in parallel;
receive item keys for items that were updated within the multiple files during the specified time range;
filter each of the item keys based at least on their associated business item and generate an update message by combining item keys from across the multiple files that correspond with a same business object and ignoring item keys associated with the same business object;
send the update message to the modern database; and
based on the update message, perform data validation at the modern database to determine the updated item keys for the multiple files on the legacy database are captured on the modern database operating in parallel.
9. The computing apparatus of claim 8 , wherein the legacy database is a Pick environment and the modern database is a modern microservice architecture.
10. The computing apparatus of claim 8 , wherein additional update messages are generated for additional business objects, and wherein each update message comprises all of the item keys associated with a corresponding business object during the specified time range.
11. The computing apparatus of claim 8 , wherein the item keys comprise an item identifier and a timestamp of a last update.
12. The computing apparatus of claim 8 , wherein the business objects comprise customer business objects, employee business objects, vendor business objects, and financial institution business objects.
13. The computing apparatus of claim 8 , wherein the files are not homogenous with respect to business object content.
14. The computing apparatus of claim 8 , wherein the update message comprises a single notification for all updates associated with a same customer account.
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:
request update information for multiple files on a legacy database for a specified time range, wherein the legacy database is operating in parallel with a modern database in parallel;
receive item keys for items that were updated within the multiple files during the specified time range;
filter each of the item keys based at least on their associated business item and generate an update message by combining item keys from across the multiple files that correspond with a same business object and ignoring item keys associated with the same business object;
send the update message to the modern database; and
based on receipt of the update message, perform data validation at the modern database comprising determining updated item keys for the multiple files on the legacy database are captured on the modern database operating in parallel.
16. The computer-readable storage medium of claim 15 , wherein the legacy database is a Pick environment and the modern database is a modern microservice architecture.
17. The computer-readable storage medium of claim 15 , wherein additional update messages are generated for additional business objects, and wherein each update message comprises all of the item keys associated with a corresponding business object during the specified time range.
18. The computer-readable storage medium of claim 15 , wherein the item keys comprise an item identifier and a timestamp of a last update.
19. The computer-readable storage medium of claim 15 , wherein the files are not homogenous with respect to business object content.
20. The computer-readable storage medium of claim 15 , wherein the update message comprises a single notification for all updates associated with a same customer account.