Joining Of Logistical And Financial Data Related to Procurement Spending
First Claim
1. A method implemented on a computer comprising one or more data processors and one or more computer-readable media, comprising:
- replicating, by one or more data processors, financial data from a first source to an analytics database implemented on one or more computer-readable media;
replicating, by one or more data processors, procurement data from a second source to the analytics database;
filtering, by one or more data processors, the financial data for one or more nonprocurement-related items and procurement-related items to obtained procurement-related financial data;
joining, by one or more data processors, the obtained procurement financial data with the procurement data in the analytics database based on related information between the financial data and the procurement data, the joining comprising creating a new database table based on a first table containing the obtained procurement-related financial data and a second table containing the procurement data; and
generating, by one or more data processors, one or more reports based on the one or more nonprocurement-related items and the joined financial and procurement data in the analytics database.
2 Assignments
0 Petitions
Accused Products
Abstract
A system, method, and computer program product for joining logistical and financial data related to procurement spending in a database. Financial data can be replicated from a first source to an analytics database. Procurement data from a second source can be replicated to the analytics database. The financial data can be filtered for procurement-related items to obtain procurement-related financial data. The obtained procurement financial data can be joined with the procurement data in the analytics database based on related information between the financial data and the procurement data. One or more reports based on the joined financial and procurement data can be generated in the analytics database. Related apparatus, systems, techniques and articles are also described.
11 Citations
19 Claims
-
1. A method implemented on a computer comprising one or more data processors and one or more computer-readable media, comprising:
-
replicating, by one or more data processors, financial data from a first source to an analytics database implemented on one or more computer-readable media; replicating, by one or more data processors, procurement data from a second source to the analytics database; filtering, by one or more data processors, the financial data for one or more nonprocurement-related items and procurement-related items to obtained procurement-related financial data; joining, by one or more data processors, the obtained procurement financial data with the procurement data in the analytics database based on related information between the financial data and the procurement data, the joining comprising creating a new database table based on a first table containing the obtained procurement-related financial data and a second table containing the procurement data; and generating, by one or more data processors, one or more reports based on the one or more nonprocurement-related items and the joined financial and procurement data in the analytics database. - View Dependent Claims (2, 3, 5)
-
-
4. (canceled)
-
6. (canceled)
-
7. A non-transitory machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
-
replicating financial data from a first source to an analytics database; replicating procurement data from a second source to the analytics database; filtering the financial data for one or more nonprocurement-related items and procurement-related items to obtained procurement-related financial data; joining the obtained procurement financial data with the procurement data in the analytics database based on related information between the financial data and the procurement data; and generating one or more reports based on the one or more nonprocurement-related items and the joined financial and procurement data in the analytics database. - View Dependent Claims (8, 9, 11, 12)
-
-
10. (canceled)
-
13. A system comprising:
-
at least one programmable processor; and a machine-readable medium storing instructions that, when executed by the at least one programmable processor, cause the at least one programmable processor to perform operations comprising; replicating financial data from a first source to an analytics database; replicating procurement data from a second source to the analytics database; filtering the financial data for one or more nonprocurement-related items and procurement-related items to obtained procurement-related financial data; joining the obtained procurement financial data with the procurement data in the analytics database based on related information between the financial data and the procurement data; and generating one or more reports based on the one or more nonprocurement-related items and the joined financial and procurement data in the analytics database. - View Dependent Claims (14, 15, 17, 18, 19)
-
-
16. (canceled)
Specification