IP Library Granted Patent US 10,872,092
Granted Patent B2
US 10,872,092 · App. 15/980,989 · Granted Dec 22, 2020

Using flat data input set for simultaneous application of multiple separate calculations rule sets to obtain multiple output results

Inventors: Kai Bi (Houston, TX); Michael Bargar (Houston, TX)
Assignee: UTEGRATION LLC
G06F16/252G06F16/284
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 10,872,092
App. No.
15/980,989
Granted
Dec 22, 2020
Kind
B2
Abstract

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.

Claims (61)

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;

before posting the information to the database as a line item comprising a plurality of fields:

adding the first data field to the plurality of fields;

making a determination to split 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;

splitting, based on the determination, the line item to create the first sub-line item and the second sub-line item, the first sub-line item comprising the first data field; and

adding a second data field to the second sub-line item,

wherein:

an aggregate total transaction amount represented by the first sub-line item and the second sub-line item match a total transaction amount of the line item, and

both the first sub-line item and the second sub-line item are used in generating the financial transactional report;

posting, using the updated database posting logic, the information to the database as the line item comprising the plurality of fields;

receiving a request to generate the financial transactional report;

identifying the line item by 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. 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, and adding a second data field to the plurality of fields, the second data field added to relate the line item to an asset;

receiving a request to generate a transaction flow trace;

identifying the line item by the second data field identifying the asset, the asset being associated with a project, the project being associated with at least one object selected from a group consisting of a work order and invoice, the object being associated with a cost; and

generating the transaction flow trace using the line item.

4. The method of claim 1 , wherein the database is an in-memory database.

5. The method of claim 1 , wherein the database is managed by a column-oriented database management system.

6. 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;

before posting the information to the database as a line item comprising a plurality of fields:

adding the first data field to the plurality of fields;

making a determination to split 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;

splitting, based on the determination, the line item to create the first sub-line item and the second sub-line item, the first sub-line item comprising the first data field; and

adding a second data field to the second sub-line item,

wherein:

an aggregate total transaction amount represented by the first sub-line item and the second sub-line item match a total transaction amount of the line item, and

both the first sub-line item and the second sub-line item are used in generating the financial transactional report;

posting, using the updated database posting logic, the information to the database as the line item comprising the plurality of fields;

receiving a request to generate the financial transactional report;

identifying the line item by 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.

7. The non-transitory computer readable medium of claim 6 , 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.

8. The non-transitory computer readable medium of claim 6 , 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:

receiving a request to generate a transaction flow trace;

identifying the line item by the second data field identifying the asset, the asset being associated with a project, the project being associated with at least one object selected from a group consisting of a work order and invoice, the object being associated with a cost; and

generating the transaction flow trace using the line item.

9. The non-transitory computer readable medium of claim 6 , wherein the database is an in-memory database.

10. The non-transitory computer readable medium of claim 6 , wherein the database is managed by a column-oriented database management system.

11. 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.

12. The non-transitory computer readable medium of claim 6 , wherein the financial transactional report is one selected from a group consisting of a regulatory accounting report and a financial accounting report.

13. The method of claim 3 , further comprising

before posting the information to the database as the line item comprising the plurality of fields:

adding the first data field to the plurality of fields;

making a determination to split 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;

splitting, based on the determination, the line item to create the first sub-line item and the second sub-line item, the first sub-line item comprising the first data field; and

adding a second data field to the second sub-line item,

wherein:

an aggregate total transaction amount represented by the first sub-line item and the second sub-line item match a total transaction amount of the line item, and

both the first sub-line item and the second sub-line item are used in generating the financial transactional report.

14. The method of claim 3 , 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 method of claim 3 , wherein the database is an in-memory database.

16. The method of claim 3 , wherein the database is managed by a column-oriented database management system.

Assignments (3)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Oct 13, 2023
From: UTEGRATION, LLC
To: COGNIZANT TECHNOLOGY SOLUTIONS U.S. CORPORATION
Reel/Frame 065207/0339 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 13, 2018
From: BI, KAI; BARGAR, MICHAEL
To: UTEGRATION LLC
Reel/Frame 046076/0652 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 4, 2018
From: BAI, KAI; BARGAR, MICHAEL
To: UTEGRATION LLC
Reel/Frame 045972/0154 →