METHOD AND SYSTEM TO PROVIDE COMPOSITE VIEW OF DATA FROM DISPARATE DATA SOURCES

• US 20150310064A1
• Filed: 05/11/2015
• Published: 10/29/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
• Granted Patent: US 9,760,603 B2
• Time in Patent Office: Days
• 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:

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 field in a master view that is designated as searchable by a criterion with a 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.