DYNAMIC MAP TEMPLATE DISCOVERY AND MAP CREATION

• US 20130339393A1
• Filed: 05/31/2013
• Published: 12/19/2013
• Est. Priority Date: 06/18/2012
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Gaur, Nitin, Kaplinger, Todd E., Bhogal, Kulvir Singh, Berg, Douglas
• Granted Patent: US 9,798,746 B2
• Time in Patent Office: Days
• US Class Current: 707/792
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/24561 Intermediate data storage techniques for performance improvement

Abstract

A method, system and computer program product for dynamic map template discovery and map creation may include determining a frequency of use of a data object in a database and discovering a dynamic map template corresponding to the data object based on the frequency of use of the data object. The method may also include creating a dynamic map from the dynamic map template in response to discovering the dynamic map template.

Claims

1. A method for dynamic map template discovery and map creation, comprising:

determining, by a processor, a frequency of use of a data object in a database;

discovering, by the processor, a dynamic map template corresponding to the data object based on the frequency of use of the data object; and

creating a dynamic map from the dynamic map template in response to discovering the dynamic map template.

2. The method of claim 1, wherein discovering the dynamic map template comprises searching for the dynamic map template in response to the frequency of use of the data object exceeding a predetermined threshold.

3. The method of claim 1, further comprising loading the dynamic map in an in memory data grid.

4. The method of claim 1, further comprising:

analyzing database usage statistics to determine if the frequency of use of the data object exceeds a predetermined threshold; and

loading the data object in an in memory data grid in response to the frequency of use of the data object exceeding the predetermined threshold.

5. The method of claim 4, further comprising:

creating a dynamic map corresponding to the data object; and

loading the dynamic map in the in memory data grid.

6. The method of claim 4, wherein analyzing the database usage statistics comprises analyzing a frequency of access to a plurality of tables, columns and rows in the database.

7. The method of claim 1, further comprising performing a dynamic map discovery of maps in an in memory data grid in response to receiving a request for a map to access particular data.

8. The method of claim 1, further comprising:

receiving a request for a map to access particular data; and

determining if the requested map exists in an in memory data grid for accessing the particular data requested.

9. The method of claim 8, further comprising fetching the requested map for accessing the particular data in response to the requested map being discovered in the in memory data grid by a dynamic map discovery engine.

10. The method of claim 9, further comprising comparing the requested map to a plurality of dynamic map templates for a map template corresponding to the requested map in response to the requested map not being discovered in the in memory data grid by the dynamic map discovery engine.

11. The method of claim 10. further comprising:

dynamically creating a new map in response to a name of the requested map matching a regular expression of one of the plurality of dynamic map templates;

assigning the name of the requested map to the new map; and

loading the new map and associated data in the in memory data grid.

12. The method of claim 11, wherein the new map inherits the setting of the one of the dynamic map templates.

13-20. -20. (canceled)

21. A method for dynamic map template discovery and map creation, comprising:

determining, by a processor, a frequency of use of a data object in a database;

discovering, by the processor, a dynamic map template corresponding to the data object based on the frequency of use of the data object;

creating a dynamic map from the dynamic map template in response to discovering the dynamic map template;

analyzing database usage statistics to determine if the frequency of use of the data object exceeds a predetermined threshold;

loading the data object in an in memory data grid in response to the frequency of use of the data object exceeding the predetermined threshold;

creating a dynamic map corresponding to the data object; and

loading the dynamic map in the in memory data grid.

22. The method of claim 21, further comprising performing a dynamic map discovery of maps in the in memory data grid in response to receiving a request for a map to access particular data.

23. A method for dynamic map template discovery and map creation, comprising:

determining, by a processor, a frequency of use of a data object in a database;

discovering, by the processor, a dynamic map template corresponding to the data object based on the frequency of use of the data object;

creating a dynamic map from the dynamic map template in response to discovering the dynamic map template;

receiving a request for a map to access particular data; and

determining if the requested map exists in an in memory data grid for accessing the particular data requested.

24. The method of claim 23, further comprising fetching the requested map for accessing the particular data in response to the requested map being discovered in the in memory data grid by a dynamic map discovery engine.

25. The method of claim 24, further comprising comparing the requested map to a plurality of dynamic map templates for a map template corresponding to the requested map in response to the requested map not being discovered in the in memory data grid by the dynamic map discovery engine.

26. The method of claim 25. further comprising:

dynamically creating a new map in response to a name of the requested map matching a regular expression of one of the plurality of dynamic map templates;

assigning the name of the requested map to the new map; and

loading the new map and associated data in the in memory data grid.

27. The method of claim 26, wherein the new map inherits the setting of the one of the dynamic map templates.