Rich database metadata model that captures application relationships, mappings, constraints, and complex data structures

• US 9,020,979 B2
• Filed: 01/05/2012
• Issued: 04/28/2015
• Est. Priority Date: 01/05/2012
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Charlet, Kyle J., Church, Nathan D., Hite, Kevin D., Holtz, Christopher M.
• Primary Examiner(s): Mahmoudi, Tony
• Assistant Examiner(s): PHAN, TUANKHANH D
• Application Number:
  US13/344,231
• Publication Number:
  US 20130179474A1
• Time in Patent Office: 1,209 Days
• Field of Search: 707790-811, 707964-975, 707/999.1, 709/224, 711/171
• US Class Current: 707/802
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 7/00 Methods or arrangements for processing data by operating upon the order or content of the data handled logic circuits H03K19/00

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.

Claims

1. A method for capturing rich database metadata associated with a database, comprising:

enhancing a database catalog with the database metadata, wherein a database management system manages the database catalog, wherein the database catalog allows the database management system to manage application constraints, user defined types, complete data structures and physical representation of data on behalf of applications associated with the database, relieving the applications of a requirement to ensure integrity associated with the data, by;

capturing partitioned column metadata of a database, for columns referenced by one or more applications referencing the database, as mappings defined by a plurality of constraint statements, wherein the database management system, via the database catalog, manages constraints associated with the columns instead of the one or more applications;

defining non-standard user-defined types of the database referenced by the one or more applications referencing the database according to a schema, wherein the database management system, via the database catalog, manages the non-standard user-defined types of the database instead of the one or more applications;

defining physical representations of the columns of the database according to the schema, wherein the physical representations of the columns are referenced by the one or more applications referencing the database, wherein the database management system, via the database catalog, manages the physical representations of the columns of the database instead of the one or more applications;

storing the defined mappings, the defined user-defined types, and the defined physical representations of columns to the database catalog of the database;

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 database 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; and

wherein the enhanced database catalog comprises application constraints, user-defined types, and physical representation of the data in a metadata format that integrates with an existing database metadata model.

2. The method of claim 1, wherein the capturing of the partitioned column metadata of the database as mappings defined by the plurality of constraint statements comprises:

breaking down a partitioned column of the database into a series of case statements, wherein each case statement defines a new mapping depending on a specific value of a data element embedded in the partitioned column or embedded in another column of the database.

3. The method of claim 1, further comprising:

defining application enumerated data values in the database controlled by the one or more applications referencing the database according to the XML schema; and

storing the defined application enumerated data values to the database catalog of the database.

4. The method of claim 1, wherein the schema comprises an Extensible Markup Language (XML) schema, wherein the method further comprises:

retrieving from the database catalog an XML instance document that is valid to the database catalog'"'"'s XML schema.

5. A computer program product for capturing rich database metadata associated with a database, the computer program product comprising:

a computer readable storage device having computer readable program code embodied therewith, the computer readable program code configured to;

enhance a database catalog with the database metadata, wherein a database management system manages the database catalog, wherein the database catalog allows the database management system to manage application constraints, user defined types, complete data structures and physical representation of data on behalf of applications associated with the database, relieving the applications of a requirement to ensure integrity associated with the data, by;

capturing partitioned column metadata of a database, for columns referenced by one or more applications referencing the database, as mappings defined by a plurality of constraint statements, wherein the database management system, via the database catalog, manages constraints associated with the columns instead of the one or more applications;

defining non-standard user-defined types of the database referenced by the one or more applications referencing the database according to a schema, wherein the database management system, via the database catalog, manages the non-standard user-defined types of the database instead of the one or more applications;

defining physical representations of the columns of the database according to the schema, wherein the physical representations of the columns are referenced by the one or more applications referencing the database, wherein the database management system, via the database catalog, manages the physical representations of the columns of the database instead of the one or more applications;

storing the defined mappings, the defined user-defined types, and the defined physical representations of columns to the database catalog of the database;

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 database 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; and

wherein the enhanced database catalog comprises application constraints, user-defined types, and physical representation of the data in a metadata format that integrates with an existing database metadata model.

6. The computer program product of claim 5, wherein the computer readable program code configured to capture the partitioned column metadata of the database as mappings defined by the plurality of constraint statements is further configured to:

break down a partitioned column of the database into a series of case statements, wherein each case statement defines a new mapping depending on a specific value of a data element embedded in the partitioned column or embedded in another column of the database.

7. The computer program product of claim 5, wherein the computer readable program code is further configured to:

define application enumerated data values in the database controlled by the one or more applications referencing the database according to the XML schema; and

store the defined application enumerated data values to the database catalog of the database.

8. The computer program product of claim 5, wherein the schema comprises an Extensible Markup Language (XML) schema, wherein the computer readable program code is further configured to:

retrieve from the database catalog an XML instance document that is valid to the database catalog'"'"'s XML schema.

9. A system comprising:

a processor; and

a computer readable storage medium having computer readable program code for capturing rich database metadata associated with a database embodied therewith, wherein when executed by the processor, the computer readable program code causes the system to;

enhance a database catalog with the database metadata, wherein a database management system manages the database catalog, wherein the database catalog allows the database management system to manage application constraints, user defined types, complete data structures and physical representation of data on behalf of applications associated with the database, relieving the applications of a requirement to ensure integrity associated with the data, by;

capturing partitioned column metadata of a database, for columns referenced by one or more applications referencing the database, as mappings defined by a plurality of constraint statements, wherein the database management system, via the database catalog, manages constraints associated with the columns instead of the one or more applications;

defining non-standard user-defined types of the database referenced by the one or more applications referencing the database according to a schema, wherein the database management system, via the database catalog, manages the non-standard user-defined types of the database instead of the one or more applications;

defining physical representations of columns of the database according to the schema, wherein the physical representations of the columns are referenced by the one or more applications referencing the database, wherein the database management system, via the database catalog, manages the physical representations of the columns of the database instead of the one or more applications;

storing the defined mappings, the defined user-defined types, and the defined physical representations of columns to the database catalog of the database;

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 database 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; and

wherein the enhanced database catalog comprises application constraints, user-defined types, and physical representation of the data in a metadata format that integrates with an existing database metadata model.

10. The system of claim 9, wherein in the capturing of the partitioned column metadata of the database as mappings defined by the plurality of constraint statements, the system further:

breaks down a partitioned column of the database into a series of case statements, wherein each case statement defines a new mapping depending on a specific value of a data element embedded in the partitioned column or embedded in another column of the database.

11. The system of claim 9, wherein the system further:

defines application enumerated data values in the database controlled by the one or more applications referencing the database according to the XML schema; and

stores the defined application enumerated data values to the database catalog of the database.

12. The system of claim 9, wherein the schema comprises an Extensible Markup Language (XML) schema, wherein the system further:

retrieves from the database catalog an XML instance document that is valid to the database catalog'"'"'s XML schema.