Support for concurrent active SQL statements having shared SQL context information

• US 7,007,016 B2
• Filed: 12/11/2002
• Issued: 02/28/2006
• Est. Priority Date: 12/20/2001
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Bird, Paul M., Vincent, Timothy J.
• Primary Examiner(s): TRUONG, CAM Y T
• Application Number:
  US10/317,229
• Publication Number:
  US 20030120648A1
• Time in Patent Office: 1,175 Days
• Field of Search: 707/2, 707/4, 707/100, 707/3, 707/102
• US Class Current: 1/1
• 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. A 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 structured query language (SQL) actions and 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, a sibling control block representing a unique occurrence of a structured query language (SQL) request within the application'"'"'s execution and each sibling control block being uniquely identified from other sibling control blocks at least under the same section entry;

wherein control and state information of a request are established in a sibling control block such that multiple requests referring to the same structured query language (SQL) context do not generate a conflict.

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 structured query language (SQL) query actions and 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, wherein:

a sibling control block contains control and state information relevant for the request the sibling control block represents and is independent of other sibling control blocks associated with the same section, wherein control and state information of a request are established in a sibling control block such that multiple requests referring to the same structured query language (SQL) context do not generate a conflict.

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 represent 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 structured query language (SQL) 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, wherein maintaining context information in the sibling control blocks facilitates concurrently active structured query language (SQL) statements being referenced using the same context information as provided by package and section entry data, and to have differing request control information, as provided by the sibling control blocks;

wherein control and state information of a request are established in a sibling control block such that multiple requests referring to the same structured query language (SQL) context do not generate a conflict.

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 identity 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.