I want to update or insert 100,0000 records into a database in a single batch process using some effective design pattern.
Example: I have 1 million records in my table date range from 1/1/2020 to 1/1/2024 and if user updates any transaction in the middle, e.g. 1/1/2022, then based on that particular date I need to update the remaining records that come after 1/1/2022.
I am using Java and Hibernate.
Need to understand more about how design patterns work with bulk data and which design pattern I should learn for the above scenario?