公开(公告)号：US08924398B2

公开(公告)日：2014-12-30

申请号：US13070388

申请日：2011-03-23

Applicant: Oscar J. Garza ,  Yanmin Liu ,  Kenneth M. McDonald

Inventor： Oscar J. Garza ,  Yanmin Liu ,  Kenneth M. McDonald

IPC: G06F17/30

CPC classification number: G06F17/303 ,  G06F17/30297

Abstract: Systems, methods, and computer readable media for automatically generating Data Definition Language (DDL) commands from database log information is described. In general, techniques are disclosed for analyzing database log entries to identify those associated with targeted DDL commands and associating those entries with a DDL command object. The DDL command object may be used (immediately or at some later time) to generate a DDL commands corresponding to the (possibly many) aggregated log records associated with the command object. The use of multiple database log entries as described herein enables the generation of DDL commands that capture database activity occurring over a period of time (full time context auditing) and can, therefore, naturally account for database schema changes.

Abstract translation: 描述了用于从数据库日志信息自动生成数据定义语言（DDL）命令的系统，方法和计算机可读介质。 通常，公开了用于分析数据库日志条目以识别与目标DDL命令相关联的技术并将这些条目与DDL命令对象相关联的技术。 可以使用DDL命令对象（立即或在稍后的时间）生成与命令对象相关联的（可能许多）聚合日志记录相对应的DDL命令。 使用如本文所述的多个数据库日志条目使得能够生成捕获在一段时间内发生的数据库活动（全时上下文审计）的DDL命令，并且因此可以自然地考虑数据库模式更改。

公开(公告)号：US20130006940A1

公开(公告)日：2013-01-03

申请号：US13198369

申请日：2011-08-04

Applicant: Oscar J. Garza ,  Michael J. Hanus ,  Kenneth M. McDonald ,  Kenneth J. Durfee

Inventor： Oscar J. Garza ,  Michael J. Hanus ,  Kenneth M. McDonald ,  Kenneth J. Durfee

IPC: G06F7/00

CPC classification number: G06F17/3028 ,  G06F17/30 ,  G06F17/30318 ,  G06F17/30368 ,  G06F17/30595

Abstract: In one general aspect, an apparatus can include a completion identifier configured to identify, for completion processing, a large object (LOB) deleted from an auxiliary table within a DB2 database environment based on a space map record associated with the large object where the auxiliary table functions as an auxiliary space to a base table. The apparatus can also include a completion analyzer configured to identify a resource where an image of the large object is stored at a time before the deletion of the large object from the auxiliary table.

Abstract translation: 在一个一般方面，装置可以包括完成标识符，其被配置为基于与大对象相关联的空间映射记录来识别从DB2数据库环境中的辅助表中删除的大对象（LOB），用于完成处理，其中辅助对象 表作为基表的辅助空间。 该装置还可以包括：完成分析器，被配置为在从辅助表删除大对象之前的时刻识别大对象的图像被存储的资源。

公开(公告)号：US08121992B2

公开(公告)日：2012-02-21

申请号：US12762592

申请日：2010-04-19

Applicant: Michael J. Hanus ,  Kenneth M. McDonald ,  Kenneth J. Durfee ,  Bobby B. Baty

Inventor： Michael J. Hanus ,  Kenneth M. McDonald ,  Kenneth J. Durfee ,  Bobby B. Baty

IPC: G06F7/00 ,  G06F17/00

CPC classification number: G06F17/30318 ,  G06F17/30368 ,  Y10S707/954

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.

Abstract translation: 一种机制与DB2®Log和分析工具（如BMC的Log Master™）协同工作，以处理存储在DB2数据库系统表中的大对象（LOB）的记录数据。 多个控件跟踪为LOB记录的数据。 该机制从DB2日志读取日志记录，并使用该控件来确定跟踪的LOB与哪些跟踪日志记录相关联，并从这些关联的日志记录中获取数据。 该机制构建密钥来索引数据，并将密钥和数据存储在虚拟存储访问方法存储中，该存储具有独立于DB2日志的日志记录存储的密钥排序数据集。 当分析工具请求时，可以使用第一个存储区中的键和映射记录重新组合存储中的数据，该记录映射跟踪的LOB的记录数据。

公开(公告)号：US20080243945A1

公开(公告)日：2008-10-02

申请号：US11695114

申请日：2007-04-02

Applicant: Michael J. Hanus ,  Kenneth M. McDonald ,  Kenneth J. Durfee ,  Bobby B. Baty

Inventor： Michael J. Hanus ,  Kenneth M. McDonald ,  Kenneth J. Durfee ,  Bobby B. Baty

IPC: G06F17/30

CPC classification number: G06F17/30318 ,  G06F17/30368 ,  Y10S707/954

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.

Abstract translation: 一种机制与DB2（R）Log和分析工具（如BMC的Log Master TM）配合使用，以处理存储在DB2数据库系统表中的大对象（LOB）的记录数据。 多个控件跟踪为LOB记录的数据。 该机制从DB2日志读取日志记录，并使用控件来确定跟踪的LOB与哪些跟踪日志记录相关联，并从这些关联的日志记录中获取数据。 该机制构建密钥来索引数据，并将密钥和数据存储在虚拟存储访问方法存储中，该存储具有独立于DB2日志的日志记录存储的密钥排序数据集。 当分析工具请求时，可以使用第一个存储区中的键和映射记录重新组合存储中的数据，该记录映射跟踪的LOB的记录数据。

公开(公告)号：US07769718B2

公开(公告)日：2010-08-03

申请号：US11536490

申请日：2006-09-28

Applicant: Michael S. Murley ,  Thomas G. Price ,  Kenneth M. McDonald ,  Stanley D. Dee ,  Linda S. Ball

Inventor： Michael S. Murley ,  Thomas G. Price ,  Kenneth M. McDonald ,  Stanley D. Dee ,  Linda S. Ball

IPC: G06F7/00 ,  G06F17/00

CPC classification number: G06F17/30348 ,  Y10S707/99953

Abstract: Techniques to create physically and transactionally consistent copies of one or more database objects without impacting the availability of the target database objects are described. In one technique, a consistent copy is created as of the time a copy utility is executed. In another technique, a consistent copy is created as of an arbitrary specified time. This approach modifies a prior copy to bring it “up-to-date.” In yet another technique, a consistent copy is created by starting with a current snapshot of the target database objects and selectively removing updates from it back to a user specified arbitrary point-in-time. Each of the described techniques generate consistent copies of the target database objects without blocking users from accessing the target objects during the copy operation.

Abstract translation: 描述了在不影响目标数据库对象的可用性的情况下创建一个或多个数据库对象的物理和事务一致副本的技术。 在一种技术中，在执行副本实用程序时创建一致的副本。 在另一种技术中，创建一个一致的副本作为任意指定的时间。 该方法修改了先前的副本以使其“最新”。在另一种技术中，通过从目标数据库对象的当前快照开始创建一致的副本，并选择性地将其更新返回给用户指定的任意 时间点。 所描述的每个技术在复制操作期间产生目标数据库对象的一致副本而不阻止用户访问目标对象。

公开(公告)号：US07730044B2

公开(公告)日：2010-06-01

申请号：US11695114

申请日：2007-04-02

Applicant: Michael J. Hanus ,  Kenneth M. McDonald ,  Kenneth J. Durfee ,  Bobby B. Baty

Inventor： Michael J. Hanus ,  Kenneth M. McDonald ,  Kenneth J. Durfee ,  Bobby B. Baty

IPC: G06F17/30

CPC classification number: G06F17/30318 ,  G06F17/30368 ,  Y10S707/954

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.

Abstract translation: 一种机制与DB2®Log和分析工具（如BMC的Log Master™）协同工作，以处理存储在DB2数据库系统表中的大对象（LOB）的记录数据。 多个控件跟踪为LOB记录的数据。 该机制从DB2日志读取日志记录，并使用控件来确定跟踪的LOB与哪些跟踪日志记录相关联，并从这些关联的日志记录中获取数据。 该机制构建密钥来索引数据，并将密钥和数据存储在虚拟存储访问方法存储中，该存储具有独立于DB2日志的日志记录存储的密钥排序数据集。 当分析工具请求时，可以使用第一个存储区中的键和映射记录重新组合存储中的数据，该记录映射跟踪的LOB的记录数据。

公开(公告)号：US07133884B1

公开(公告)日：2006-11-07

申请号：US10723677

申请日：2003-11-26

Applicant: Michael S. Murley ,  Thomas G. Price ,  Kenneth M. McDonald ,  Stanley J. Dee ,  Linda S. Ball

Inventor： Michael S. Murley ,  Thomas G. Price ,  Kenneth M. McDonald ,  Stanley J. Dee ,  Linda S. Ball

IPC: G06F17/00

CPC classification number: G06F17/30348 ,  Y10S707/99953

Abstract: Techniques to create physically and transactionally consistent copies of one or more database objects without impacting the availability of the target database objects are described. In one technique, a consistent copy is created as of the time a copy utility is executed. In another technique, a consistent copy is created as of an arbitrary specified time. This approach modifies a prior copy to bring it “up-to-date.” In yet another technique, a consistent copy is created by starting with a current snapshot of the target database objects and selectively removing updates from it back to a user specified arbitrary point-in-time. Each of the described techniques generate consistent copies of the target database objects without blocking users from accessing the target objects during the copy operation.

Abstract translation: 描述了在不影响目标数据库对象的可用性的情况下创建一个或多个数据库对象的物理和事务一致副本的技术。 在一种技术中，在执行副本实用程序时创建一致的副本。 在另一种技术中，创建一个一致的副本作为任意指定的时间。 这种方法修改了先前的副本以使其“最新”。 在另一种技术中，通过从目标数据库对象的当前快照开始并且选择性地将其更新返回给指定的任意时间点的用户来创建一致的副本。 所描述的每个技术在复制操作期间产生目标数据库对象的一致副本而不阻止用户访问目标对象。

公开(公告)号：US07099037B2

公开(公告)日：2006-08-29

申请号：US10818881

申请日：2004-04-05

Applicant: G. Phil Clark ,  Jeffrey W. Crawford ,  Kenneth M. McDonald

Inventor： G. Phil Clark ,  Jeffrey W. Crawford ,  Kenneth M. McDonald

IPC: G06F15/00

CPC classification number: G06F3/1219 ,  G06F3/1208 ,  G06F3/1251 ,  G06F3/1285 ,  Y10S707/99931

Abstract: A method and a computer data signal including instructions for processing printed unit orders for printing on printers adapted for printing N pages across a print web. The orders are grouped based on page type (e.g., size, thickness, color) and binding type into print batches. These print batches are sorted, processed and then sent to the printer. Printed units may be organized with N single printed units printed in parallel across the web, a single printed unit sorted into N sections printed in parallel across all of the webs, or in super batches including multiple printed units, with N super batches printed in parallel across the web.

Abstract translation: 一种方法和计算机数据信号，包括用于处理印刷单元订单以用于在打印机上打印N页打印机的打印单元的指令。 订单根据页面类型（例如，尺寸，厚度，颜色）和打印批次的装订类型进行分组。 这些打印批次被排序，处理，然后发送到打印机。 印刷单元可以组织成N个单个印刷单元并联印刷在网上，单个印刷单元分为N个部分，平行印刷在所有的网上，或者以超级批次包括多个印刷单元，N个超级批次平行印刷 跨网路

公开(公告)号：US20100205157A1

公开(公告)日：2010-08-12

申请号：US12762592

申请日：2010-04-19

Applicant: Michael J. Hanus ,  Kenneth M. McDonald ,  Kenneth J. Durfee ,  Bobby B. Baty

Inventor： Michael J. Hanus ,  Kenneth M. McDonald ,  Kenneth J. Durfee ,  Bobby B. Baty

IPC: G06F17/30 ,  G06F7/00

CPC classification number: G06F17/30318 ,  G06F17/30368 ,  Y10S707/954

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.

Abstract translation: 一种机制与DB2®Log和分析工具（如BMC的Log Master™）协同工作，以处理存储在DB2数据库系统表中的大对象（LOB）的记录数据。 多个控件跟踪为LOB记录的数据。 该机制从DB2日志读取日志记录，并使用控件来确定跟踪的LOB与哪些跟踪日志记录相关联，并从这些关联的日志记录中获取数据。 该机制构建密钥来索引数据，并将密钥和数据存储在虚拟存储访问方法存储中，该存储具有独立于DB2日志的日志记录存储的密钥排序数据集。 当分析工具请求时，可以使用第一个存储区中的键和映射记录重新组合存储中的数据，该记录映射跟踪的LOB的记录数据。

公开(公告)号：US08595190B2

公开(公告)日：2013-11-26

申请号：US13198369

申请日：2011-08-04

Applicant: Oscar J. Garza ,  Michael J. Hanus ,  Kenneth M. McDonald ,  Kenneth J. Durfee

Inventor： Oscar J. Garza ,  Michael J. Hanus ,  Kenneth M. McDonald ,  Kenneth J. Durfee

IPC: G06F7/04 ,  G06F17/30

CPC classification number: G06F17/3028 ,  G06F17/30 ,  G06F17/30318 ,  G06F17/30368 ,  G06F17/30595

Abstract: In one general aspect, an apparatus can include a completion identifier configured to identify, for completion processing, a large object (LOB) deleted from an auxiliary table within a DB2 database environment based on a space map record associated with the large object where the auxiliary table functions as an auxiliary space to a base table. The apparatus can also include a completion analyzer configured to identify a resource where an image of the large object is stored at a time before the deletion of the large object from the auxiliary table.

Abstract translation: 在一个一般方面，装置可以包括完成标识符，其被配置为基于与大对象相关联的空间映射记录来识别从DB2数据库环境中的辅助表中删除的大对象（LOB），用于完成处理，其中辅助对象 表作为基表的辅助空间。 该装置还可以包括：完成分析器，被配置为在从辅助表删除大对象之前的时刻识别大对象的图像被存储的资源。