Granted Patent B2

US 10,169,465 · App. 14/570,662 · Granted Jan 1, 2019

Inventors: Robert D. Andrews (Rochester, MN); Robert J. Bestgen (Rochester, MN); Gene R. Cobb (Oronoco, MN); Kathryn R. Steinbrink (Chatfield, MN)

Assignee: International Business Machines Corporation

G06F17/30867G06F17/30864

Abstract

Claims (38)

1. A computer-implemented method to manage runtime environments (RTEs), the computer-implemented method comprising:

receiving, by a server computing system, a query from a requesting entity;

determining an RTE to execute the query against, wherein the RTE is selected from a plurality of RTEs, each of which corresponds to a respective, isolated set of data libraries, wherein each set of data libraries is distinct and stores data according to a predefined schema common across the plurality of RTEs, wherein the determined RTE identifies one or more exit programs;

determining whether a current RTE for executing queries on the server computing system matches the determined RTE;

upon determining that the current RTE does not match the determined RTE, dynamically reconfiguring the server computing system by operation of one or more computer processors to access the data libraries associated with the determined RTE, wherein the server computing system is dynamically reconfigured without requiring any server restart;

dynamically modifying the query by executing the one or more exit programs; and

generating a set of results by executing the dynamically modified query against the determined RTE on the dynamically reconfigured server computing system, whereafter the set of results is output to the requesting entity.

2. The computer-implemented method of claim 1 , wherein the requesting entity comprises a user submitting the query, wherein the RTE is determined from a user profile associated with the user.

3. The computer-implemented method of claim 1 , wherein the requesting entity comprises a user submitting the query, wherein the RTE is determined from a group profile associated with the user.

4. The computer-implemented method of claim 1 , wherein the RTE is determined as a default RTE.

5. The computer-implemented method of claim 1 , wherein the query identifies a user selection of an RTE for executing the query.

6. The computer-implemented method of claim 1 , further comprising:

generating a report from the set of results; and

transmitting the report to the requesting entity, the requesting entity comprising a client computing system.

7. The computer-implemented method of claim 1 , wherein upon determining that the current RTE does not match the determined RTE, the server computing system is dynamically reconfigured for query execution according to the determined RTE without requiring any server restart and without requiring any user re-login.

8. The computer-implemented method of claim 7 , wherein the plurality of RTEs is characterized by a set of RTE properties, wherein the query is dynamically modified using the one or more exit programs and further using one or more exit program libraries corresponding to the one or more exit programs.

9. The computer-implemented method of claim 8 , wherein the determined RTE has a corresponding RTE definition that was generated when executing an application on the server computing system, wherein the application is configured to, upon determining that the server computing system is already configured for query execution according to the determined RTE, cause execution of the query without requiring the server computing system to be reconfigured, without requiring any server restart, and without requiring any user re-login.

10. The computer-implemented method of claim 9 , wherein the query is dynamically modified: (i) to become a case insensitive search and (ii) to track data from a set of data libraries accessed by the requesting entity, wherein the set of RTE properties identifies a set of one or more data libraries to associate with that RTE in the corresponding RTE definition.

11. The computer-implemented method of claim 10 , further comprising:

associating a user profile with the determined RTE;

associating the determined RTE with a group profile;

configuring the determined RTE as a default RTE for executing data queries; and

associating the one or more exit programs and the one or more exit program libraries with the determined RTE.

12. The computer-implemented method of claim 11 , wherein the set of RTE properties specifies each set of data libraries, wherein the application comprises a web query application operatively connected to an execution environment of a web browser.

13. The computer-implemented method of claim 12 , wherein the RTE is automatically selected based on the user profile and based further on the group profile, wherein the query is received from a requesting entity via the runtime environment, wherein the computer-implemented further comprises:

generating a report from the set of results obtained from executing the query; and

transmitting the report to the requesting entity.

14. The computer-implemented method of claim 13 , wherein the one or more exit programs are invoked by the web query application in order to dynamically modify the query, wherein each RTE has a respective RTE definition that is modifiable via an RTE configuration component;

wherein the one or more exit program libraries are accessible only by the one or more exit programs, wherein the web query application is operatively connected to a database management system for a database storing the set of data libraries for the RTE.

15. The computer-implemented method of claim 14 , wherein the web query application, the database management system, the web browser, the one or more exit programs, and the RTE configuration component are distinct applications;

wherein the web query application is configured to access a specified set of tables stored in the database, the specified set of tables including an RTE user table, an active RTE user table, and an RTE definition table.

16. The computer-implemented method of claim 15 , wherein the user RTE table includes: (i) an RTE identifier field and (ii) an RTE username field; wherein the active RTE user table includes: (i) an RTE identifier field and (ii) an RTE username field; wherein the RTE definition table includes: (i) an RTE identifier field; (ii) an RTE username field; (iii) an RTE description field; (iv) an RTE libraries field; (v) an RTE exit program field; and (vi) an RTE exit program library field; wherein the computer-implemented method further comprises:

generating a report from the set of results; and

transmitting the report to the requesting entity, the requesting entity comprising a client computing system.

17. The computer-implemented method of claim 1 , wherein the query is dynamically modified using the one or more exit programs and further using one or more exit program libraries corresponding to the one or more exit programs.

18. The computer-implemented method of claim 1 , wherein the determined RTE has a corresponding RTE definition that was generated when executing an application on the server computing system, wherein the application is configured to, upon determining that the server computing system is already configured for query execution according to the determined RTE, cause execution of the query without requiring the server computing system to be reconfigured, without requiring any server restart, and without requiring any user re-login.

19. The computer-implemented method of claim 1 , wherein the query is dynamically modified to become a case insensitive search.

20. The computer-implemented method of claim 1 , wherein the query is dynamically modified to track data from a set of data libraries accessed by the requesting entity.

Assignments (1)

Continuity (2)

Cited By (13)

US 12,204,563 US 12,204,593 US 12,248,484 US 12,265,525 US 12,271,389 US 12,287,790 US 12,393,631 US 12,436,963 US 12,585,638 US 12,613,864 US 12,639,379 US 12,650,965 US 12,670,152