Methods for data warehousing based on heterogenous databases
First Claim
1. A method for establishing a data warehouse from a plurality of source databases including at least one relational database and at least one object-oriented database, comprising the steps of:
- a. integrating the schema of said plurality of source databases into a global schema, including resolving semantic conflicts between said source databases, and b. establishing a frame metadata model for describing data stored in said local databases, said frame metadata model including means for describing any constraints developed during schema integration and further including means for describing relationships between data stored in local object-oriented databases.
0 Assignments
0 Petitions
Accused Products
Abstract
According to the present invention there is provided a method for establishing a data warehouse capable from a plurality of source databases including at least one relational database and at least one object-oriented database, comprising the steps of: integrating the schema of said plurality of source databases into a global schema, including resolving semantic conflicts between said source databases, and establishing a frame metadata model for describing data stored in said local databases, said frame metadata model including means for describing any constraints developed during schema integration and further including means for describing relationships between data stored in local object-oriented databases.
-
Citations
33 Claims
-
1. A method for establishing a data warehouse from a plurality of source databases including at least one relational database and at least one object-oriented database, comprising the steps of:
-
a. integrating the schema of said plurality of source databases into a global schema, including resolving semantic conflicts between said source databases, and b. establishing a frame metadata model for describing data stored in said local databases, said frame metadata model including means for describing any constraints developed during schema integration and further including means for describing relationships between data stored in local object-oriented databases. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)
-
-
18. An architecture for a data warehouse comprising:
- a plurality of local databases including at least one relational database and at least one object-oriented database, a global schema formed from integrating the schema of said local databases, a frame metadata model for describing data in said local databases and for describing relationships between data in said at least one object oriented database and for describing any constraints derived during schema integration, a star schema for abstracting data from said local databases into a data cube for analysis, and means for querying said data cube.
- View Dependent Claims (19, 20, 21, 22, 23, 24, 25)
-
26. A data warehouse comprising a plurality of local databases including at least one relational database and at least one object-oriented database, comprising:
- means for abstracting data from said local databases for analysis and means for querying said abstracted data, wherein said means for abstracting data is able to present said abstracted data for analysis in either relational or object-oriented views at the request of a user.
- 27. A method for integrating the schema of a plurality of local databases wherein said local database schemas are integrated in pairs, the integration of a pair of local database schemas including the resolving of semantic conflicts and merging of classes and relationships, and wherein a frame metadata model is established for describing the contents of said integrated local databases including any constraints established during said schema integration.
Specification