System and method for intercommunicating between applications and a database manager

• US 5,129,086 A
• Filed: 11/29/1988
• Issued: 07/07/1992
• Est. Priority Date: 11/29/1988
• Status: Expired due to Term

• Current Assignee: Cisco Technology, Inc. (Cisco Systems, Inc.)
• Original Assignee: International Business Machines Corporation
• Inventors: McConaughy, John M., Coyle, Daniel J. Jr., Hargrove, Dan C.
• Primary Examiner(s): Lee, Thomas C.
• Assistant Examiner(s): Lim, Krisna
• Application Number:
  US07/277,386
• Time in Patent Office: 1,316 Days
• Field of Search: 364/200 MS File, 364/300 MS File, 395/600, 395/650
• US Class Current: 719/328
• CPC Class Codes: G06F 16/2438 Embedded query languages
• CPC Class Codes: G06F 8/00 Arrangements for software engineering testing or debugging G06F11/36; administrative, planning or organisation aspects of software project management G06Q10/06
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

An interfacing system and method for use in computerized systems for intercommunication between application and database systems. A plurality of generic application program interfaces are employed as an interface for use in precompiler development as a runtime interface target to initialize data structures with data required to perform runtime database query language-related functions. The application program is isolated from the database kernel interface facilitating alteration of the database kernel interface without affecting the application program or user-developed precompilers. Parameters used by the interface are employed by applications written to a plurality of host languages. The applications indirectly use these data structures required by the kernel. The interface system supports serialized multiple thread access to the database kernel facilitating performance/functional benefits of multi-threaded applications.

Claims

1. A method for intercommunicating between application programs and a database manager comprising the computer implemented steps of:

allocating, re-allocating, or de-allocating said dynamic data structures required by said application programs;

registering a user-defined data structure comprised of syntactic structure used by said application programs;

initializing said dynamic and said user-defined data structures;

communicating previously allocated or registered ones of said dynamic data structures and said user-defined data structures, respectively, to said database manager to process a database access statement;

validating content of said user-defined data structure;

communicating access program identification information to said database manager at runtime and wherein said method further includes the computer implemented steps of

pre-compiling a source module corresponding to one of said application programs and;

selecting said access program identification information prior to said communicating as a function of information generated from said pre-compiling of said source module.

pre-compiling a source module corresponding to one of said application programs.

2. The method of claim 1 wherein said application programs have multiplied threads, and wherein said method further includes serializing access by said application programs to said database manager from different threads of said multiple threads within said application programs by semaphores.

3. The method of claim 1 further including ensuring validity of said user-defined data structures and said dynamic data structures.

4. The method of claim 1 wherein said database manager includes multiple access programs and wherein said method further includes as one of said steps managing module-specific data required by said application programs using said multiple-access programs.

5. A system for intercommunicating between application programs and a database manager comprising:

means for allocating, re-allocating, or de-allocating dynamic data structures required by said application programs;

means for registering user-defined data structures comprised of syntactic structure used by said application programs;

means interconnected to said means for registering and to said means for allocating, re-allocating, or de-allocating, for initializing said user-defined data structures and said dynamic data structures;

means interconnected between said database manager and said means for initializing, for communicating previously allocated or registered one of said dynamic data structures and said user-defined data structures, respectively, to said database manager to process a database access statement;

means for validating content of said user-defined data structures; and

means for communicating access program identification information to said database manager at runtime, wherein said program identification information uniquely identifies database objects required to process said database access statements and wherein said system includes

means for pre-compiling a source module corresponding to one of said application programs; and

means for selecting said access program identification information prior to said communicating as a function of information generated from said pre-compiling of said source module.

6. The system of claim 5 wherein said application programs have multiple-threads, wherein said system includes means for serializing access by said application programs to said database manager from different threads of said multiple threads within said application programs by semaphores.

7. The system of claim 5 further including means for ensuring validity of said user-defined and said dynamic data structures.

8. The system of claim 5 wherein said database includes multiple access programs;

and

wherein said system further includes means for managing module-specific data required by said application programs using said multiple access programs.

9. The system of claim 6 wherein said multiple threads of said application programs each have associated therewith respective thread identifications and wherein said means for serializing access by said application programs to said database manager includes means for establishing semaphores functionally related to said thread identifications.

10. The system of claim 5 wherein said database manager includes multiple access programs, each of said multiple access programs being called by a respective one of said application programs;

wherein each of said application programs includes a related source module;

and further wherein said system includes means for pre-compiling each said related source module to generate corresponding source module information; and

means for selecting one of said access programs to execute for a corresponding one of said application programs as a function of said corresponding source module information.