摘要 |
A system, method and database design is provided for unifying data from a plurality of heterogeneous databases (130), each having business-context related data and a data access mechanism (910). A database is created (e.g., the UniDimNet) (210) which contains a node for each dimension of an industry. For each data source (130) which is accessible via the system, a set of data source specific dimensions (390) is created and mapped to the corresponding industry business context dimension(s). A set of templates (e.g., UniViews) (220) is created to query the data sources (130). Each UniView (220) contains a specific question for a specific dimension designed for a specific data source (172). UniViews query (900) the database they are associated with by using the data access mechanism (910) of the associated database. A central server(120) coordinates the system and facilitates use of the system through an interface (e.g., the UniViewer) (150). The UniViewer (150) allows a user to query the data sources by identifying an industry business context dimension, a dimension instance and at least one UniView (220). Multiple UniViews (220) can be combined, cached and saved to facilitate complex queries. |