Method and system using date/time mutation to return data to Java applications

• US 7,836,096 B2
• Filed: 12/14/2006
• Issued: 11/16/2010
• Est. Priority Date: 12/14/2006
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Weihrauch, Maryela E., Ostler, Paul A., Lee, Bilung
• Primary Examiner(s): Trujillo; James
• Assistant Examiner(s): Casanova; Jorge A
• Application Number:
  US11/611,025
• Publication Number:
  US 20080147594A1
• Time in Patent Office: 1,433 Days
• Field of Search: 707/999.101, 707/999.102, 707/999.103, 707/802, 707/803
• US Class Current: 707/803
• CPC Class Codes: G06F 16/2393 Updating materialised views
• CPC Class Codes: G06F 16/24552 Database cache management
• CPC Class Codes: G06F 16/2477 Temporal data queries

Abstract

The present invention provides a method, computer program product and article for creating and reusing a value object for data that is requested a first time and again in subsequent data requests in related result sets. Mutation directives and an associated methodology are presented in one of four different levels which permit the present invention to operate within the JDBC standard.

Claims

1. A method for creating a data object in response to data requested on a first instance and reusing said created data object in a subsequent request, comprising:

establishing a mutation directive with an associated value;

inheriting said mutation directive into one or more mutation levels in a predetermined sequence, receiving a result set in response to an information query, wherein said step of inheriting occurs sequentially in a predetermined manner by inheriting said value of said mutation directive first into a data source, second into a connection, third into a statement, and fourth into a result set;

determining a data object for a column of said result set for one or more of a specific date, time, or timestamp in relation to said mutation directive value, returning said determined data object; and

closing each of said one or more mutation levels.

2. The method of claim 1, wherein said step of determining includes one of creating, mutating or retrieving said data object in relation to active state of said mutation directive.

3. The method of claim 2, wherein said active state is one of either ON or OFF.

4. The method of claim 3, wherein said value of said mutation directive is set to permit a database command sequence to recycle/mutate said data object.

5. The method of claim 4, wherein said database command sequence is a database driver and said data object is one of a date/time/timestamp data object.

6. The method of claim 3, wherein said value of said mutation directive is set to not permit a database command sequence to recycle/mutate said data object.

7. The method of claim 6, wherein said database command sequence is a database driver and said data object is one of a date/time/timestamp data object.

8. The method of claim 1, further comprising the step of creating an array for said data object wherein said array is of a dimension in relation to a number of columns in said result set.

9. The method of claim 8, wherein said data object for a column is limited to one of a specific date, time, or timestamp in the predetermined row of the result set in relation to said result set.

10. The method of claim 1, wherein the mutation directive is set in any of and any combination of the data source, the connection, the statement and the result set.

11. The method of claim 10, wherein said mutation directive is set a value of OFF and the step of determining a data object includes creating said data.

12. The method of claim 10, wherein said mutation directive is set a value of ON.

13. The method of claim 12, wherein said data object is created only once per column in said result set.

14. The method of claim 13, wherein an array is used to cache said data object.

15. A computer program product stored on a computer usable medium comprising:

computer readable program code for causing a computer to control an execution of an application, the computer program product including program instructions for creating and reusing a value object for select data using a mutation directive comprising;

establishing a mutation directive with an associated value;

inheriting said mutation directive into one or more mutation levels in a predetermined sequence, wherein said step of inheriting occurs sequentially in a predetermined manner by inheriting said value of said mutation directive first into a data source, second into a connection, third into a statement, and fourth into a result set,

receiving a result set in response to an information query;

determining a data object for a column of said result set for one or more of a specific date, time, or timestamp in relation to said mutation directive value;

returning said determined data object; and

closing each of said one or more mutation levels.

16. An article comprising:

a machine-readable storage medium having a plurality of machine accessible instructions, which if executed by a machine, cause the machine to perform operations comprising;

establishing a mutation directive with an associated value,

inheriting said mutation directive into one or more mutation levels in a predetermined sequence, wherein said step of inheriting occurs sequentially in a predetermined manner by inheriting said value of said mutation directive first into a data source, second into a connection, third into a statement, and fourth into a result set,

receiving a result set in response to an information query,

determining a data object for a column of said result set for one or more of a specific date, time, or timestamp in relation to said mutation directive value,

returning said determined data object and

closing each of said one or more mutation levels,

wherein said data object is one of a date/time/timestamp data object.

17. The article of claim 16, wherein said step of determining includes one of creating, mutating or retrieving said data object in relation to active state of said mutation directive.

18. The article of claim 17, wherein said active state is one of either ON or OFF.

19. The article of claim 16, further comprising the step of creating an array for said data object wherein said array is of a dimension in relation to a number of columns in said result set.

20. A method for creating and reusing a value object for select data using a mutation directive comprising:

setting a mutation directive;

obtaining a connection from a data source

inheriting the mutation directive into the connection;

creating a statement from the connection;

inheriting the mutation directive from the connection into the statement;

receiving a result set from the statement as a result of a query;

inheriting the mutation directive from the statement into the result set;

identifying active status of said mutation statement in said result set in relation to said mutation directive;

positioning result set in a predetermined row in relation to said identifying active status step;

requesting a data object from a column of one or more of a specific date, time, or timestamp in the predetermined row of the result set in relation to said positioning step;

retrieving said data object in relation to said identifying step where if said identifying step is “

ON”

retrieving said data object from an array cached at predetermined column position, and mutating said data object in relation to value received from data source, or if said identifying step is “

OFF”

or if there is no data object stored in said array, creating a new data object in relation to value received from data source;

returning said data object ;

closing said result set;

closing said statement; and

closing said connection.