Support for concurrent active SQL statements having shared SQL context information

• US 20030120648A1
• Filed: 12/11/2002
• Published: 06/26/2003
• Est. Priority Date: 12/20/2001
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Bird, Paul M., Vincent, Timothy J.
• Granted Patent: US 7,007,016 B2
• Time in Patent Office: Days
• US Class Current: 707/4
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

An SQL database management system for executing SQL requests from applications. The SQL database management system includes a hierarchical arrangement of data structures comprising packages, section entries, sibling control blocks and sections, for representing SQL context information and SQL statement information. Each package represents SQL context information on an application component-level basis. Each section entry is associated with a package and corresponds to a set of SQL actions. Each section entry is potentially associated with one or more sibling control blocks. Each sibling control block is associated with one section and represents context information relating to a unique SQL request. Each section includes logic for a specific SQL statement.

Claims

1. An database management system for executing query language requests from applications, comprising representation means for representing query context information and statement information of a query language, the representation means comprising means for defining and utilizing a hierarchical arrangement of data structures comprising packages, section entries, sibling control blocks and sections, each package representing query language context information on an application component-level basis, each section entry being associated with one of the packages and corresponding to a set of actions and potentially being associated with one or more sibling control blocks, each sibling control block being associated with one section and representing context information relating to a unique query language request, and each section comprising logic for a specific query statement.

2. The system of claim 1 in which the invocation of nested user-defined routines is supported and in which each sibling control block is associated with a nesting level within the user-defined routines.

3. The system of claim 2 in which each sibling control block comprises an identifier to uniquely identify the sibling control block within a set of sibling control blocks associated with a selected nesting level.

4. A computer program product for use in a database management system for executing requests from applications, the computer program product comprising a computer usable medium having computer readable code means embodied in said medium for implementing a representation of query context information and query statement information, comprising computer readable program code means for defining and utilizing a hierarchical arrangement of data structures comprising packages, section entries, sibling control blocks and sections, each package representing context information on an application component-level basis, each section entry being associated with one of the packages and corresponding to a set of query actions and potentially being associated with one or more sibling control blocks, each sibling control block being associated with one section and representing context information relating to a unique query request, and each section comprising logic for a specific query statement.

5. The program product of claim 4 in which the database management system supports the invocation of nested user-defined routines and in which each sibling control block is associated with a nesting level within the user-defined routines.

6. The program product of claim 5 in which each sibling control block comprises an identifier to uniquely identify the sibling control block within a set of sibling control blocks associated with a selected nesting level.

7. The program product of claim 4, in which SQL is a query language used.

8. A method for representing query context information and query statement information in a database management system for executing query requests from applications, the database management system comprising means for defining and utilizing a hierarchical arrangement of data structures comprising packages, section entries, sibling control blocks and sections, the method comprising:

a. defining a first package to representing query context information for an application,

b. defining a set of section entries and associating those section entries with the first package, each section entry in the set corresponding to a set of query actions in the application,

c. defining one or more sibling control blocks, each sibling control block being associated with one section entry and being defined to represent context information relating to a unique query request, and

d. defining one or more sections, each section to be associated with one sibling control block and comprising logic for a specific query statement.

9. The method of claim 8 in which the database management system supports the invocation of nested user-defined routines and in which the step of defining one or more sibling control blocks comprises the further step of associating each sibling control block with a nesting level value corresponding to the nesting level of a user-defined routine associated with the sibling control block.

10. The method of claim 9 wherein the act of defining one or more sibling control blocks comprises associating each sibling control block with an identifier to uniquely identify the sibling control block within a set of sibling control blocks associated with a selected nesting level.

11. The method of claim 8 in which SQL is a query language used.