Elicitation and conversion of hidden objects and restrictions in a database schema
| Autor Principal: | |
|---|---|
| Otros autores o Colaboradores: | , |
| Formato: | Capítulo de libro |
| Lengua: | inglés |
| Temas: | |
| Acceso en línea: | http://dx.doi.org/10.1145/508791.508878 Consultar en el Cátalogo |
| Resumen: | Mapping a database schema from one model into another, with a higher semantic capacity, is a current research subject with application in several development fields, such as schema integration and translation, migration from l e g a ~ systems and revngineering o f poor quality or no-longer accurate data models. Inclusion dependencies are one o f the most important concepts in relational databases and they are the key to perform some reengineering o f database schemas. Referential integrity restrictions (fir), a particular case o f an inclusion conslraint, requires that the set of distinct values occurring in some specified column, simple or composite (foreign key), must be a subset o f the set o f distinct primary key values drawn from the same domain. Pure inclusion dependencies (id), however, may apply between other pairs o f attributes also (alternate keys or non-keys). Database schemas containing ids frequently reveal the presence o f hidden objects and misrepresented relationships and, as a consequence, incree,se the effort to develop program applications and maintain the integrity. This work presents a heuristics for the conversion of schemas with ids into equivalent schemas with only firs. In case some irreducible ids remain, a semantic interpretation oftbeir necessity and maintenance is given. |
| Notas: | Formato de archivo: PDF. -- Este documento es producción intelectual de la Facultad de Informática - UNLP (Colección BIPA/Biblioteca) |
| Descripción Física: | 1 archivo (627,5 kB) |
| DOI: | 10.1145/508791.508878 |