Method and system to provide composite view of components

• US 9,053,149 B2
• Filed: 12/22/2004
• Issued: 06/09/2015
• Est. Priority Date: 12/23/2003
• Status: Active Grant

• Current Assignee: Ip Ot Sub Ulc
• Original Assignee: Open TEXT SA (Open Text Corporation)
• Inventors: Ebenstein, Hillary, Goodwin, Giles, Penston, George, Guttmann, Gregory, MacLeod, David, Althoff, Jeff
• Primary Examiner(s): Baderman, Scott
• Assistant Examiner(s): Cortes, Howard
• Application Number:
  US11/021,588
• Publication Number:
  US 20140201190A1
• Time in Patent Office: 3,821 Days
• Field of Search: 707/1, 707/100, 707/102, 707/101, 707/104.1, 707/6, 707/7, 715/715, 715/520, 715/515, 715/503, 715/509, 715/516, 715/209, 715/210, 715/212, 715/220, 715/243, 715/246, 715/253, 715/215, 705/1
• US Class Current: 1/1
• 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:

creating, by a computer, 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 data model fields corresponding to the different data source fields of the plurality of data sources, wherein the data model fields are user-selected.

creating, by the computer, views based on a set of view fields, wherein the set of view fields are user-selected, each view field in the set of view fields corresponding to a data model field in one of the data models, one or more view fields of the set of view fields designated as searchable;

creating, by the computer, a composite view utilizing the views, the composite view configured to display related data from different data sources of the plurality of data sources through the data model fields of the data models in a substantially similar format, regardless of the variety of formats of the plurality of data sources, the composite view including a master view and at least one subview from the views, the creating including;

designating a view field in the master view as searchable by a criterion;

designating a view field in the at least one subview as searchable by the criterion; and

mapping the view field in the master view that is designated as searchable by the criterion with the view field in the at least one subview that is also designated as searchable by the criterion,

the searchable view field in the master view associated with data source fields from different data sources via data model fields such that a user interaction with the searchable view field in the master view causes display of the at least one subview or a change thereto based at least in part on data obtained from the different data sources using the data model fields and the data source fields; and

sending the composite view to a user device.

2. The method according to claim 1, wherein the at least one subview includes a first subview and a second subview and user interaction with a field in the first subview causes a change to the second subview.

3. The method according to claim 1, wherein the composite view is configured to be altered entirely based on interaction with the master view such that a user is prevented from having to manually mine the different data sources for the related data.

4. The method according to claim 1, wherein the mapping allows the master view and the at least one subview to display the related data from the different data sources regardless of format of the different data sources or data models on which the master view and the at least one subview are based.

5. The method according to claim 1, wherein the views exist independent of one another and independent of the composite view.

6. The method according to claim 1, further comprising:

generating, by the computer, one or more additional composite views utilizing the views.

7. The method according to claim 1, wherein the views comprise a chart, a form, a report, or a combination thereof.

8. A computer program product for aggregating and displaying data from a plurality of disparate 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 data model fields corresponding to the different data source fields of the plurality of data sources, wherein the data model fields are user-selected.

creating views based on a set of view fields, wherein the set of view fields are user-selected, each view field in the set of view fields corresponding to a data model field in one of the data models, one or more view fields of the set of view fields designated as searchable;

creating a composite view utilizing the views, the composite view configured to display related data from different data sources of the plurality of data sources through the data model fields of the data models in a substantially similar format, regardless of the variety of formats of the plurality of data sources, the composite view including a master view and at least one subview from the views, the creating including;

designating a view field in the master view as searchable by a criterion;

designating a view field in the at least one subview as searchable by the criterion; and

mapping the view field in the master view that is designated as searchable by the criterion with the view field in the at least one subview that is also designated as searchable by the criterion, the searchable view field in the master view associated with data source fields from different data sources via data model fields such that a user interaction with the searchable view field in the master view causes display of the at least one subview or a change thereto based at least in part on data obtained from the different data sources using the data model fields and the data source fields; and

sending the composite view to a user device.

9. The computer program product of claim 8, wherein the at least one subview includes a first subview and a second subview and user interaction with a field in the first subview causes a change to the second subview.

10. The computer program product of claim 8, wherein the composite view is configured to be altered entirely based on interaction with the master view such that a user is prevented from having to manually mine the different data sources for the related data.

11. The computer program product of claim 8, wherein the mapping allows the master view and the at least one subview to display the related data from the different data sources regardless of format of the different data sources or data models on which the master view and the at least one subview are based.

12. The computer program product of claim 8, wherein the views exist independent of one another and independent of the composite view.

13. The computer program product of claim 8, wherein the instructions are further translatable by the at least one processor to perform:

generating one or more additional composite views utilizing the views.

14. The computer program product of claim 8, wherein the views comprise a chart, a form, a report, or a combination thereof.

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

at least one processor; and

at least one non-transitory computer readable medium storing 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 data model fields corresponding to the different data source fields of the plurality of data sources, wherein the data model fields are user-selected;

creating views based on a set of view fields, wherein the set of view fields are user-selected, each view field in the set of view fields corresponding to a data model field in one of the data models, one or more view fields of the set of view fields designated as searchable;

creating a composite view utilizing the views, the composite view configured to display related data from different data sources of the plurality of data sources through the data model fields of the data models in a substantially similar format, regardless of the variety of formats of the plurality of data sources, the composite view including a master view and at least one subview from the views, the creating including;

designating a view field in the master view as searchable by a criterion;

designating a view field in the at least one subview as searchable by the criterion; and

mapping the view field in the master view that is designated as searchable by the criterion with the view field in the at least one subview that is also designated as searchable by the criterion, the searchable view field in the master view associated with data source fields from different data sources via data model fields such that a user interaction with the searchable view field in the master view causes display of the at least one subview or a change thereto based at least in part on data obtained from the different data sources using the data model fields and the data source fields; and

sending the composite view to a user device.

16. The system of claim 15, wherein the at least one subview includes a first subview and a second subview and user interaction with a field in the first subview causes a change to the second subview.

17. The system of claim 15, wherein the composite view is configured to be altered entirely based on interaction with the master view such that a user is prevented from having to manually mine the different data sources for the related data.

18. The system of claim 15, wherein the mapping allows the master view and the at least one subview to display the related data from the different data sources regardless of format of the different data sources or data models on which the master view and the at least one subview are based.

19. The system of claim 18, wherein the views exist independent of one another and independent of the composite view.

20. The system of claim 15, wherein the instructions are further translatable by the at least one processor to perform:

generating one or more additional composite views utilizing the views.

21. The system of claim 15, wherein the views comprise a chart, a form, a report, or a combination thereof.