Patent ID: 8799225

Claim:
A process of collecting database audit trail information associated with a database that maintains a database transaction log of first database activities performed on the database, said process comprising: maintaining trace data, by a processor, regarding second database activities performed on the database, the trace data identifying session activities performed after session establishment and identifying before and after values, the second database activities resulting from commands sent to the database, the trace data identifying database activities not identifiable through the database transaction log maintained by the database; collecting log information about the first database activities from the database transaction log to generate collected transaction log information, the collected transaction log information identifying information regarding a particular first database activity and including a first system process identifier associated with the particular first database activity; collecting trace information about the second database activities from the trace data to generate collected trace information, the collected trace information identifying a particular session activity and including a second system process identifier associated with the particular session activity; using the first system process identifier and the second system process identifier to correlate the collected transaction log information with the collected trace information to generate correlated information; and constructing the database audit trail information based on the correlated information.