Systems and methods for handling multiple static query modules for distinct environments

• US 7,765,531 B2
• Filed: 10/06/2004
• Issued: 07/27/2010
• Est. Priority Date: 10/06/2004
• Status: Expired due to Fees

• Current Assignee: Hewlett Packard Enterprise Development LP (Hewlett-Packard Enterprise Company)
• Original Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Inventors: Wehrmeister, Robert Matthew, Reyes, Thomas Canivel, Birdsall, David Wayne, Hanlon, Michael James, Gilbert, Gary Martin, Zeller, Hansjorg, Sharma, Anoop
• Primary Examiner(s): Zhen; Wei Y
• Assistant Examiner(s): Nahar; Qamrun
• Application Number:
  US10/960,708
• Publication Number:
  US 20060074635A1
• Time in Patent Office: 2,120 Days
• Field of Search: 717/141, 717/143, 707/4
• US Class Current: 717/141
• CPC Class Codes: G06F 16/2438 Embedded query languages
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

Systems and methods to indicate whether to store a database query language module in a local directory or a global directory are disclosed. An application program can be created once, tested once, and deployed in separate environments. The database query language modules can be shared among a group of application programs running in a common environment. Separate query language modules can be maintained for each environment.

Claims

1. An apparatus comprising:

logic instructions embedded on non-transitory computer readable medium operable to;

pre-compile a source code file, wherein the source file includes database query language statements embedded in programming language statements;

generate a query language module based on the query language statements; and

detect a command line that indicates whether the query language module should be stored in a local directory or a global directory, wherein executable program modules that use more than one query language module can use a combination of query language modules in local directory and global directory.

2. The apparatus of claim 1, further comprising:

logic instructions embedded on computer readable medium operable to;

search the local directory for the query language module; and

search the global directory for the query language module.

3. The apparatus of claim 1, further comprising:

logic instructions embedded on computer readable medium operable to;

verify identity of the query language module.

4. The apparatus of claim 1, further comprising:

a data element that specifies a default directory for the query language module.

5. The apparatus of claim 1, further comprising:

logic instructions embedded on computer readable medium operable to perform at least one of the group consisting of;

move the query language module from one location to another;

copy the query language module;

restore the query language module;

remove the query language module;

create the query language module;

archive the query language module; and

assign an alias name for the query language module.

6. The apparatus of claim 1, further comprising:

logic instructions embedded on computer readable medium operable to;

compile and link the programming language statements to generate an executable program module, wherein the executable program module and the query language module reside in the local directory.

7. The apparatus of claim 1, further comprising:

a processor configured to execute the logic instructions.

8. The apparatus of claim 1, wherein the command line is included in the source code file.

9. A method comprising:

pre-compile a source code file, wherein the source file includes database query language statements embedded in programming language statements;

generate a query language module based on the query language statements;

segregating the query language statements from the programming language statements in the source file; and

using an indicator in a command line parameter file to determine whether to store the query language module in a local directory or a global directory, the query language module is based on the query language statements, wherein executable program modules that use more than one query language module can use a combination of query language modules in local directory and global directory.

10. The method of claim 9, further comprising:

compiling the query language statements to generate the query language module.

11. The method of claim 10, further comprising:

detecting a name of the query language module when the query language module is invoked; and

verifying that the name of the invoked query language module matches the name of the query language module.

12. The method of claim 11, further comprising:

issuing an error indicator when the name of the invoked query language module does not match the name of the query language module.

13. The method of claim 9, further comprising:

determining whether the query language module is in the local directory when an application program invokes the query language module.

14. The method of claim 9, further comprising:

determining whether the query language module is in the global directory when the query language module is not found in the local directory.

15. The method of claim 9, wherein the query language module in the local directory is accessible by any application program in the local directory.

16. The method of claim 9, wherein the query language module in the global directory is accessible by an application program in the local directory.

17. An apparatus comprising:

means for pre-compiling a source code file, wherein the source file includes database query language statements embedded in programming language statements;

means for generating a query language module based on the query language statements;

means for detecting an indicator of whether to store the database query language module in a local directory or a global directory, wherein the indicator is included in the source code file ; and

means for storing the query language module in the local directory or the global directory based on the indicator, wherein executable program modules that use more than one query language module can use a combination of query language modules in local directory and global directory.

18. The apparatus of claim 17, further comprising:

means for separating query language statements from programming language statements in the source code file, wherein the query language module is based on the query language statements.

19. The apparatus of claim 17, further comprising:

means for determining whether the query language module is in the local directory when an application program invokes the query language module; and

means for determining whether the query language module is in the global directory when the query language module is not found in the local directory.

20. The apparatus of claim 17, wherein the query language module is a Structured Query Language (SQL) module.