Patents by Inventor Kenneth M. McDonald

Kenneth M. McDonald has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Patent number: 8924398
    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.
    Type: Grant
    Filed: March 23, 2011
    Date of Patent: December 30, 2014
    Assignee: BMC Software, Inc.
    Inventors: Oscar J. Garza, Yanmin Liu, Kenneth M. McDonald
  • Patent number: 8595190
    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.
    Type: Grant
    Filed: August 4, 2011
    Date of Patent: November 26, 2013
    Assignee: BMC Software, Inc.
    Inventors: Oscar J. Garza, Michael J. Hanus, Kenneth M. McDonald, Kenneth J. Durfee
  • Publication number: 20130006940
    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.
    Type: Application
    Filed: August 4, 2011
    Publication date: January 3, 2013
    Applicant: BMC SOFTWARE, INC.
    Inventors: Oscar J. Garza, Michael J. Hanus, Kenneth M. McDonald, Kenneth J. Durfee
  • Publication number: 20120246179
    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.
    Type: Application
    Filed: March 23, 2011
    Publication date: September 27, 2012
    Applicant: BMC SOFTWARE, INC.
    Inventors: Oscar J. Garza, Yanmin Liu, Kenneth M. McDonald
  • Patent number: 8121992
    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.
    Type: Grant
    Filed: April 19, 2010
    Date of Patent: February 21, 2012
    Assignee: BMC Software, Inc.
    Inventors: Michael J. Hanus, Kenneth M. McDonald, Kenneth J. Durfee, Bobby B. Baty
  • Publication number: 20100205157
    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.
    Type: Application
    Filed: April 19, 2010
    Publication date: August 12, 2010
    Applicant: BMC SOFTWARE, INC.
    Inventors: Michael J. Hanus, Kenneth M. McDonald, Kenneth J. Durfee, Bobby B. Baty
  • Patent number: 7769718
    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.
    Type: Grant
    Filed: September 28, 2006
    Date of Patent: August 3, 2010
    Assignee: BMC Software, Inc.
    Inventors: Michael S. Murley, Thomas G. Price, Kenneth M. McDonald, Stanley D. Dee, Linda S. Ball
  • Patent number: 7730044
    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.
    Type: Grant
    Filed: April 2, 2007
    Date of Patent: June 1, 2010
    Assignee: BMC Software, Inc.
    Inventors: Michael J. Hanus, Kenneth M. McDonald, Kenneth J. Durfee, Bobby B. Baty
  • Publication number: 20080243945
    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.
    Type: Application
    Filed: April 2, 2007
    Publication date: October 2, 2008
    Applicant: BMC SOFTWARE, INC.
    Inventors: Michael J. Hanus, Kenneth M. McDonald, Kenneth J. Durfee, Bobby B. Baty
  • Patent number: 7133884
    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.
    Type: Grant
    Filed: November 26, 2003
    Date of Patent: November 7, 2006
    Assignee: BMC Software, Inc.
    Inventors: Michael S. Murley, Thomas G. Price, Kenneth M. McDonald, Stanley J. Dee, Linda S. Ball
  • Patent number: 7099037
    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.
    Type: Grant
    Filed: April 5, 2004
    Date of Patent: August 29, 2006
    Assignee: Lightning Source Inc.
    Inventors: G. Phil Clark, Jeffrey W. Crawford, Kenneth M. McDonald
  • Publication number: 20040211330
    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.
    Type: Application
    Filed: April 5, 2004
    Publication date: October 28, 2004
    Applicant: Lightning Source, Inc.
    Inventors: G. Phil Clark, Jeffrey W. Crawford, Kenneth M. McDonald