Repackageable virtualized transparent access to heterogeneous data sources

• US 9,953,099 B2
• Filed: 12/17/2010
• Issued: 04/24/2018
• Est. Priority Date: 12/17/2010
• Status: Active Grant

• Current Assignee: DST Health Solutions Incorporated (SS&C Technologies Holdings Incorporated)
• Original Assignee: DST Health Solutions Incorporated (SS&C Technologies Holdings Incorporated)
• Inventors: Creel, Christopher T.
• Primary Examiner(s): Pham, Tuan A
• Assistant Examiner(s): Gurmu, Muluemebet
• Application Number:
  US12/971,541
• Publication Number:
  US 20120158699A1
• Time in Patent Office: 2,685 Days
• Field of Search: 707722
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation

Abstract

A transparent data access interface/layer for repackageable virtualized transparent access to heterogeneous business process data sources, internally maintained or outsourced, is disclosed. This data access interface provides substantially real time customer/client specific, i.e. transparent, access to a customer/client generic enterprise storage and data processing architecture, such as an architecture operated by a business process outsourcing organization (“BPO”), which includes multiple disparate/heterogeneous data sources, having disparate formats and access methodologies, storing and processing customer/client specific data for multiple customers, while also permitting similarly transparent access across the enterprise storage architecture, e.g. across multiple customers/clients, such as for BPO-internal processing and reporting requirements. The data stored in the data sources may include data collected/received from the customer of the BPO, such as data identifying the BPO'"'"'s customer'"'"'s customers/clients and/or business processing rules or algorithms, data received/collected from the customers/clients of the BPO'"'"'s customer, such as transactional data, e.g. insurance claims, etc., data calculated or computed by the BPO based on stored or collected data, data representative of business processing rules developed by the BPO, such as rules for maintaining customer specific service level agreements, or combinations thereof.

Claims

1. A method of accessing a plurality of heterogeneous data sources, each of the plurality of heterogeneous data sources characterized by a heterogeneity different from a heterogeneity of at least one other of the plurality of heterogeneous data sources, the plurality of heterogeneous data sources being operative to store a plurality of data items, each of the plurality of data items being associated with at least one of a plurality of entities, the method comprising:

providing a data source identification processor operative to store association data representative of at least an association between each of the plurality of entities and each of the plurality of heterogeneous data sources and further representative of an association between each of the plurality of entities and each of the plurality of data items and in which each of the plurality of heterogeneous data sources each of the plurality of data items is stored, the data source identification processor being further operative to store access data in a database coupled therewith, the access data representative of the heterogeneity of each of the plurality of heterogeneous data sources, the heterogeneity being indicative of one or more characteristics of the data items stored in each of the plurality of heterogeneous data sources;

receiving a first request from a requestor specifying a first operation associated with at least one of the plurality of entities;

determining, by the data source identification processor, based on the specified at least one of the plurality of entities, a subset of the plurality of heterogeneous data sources to which the first operation should be performed;

determining, by the data source identification processor, based on the specified at least one of the plurality of entities, the heterogeneity of each of the determined subset of heterogeneous data sources;

generating and sending a data source request to each of the determined subset of the plurality of heterogeneous data sources, each data source request being generated based on the access data stored in the database to be compatible with the heterogeneity of the data source to which it is being sent, and specifying the first operation to be performed;

receiving, in response to the sending, at least one result of the performance of the first operation from at least one of the determined subset of the heterogeneous data sources;

augmenting each of the received at least one result with an identifier which identifies the entity of the specified at least one of the plurality of entities associated therewith; and

providing the augmented at least one result to the requestor.

2. The method of claim 1 wherein the heterogeneity of each of the plurality of heterogeneous data sources comprises at least one of file format, access protocol, query language, data representation, inter-data source relationship, or combinations thereof.

3. The method of claim 1 wherein each of the plurality of heterogeneous data sources is operative to store at least one of the plurality of data items.

4. The method of claim 1 wherein the first operation comprises one of a read operation, a store operation, an update operation or a combination thereof.

5. The method of claim 1 wherein the first operation further specifies a subset of the plurality of data items associated with the at least one of the plurality of entities with respect to which the first operation is to be performed.

6. The method of claim 1 wherein the determining further comprises accessing the association data and the access data based on the at least one of the plurality of entities associated with the first operation.

7. The method of claim 1 wherein the augmenting further comprises homogenizing each of the at least one result prior to the providing to remove the heterogeneity of the at least one of the determined subset of the heterogeneous data sources from which the at least one result was received.

8. The method of claim 1 wherein the first request further specifies the first operation associated with the at least one entity and a second entity, different therefrom, of the plurality of entities, the providing further comprising providing only the augmented at least one result associated with the at least one entity to the requestor.

9. The method of claim 1 wherein each of the data source requests are sent substantially simultaneously.

10. The method of claim 1 wherein the determined subset of the plurality of heterogeneous data sources comprises all of the plurality of heterogeneous data sources.

11. The method of claim 1 further comprising:

providing a first interface associated with a first entity of the plurality of entities;

receiving the first request via the first interface from the requestor, wherein the first request does not identify the first entity; and

associating the first entity with the first request based on receipt of the first request via the first interface and the association of the first entity with the first interface.

12. The method of claim 11 wherein the first interface is perceived as a database table specific to the first entity.

13. The method of claim 1 wherein at least one of the plurality of heterogeneous data sources is operated by an entity different from another entity which operates another of the plurality of heterogeneous data sources.

14. The method of claim 1 wherein the data source identification processor and the plurality of heterogeneous data sources are operated by the same entity.

15. A system for providing access to a plurality of heterogeneous data sources, each of the plurality of heterogeneous data sources characterized by a heterogeneity different from a heterogeneity of at least one other of the plurality of heterogeneous data sources, the plurality of heterogeneous data sources being operative to store a plurality of data items, each of the plurality of data items being associated with at least one of a plurality of entities, the system comprising:

a data source identification processor operative to store association data representative of at least an association between each of the plurality of entities and each of the plurality of heterogeneous data sources and further representative of an association between each of the plurality of entities and each of the plurality of data items and in which each of the plurality of heterogeneous data sources each of the plurality of data items is stored, the data source identification processor being further operative to store access data in a database coupled therewith, the access data representative of the heterogeneity of each of the plurality of heterogeneous data sources, the heterogeneity being indicative of one or more characteristics of the data items stored in each of the plurality of heterogeneous data sources;

a request interface operative to receive a first request from a requestor wherein the first request specifies a first operation associated with at least one of the plurality of entities;

the data source identification processor being coupled with the request interface and further operative, based on the specified at least one of the plurality of entities, to determine a subset of the plurality of heterogeneous data sources to which the first operation should be performed and to determine the heterogeneity of each of the determined subset of heterogeneous data sources;

the system further comprising a request generator coupled with the data source identification processor and operative to generate and send a data source request to each of the determined subset of the plurality of heterogeneous data sources, each data source request being generated based on the access data stored in the database to be compatible with the heterogeneity of the data source to which it is being sent, and specifying the first operation to be performed; and

a result processor operative to receive, in response to the sending, at least one result of the performance of the first operation from at least one of the determined subset of the heterogeneous data sources, the result processor being further operative to augment each of the received at least one result with an identifier which identifies the entity of the specified at least one of the plurality of entities associated therewith, and provide the augmented at least one result to the requestor.

16. The system of claim 15 wherein the heterogeneity of each of the plurality of heterogeneous data sources comprises at least one of file format, access protocol, query language, data representation, inter-data source relationship, or combinations thereof.

17. The system of claim 15 wherein each of the plurality of heterogeneous data sources is operative to store at least one of the plurality of data items.

18. The system of claim 15 wherein the first operation comprises one of a read operation, a store operation, an update operation or a combination thereof.

19. The system of claim 15 wherein the first operation further specifies a subset of the plurality of data items associated with the at least one of the plurality of entities with respect to which the first operation is to be performed.

20. The system of claim 15 wherein the data source identification processor is further operative to access the association data and the access data based on the at least one of the plurality of entities associated with the first operation.

21. The system of claim 15 wherein the result processor is further operative to homogenize each of the at least one result, prior to the provision of the augmented at least one result, to remove the heterogeneity of the at least one of the determined subset of the heterogeneous data sources from which the at least one result was received.

22. The system of claim 15 wherein the first request further specifies the first operation associated with the at least one entity and a second entity, different therefrom, of the plurality of entities, the result processor being further operative to provide only the augmented at least one result associated with the at least one entity to the requestor.

23. The system of claim 15 wherein each of the data source requests are sent substantially simultaneously.

24. The system of claim 15 wherein the determined subset of the plurality of heterogeneous data sources comprises all of the plurality of heterogeneous data sources.

25. The system of claim 15 further comprising:

a first interface associated with a first entity of the plurality of entities, the first interface being operative to receive the first request via the first interface from the requestor, wherein the first request does not identify the first entity, and further operative to associate the first entity with the first request based on receipt of the first request via the first interface and the association of the first entity with the first interface.

26. The system of claim 25 wherein the first interface is perceived as a database table specific to the first entity.

27. The system of claim 15 wherein at least one of the plurality of heterogeneous data sources is operated by an entity different from another entity which operates another of the plurality of heterogeneous data sources.

28. The system of claim 15 wherein the data source identification processor and the plurality of heterogeneous data sources are operated by the same entity.

29. A system for providing access to a plurality of heterogeneous data sources, each of the plurality of heterogeneous data sources characterized by a heterogeneity different from a heterogeneity of at least one other of the plurality of heterogeneous data sources, the plurality of heterogeneous data sources being operative to store a plurality of data items, each of the plurality of data items being associated with at least one of a plurality of entities, the system comprising a processor and a memory coupled with the processor, the system further comprising:

first logic stored in the memory and executable by the processor to store association data representative of at least an association between each of the plurality of entities and each of the plurality of heterogeneous data sources and further representative of an association between each of the plurality of entities and each of the plurality of data items and in which each of the plurality of heterogeneous data sources each of the plurality of data items is stored, the first logic being further executable by the processor to store access data in a database coupled therewith, the access data representative of the heterogeneity of each of the plurality of heterogeneous data sources, the heterogeneity being indicative of one or more characteristics of the data items stored in each of the plurality of heterogeneous data sources;

second logic stored in the memory and executable by the processor to receive a first request from a requestor wherein the first request specifies a first operation associated with at least one of the plurality of entities;

the first logic being coupled with the second logic, the first logic being further operative to, based on the specified at least one of the plurality of entities, determine a subset of the plurality of heterogeneous data sources to which the first operation should be performed and to determine the heterogeneity of each of the determined subset of heterogeneous data sources;

the system further comprising third logic stored in the memory and executable by the processor to generate and send a data source request to each of the determined subset of the plurality of heterogeneous data sources, each data source request being generated based on the access data stored in the database to be compatible with the heterogeneity of the data source to which it is being sent, and specifying the first operation to be performed; and

fourth logic stored in the memory and executable by the processor to receive, in response to the sending, at least one result of the performance of the first operation from at least one of the determined subset of the heterogeneous data sources, the fourth logic being further executable by the processor to augment each of the received at least one result with an identifier which identifies the entity of the specified at least one of the plurality of entities associated therewith, and provide the augmented at least one result to the requestor.