Dependencia de existencia en la modelación de datos
Fecha
2010
Autores
Cabrera González, Norma Elisa
González González, Luisa Manuela
García González, Carlos Ernesto
Rodríguez Morffi, Abel
Título de la revista
ISSN de la revista
Título del volumen
Editor
Feijóo
Resumen
La dependencia de existencia garantiza integridad semántica entre las propiedades estáticas y dinámicas de los datos. En los esquemas relacionales, se modela a través de las llaves foráneas y su comportamiento. A pesar de su utilidad para la modelación de datos, tanto en ambientes centralizados como en ambientes distribuidos, en la literatura tal propiedad se describe de forma intuitiva y generalmente no aparece debidamente abordada. En este material se hace un análisis de las construcciones en el modelo Entidad Relación Extendido que reflejan de alguna manera dependencia de existencia, se modela su comportamiento en esquemas relacionales, sobre la base de sus particularidades y se analiza la aplicación de la dependencia de existencia en asociaciones para la fragmentación horizontal derivada en el marco de Bases de Datos Distribuidas. Esta monografía puede servir como apoyo a la docencia de pregrado y postgrado en temas avanzados de Bases de Datos
Descripción
Palabras clave
Dependencia de Existencia, Modelación de Datos
Citación
ABITEBOUL, S., HULL, R. & VIANU, V. (1995) Foundations of Databases, Addison-Wesley.
BATINI, C., CERI, S. & NAVATHE, S. B. (1992) Conceptual Database Design: An Entity-Relationship Approach., Redwood City, CA., Benjamin/Cummings.
BATINI, C., CERI, S. & NAVATHE, S. B. (1994) Diseño conceptual de bases de datos: un enfoque de entidades-interrelaciones, Díaz de Santos.
BISKUP, J. (1995) Achievements of Relational Database Schema Design Theory Revisited. Springer-Verlag, Berlin, 29-54.
BLAHA, M. R., PREMERLANI, W. J. & RUMBAUGH, J. E. (1988) Relational database design using an object-oriented methodology. Communications of the ACM archive New York, NY, USA, 31, 414 - 427.
BRACHMAN, R. J. (1983) What IS-A Is and Isn’t: An Analysis of Taxonomic Links in Semantic Networks. Computer.
BRODIE, M. L. (1978) Specification and Verification of Data Base Semantic Integrity. Technical Report CSRG-91. University of Toronto.
BRODIE, M. L. (1981) Association: A Database Abstraction. Entity-Relationship Conf.
BRODIE, M. L., MYLOPOULOS, J. & SCHMIDT, J. W. (1984) Perspectives from Artificial Intelligence, Databases, and Programming Languages, New York: Springen-Verlag.
BUCHMANN, A. P. (1993) Active Object Systems. NATO ASI OODBS.
CODD, E. F. (1970) A Relational Model of Data for Large Shared Data Banks. Commun. ACM, 13, 377-387.
CODD, E. F. (1979) Extending the Data Base Relational Model to Capture More Meaning. ACM Trans. on Database Systems, 4, 397-434.
CHEN, P. P. (1976) The entity-relationship model: Toward a unified view of data. ACM Transactions on Database Systems, 1, 9-36.
DATE, C. J. (2000) An Introduction to Database Systems, Boston, MA, Addison-Wesley.
DE MIGUEL, A. & PIATTINI, M. (1993) Concepción y diseño de bases de datos: Del Modelo E/R al modelo relacional, Madrid,
RAMA.
DESLOCH, S. (1993) Semantic Integrity in Advanced Database Management Systems. Fachbereich Informatik. Universit ̈at Kaiserslautern.
DOGAC, A., OZKARAHAN, E. & CHEN, P. (1990) An integrity system for a relational database architecture. Eight International Conference on Entity-Relationship Approach. Toronto, Canada, North-Holland.
EISENBERG, A. & MELTON, J. (1999) SQL: 1999, formerly known as SQL3. ACM. SIGMOD Rec. , 28, 131--138.
ELMASRI, R., WEELDREYER, J. A. & HEVNER, A. R. (1985) The Category Concept: An Extension to the Entity-Relationship Model. Data Knowl. Eng., 1, 75-116.
ELMASRI, R. & NAVATHE, S. B. (1997) Fundamentals of Database Systems, third edition, Addison-Wesley
ELMASRI, R. & NAVATHE, S. B. (2003) Fundamentals of Database Systems, fourth edition, Addison-Wesley.
ESWARAN, K. P. & CHAMBERLIN, D. D. (1975) Functional SpecificaSpecifications of a Subsystem for Data Base Integrity. IN D.S., K. (Ed.) 1st Int. Conf. on Very Large Data Bases. Framinghamingham, Mass., USA.
FERG, S. (1985) Modelling the Time Dimension in an Entity-Relationship Diagram. IN CHEN, P. (Ed.) Fourth International Conference on Entity-Relationship Approach. Chicago, Illinois, USA, IEEE Computer Society and North-Holland.
GERTZ, M. (1996) iagnosis and Repair of Constraint Violations in Database Systems, Infix Verlag, St. Augustin, Germany.
GRAY, J. (1978) Notes on Data Base Operating Systems. Advanced Course: Operating Systems.
GREFEN, P. W. P. J. (1992) Integrity Control in Parallel Database systems. The Netherlands, University of Twente.
HAMMER, M. & MCLEOD, D. (1975) Semantic Integrity in a Relational Data Base System. Proceedings of the International Conference on Very Large Data Bases, September 22-24, 1975, Framingham, Massachusetts, USA. ACM.
HAMMER, M. & MCLEOD, D. (1978) The Semantic Data Model: A Modelling Mechanism for Data Base Applications, ACM.
HOROWITZ, B. M. (1992) A Run-Time Execution Model for Referential Integrity Maintenance. ICDE. KETABCHI, M. A., BERZINS, V. & MARCH, S. T. (1988) An object-oriented semantic data model for CAD applications. Inf. Sci., 46, 109-139.
KILOV, H. & ROSS, J. (1994) Information Modeling: An Object Oriented Approach, Cliffs N.J.: Prentice Hall.
MAIER, D. (1983) The Theory of Relational Databases, Computer Science Press.
MELTON, J. & SIMON, A. R. (1995) Understanding the New SQL: A Complete Guide, Morgan Kaufmann.
MYLOPOULOS, J., BERNSTEIN, P. & WONG, H. (1980) A Languaje Facility for Designig Database-Intensive Applications. TODS, 5:2.
NAVATHE, S. & CHENG, A. (1983) "A Methodology for Database Schema Mapping from Extended Entity Relationship Models into the Hierarchical Model," The Entity-Relationship Approach to Software Engineering.
ÖZSU, M. T. & PATRICK, V. (1999) Principles of Distributed Database Systems, Second Edition, Prentice-Hall.
PATON, N. W. & DÍAZ, O. (1999) Introduction. IN SPRINGER, N. Y. (Ed.) Active Rules in Database Systems.
PECKHAM, J. & MARYANSKI, F. J. (1988) Semantic Data Models. ACM Comput. Surv., 20, 153-189. PUT, F. (1988) Introducing dynamic and temporal aspects in a conceptual (database) schema. doctoral dissertation. Faculteit der Economische en Toegepaste Economische Wetenschappen, K.U.Leuven. RUMBAUGH, J. E. (1987) Relations as Semantic Constructs in an Object-Oriented Language.
RUMBAUGH, J. E., BLAHA, M. R., PREMERLANI, W. J., EDDY, F. & LORENSEN, W. (1991) Objecte Oriented Modeling and Design, Prentice Hall Int ́l.
SCHEUERMANN, P. & SCHEFFNER, G. (1980) "Abstraction Capabilities and Invariant Properties Modelling within the Entity-Relationship Approach", Entity-Relationship Aproach to Systems Analysis and Design. 121-140.
SMITH, J. & SMITH, D. (1977) Database abstractions: Aggregation and generalization. ACM Transactions On Database Systems, 2, 105-133.
SNOECK, M. & DEDENE, G. (1998) Existence Dependency: The key to semantic integrity between structural and behavioural aspects of object types. IEEE Transactions on Software Engineering, 24.
SNOECK, M. & DEDENE, G. (2000) Core Modelling Concepts to define Agregation. L'Objet, 7, 281-306.
STONEBRAKER, M. (1975) Implementation of Integrity Constraints and Views by Query Modification. IN KING, W. F. (Ed.) SIGMOD International Conference on Management of Data. San Jose, California, ACM.
TEOREY, T. (1999) Database Modeling & Design, Morgan Kaufmann Publishers.
TEOREY, T., YANG, D. & FRY, J. (1986) A logical design methodology for relational databases using the extended E-R model. ACM Computing Surveys, 18, 197-222.
TEOREY, T. J. & FRY, J. P. (1980) The Logical Record Access Approach to Database Design. ACM Computing Surveys (CSUR) archive New York, NY, USA, 12,179 - 211.
TÜRKER, C. (1999) Semantic Integrity Constraints in Federated Database Schemata, Infix Verlag, St. Augustin, Germany.
ULLMAN, J. D. & WIDOM, J. (1999) Introducción a los sistemas de Bases de Datos, Mexico, Prentice Hall Hispanoamericana.
WERTZ, C. (1993) Relational Database Design, CRC Press, Greenwich, CT.
WILMOT, R. B. (1984) Foreign Keys Decrease Adaptability of Database Designs. Commun. ACM, 27, 1237-1243