Invention Grant
US08121992B2 Log data store and assembler for large objects in database system
有权
在数据库系统中为大型对象记录数据存储和汇编程序
- Patent Title: Log data store and assembler for large objects in database system
- Patent Title (中): 在数据库系统中为大型对象记录数据存储和汇编程序
-
Application No.: US12762592Application Date: 2010-04-19
-
Publication No.: US08121992B2Publication Date: 2012-02-21
- Inventor: Michael J. Hanus , Kenneth M. McDonald , Kenneth J. Durfee , Bobby B. Baty
- Applicant: Michael J. Hanus , Kenneth M. McDonald , Kenneth J. Durfee , Bobby B. Baty
- Applicant Address: US TX Houston
- Assignee: BMC Software, Inc.
- Current Assignee: BMC Software, Inc.
- Current Assignee Address: US TX Houston
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00

Abstract:
A mechanism works in conjunction with a DB2® Log and an analysis tool, such as BMC's Log Master™, to handle logged data for Large Objects (LOBs) stored in tables of a DB2 database system. A plurality of controls track data logged for the LOBs. The mechanism reads log records from a DB2 Log and uses the controls to determine which of the tracked LOBs is associated with the log records and obtains data from those associated log records. The mechanism builds keys to index the data and stores the keys and the data in a Virtual Storage Access Method store having Key Sequenced Data Sets maintained separate from the log record store for the DB2 Log. When requested by the analysis tool, the data in the store can be reassembled using the keys and map records in the first store that map the logged data for the tracked LOBs.
Public/Granted literature
- US20100205157A1 Log Data Store and Assembler for Large Objects in Database System Public/Granted day:2010-08-12
Information query