On-Demand Service Reconciliation, Audit, and Alert Apparatus and Method
0 Assignments
0 Petitions
Accused Products
Abstract
An audit tool (AT) operates in cooperation with an audit tool manager (ATM), a policy file (PF) and a query file (QF) in order to provide a real time display of usage within an on-demand service system. The ATM identifies the data to be gathered. Using the ATM, the user identifies comparison points, maps the comparison points to audit controls, defines policies and develops SQL queries to report transactions and record quantities. The AT gathers data, displays the gathered data, and compares the data points, and alerts the user to a discrepancy. The AT displays the compared data points side by side so that real time visual verification can be made, and the AT also alerts the user to discrepancies.
12 Citations
19 Claims
-
1-17. -17. (canceled)
-
18. An apparatus for validating data integrity of an on-demand service system that bills for resources actually used, comprising:
-
a computer connected to a system by a network; a program in a storage connected to the computer; a query file in the storage; a policy file in the storage; wherein the program causes a processor of the computer to perform actions comprising; identifying at least two separate points in the on-demand service system where a data item is accessible; identifying an originating point in the on-demand service system of the data item; identifying a last point in the on-demand service system where the data item appears; using a SQL query, gathering a plurality of values from each separate point in the on-demand service system where the data item is accessible; displaying the plurality of values side by side on a graphical user interface so that a real time visual verification is enabled; determining if the plurality of values complies with an audit policy; and when a discrepancy exists with the compliance of the plurality of values with the audit policy, displaying an alert; wherein the discrepancy is that one or more of the plurality of values are not equal; wherein the separate points of the on-demand service system where the data item is accessible comprise; at least one server log file and at least one database; and wherein a data integrity of the on-demand service system is validated.
-
-
19. A computer program product for validating data integrity of an on-demand service system that bills for resources actually used, comprising:
-
a computer readable medium; a program stored in the computer readable medium, the program containing instructions to cause a processor of a computer to perform actions comprising; identifying at least two separate points in the on-demand service system where a data item is accessible; identifying an originating point in the on-demand service system of the data item; identifying a last point in the on-demand service system where the data item appears; using a SQL query, gathering a plurality of values from each separate point in the on-demand service system where the data item is accessible; displaying the plurality of values side by side on a graphical user interface so that a real time visual verification is enabled; determining if the plurality of values complies with an audit policy; and when a discrepancy exists with the compliance of the plurality of values with the audit policy, displaying an alert; wherein the discrepancy is that one or more of the plurality of values are not equal; wherein the separate points of the on-demand service system where the data item is accessible comprise; at least one server log file and at least one database; and wherein a data integrity of the on-demand service system is validated.
-
Specification