Patent ID: 7885934
Filing Date: 2011-02-08
Classification: G06F

Abstract:
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.