Using flat data input for simultaneous application of multiple separate calculations rule sets to obtain multiple output results
A method may include updating database posting logic to obtain an updated database posting logic that, during a posting process to a database, adds a data field to a new line item being posted via the posting process. The method may further include receiving information from a data provider. The method may further include posting, using the updated database posting logic, the information to the database as a line item including various fields including the data field. The method may further include receiving a request to generate a transactional report. The method may further include using the data field to identify the line item. The method may further include generating the transactional report using the line item.
1. A method, comprising:
updating database posting logic to obtain an updated database posting logic configured to, during a posting process to a database, add a first data field to a new line item being posted via the posting process, the first data field identifying a relationship of the new line item to a regulatory accounting type of a financial transactional report;
receiving information from a data provider;
posting, using the updated database posting logic, the information to the database as a line item comprising a plurality of fields, wherein the posting comprises adding the first data field to the plurality of fields;
receiving a request to generate the financial transactional report;
identifying the regulatory accounting type of the financial transactional report;
identifying the line item based on the first data field identifying the relationship of the line item to the regulatory accounting type of the financial transactional report; and
generating the financial transactional report using the line item.
2. The method of claim 1 , wherein the database is a relational database that provides a real time update to the financial transactional report using the updated database posting logic and the information from the data provider.
3. The method of claim 1 , further comprising, before posting the line item:
splitting the line item into a first sub-line item and a second sub-line item based on a granularity required for the regulatory accounting type of the financial transactional report.
4. The method of claim 1 , wherein the posting further comprises adding a second data field to the plurality of fields, the second data field added to relate the line item to an asset, and wherein the method further comprises:
generating a transaction flow trace using the line item and the second data field.
5. The method of claim 1 , wherein the database is an in-memory database.
6. The method of claim 1 , wherein the database is managed by a column-oriented database management system.
7. A non-transitory computer readable medium comprising instructions that, when executed by a computer processor, perform a method comprising:
updating database posting logic to obtain an updated database posting logic configured to, during a posting process to a database, add a first data field to a new line item being posted via the posting process, the first data field identifying a relationship of the new line item to a regulatory accounting type of a financial transactional report;
receiving information from a data provider;
posting, using the updated database posting logic, the information to the database as a line item comprising a plurality of fields, wherein the posting comprises adding the first data field to the plurality of fields;
receiving a request to generate the financial transactional report;
identifying the regulatory accounting type of the financial transactional report;
identifying the line item based on the first data field identifying the relationship of the line item to the regulatory accounting type of the financial transactional report; and
generating the financial transactional report using the line item.
8. The non-transitory computer readable medium of claim 7 , wherein the database is a relational database configured to provide a real time update to the financial transactional report using the updated database posting logic and the information from the data provider.
9. The non-transitory computer readable medium of claim 7 , the method further comprising, before posting the line item:
splitting the line item into a first sub-line item and a second sub-line item based on a granularity required for the regulatory accounting type of the financial transactional report.
10. The non-transitory computer readable medium of claim 7 , wherein the posting further comprises adding a second data field to the plurality of fields, the second data field added to relate the line item to an asset, wherein the method further comprises:
generating a transaction flow trace using the line item and the second data field.
11. The non-transitory computer readable medium of claim 7 , wherein the database is an in-memory database.
12. The non-transitory computer readable medium of claim 7 , wherein the database is managed by a column-oriented database management system.
13. A system, comprising:
a report generator operatively connected to a data provider and a report data repository and comprising:
a data posting logic engine; and
a database operatively connected to the data posting logic engine, and a calculation engine operatively connected to the database,
wherein the report generator is configured to:
update the database posting logic engine to obtain an updated database posting logic engine configured to, during a posting process to a database, include a first data field to a new line item being posted via the posting process, the first data field identifying a relationship of the new line item to a regulatory accounting type of a financial transactional report;
receive information from a data provider;
post, using the updated database posting logic engine, the information to the database as a line item comprising a plurality of fields comprising the first data field, wherein posting comprises adding the first data field to the plurality of fields;
receive a request to generate the financial transactional report;
identify the regulatory accounting type of the financial transactional report;
identifying the line item based on the first data field identifying the relationship of the line item to the regulatory accounting type of the financial transactional report;
generate the financial transactional report using the line item using the calculation engine.
14. The system of claim 13 , wherein the database is a relational database that provides a real time update to the financial transactional report using the updated database posting logic and the information from the data provider.
15. The system of claim 13 , wherein the report generator is further configured to, before posting the line item:
splitting the line item into a first sub-line item and a second sub-line item based on a granularity required for the regulatory accounting type of the financial transactional report.
16. The system of claim 13 , wherein the financial transactional report is a transaction flow trace.
17. The system of claim 13 , wherein the database is an in-memory database.
18. The method of claim 1 , wherein the financial transactional report is one selected from a group consisting of a regulatory accounting report and a financial accounting report.
19. The non-transitory computer readable medium of claim 7 , wherein the financial transactional report is one selected from a group consisting of a regulatory accounting report and a financial accounting report.
20. The system of claim 13 , wherein the financial transactional report is one selected from a group consisting of a regulatory accounting report and a financial accounting report.