Model for capturing audit trail data with reduced probability of loss of critical data

• US 9,659,041 B2
• Filed: 01/30/2012
• Issued: 05/23/2017
• Est. Priority Date: 01/30/2012
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Rao, Hari Charan Ramachandra, Pasupuleti, Viswanath, Sambamurthy, Govinda Raj
• Primary Examiner(s): Herndon, Heather
• Assistant Examiner(s): Davanlou, Soheila (Gina)
• Application Number:
  US13/360,822
• Publication Number:
  US 20130198138A1
• Time in Patent Office: 1,940 Days
• Field of Search: 707648, 707E17046, 707703
• CPC Class Codes: G06F 11/3476 Data logging G06F11/14, G06F11/2205 take precedence
• CPC Class Codes: G06F 16/219 Managing data history or versioning querying versioned data G06F16/2474; querying temporal data G06F16/2477

Abstract

An aspect of the present invention provides for capturing of audit trail data related to processing of requests. In an embodiment, the received requests are classified into a first category and a second category. For each request in the first category, the corresponding audit trail data is stored directly into non-volatile storage upon processing of the request. On the other hand, for each request in the second category, the audit trail data is first stored into a volatile memory upon processing of the request, and then later copied from the volatile memory to non-volatile storage. Thus, the audit trail data corresponding to both categories of requests is eventually available stored on non-volatile storage.

Claims

1. A method of capturing audit trail data related to processing of requests, said method being performed in a server system providing access to a plurality of electronic objects, said method comprising:

receiving a plurality of requests, with processing of each request requiring access to a corresponding set of electronic objects of said plurality of electronic objects provided access to by said server system;

classifying each of said plurality of requests into one of a first category and a second category, wherein a first set of requests of said plurality of requests are classified into said first category in view of each of said first set of requests being a write request modifying one or more of said corresponding set of electronic objects, and wherein a second set of requests of said plurality of requests are classified into said second category in view of each of said second set of requests being a read request for one or more of said corresponding set of electronic objects;

processing each of said plurality of requests by performing corresponding tasks by accessing the corresponding set of electronic objects of said plurality of electronic objects,

wherein audit trail data is formed in relation to performance of the corresponding tasks, wherein said audit trail data for each request comprises details of accessing the corresponding set of electronic objects during said processing of the request;

for each write request of said first set of requests classified in said first category, storing the audit trail data corresponding to the write request directly into a first database system upon said processing of the write request, and later transferring the audit trail data corresponding to the write request to a second database system from said first database system,

wherein said first database system is according to a first schema and said second database system is according to a second schema, wherein each of said first database system and said second database system is designed to facilitate storing of said audit trail data using SQL (structured query language) queries,

wherein said second schema specifies primary and foreign key constraints, which are not specified in said first schema,

wherein said storing first stores the audit trail data corresponding to each write request of said first set of requests in said first database system without enforcing said constraints due to said first schema not specifying said constraints,

wherein said transferring to said second database system causes said constraints to be enforced in said second database system; and

for each read request of said second set of requests classified in said second category, storing the audit trail data corresponding to the read request first into a volatile memory upon said processing of the read request and then copying the audit trail data corresponding to the read request from said volatile memory to said second database system.

2. The method of claim 1, wherein said copying copies the audit trail data for each read request of said second set of requests from said volatile memory to said second database system upon lapse of a pre-specified duration since previous copying or when the data stored in said volatile memory exceeds a pre-specified threshold, and

wherein said copying copies the audit trail data for each write request of said first set of requests from said first database system to said second database system only upon lapse of a corresponding pre-specified duration since previous copying.

3. The method of claim 2, further comprising generating reports, covering both of said first set of requests and said second set of requests, based on the audit trail data stored in said second database system.

4. The method of claim 1, wherein said classifying comprises:

determining whether each of said plurality of requests can be classified into said first category; and

including the request in said first set of requests if said determining determines that the request can be classified into said first category, and in said second set of requests otherwise.

9. The method of claim 1, wherein audit trail data for multiple read requests of said second set of requests is stored in said volatile memory before said copying is performed in a batch mode to said second database system,

wherein said volatile memory is reused for storing audit trail data for later received ones of said second set of requests.

5. A non-transitory computer readable medium carrying one or more sequences of instructions for causing a server system to capture audit trail data related to processing of requests, said server system providing access to a plurality of electronic objects, wherein execution of said one or more instructions by one or more processors contained in said server system causes said server system to perform the actions of:

receiving a plurality of requests, with processing of each request requiring access to a corresponding set of electronic objects of said plurality of electronic objects provided access to by said server system;

classifying each of said plurality of requests into one of a first category and a second category, wherein a first set of requests of said plurality of requests are classified into said first category in view of each of said first set of requests being a write request modifying one or more of said corresponding set of electronic objects, and wherein a second set of requests of said plurality of requests are classified into said second category in view of each of said second set of requests being a read request for one or more of on said corresponding set of electronic objects;

processing each of said plurality of requests by performing corresponding tasks by accessing the corresponding set of electronic objects of said plurality of electronic objects,

wherein audit trail data is formed in relation to performance of the corresponding tasks, wherein said audit trail data for each request comprises details of accessing the corresponding set of electronic objects during said processing of the request;

for each write request of said first set of requests classified in said first category, storing the audit trail data corresponding to the write request directly into a first database system upon said processing of the request, and later transferring the audit trail data corresponding to the request to a second database system from said first database system,

wherein said first database system is according to a first schema and said second database system is according to a second schema, wherein each of said first database system and said second database system is designed to facilitate storing of said audit trail data using SQL (structured query language) queries,

wherein said second schema specifies primary and foreign key constraints, which are not specified in said first schema,

wherein said storing first stores the audit trail data corresponding to each write request of said first set of requests in said first database system without enforcing said constraints due to said first schema not specifying said constraints,

wherein said transferring to said second database system causes said constraints to be enforced in said second database system; and

for each read request of said second set of requests classified in said second category, storing the audit trail data corresponding to the read request first into a volatile memory upon said processing of the read request and then copying the audit trail data corresponding to the read request from said volatile memory to said second database system.

6. The non-transitory computer readable medium of claim 5, wherein said copying copies the audit trail data for each read request of said second set of requests from said volatile memory to said second database system upon lapse of a pre-specified duration since previous copying or when the data stored in said volatile memory exceeds a pre-specified threshold, and

wherein said copying copies the audit trail data for each write request of said first set of requests from said first database system to said second database system only upon lapse of a corresponding pre-specified duration since previous copying.

10. The non-transitory computer readable medium of claim 5, wherein audit trail data for multiple read requests of said second set of requests is stored in said volatile memory before said copying is performed in a batch mode to said second database system,

wherein said volatile memory is reused for storing audit trail data for later received ones of said second set of requests.

12. The non-transitory computer readable medium of claim 5, wherein said copying copies the audit trail data for each read request of said second set of requests from said volatile memory to said second database system upon lapse of a pre-specified duration since previous copying or when the data stored in said volatile memory exceeds a pre-specified threshold, and

wherein said audit trail data for each write request of said first set of requests is copied from said first database system to said second database system only upon lapse of a corresponding pre-specified duration since previous copying.

7. A server system comprising:

a memory to store instructions;

a processor to retrieve said instructions and execute the retrieved instructions, wherein execution of said instructions causes said server system to perform the actions of;

receiving a plurality of requests, with processing of each request requiring access to a corresponding set of electronic objects of a plurality of electronic objects provided access to by said server system;

classifying each of said plurality of requests into one of a first category and a second category, wherein a first set of requests of said plurality of requests are classified into said first category in view of each of said first set of requests being a write request modifying one or more of said corresponding set of electronic objects, and wherein a second set of requests of said plurality of requests are classified into said second category in view of each of said second set of requests being a read request for one or more of said corresponding set of electronic objects;

processing each of said plurality of requests by performing corresponding tasks by accessing the corresponding set of electronic objects of said plurality of electronic objects,

wherein audit trail data is formed in relation to performance of the corresponding tasks, wherein said audit trail data for each request comprises details of accessing the corresponding set of electronic objects during said processing of the request;

for each write request of said first set of requests classified in said first category, storing the audit trail data corresponding to the write request directly into a first database system upon said processing of the write request, and later transferring the audit trail data corresponding to the write request to a second database system from said first database system,

wherein said first database system is according to a first schema and said second database system is according to a second schema, wherein each of said first database system and said second database system is designed to facilitate storing of said audit trail data using SQL (structured query language) queries,

wherein said second schema specifies primary and foreign key constraints, which are not specified in said first schema,

wherein said storing first stores the audit trail data corresponding to each write request of said first set of requests in said first database system without enforcing said constraints due to said first schema not specifying said constraints,

wherein said transferring to said second database system causes said constraints to be enforced in said second database system; and

for each read request of said second set of requests classified in said second category, storing the audit trail data corresponding to the read request first into a volatile memory upon said processing of the read request and then copying the audit trail data corresponding to the read request from said volatile memory to said second database system.

8. The server system of claim 7, wherein said server system copies the audit data for each read request of said second set of requests from said volatile memory to said second database system upon lapse of a pre-specified duration since previous copying or when the data stored in said volatile memory exceeds a pre-specified threshold, and

wherein said server system copies the audit trail data for each write request of said first set of requests from said first database system to said second database system only upon lapse of a corresponding pre-specified duration since previous copying.

11. The server system of claim 7, wherein audit trail data for multiple read requests of said second set of requests is stored in said volatile memory before said copying is performed in a batch mode to said second database system,

wherein said volatile memory is reused for storing audit trail data for later received ones of said second set of requests.