Rich Database Metadata Model that Captures Application Relationships, Mappings, Constraints, and Complex Data Structures
First Claim
1. A method for capturing rich database metadata, comprising:
- capturing partitioned column metadata of a database, for columns partitioned by one or more applications referencing the database, as mappings defined by a plurality of constraint statements;
defining non-standard user-defined types of the database stored by the one or more applications referencing the database according to a schema;
defining physical representations of the columns of the database according to the schema, wherein the physical representations of the columns are controlled by the one or more applications referencing the database;
storing the defined mappings, the defined user-defined types, and the defined physical representations of columns to a catalog of the database; and
managing application constraints, the non-standard user-defined types, and the physical representation of the columns by a database management system for the database on behalf of the one or more applications referencing the database using the defined mappings, the defined user-defined types, and the defined physical representations of the columns stored to the catalog,wherein logic for managing the application constraints, the non-standard user-defined types, and the physical representation of the columns are not stored in the one or more applications.
1 Assignment
0 Petitions
Accused Products
Abstract
The capturing of rich database metadata includes: capturing partitioned column metadata of a database as mappings defined by a plurality of constraint statements; defining non-standard user-defined types of the database according to a schema; defining physical representations of columns of the database according to the schema; and storing the defined mappings, the defined user-defined types, and the defined physical representations of columns to a catalog of the database. Application enumerated data values in the database may also be defined according to the XML schema and stored to the catalog of the database. In this manner, the database management system may manage application constraints, user-defined types, and physical representations of data for applications referencing the same database using the metadata information stored in the catalog of the database.
-
Citations
15 Claims
-
1. A method for capturing rich database metadata, comprising:
-
capturing partitioned column metadata of a database, for columns partitioned by one or more applications referencing the database, as mappings defined by a plurality of constraint statements; defining non-standard user-defined types of the database stored by the one or more applications referencing the database according to a schema; defining physical representations of the columns of the database according to the schema, wherein the physical representations of the columns are controlled by the one or more applications referencing the database; storing the defined mappings, the defined user-defined types, and the defined physical representations of columns to a catalog of the database; and managing application constraints, the non-standard user-defined types, and the physical representation of the columns by a database management system for the database on behalf of the one or more applications referencing the database using the defined mappings, the defined user-defined types, and the defined physical representations of the columns stored to the catalog, wherein logic for managing the application constraints, the non-standard user-defined types, and the physical representation of the columns are not stored in the one or more applications. - View Dependent Claims (2, 3, 4)
-
-
5. (canceled)
-
6. A computer program product for capturing rich database metadata, the computer program product comprising:
a computer readable storage device having computer readable program code embodied therewith, the computer readable program code configured to; capture partitioned column metadata of a database, for columns partitioned by one or more applications referencing the database, as mappings defined by a plurality of constraint statements; define non-standard user-defined types of the database stored by the one or more applications referencing the database according to a schema; define physical representations of the columns of the database according to the schema, wherein the physical representations of the columns are controlled by the one or more applications referencing the database; store the defined mappings, the defined user-defined types, and the defined physical representations of columns to a catalog of the database; and manage application constraints, the non-standard user-defined types, and the physical representation of the columns by a database management system for the database on behalf of the one or more applications referencing the database using the defined mappings, the defined user-defined types, and the defined physical representations of the columns stored to the catalog, wherein the computer readable program code configured to manage the application constraints, the non-standard user-defined types, and the physical representation of the columns are not stored in the one or more applications. - View Dependent Claims (7, 8, 9)
-
10. (canceled)
-
11. A system comprising:
-
a processor; and a computer readable storage medium having computer readable program code embodied therewith, wherein when executed by the processor, the computer readable program code causes the system to; capture partitioned column metadata of a database, for columns partitioned by one or more applications referencing the database, as mappings defined by a plurality of constraint statements; define non-standard user-defined types of the database stored by the one or more applications referencing the database according to a schema; define physical representations of columns of the database according to the schema, wherein the physical representations of the columns are controlled by the one or more applications referencing the database; store the defined mappings, the defined user-defined types, and the defined physical representations of columns to a catalog of the database; and manage application constraints, the non-standard user-defined types, and the physical representation of the columns by a database management system for the database on behalf of the one or more applications referencing the database using the defined mappings, the defined user-defined types, and the defined physical representations of the columns stored to the catalog, wherein the computer readable program code configured to manage the application constraints, the non-standard user-defined types, and the physical representation of the columns are not stored in the one or more applications. - View Dependent Claims (12, 13, 14)
-
-
15. (canceled)
Specification