Browse Prior Art Database

Method And System For Propagating Database Constraints To Application Layers

IP.com Disclosure Number: IPCOM000201280D
Publication Date: 2010-Nov-09
Document File: 2 page(s) / 18K

Publishing Venue

The IP.com Prior Art Database

Abstract

A method and system for propagating database constraints to application layers is disclosed. Application layers include user interface and various data access layers.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 52% of the total text.

Page 01 of 2

Method And System For Propagating Database Constraints To Application Layers

Disclosed is a method and system for propagating database constraints to application layers.

Application layers include user interface and various data access layers.

A database used in an application may have multiple constraints defined in a database

schema including, but not limited to, column types, column sizes, and primary and foreign key constraints. Generally, the constraints are manually propagated to application layers. For example, a constraint in a database is propagated as a validation rule for a user interface used to access the database.

Accordingly,

constraints in the database schema are modified, the modified constraints are propagated to the application layers manually. Therefore, there is a need for a method and system for automatically propagating database constraints to application layers.

The method and system disclosed herein accesses a database schema to retrieve database constraints for a database and stores the database constraints in a metadata file in a declarative form using XML. In addition to the database constraints, the database schema includes enumeration defining sets of valid values for columns in a table. The enumerations are also stored in the metadata file in the declarative form. Thereafter, a mapping is created between application layers accessing the database and the database. Subsequently, the metadata file is provided at runtime to the application layers.

The figure illustrates the method and system for propagating database constraints to app...