Abstract: Provided are techniques for identifying normalization violations. Selection of one of a data model, a portion of the data model, and an object in the data model is received. Selection of one or more normalization rules is received. One or more normalization violations are identified in the one of the data model, the portion of the data model, and the object in the data model using the one or more normalization rules. The one or more normalization violations are displayed.

Abstract: Provided are method, system, and article of manufacture, wherein a table is determined to be an enumeration table, in response to an indication provided to an application. Metadata corresponding to rows and columns of the enumeration table is generated. A model that logically represents the enumeration table by storing the generated metadata is maintained.

Abstract: Provided are a method, system, and program for determining compliance of a database architecture to an enterprise data standard. A physical model is generated defining database elements in a database. A logical model is provided representing a definition of elements and their relationships. The logical model is used to generate a mapping of database element names in the physical model to corresponding elements in the logical model. The mapping and the logical model are processed to determine an extent to which the database elements and relationships in the physical model violate rules of the logical model.

Abstract: A method and apparatus for improving the efficiency and security of a database management system (DBMS) is disclosed. A plurality of query packages are stored at a host DBMS. Generation of the query packages is limited only to those users that have authorization, such as the database administrator of the DBMS. The query packages include a plurality of procedures. Each procedure is a single SQL statement that has been pre-compiled. Each query package also includes an authorization table that enumerates each individual user, or category of user, that can invoke any procedure within the query package. By formulating a plurality of query packages, each package tailored to a particular category of user, security of the data on the DBMS is enhanced. Further, by having static statements that are pre-compiled, access time to the data on the DBMS is significantly reduced. Moreover, the database administrator and users can interactively generate and use the query packages in a user friendly environment.