Computer-readable medium to multiplex multiple application server requests over a single database connection

US7933948B2 · kind B2 · utility

Assignee

• International Business Machines Corporation · US

Inventors

• Paul M. Bird · Markham, CA
• William Robert Bireley · معلمی نژاد, US
• Curt L. Cotner · Gilroy, US
• Tammie Dang · معلمی نژاد, US
• Margaret A. Dong · San Jose, US
• Georgia C. Fuller · San Jose, US
• Michelle Lam · Los Angeles, US
• James W. Pickel · Gilroy, US
• Frankie K. Sun · North York, CA

Key dates

• Filing date: Jun 30, 2008
• Grant date: Apr 26, 2011
• Expiry date: Jul 2, 2029

Classification

• Technology area (CPC Y): Emerging Cross-Sectional Technologies
• CPC primary: Y10S707/99953
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

In a system for avoiding section collision for application server requests over a single database connection, the database server assigns query identifiers to each instance of the same cursor opened for the same processing level within an application, allowing multiple instances of the same cursor to be processed in parallel without section collision. The application server assigns a command source identifier to each statement sent over a single database connection to uniquely identify the application source of the statement. This applies for multiples of the same statement sent by different application sources within the same application, for a single statement containing multiple application sources, and for multiple statements from different applications multiplexed over a single database connection. These statements can be processed separately from and in parallel with the each other without section collision.