Multitenant architecture for prior period adjustment processing

1. A data processing method comprising:

using an application server computer of an application service provider (ASP), establishing computerized shared multi-tenant data storage in which tenant data that is associated with a plurality of different tenants of the ASP is stored together in a production database, wherein the application server computer maintains a replay log that tracks changes for each tenant, the replay log comprising stored digital data representing a plurality of events, each event defining an adjustment;

receiving, by the application server computer, a first request to perform a prior period adjustment (PPA) for a first tenant in which data values applicable to a time period earlier than a current time period will be modified;

in response to the first request, identifying a working subset of data from first tenant data in the production database and copying the working subset of data to a calculation database that is separate from the production database, wherein the working subset comprises a minimum amount of data needed to perform accurate PPA according to a policy associated with the first tenant;

performing the PPA, using the working subset in the calculation database, to result in creating and storing a plurality of result data;

while performing the PPA:

receiving a second request using the first tenant data in the production database,

performing the second request using the first tenant data in the production database, and

updating the replay log based on the second request by recording the plurality of events during a calculation process and tracking changes for each tenant;

after completing the PPA performing a synchronizing step by transferring the plurality of results to the production database and using the replay log to replay the plurality of events performed from the second request and action adjustment;

sending a notification to one or more entities impacted by the plurality of changes that were made to the first tenant data during transferring, wherein the notification identifies differences represented in the plurality of changes.

2. The method of claim 1 , wherein an event of the plurality of events comprises a data deletion event.

3. The method of claim 1 , further comprising: performing the second request by modifying the first tenant data.

4. The method of claim 1 , wherein the working subset of data is read-only and cannot be written back to the production database.

5. The method of claim 1 , further comprising:

in response to a failure while performing the PPA, identifying a portion of the working subset related to the failure;

deleting the portion of the working subset related to the failure;

copying the portion of the working subset related to the failure from the production database to the calculation database.

6. The method of claim 1 , wherein the production database comprises two or more databases in different formats.

7. A computer system comprising:

a production database storing tenant data that is associated with a plurality of different tenants of an application service provider;

a calculation database that is separate from the production database;

one or more application server computers communicatively connected to the production database and the calculation database, the one or more application server computers comprising one or more processors and electronic digital memory storing one or more sequences of instructions which, when executed by the one or more processors, cause the one or more processors to perform:

establishing computerized shared multi-tenant data storage in the production database, wherein the application server computer maintains a replay log that tracks changes for each tenant, the replay log comprises stored digital data representing a plurality of events, each event defining an adjustment;

receiving a first request to perform a prior period adjustment (PPA) for a first tenant in which data values applicable to a time period earlier than a current time period will be modified;

in response to the first request, identifying a working subset of data from first tenant data in the production database and copying the working subset of data to the calculation database, wherein the working subset comprises a minimum amount of data needed to perform accurate PPA according to a policy associated with the first tenant;

performing the PPA, using the working subset in the calculation database, to result in creating and storing a plurality of result data;

while performing the PPA:

receiving a second request using the first tenant data in the production database,

performing the second request using the first tenant data in the production database, and

updating the replay log based on the second request by recording the plurality of events during a calculation process and tracking changes for each tenant;

after completing the PPA, performing a synchronizing step by transferring the plurality of results to the production database and using the replay log to replay the plurality of events performed from the second request and action adjustment;

sending a notification to one or more entities impacted by the plurality of changes that were made to the first tenant data during transferring, wherein the notification identifies differences represented in the plurality of changes.

8. The computer system of claim 7 , wherein an event of the plurality of events comprises a data deletion event.

9. The computer system of claim 7 , the one or more sequences of instructions, when executed by the one or more processors, further causing the one or more processors to perform:

performing the second request by modifying the first tenant data.

10. The computer system of claim 7 , wherein the working subset of data is read-only and cannot be written back to the production database.

11. The computer system of claim 7 , the one or more sequences of instructions, when executed by the one or more processors, further causing the one or more processors to perform:

in response to a failure while performing the PPA, identifying a portion of the working subset related to the failure;

deleting the portion of the working subset related to the failure;

copying the portion of the working subset related to the failure from the production database to the calculation database.

12. The computer system of claim 7 , wherein the production database comprises two or more databases in different formats.