Coordinated configuration, management, and access across multiple data stores

• US 9,922,101 B1
• Filed: 06/28/2013
• Issued: 03/20/2018
• Est. Priority Date: 06/28/2013
• Status: Active Grant

• Current Assignee: Vmware LLC (Broadcom, Inc.), EMC Corporation (Dell Technologies Inc.)
• Original Assignee: EMC Corporation (Dell Technologies Inc.)
• Inventors: Reiner, David Stephen, Nanda, Nihar K., Hushon, Jr., John D., Brown, David R., Ramnarayanan, Jagannathan
• Primary Examiner(s): Cao, Phuong Thao
• Application Number:
  US13/931,134
• Time in Patent Office: 1,726 Days
• Field of Search: 707602
• CPC Class Codes: G06F 16/256 in federated or virtual databases

Abstract

Example embodiments of the present invention relate to a method, a system, and a computer program product for federated service requests of a logical data store comprising a plurality of heterogeneous data stores. The method includes providing a data abstraction services layer as a control plane for federated service requests of a logical data store, comprising a plurality of heterogeneous data stores, by an application operating on a processing device, receiving a service request at the data abstraction services layer from the application operating on the processing device directed to the logical data store, and returning results of the service request from the data abstraction services layer to the application operating on the processing device.

Claims

1. A computer-implemented method comprising:

providing a data abstraction services layer to receive and process service requests to a logical data store from an application operating on a processing device, the service requests comprising configuration service requests, provisioning service requests, and management service requests, the logical data store comprising a plurality of heterogeneous data stores, including at least a first data store with a first latency and a second data store with a second latency different than the first latency, wherein;

the logical data store utilizes a plurality of data sets residing in the plurality of heterogeneous data stores, each respective data set providing at least one link between a portion of a first data set from the first data store and a portion of a second data set from the second data store; and

a subset of the first and second data sets comprises a plurality of respective multi-latency tables, each respective multi-latency table providing at least one multi-latency link between at least a portion of a first table from the first data store and at least a portion of a second table from the second data store;

configuring the data abstraction services layer to automatically determine and present to the application a coherent view across the plurality of heterogeneous data stores, the coherent view configured to hide from the application information relating to at least a portion of the data attributes associated with the plurality of heterogeneous data stores and with the plurality of data sets, the hiding including hiding at least a portion of the data attributes relating to data latency;

receiving a service request at the data abstraction services layer from the application, the service request directed to the logical data store and including at least one of configuration service requests, provisioning service requests, and management service requests; and

returning results of the service request from the data abstraction services layer to the application operating on the processing device.

2. The method of claim 1 wherein providing a data abstraction services layer comprises:

gathering data attributes regarding the plurality of heterogeneous data stores and the plurality of data sets stored at respective ones of the plurality of heterogeneous data stores;

generating an abstraction of the plurality of heterogeneous data stores according to the gathered data attributes; and

presenting the abstraction of the plurality of heterogeneous data stores to the application.

3. The method of claim 2:

wherein gathering data attributes regarding the plurality of heterogeneous data stores comprises;

discovering data sets from the plurality of heterogeneous data stores; and

describing the discovered data sets according to the data attributes; and

wherein generating an abstraction of the plurality of heterogeneous data stores according to the gathered data attributes comprises;

masking data attributes regarding data stored in the data sets at the plurality of heterogeneous data stores; and

providing simplified operation across the plurality of heterogeneous data stores.

4. The method of claim 3 wherein masking data attributes regarding data stored in the data sets at the plurality of heterogeneous data stores comprises:

performing a semantic analysis of interrelationships among the discovered data sets; and

creating a mapping of data types and instances among the discovered data sets based on the semantic analysis.

5. The method of claim 4 wherein masking data attributes regarding data stored at the plurality of heterogeneous data stores further comprises masking at least one data attribute selected from the group consisting of:

data latency;

data state;

data locations;

data location hierarchies;

data replication;

data partitioning across stores;

compression;

encryption;

data model differences;

schema differences and mappings;

inter-data-store consistency management;

policy definition and enforcement;

performance acceleration techniques;

access authorization, authentication, audit;

access optimization;

query federation;

a choice of replication factors across partitions;

master-slave vs. peer replication; and

consistency, availability, and potential partition.

6. The method of claim 3 wherein providing simplified operation across the plurality of heterogeneous data stores comprises one or more of:

providing simplified provisioning across the plurality of heterogeneous data stores;

providing simplified configuration across the plurality of heterogeneous data stores; and

providing simplified management across the plurality of heterogeneous data stores.

7. The method of claim 2 wherein receiving a service request at the data abstraction services layer directed to the logical data store comprises:

receiving the service request from the application operating on the processing device;

determining service, request attributes regarding the service request received from the application;

generating subrequests according to the service request attributes and the data attributes regarding the plurality of heterogeneous data stores; and

submitting the subrequests to respective data sets according to the data attributes regarding the plurality of heterogeneous data stores.

8. The method of claim 7

wherein the service request comprises a query;

wherein generating subrequests according to the service request attributes and the data attributes regarding the plurality of heterogeneous data stores comprises performing query decomposition of the query received from the application; and

wherein submitting the subrequests to respective data sets according to the data attributes regarding the plurality of heterogeneous data stores comprises performing subquery orchestration among the subrequests and the data sets.

9. The method of claim 2 wherein returning results of the service request from the data abstraction services layer to the application operating on the processing device comprises:

gathering results from the plurality of heterogeneous data stores;

generating abstracted data store results according to the gathered results and the data attributes regarding the plurality of heterogeneous data stores; and

presenting the abstracted data store results to the application operating on the processing device.

10. The method of claim 9

wherein gathering results from the plurality of heterogeneous data stores comprises performing one or more of data movement, data filtering, and data combining;

and

wherein generating abstracted data store results according to the gathered results and the data attributes regarding the plurality of heterogeneous data stores comprises performing one or more of data annotation and data transformation.

11. The method of claim 1, wherein configuring the data abstraction services layer to automatically determine the coherent view further comprises:

describing at least a portion of data sets that are discovered in the plurality of heterogeneous data stores, according to respective data attributes associated with the data sets and data stores;

performing a semantic analysis of interrelationships among the discovered data sets;

creating a mapping of data types and instances among the discovered data sets based on the semantic analysis; and

masking at least a portion of the data attributes associated with at least one of the data sets and data stores.

12. A data management system comprising:

a processor;

a logical data store comprising a plurality of heterogeneous data store, including at least a first data store with a first latency and a second data store with a second latency different than the first latency, wherein;

the logical data store utilizes a plurality of data sets residing in the plurality of heterogeneous data stores, each respective data set providing at least one link between a portion of a first data set from the first data store and a portion of a second data set from the second data store; and

a subset of the first and second data sets comprises a plurality of respective multi-latency tables, each respective multi-latency table providing at least one multi-latency link between at least a portion of a first table from the first data store and at least a portion of a second table from the second data store;

memory storing computer executable code that, when executed on the processor, causes the system to provide data management, the computer executable code enabled to perform the operations of;

providing a data abstraction services layer to receive and process configuration service requests, provisioning service requests, and management service requests to the logical data store, by an application operating on a processing device;

configuring the data abstraction services layer to automatically determine and present to the application a coherent view across the plurality of heterogeneous data stores, the coherent view configured to hide from the application information relating to at least a portion of the data attributes associated with the plurality of heterogeneous data stores and with the plurality of data sets, the hiding including hiding at least a portion of the data attributes relating to data latency;

receiving a service request at the data abstraction services layer from the application, the service request directed to the logical data store, the service request selected from a group consisting of configuration service requests, provisioning service requests, and management service requests; and

returning results of the service request from the data abstraction services layer to the application operating on the processing device.

13. The method of claim 12 wherein providing a data abstraction services layer comprises:

gathering data attributes regarding the plurality of heterogeneous data stores and the plurality of data sets stored at respective ones of the plurality of heterogeneous data stores;

generating an abstraction of the plurality of heterogeneous data stores according to the gathered data attributes; and

presenting the abstraction of the plurality of heterogeneous data stores to the application.

14. The system of claim 13

wherein gathering data attributes regarding the plurality of heterogeneous data stores comprises:

discovering data sets from the plurality of heterogeneous data stores; and

describing the discovered data sets according to the data attributes; and

wherein generating an abstraction of the plurality of heterogeneous data stores according to the gathered data attributes comprises;

masking data attributes regarding data sets stored in the plurality of heterogeneous data stores; and

providing simplified operation across the plurality of heterogeneous data stores.

15. The system of claim 14 wherein masking data attributes regarding data stored in the data sets at the plurality of heterogeneous data stores comprises:

performing a semantic analysis of interrelationships among the discovered data sets; and

creating a mapping of data types and instances among the discovered data sets based on the semantic analysis.

16. The system of claim 14 wherein providing simplified operation across the plurality of heterogeneous data stores comprises one or more of:

providing simplified provisioning across the plurality of heterogeneous data stores;

providing simplified configuration across the plurality of heterogeneous data stores; and

providing simplified management across the plurality of heterogeneous data stores.

17. The system of claim 13 wherein receiving a service request at the data abstraction services layer directed to the logical data store comprises:

receiving the service request from the application operating on the processing device;

determining service request attributes regarding the service request received from the application;

generating subrequests according to the service request attributes and the data attributes regarding the plurality of heterogeneous data stores; and

submitting the subrequests to respective data sets according to the data attributes regarding the plurality of heterogeneous data stores.

18. The system of claim 17

wherein the service request comprises a query;

wherein generating subrequests according to the service request attributes and the data attributes regarding the plurality of heterogeneous data stores comprises performing query decomposition of the query received from the application; and

wherein submitting the subrequests to respective data sets according to the data attributes regarding the plurality of heterogeneous data stores comprises performing subquery orchestration among the subrequests and the data sets.

19. The system of claim 13 wherein returning results of the service request from the data abstraction services layer to the application operating on the processing device comprises:

gathering results from the plurality of heterogeneous data stores;

generating abstracted data store results according to the gathered results and the data attributes regarding the plurality of heterogeneous data stores; and

presenting the abstracted data store results to the application operating on the processing device.

20. The system of claim 19

wherein gathering results from the plurality of heterogeneous data stores comprises performing one or more of data movement, data filtering, and data combining;

and

wherein generating abstracted data store results according to the gathered results and the data attributes regarding the plurality of heterogeneous data stores comprises performing one or more of data annotation and data transformation.

21. A computer program product including a non-transitory computer readable medium storing computer program code that when executed on a processor of a computer causes the computer to:

provide a data abstraction services layer to receive and process service requests to a logical data store from an application operating on a processing device, the service requests comprising configuration service requests, provisioning service requests, and management service requests, the logical data store comprising a plurality of heterogeneous data stores, including at least a first data store with a first latency and a second data store with a second latency different than the first latency, wherein;

the logical data store utilizes a plurality of data sets residing in the plurality of heterogeneous data stores, each respective data set providing at least one link between a portion of a first data set from the first data store and a portion of a second data set from the second data store; and

a subset of the first and second data sets comprises a plurality of respective multi-latency tables, each respective multi-latency table providing at least one multi-latency link between at least a portion of a first table from the first data store and at least a portion of a second table from the second data store;

configure the data abstraction services layer to automatically determine and present to the application a coherent view across the plurality of heterogeneous data stores, the coherent view configured to hide from the application information relating to at least a portion of the data attributes associated with the plurality of heterogeneous data stores and with the plurality of data sets, the hiding including hiding at least a portion of the data attributes relating to data latency;

receive a service request at the data abstraction services layer from the application, the service request directed to the logical data store, the service request selected from a group consisting of configuration service requests, provisioning service requests, and management service requests; and

return results of the service request from the data abstraction services layer to the application operating on the processing device.