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

• US 20060074635A1
• Filed: 10/06/2004
• Published: 04/06/2006
• Est. Priority Date: 10/06/2004
• Status: Active Grant

• Current Assignee: Hewlett Packard Enterprise Development LP (Hewlett-Packard Enterprise Company)
• Original Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Inventors: Zeller, Hansjorg, Sharma, Anoop, Wehrmeister, Robert Matthew, Reyes, Thomas Canivel, Birdsall, David Wayne, Hanlon, Michael James, Gilbert, Gary Martin
• Granted Patent: US 7,765,531 B2
• Time in Patent Office: Days
• US Class Current: 704/9
• 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 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 module based on the query language statements; and

detect a command line that indicates whether the query module should be stored in a local directory or a global directory.

2. The apparatus of claim 1, further comprising:

logic instructions 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 operable to;

verify the 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 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 operable to;

compile and link the programming language statements to generate an executable program module, wherein the 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 logic instructions are implemented as software instructions stored on a computer-readable medium.

9. A method comprising:

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

determining a location to store a query language module based on whether the query language statements are stored in a local directory or a 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 the 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 detecting an indicator of whether to store a database query language module in a local directory or a global directory.

18. The apparatus of claim 17, further comprising:

means for separating query language statements from programming statements in the source 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.