System and method for automatically identifying a unit of change requiring upgrade in a database management system

• US 7,818,738 B2
• Filed: 12/15/2006
• Issued: 10/19/2010
• Est. Priority Date: 12/15/2006
• Status: Expired due to Fees

• Current Assignee: LinkedIn Corporation (Microsoft Corporation)
• Original Assignee: International Business Machines Corporation
• Inventors: Greenhaw, Angelique Nicole, Krein, Terry Lee, Barmettler, John Charles, Ranson, Karen Alicia, Ricchio, Francis Joseph, Vakkalagadda, Anuradha Venkata, Tien, Thanh, Tse, Judy Y.
• Primary Examiner(s): Zhen; Wei Y
• Assistant Examiner(s): CHOW, CHIH CHING
• Application Number:
  US11/611,723
• Publication Number:
  US 20080147744A1
• Time in Patent Office: 1,404 Days
• Field of Search: 717/168, 707/610, 707/624
• US Class Current: 717/168
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409

Abstract

A system and method to automatically identify resources requiring upgrade in a hierarchical database management system. The system may include an input module to receive input identifying a single resource for upgrade. A comparator module may compare an active resource library to a staging library to identify additional resources for upgrade, and an incorporation module may incorporate the single input resource and the additional resources into an upgrade list. A generation module may then automatically derive a unit of change from this list, where the unit of change includes the single input resource as well as additional resources that interact with the input resource.

Claims

1. A system to automatically identify a unit of change requiring upgrade in a hierarchical database management system, comprising:

a storage device storing executable code;

a processor executing the executable code, the executable code comprising;

a hierarchical database management system to manage a plurality of resources, the resources comprising databases and application programs interacting with the databases;

an active resource library storing resource information identifying each of the plurality of resources and associated resources interacting with the plurality of resources;

a staging library storing a copy of the resource information, the resource information of the copy modified to identify for upgrade at least one of the plurality of resources; and

an upgrade module for automatically identifying a unit of change requiring upgrade in the database management system, the upgrade module comprising;

an input module to input, by a user, exactly one resource identified for upgrade in the staging library;

a comparator module to compare the active resource library to the staging library to identify additional resources requiring upgrade, the additional resources having an association with the exactly one resource identified for upgrade, the association comprising an inter-relationship between databases and application programs interacting with the databases, the comparator module further identifying a first resource as an additional resource requiring upgrade by detecting a discrepancy between a first timestamp associated with the first resource in the active resource library and a second timestamp associated with the first resource in the staging library;

an incorporation module to incorporate the exactly one resource identified for upgrade and the additional resources into an upgrade list; and

a generation module to automatically generate from the upgrade list a unit of change comprising the exactly one resource identified for upgrade and additional resources interacting with the exactly one resource.

2. The system of claim 1, wherein the upgrade module further comprises an implementation module to implement required upgrades in the exactly one resource identified for upgrade and the additional resources interacting with the exactly one resource that comprise the unit of change.

3. A computer program product comprising a non-transitory computer readable medium having computer usable program code programmed for automatically identify a unit of change requiring upgrade in a hierarchical database management system, the operations of the computer program product comprising:

providing a hierarchical database management system to manage a plurality of resources, the resources comprising databases and application programs interacting with the databases;

providing an active resource library storing resource information identifying each of the plurality of resources and associated resources interacting with the plurality of resources;

providing a staging library storing a copy of the resource information, the resource information of the copy modified to identify for upgrade at least one of the plurality of resources;

inputting, by a user, exactly one resource identified for upgrade in the staging library;

comparing the active resource library to the staging library to identify additional resources requiring upgrade, the additional resources having an association with the exactly one resource identified for upgrade, the association comprising an inter-relationship between databases and application programs interacting with the databases;

identifying a first resource as an additional resource requiring upgrade by detecting a discrepancy between a first timestamp associated with the first resource in the active resource library and a second timestamp associated with the first resource in the staging library;

incorporating the exactly one resource identified for upgrade and the additional resources into an upgrade list; and

automatically generating, from the upgrade list, a unit of change comprising the exactly one resource identified for upgrade and additional resources interacting with the exactly one resource.

4. A computer program product of claim 3, further comprising implementing required upgrades in the exactly one resource identified for upgrade and additional resources interacting with the exactly one resource that comprise the unit of change.