Monitoring and auditing system
First Claim
Patent Images
1. A method comprising:
- utilizing a first server to accept transactions, database queries, and/or requests for reports transmitted from plural users to said first server, extracting first audit information from said transactions, said database queries, and/or said requests for reports, and logging said first audit information in a first log;
modeling one or more transactions, queries and/or reports to be requested in advance of one or more said transactions, said database queries, and/or said reports being requested;
transmitting said transactions, said database queries, and/or said requests for reports from said first server to a database system after logging said first audit information and after adding comment information to said transactions, said database queries, and/or said requests for reports, said comment information not being present in said transactions, said database queries and/or said requests for reports when said transactions, said database queries and/or said requests for reports are transmitted from plural users to said first server;
determining one or more communications taking place via a communications channel between said first server and said database system, ascertaining second audit information from said comment information and from information ascertained and/or compiled by said modeling, and capturing said second audit information into a second log from said communications channel between said first server and said database system, said second audit information including at least some of said added comment information; and
constructing an audit record for at least one of said transactions, said database queries, and/or said requests for reports via a Business Intelligence (“
BI”
) tool by correlating and combining said first audit information and said second audit information, said BI tool operates to monitor said first and second audit information, said step of combining comprises utilizing one or more identifiers added to at least one of;
said transactions, said database queries, said requests for reports, said first audit information, said comment information, said information ascertained and/or compiled by said modeling, and said second audit information, wherein;
said constructing step further comprises recording a user identification, a report name, and a universe/catalogue name associated with each of said transactions, said database queries, and/or said requests for reports, at least one of said user identification, said report name, and said universe/catalogue name being compiled from said comment information added to said transactions, said database queries, and/or said requests for reports after said transactions, said database queries, and/or said requests for reports are generated by one or more said plural users, and at least one of said user identification, said report name, and said universe/catalogue name being compiled from information not added to said transactions, said database queries, and/or said requests for reports after said transactions, said database queries, and/or said requests for reports are generated by one or more said plural users.
2 Assignments
0 Petitions
Accused Products
Abstract
An improved method and apparatus for auditing database queries, wherein comments are added by a server prior to the server forwarding the queries to the database system. The comments are then used to derive audit information, which is correlated with other audit information in a different server, to produce a more complete audit record.
-
Citations
16 Claims
-
1. A method comprising:
-
utilizing a first server to accept transactions, database queries, and/or requests for reports transmitted from plural users to said first server, extracting first audit information from said transactions, said database queries, and/or said requests for reports, and logging said first audit information in a first log; modeling one or more transactions, queries and/or reports to be requested in advance of one or more said transactions, said database queries, and/or said reports being requested; transmitting said transactions, said database queries, and/or said requests for reports from said first server to a database system after logging said first audit information and after adding comment information to said transactions, said database queries, and/or said requests for reports, said comment information not being present in said transactions, said database queries and/or said requests for reports when said transactions, said database queries and/or said requests for reports are transmitted from plural users to said first server; determining one or more communications taking place via a communications channel between said first server and said database system, ascertaining second audit information from said comment information and from information ascertained and/or compiled by said modeling, and capturing said second audit information into a second log from said communications channel between said first server and said database system, said second audit information including at least some of said added comment information; and constructing an audit record for at least one of said transactions, said database queries, and/or said requests for reports via a Business Intelligence (“
BI”
) tool by correlating and combining said first audit information and said second audit information, said BI tool operates to monitor said first and second audit information, said step of combining comprises utilizing one or more identifiers added to at least one of;
said transactions, said database queries, said requests for reports, said first audit information, said comment information, said information ascertained and/or compiled by said modeling, and said second audit information, wherein;said constructing step further comprises recording a user identification, a report name, and a universe/catalogue name associated with each of said transactions, said database queries, and/or said requests for reports, at least one of said user identification, said report name, and said universe/catalogue name being compiled from said comment information added to said transactions, said database queries, and/or said requests for reports after said transactions, said database queries, and/or said requests for reports are generated by one or more said plural users, and at least one of said user identification, said report name, and said universe/catalogue name being compiled from information not added to said transactions, said database queries, and/or said requests for reports after said transactions, said database queries, and/or said requests for reports are generated by one or more said plural users. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. An apparatus for logging information related to transactions, database queries, and/or requests for reports, said apparatus comprising:
-
a first server that accepts transactions, database queries, and/or requests for reports from plural users, extracts first audit information from said transactions, said database queries, and/or said requests for reports, generates a first audit log from said transactions, said database queries, and/or said requests for reports, and transmits said transactions, said database queries, and/or said requests for reports from said first server to a database system after logging said first audit information and after adding comment information to said transactions, said database queries, and/or said requests for reports, said comment information not being present in said transactions, said database queries and/or said requests for reports when said transactions, said database queries and/or said requests for reports are transmitted from plural users to said first server; a monitor that operates to determine the occurrence of and monitor one or more communications taking place via a communications channel between said first server and said database system, said monitor in communication with a second log for recording information embedded-in messages transmitted from said first server to said database system via said communications channel in said second log, said embedded information not being present in said database queries when said database queries are originally sent by said plural users but being added thereafter, said embedded information including at least some of said added comment information; and software for;
(i) modeling one or more transactions, database queries and/or reports to be requested in advance of one or more said transactions, said database queries, and/or said reports being requested; and
(ii) combining said embedded information with information in said first audit log and/or said ascertained information from said modeling to construct a final audit record for at least one of said transactions, said database queries, and/or said requests for reports via a Business Intelligence (“
BI”
) tool by correlating and combining said first audit information and said embedded information, said BI tool operates to monitor said first audit information and said embedded information, wherein said step of combining comprises utilizing one or more identifiers added to at least one of;
said transactions, said database queries, said requests for reports, said first audit information, said comment information, said information ascertained and/or compiled by said modeling, and said embedded information, wherein;said construction further comprises recording a user identification, a report name, and a universe/catalogue name associated with each of said transactions, said database queries, and/or said requests for reports, at least one of said user identification, said report name, and said universe/catalogue name being compiled from said comment information added to said transactions, said database queries, and/or said requests for reports after said transactions, said database queries, and/or said requests for reports are generated by one or more said plural users, and at least one of said user identification, said report name, and said universe/catalogue name being compiled from information not added to said transactions, said database queries, and/or said requests for reports after said transactions, said database queries, and/or said requests for reports are generated by one or more said plural users. - View Dependent Claims (15, 16)
-
Specification