CA2317166A1 - Metadata model - Google Patents
Metadata model Download PDFInfo
- Publication number
- CA2317166A1 CA2317166A1 CA002317166A CA2317166A CA2317166A1 CA 2317166 A1 CA2317166 A1 CA 2317166A1 CA 002317166 A CA002317166 A CA 002317166A CA 2317166 A CA2317166 A CA 2317166A CA 2317166 A1 CA2317166 A1 CA 2317166A1
- Authority
- CA
- Canada
- Prior art keywords
- model
- objects
- business
- metadata
- data access
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 claims 2
- 239000002131 composite material Substances 0.000 claims 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A metadata model defines model objects to represent one or more data sources. The metadata model comprises a data access layer, a business layer and a package layer The data access layer contains data access model objects. The data access model objects include a data access model object that describes how to retrieve data from the data sources. The business layer contains business model objects The business model objects include a business model object that describes a business view of data in the data sources The package layer contains package model objects which reference subsets of business model objects.
Claims (24)
1. A metadata model defining model objects to represent one or more data sources, the metadata model comprising:
a data access layer containing data access model objects, the data access model objects including a data access model object that describes how to retrieve data from the data sources;
a business layer containing business model objects, the business model objects including a business model object that describes a business view of data in the data sources; and a package layer containing package model objects, the package model objects including a package model object which reference subsets of business model objects.
a data access layer containing data access model objects, the data access model objects including a data access model object that describes how to retrieve data from the data sources;
a business layer containing business model objects, the business model objects including a business model object that describes a business view of data in the data sources; and a package layer containing package model objects, the package model objects including a package model object which reference subsets of business model objects.
2. The metadata model as claimed in claim 1, wherein the data access model objects include a data access model object that is constructed from metadata in the data sources.
3. The metadata model as claimed in claim 1, wherein the business model objects include a business model object that is transformed from the data access object.
4. The metadata model as claimed in claim 1, wherein the business model objects include a business model object that is imported from a metadata repository.
5. The metadata model as claimed in claim 1, wherein a business model object describes a business rule.
6. The metadata model as claimed in claim 5, wherein the business model object that describes a business rule is a calculation.
7. The metadata model as claimed in claim 5, wherein the business model object that describes a business rule is a filter.
8. The metadata model as claimed in claim 5, wherein the business model object that describes a business rule is a prompt.
9. The metadata model as claimed in claim 1, wherein a business model object describes a display rule.
10. The metadata model as claimed in claim 9, wherein a business model object that describes a display rule is a display style.
11. The metadata model as claimed in claim 1, wherein the package model objects include a package model object that is imported from a metadata repository.
12. The metadata model as claimed in claim 1, wherein the data sources include a database that contains a table having columns;
the data access model objects include table objects that describe definitions of the tables contained in the data sources, and column objects that describe definitions of the columns of the tables contained in the data sources; and the business model objects include entities that are constructed based on the table objects in the data access layer, and attributes that are constructed based on the column objects in the data access layer
the data access model objects include table objects that describe definitions of the tables contained in the data sources, and column objects that describe definitions of the columns of the tables contained in the data sources; and the business model objects include entities that are constructed based on the table objects in the data access layer, and attributes that are constructed based on the column objects in the data access layer
13. The metadata model as claimed in claim 1, wherein the data sources include one or more files;
the data access model objects include file objects that describe definitions of the files contained in the data sources; and the business model objects include entities that are constructed based on the file objects in the data access layer.
the data access model objects include file objects that describe definitions of the files contained in the data sources; and the business model objects include entities that are constructed based on the file objects in the data access layer.
14. The metadata model as claimed in claim 1, wherein the data sources include one or more cubes;
the data access model objects include cube objects that describe definitions of the cubes contained in the data sources; and the business model objects include entities that are constructed based on the cube objects in the data access layer.
the data access model objects include cube objects that describe definitions of the cubes contained in the data sources; and the business model objects include entities that are constructed based on the cube objects in the data access layer.
15. A metadata model containing model objects representing one or more data sources, the data sources containing tables having columns, the metadata model comprising:
a data access layer containing data access model objects, the data access model objects including table objects that describe definitions of the tables contained in the data sources, and column objects that describe definitions of the columns of the tables contained in the data sources;
a business layer containing business model objects, the business model objects including entities that are constructed based on the table objects in the data access layer, and attributes that are constructed based on the column objects in the data access layer;
and a package layer containing package model objects, the package model objects including a package model object that defines a subset of the business model objects.
a data access layer containing data access model objects, the data access model objects including table objects that describe definitions of the tables contained in the data sources, and column objects that describe definitions of the columns of the tables contained in the data sources;
a business layer containing business model objects, the business model objects including entities that are constructed based on the table objects in the data access layer, and attributes that are constructed based on the column objects in the data access layer;
and a package layer containing package model objects, the package model objects including a package model object that defines a subset of the business model objects.
16. The metadata model as claimed in claim 15, wherein the data access model objects further include a data access join that describe relationship between multiple table objects.
17. The metadata model as claimed in claim 15, wherein the data access model objects further include a data access key that is a collection of columns whose composite value is distinct for all rows in a table in the data sources.
18. The metadata model as claimed in claim 17, wherein the business model objects further include a business key that is constructed based on the data access key.
19. The metadata model as claimed in claim 15, wherein the business model objects further include a business join that describe relationship between multiple entities.
20. The metadata model as claimed in claim 19, wherein the business join is a containment join representing a strong relationship between entities.
21. The metadata model as claimed in claim 19, wherein the business join is a reference join representing a relationship between entities, one of which entities functions as a look-up table.
22. The metadata model as claimed in claim 15, wherein the business model objects further include a subtype relationship that defines an inheritance relationship between two business entities.
23. The metadata model as claimed in claim 15, wherein the data sources further include one or more views, and the data access layer contains table objects that are created based on definitions of the views and a list of columns that is obtained from the views included in the data sources.
24. The metadata model as claimed in claim 15, wherein the data sources further include one or more stored procedures, and the data access layer contains a list of columns that is obtained from the stored procedures included in the data sources.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CA2317166A CA2317166C (en) | 1999-09-03 | 2000-08-31 | Metadata model |
Applications Claiming Priority (5)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CA2,281,331 | 1999-09-03 | ||
| CA002281331A CA2281331A1 (en) | 1999-09-03 | 1999-09-03 | Database management system |
| CA2317166A CA2317166C (en) | 1999-09-03 | 2000-08-31 | Metadata model |
| US09/653,035 US6662188B1 (en) | 1999-09-03 | 2000-09-01 | Metadata model |
| US09/654,744 US6609123B1 (en) | 1999-09-03 | 2000-09-01 | Query engine and method for querying data using metadata model |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CA2317166A1 true CA2317166A1 (en) | 2001-03-03 |
| CA2317166C CA2317166C (en) | 2010-03-23 |
Family
ID=32180539
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA2317166A Expired - Lifetime CA2317166C (en) | 1999-09-03 | 2000-08-31 | Metadata model |
Country Status (1)
| Country | Link |
|---|---|
| CA (1) | CA2317166C (en) |
-
2000
- 2000-08-31 CA CA2317166A patent/CA2317166C/en not_active Expired - Lifetime
Also Published As
| Publication number | Publication date |
|---|---|
| CA2317166C (en) | 2010-03-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7136866B2 (en) | Media identifier registry | |
| WO2005111780A3 (en) | Property metadata navigation and assigment | |
| Davies | Still building the memex | |
| WO2005098654A3 (en) | User-definable hierarchy for database management | |
| WO2002025471A3 (en) | Method and apparatus for structuring, maintaining, and using families of data | |
| MXPA05010224A (en) | System and method utilizing virtual folders. | |
| WO2006000748A3 (en) | Data storage and retrieval | |
| CA2477126A1 (en) | Support for multiple content-management data models | |
| WO2006089092A3 (en) | Hierarchal data management | |
| WO2002001384A3 (en) | Database system, particularly for multimedia objects | |
| WO2005098593A3 (en) | Custom entities and fields in a multi-tenant database system | |
| CA2468584A1 (en) | File system for displaying items of different types and from different physical locations | |
| WO2008052133A3 (en) | Tracking changing state data to assist in computer network security | |
| CA2117846A1 (en) | Computer Method and Storage Structure for Storing and Accessing Multidimensional Data | |
| EP1081611A3 (en) | Query engine and method for Querying data using metadata model | |
| WO2006107772A3 (en) | System and methods for facilitating a linear grid database with data organization by dimension | |
| WO2007148289A3 (en) | Representing digital content metadata | |
| WO2001082118A3 (en) | Selectively auditing accesses to rows within a relational database at a database server | |
| WO2000057311A3 (en) | Method and system for manipulating data from multiple sources | |
| EP1164508A3 (en) | Common spool files for maintaining join indexes | |
| CA2317166A1 (en) | Metadata model | |
| CA2317194A1 (en) | Query engine and method for querying data using metadata model | |
| Macgregor | Collectionâlevel descriptions: metadata of the future? | |
| Lakshmanan et al. | Efficacious data cube exploration by semantic summarization and compression | |
| Abiteboul | Object database support for digital libraries |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| EEER | Examination request | ||
| MKEX | Expiry |
Effective date: 20200831 |
|
| MKEX | Expiry |
Effective date: 20200831 |