| 000 | 02253naa a2200241 a 4500 | ||
|---|---|---|---|
| 003 | AR-LpUFIB | ||
| 005 | 20250311170420.0 | ||
| 008 | 230201s2002 xx o 000 0 eng d | ||
| 024 | 8 |
_aDIF-M6638 _b6777 _zDIF006054 |
|
| 040 |
_aAR-LpUFIB _bspa _cAR-LpUFIB |
||
| 100 | 1 | _aRivero, Laura C. | |
| 245 | 1 | 0 | _aElicitation and conversion of hidden objects and restrictions in a database schema |
| 300 | _a1 archivo (627,5 kB) | ||
| 500 | _aFormato de archivo: PDF. -- Este documento es producción intelectual de la Facultad de Informática - UNLP (Colección BIPA/Biblioteca) | ||
| 520 | _aMapping 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. | ||
| 534 | _aACM symposium on Applied computing (2002, mar.,11-14 : Madrid, España). Procceding. Nueva York, ACM,2002, pp. 463-469. | ||
| 650 | 4 | _aBASES DE DATOS | |
| 650 | 4 | _aREINGENIERÍA | |
| 700 | 1 | _aDoorn, Jorge Horacio | |
| 700 | 1 | _aFerraggine, Viviana E. | |
| 856 | 4 | 0 | _uhttp://dx.doi.org/10.1145/508791.508878 |
| 942 | _cCP | ||
| 999 |
_c55836 _d55836 |
||