Method and system to provide composite view of data from disparate data sources

• US 9,760,603 B2
• Filed: 05/11/2015
• Issued: 09/12/2017
• Est. Priority Date: 12/23/2003
• Status: Active Grant

• Current Assignee: Ip Ot Sub Ulc
• Original Assignee: Open Text Sa Ulc (Open Text Corporation)
• Inventors: Ebenstein, Hillary, Goodwin, Giles, Penston, George, Guttmann, Gregory, MacLeod, David, Althoff, Jeff
• Primary Examiner(s): Cortes, Howard
• Application Number:
  US14/709,209
• Publication Number:
  US 20150310064A1
• Time in Patent Office: 855 Days
• Field of Search: None
• CPC Class Codes: G06F 16/148 File search processing
• CPC Class Codes: G06F 16/156 Query results presentation
• CPC Class Codes: G06F 16/244 Grouping and aggregation
• CPC Class Codes: G06F 16/24535 of sub-queries or views
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: G06F 16/532 Query formulation, e.g. graphical querying
• CPC Class Codes: G06F 16/9038 Presentation of query results

Abstract

Systems and methods for defining a composite view and using the definition of the composite view to obtain, aggregate, analyze, and present data from a variety of data sources to a user. These systems and methods may allow for the definition of a visual framework to aggregate and display related data. This visual framework, or composite view, may in turn be composed of a master view and a set of subviews, each of which may display data collected from a particular data source according to a particular format. By interacting with the master view data from a variety of data sources can be displayed.

Claims

1. A method for aggregating and displaying data from a plurality of data sources, comprising:

a computer creating data models based on the plurality of data sources, the plurality of data sources storing data according to a variety of formats defining different data source fields, the data models containing user-selected data model fields corresponding to the different data source fields of the plurality of data sources;

the computer creating views based on a set of user-selected view fields, each view field in the set of view fields corresponding to a data model field in one of the data models;

the computer mapping a view field in a master view that is user-designated as searchable by a criterion with a view field in at least one subview from the views that is also designated as searchable by the criterion, wherein the mapping allows the master view and the at least one subview to display related data from different data sources of the plurality of data sources regardless of the variety of formats of the plurality of data sources or data models on which the master view and the at least one subview are based; and

the computer sending the master view and the at least one subview from the views as a composite view to the user device, wherein data displayed in the at least one subview is driven through user interaction with the master view.

2. The method according to claim 1, wherein the at least one subview comprises a set of subviews, wherein the plurality of data sources comprise disparate data sources, and wherein each subview of the set of subviews represents a data source of the disparate data sources, the data source having a particular format of the variety of formats.

3. The method according to claim 1, wherein the at least one subview comprises a set of subviews and wherein each subview of the set of subviews comprises a user interface displaying data collected from a data source of the plurality of data sources according to a particular format.

4. The method according to claim 1, wherein the at least one subview comprises multiple subviews of different sizes.

5. The method according to claim 1, wherein a data model field from the data models is user-selected as the searchable criterion and wherein user interaction with the searchable criterion in the master view causes display of a subview or a change to the at least one subview.

6. The method according to claim 1, wherein a first subview and a second subview of the at least one subviews are independently displayed on the user device in addition to the master view and wherein the first and second subviews display data collected from at least two different data sources of the plurality of data sources.

7. The method according to claim 6, wherein user interaction with the first subview changes the master view but not the second subview.

8. A computer program product for aggregating and displaying data from a plurality of data sources, the computer program product comprising at least one non-transitory computer readable medium storing instructions translatable by at least one processor to perform:

creating data models based on the plurality of data sources, the plurality of data sources storing data according to a variety of formats defining different data source fields, the data models containing user-selected data model fields corresponding to the different data source fields of the plurality of data sources;

creating views based on a set of user-selected view fields, each view field in the set of view fields corresponding to a data model field in one of the data models;

mapping a view field in a master view that is user-designated as searchable by a criterion with a view field in at least one subview from the views that is also designated as searchable by the criterion, wherein the mapping allows the master view and the at least one subview to display related data from different data sources of the plurality of data sources regardless of the variety of formats of the plurality of data sources or data models on which the master view and the at least one subview are based; and

sending the master view and the at least one subview from the views as a composite view to the user device, wherein data displayed in the at least one subview is driven through user interaction with the master view.

9. The computer program product of claim 8, wherein the at least one subview comprises a set of subviews, wherein the plurality of data sources comprise disparate data sources, and wherein each subview of the set of subviews represents a data source of the disparate data sources, the data source having a particular format of the variety of formats.

10. The computer program product of claim 8, wherein the at least one subview comprises a set of subviews and wherein each subview of the set of subviews comprises a user interface displaying data collected from a data source of the plurality of data sources according to a particular format.

11. The computer program product of claim 8, wherein the at least one subview comprises multiple subviews of different sizes.

12. The computer program product of claim 8, wherein a data model field from the data models is user-selected as the searchable criterion and wherein user interaction with the searchable criterion in the master view causes display of a subview or a change to the at least one subview.

13. The computer program product of claim 8, wherein a first subview and a second subview of the at least one subviews are independently displayed on the user device in addition to the master view and wherein the first and second subviews display data collected from at least two different data sources of the plurality of data sources.

14. The computer program product of claim 13, wherein user interaction with the first subview changes the master view but not the second subview.

15. A system for aggregating and displaying data from a plurality of data sources, the system comprising:

at least one processor;

at least one non-transitory computer readable medium; and

stored instructions translatable by the at least one processor to perform;

creating data models based on the plurality of data sources, the plurality of data sources storing data according to a variety of formats defining different data source fields, the data models containing user-selected data model fields corresponding to the different data source fields of the plurality of data sources;

creating views based on a set of user-selected view fields, each view field in the set of view fields corresponding to a data model field in one of the data models;

mapping a view field in a master view that is user-designated as searchable by a criterion with a view field in at least one subview from the views that is also designated as searchable by the criterion, wherein the mapping allows the master view and the at least one subview to display related data from different data sources of the plurality of data sources regardless of the variety of formats of the plurality of data sources or data models on which the master view and the at least one subview are based; and

sending the master view and the at least one subview from the views as a composite view to the user device, wherein data displayed in the at least one subview is driven through user interaction with the master view.

16. The system of claim 15, wherein the at least one subview comprises a set of subviews, wherein the plurality of data sources comprise disparate data sources, and wherein each subview of the set of subviews represents a data source of the disparate data sources, the data source having a particular format of the variety of formats.

17. The system of claim 15, wherein the at least one subview comprises a set of subviews and wherein each subview of the set of subviews comprises a user interface displaying data collected from a data source of the plurality of data sources according to a particular format.

18. The system of claim 15, wherein the at least one subview comprises multiple subviews of different sizes.

19. The system of claim 15, wherein a data model field from the data models is user-selected as the searchable criterion and wherein user interaction with the searchable criterion in the master view causes display of a subview or a change to the at least one subview.

20. The system of claim 15, wherein a first subview and a second subview of the at least one subviews are independently displayed on the user device in addition to the master view, wherein the first and second subviews display data collected from at least two different data sources of the plurality of data sources, and wherein user interaction with the first subview changes the master view but not the second subview.