Managing a single database management system

• US 10,628,421 B2
• Filed: 02/07/2017
• Issued: 04/21/2020
• Est. Priority Date: 02/07/2017
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Devarao, Praveen, Jose, Ashok V., Mitra, Alok, Pambalath, Smitha
• Primary Examiner(s): Le, Miranda
• Application Number:
  US15/426,988
• Publication Number:
  US 20180225314A1
• Time in Patent Office: 1,169 Days
• CPC Class Codes: G06F 16/212 with details for data modelling support
• CPC Class Codes: G06F 16/2455 Query execution

Abstract

A method, computer system, and a computer program product for managing a single database management system (DBMS) which interfaces with both a first and second application program is provided. A first data set corresponding to a first data format may be received by a DBMS interface engine. A second data set corresponding to a second data format may be received by the DBMS interface engine. A holistic data model to represent the first data set and the second dataset may be determined by analyzing the first data set and the second data set using the DBMS interface engine. The holistic data model may be structured by the DBMS interface engine with respect to a single database of the single DBMS.

Claims

1. A computer-implemented method for managing a single database management system (DBMS) which interfaces with both a first application program that indicates a first data format and a second application program that indicates a second data format, the method comprising:

receiving, by a DBMS interface engine from the first application program, a first data set corresponding to the first data format;

receiving, by the DBMS interface engine from the second application program, a second data set corresponding to the second data format, wherein the first data format differs from the second data format;

extracting, with respect to the first data set corresponding to the first data format, a format-specific data attribute;

performing, based on the format-specific data attribute with respect to the first data set, a data management action to the first data set for use in the holistic data model with respect to the single database management system;

compiling, in the single DBMS with respect to an unstructured image format, a set of spaces using an image processing technique from a set of image data within the received first data set or the received second data set;

constructing, in the single DBMS with respect to the unstructured image format, a set of edges based on a set of key image characteristics between a plurality of respective spaces of the set of spaces;

determining, by analyzing the first data set and the second data set using the DBMS interface engine, a holistic data model to represent the first data set and the second data set, wherein the holistic data model includes a first data construct based on the first data set and a second data construct based on the second data set, and wherein the holistic data model includes the set of edges;

structuring, by the DBMS interface engine, the holistic data model with respect to a single database of the single DBMS;

modeling, using a graph having a set of vertices and the set of edges, the holistic data model with respect to the single database of the single DBMS;

receiving, by the DBMS interface engine, a first query from the first application program that indicates the first data format;

receiving, by the DBMS interface engine, a second query from the second application program that indicates the second data format, wherein the first data format differs from the second data format;

searching, based on the first query from the first application program that indicates the first data format, the holistic data model with respect to the single database system;

searching, based on the second query from the second application program that indicates the second data format, the holistic data model with respect to the single database system;

resolving, both based on and in response to searching the single database of the single DBMS, a first valid search result for the first query;

resolving, both based on and in response to searching the single database of the single DBMS, a second valid search result for the second query;

providing, by the DBMS interface engine, the first valid search result responsive to the first query from the first application program that indicates the first data format, wherein the first valid search result for the first query is structured according to the first data format; and

providing, by the DBMS interface engine, the second valid search result responsive to the second query from the second application program that indicates the second data format, wherein the second valid search result for the second query is structured according to the second data format.

2. The method of claim 1, further comprising:

identifying, by the DBMS interface engine, that the first data format is a JavaScript Object Notation (JSON) format;

identifying, by the DBMS interface engine, that the second data format is a relational format;

providing, by the DBMS interface engine, the first valid search result using the JSON format; and

providing, by the DBMS interface engine, the second valid search result using the relational format.

3. The method of claim 1, further comprising:

identifying, by the DBMS interface engine, that the first data format is a relational format;

identifying, by the DBMS interface engine, that the second data format is a graph format;

providing, by the DBMS interface engine, the first valid search result using the relational format; and

providing, by the DBMS interface engine, the second valid search result using the graph format.

4. The method of claim 1, further comprising:

identifying, by the DBMS interface engine, that the first data format is a graph format;

identifying, by the DBMS interface engine, that the second data format is a JSON format;

providing, by the DBMS interface engine, the first valid search result using the graph format; and

providing, by the DBMS interface engine, the second valid search result using the JSON format.

5. The method of claim 1, further comprising:

selecting, by the DBMS interface engine, a JSON mode based on at least one data format having a JSON format;

searching, using the JSON mode, the single database of the single DBMS; and

resolving, using the JSON mode, at least one valid JSON search result.

6. The method of claim 1, further comprising:

selecting, by the DBMS interface engine, a relational mode based on at least one data format having a relational format;

searching, using the relational mode, the single database of the single DBMS; and

resolving, using the relational mode, at least one valid relational search result.

7. The method of claim 1, further comprising:

selecting, by the DBMS interface engine, a graph mode based on at least one data format having a graph format;

searching, using the graph mode, the single database of the single DBMS; and

resolving, using the graph mode, at least one valid graph search result.

8. The method of claim 1, further comprising:

detecting that both the first query from the first application program that indicates the first data format and the second query from the second application program that indicates the second data format are from a same application program, wherein the same application program includes both the first application program and the second application program.

9. The method of claim 1, further comprising:

compiling, in the DBMS with respect to a key-value format, a set of spaces which includes information related to a set of typologies;

constructing, in the DBMS with respect to the key-value format, a set of edges based on a set of key values of the key-value format; and

identifying, in the DBMS with respect to the key-value format, a set of keys which indicates a set of values.

10. The method of claim 1, further comprising:

compiling, in the DBMS with respect to a JSON format, a set of spaces which includes information related to a set of typologies;

identifying, in the DBMS with respect to the JSON format, a primary key;

structuring, in the DBMS with respect to the JSON format, a set of separate nodes to include a set of sub-documents; and

structuring, in the DBMS with respect to the JSON format, an array having a set of separate data which includes a set of values which has a key that uses an array index.

11. The method of claim 1, further comprising:

compiling, in the DBMS with respect to a relational format, a set of spaces which includes information related to a set of typologies; and

constructing, in the DBMS with respect to the relational format, a set of edges based on a relationship between a plurality of respective spaces of the set of spaces.

12. The method of claim 1, further comprising:

compiling, in the DBMS with respect to a relational format, a set of spaces which includes a respective node for a respective atomic value; and

constructing, in the DBMS with respect to the relational format, a set of edges based on a relationship between a plurality of respective same-column value nodes of the set of spaces.

13. The method of claim 1, further comprising:

compiling, in the DBMS with respect to an unstructured format, a set of spaces using a natural language processing technique; and

constructing, in the DBMS with respect to the unstructured format, a set of edges based on a set of key natural language characteristics between a plurality of respective spaces of the set of spaces.

14. The method of claim 1, further comprising:

detecting, by the DBMS interface engine, a transaction behavior parameter; and

configuring, by the DBMS interface engine, a transaction mode for which to operate management of the single DBMS.

15. A system for managing a single database management system (DBMS) which interfaces with both a first application program that indicates a first data format and a second application program that indicates a second data format, the system comprising:

a memory having a set of computer readable computer instructions, and

a processor for executing the set of computer readable instructions, the set of computer readable instructions including;

receiving, by a DBMS interface engine from the first application program, a first data set corresponding to the first data format;

receiving, by the DBMS interface engine from the second application program, a second data set corresponding to the second data format, wherein the first data format differs from the second data format;

extracting, with respect to the first data set corresponding to the first data format, a format-specific data attribute;

performing, based on the format-specific data attribute with respect to the first data set, a data management action to the first data set for use in the holistic data model with respect to the single database management system;

compiling, in the single DBMS with respect to an unstructured image format, a set of spaces using an image processing technique from a set of image data within the received first data set or the received second data set;

constructing, in the single DBMS with respect to the unstructured image format, a set of edges based on a set of key image characteristics between a plurality of respective spaces of the set of spaces;

determining, by analyzing the first data set and the second data set using the DBMS interface engine, a holistic data model to represent the first data set and the second data set, wherein the holistic data model includes a first data construct based on the first data set and a second data construct based on the second data set, and wherein the holistic data model includes the set of edges;

structuring, by the DBMS interface engine, the holistic data model with respect to a single database of the single DBMS;

modeling, using a graph having a set of vertices and the set of edges, the holistic data model with respect to the single database of the single DBMS;

receiving, by the DBMS interface engine, a first query from the first application program that indicates the first data format;

receiving, by the DBMS interface engine, a second query from the second application program that indicates the second data format, wherein the first data format differs from the second data format;

searching, based on the first query from the first application program that indicates the first data format, the holistic data model with respect to the single database system;

searching, based on the second query from the second application program that indicates the second data format, the holistic data model with respect to the single database system;

resolving, both based on and in response to searching the single database of the single DBMS, a first valid search result for the first query;

resolving, both based on and in response to searching the single database of the single DBMS, a second valid search result for the second query;

providing, by the DBMS interface engine, the first valid search result responsive to the first query from the first application program that indicates the first data format, wherein the first valid search result for the first query is structured according to the first data format; and

providing, by the DBMS interface engine, the second valid search result responsive to the second query from the second application program that indicates the second data format, wherein the second valid search result for the second query is structured according to the second data format.

16. A computer program product managing a single database management system (DBMS) which interfaces with both a first application program that indicates a first data format and a second application program that indicates a second data format, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a processor to cause the processor to perform a method comprising:

receiving, by a DBMS interface engine from the first application program, a first data set corresponding to the first data format;

receiving, by the DBMS interface engine from the second application program, a second data set corresponding to the second data format, wherein the first data format differs from the second data format;

extracting, with respect to the first data set corresponding to the first data format, a format-specific data attribute;

performing, based on the format-specific data attribute with respect to the first data set, a data management action to the first data set for use in the holistic data model with respect to the single database management system;

compiling, in the single DBMS with respect to an unstructured image format, a set of spaces using an image processing technique from a set of image data within the received first data set or the received second data set;

constructing, in the single DBMS with respect to the unstructured image format, a set of edges based on a set of key image characteristics between a plurality of respective spaces of the set of spaces;

determining, by analyzing the first data set and the second data set using the DBMS interface engine, a holistic data model to represent the first data set and the second data set, wherein the holistic data model includes a first data construct based on the first data set and a second data construct based on the second data set, and wherein the holistic data model includes the set of edges;

structuring, by the DBMS interface engine, the holistic data model with respect to a single database of the single DBMS;

modeling, using a graph having a set of vertices and the set of edges, the holistic data model with respect to the single database of the single DBMS;

receiving, by the DBMS interface engine, a first query from the first application program that indicates the first data format;

receiving, by the DBMS interface engine, a second query from the second application program that indicates the second data format, wherein the first data format differs from the second data format;

searching, based on the first query from the first application program that indicates the first data format, the holistic data model with respect to the single database system;

searching, based on the second query from the second application program that indicates the second data format, the holistic data model with respect to the single database system;

resolving, both based on and in response to searching the single database of the single DBMS, a first valid search result for the first query;

resolving, both based on and in response to searching the single database of the single DBMS, a second valid search result for the second query;

providing, by the DBMS interface engine, the first valid search result responsive to the first query from the first application program that indicates the first data format, wherein the first valid search result for the first query is structured according to the first data format; and

providing, by the DBMS interface engine, the second valid search result responsive to the second query from the second application program that indicates the second data format, wherein the second valid search result for the second query is structured according to the second data format.