Invention Grant
- Patent Title: Utilizing a structured audit log for improving accuracy and efficiency of database auditing
-
Application No.: US17708440Application Date: 2022-03-30
-
Publication No.: US12248456B2Publication Date: 2025-03-11
- Inventor: Jia Tian Zhong , Peng Hui Jiang , Dong Hui Liu , Xing Xing Shen , Jia Yu , Yong Yin , Jing Lu , Xiao Yan Tang
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Shackelford, McKinley & Norton, LLP
- Agent Robert A. Voigt, Jr.
- Main IPC: G06F16/23
- IPC: G06F16/23

Abstract:
A computer-implemented method, system and computer program product for improving accuracy and efficiency of auditing databases. A table, list or index of a database is analyzed to identify metadata, which includes time series data, user data, an Internet Protocol address and operation data. The identified metadata is associated with the corresponding record or row of the table, list or index from which the metadata was extracted. A determination is then made as to whether to record a raw data image associated with the record or row of the analyzed table, list or index based on the corresponding data operation. The identified metadata as well as the recorded data images, if any, are stored in a structured audit log. Auditing information is then obtained from a structured audit log based on matching the record or row identifier (RID) associated with the query with the RID associated with the structured audit log.
Public/Granted literature
- US20230315715A1 UTILIZING A STRUCTURED AUDIT LOG FOR IMPROVING ACCURACY AND EFFICIENCY OF DATABASE AUDITING Public/Granted day:2023-10-05
Information query