Fundamentals for the Automation of Object-Relationa Database Design

Autores
Golobisky, María Fernanda; Vecchietti, Aldo
Año de publicación
2011
Idioma
inglés
Tipo de recurso
artículo
Estado
versión publicada
Descripción
In the market there is a wide amount of CASE tools for the design of relational databases. Object-relational database management system (ORDBMS) emerged at the end of the 90?s to incorporate the object technology into the relational databases, allowing the treatment of more complex data and relationships than its predecessor. The design for this database model is not straightforward. Most of the works proposed in the literature fail because they do not provide consistent transformation formalization such that the mappings from the conceptual model to the logical schema can be automated to generate an ORDB design toolkit. This is one of the goals of this paper. For this purpose, UML class diagram metamodel for the conceptual design and SQL:2003 standard metamodel for logical schemas are considered. A characterization of the components involved in the ORDB design is made in order to propose mapping rules that can be further automated. The architecture of a CASE tool prototype is presented. Model Driven Architecture for software design and XML for the model definitions and transformations are employed.
Fil: Golobisky, María Fernanda. Consejo Nacional de Investigaciones Científicas y Técnicas. Centro Científico Tecnológico Conicet - Santa Fe. Instituto de Desarrollo y Diseño. Universidad Tecnológica Nacional. Facultad Regional Santa Fe. Instituto de Desarrollo y Diseño; Argentina
Fil: Vecchietti, Aldo. Consejo Nacional de Investigaciones Científicas y Técnicas. Centro Científico Tecnológico Conicet - Santa Fe. Instituto de Desarrollo y Diseño. Universidad Tecnológica Nacional. Facultad Regional Santa Fe. Instituto de Desarrollo y Diseño; Argentina
Materia
Object Relational Database
Design
Mapping
Uml Class Diagrams
Nivel de accesibilidad
acceso abierto
Condiciones de uso
https://creativecommons.org/licenses/by-nc-sa/2.5/ar/
Repositorio
CONICET Digital (CONICET)
Institución
Consejo Nacional de Investigaciones Científicas y Técnicas
OAI Identificador
oai:ri.conicet.gov.ar:11336/70260
Acceder
id CONICETDig_84c48e133114dc77e4566472eaa02e6e
oai_identifier_str oai:ri.conicet.gov.ar:11336/70260
network_acronym_str CONICETDig
repository_id_str 3498
network_name_str CONICET Digital (CONICET)
spelling Fundamentals for the Automation of Object-Relationa Database DesignGolobisky, María FernandaVecchietti, AldoObject Relational DatabaseDesignMappingUml Class Diagramshttps://purl.org/becyt/ford/2.2https://purl.org/becyt/ford/2In the market there is a wide amount of CASE tools for the design of relational databases. Object-relational database management system (ORDBMS) emerged at the end of the 90?s to incorporate the object technology into the relational databases, allowing the treatment of more complex data and relationships than its predecessor. The design for this database model is not straightforward. Most of the works proposed in the literature fail because they do not provide consistent transformation formalization such that the mappings from the conceptual model to the logical schema can be automated to generate an ORDB design toolkit. This is one of the goals of this paper. For this purpose, UML class diagram metamodel for the conceptual design and SQL:2003 standard metamodel for logical schemas are considered. A characterization of the components involved in the ORDB design is made in order to propose mapping rules that can be further automated. The architecture of a CASE tool prototype is presented. Model Driven Architecture for software design and XML for the model definitions and transformations are employed.Fil: Golobisky, María Fernanda. Consejo Nacional de Investigaciones Científicas y Técnicas. Centro Científico Tecnológico Conicet - Santa Fe. Instituto de Desarrollo y Diseño. Universidad Tecnológica Nacional. Facultad Regional Santa Fe. Instituto de Desarrollo y Diseño; ArgentinaFil: Vecchietti, Aldo. Consejo Nacional de Investigaciones Científicas y Técnicas. Centro Científico Tecnológico Conicet - Santa Fe. Instituto de Desarrollo y Diseño. Universidad Tecnológica Nacional. Facultad Regional Santa Fe. Instituto de Desarrollo y Diseño; ArgentinaIJCSI2011-05info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersionhttp://purl.org/coar/resource_type/c_6501info:ar-repo/semantics/articuloapplication/pdfapplication/pdfhttp://hdl.handle.net/11336/70260Golobisky, María Fernanda; Vecchietti, Aldo; Fundamentals for the Automation of Object-Relationa Database Design; IJCSI; International Journal of Computer Science Issues; 8; 2; 5-2011; 9-221694-0814CONICET DigitalCONICETenginfo:eu-repo/semantics/openAccesshttps://creativecommons.org/licenses/by-nc-sa/2.5/ar/reponame:CONICET Digital (CONICET)instname:Consejo Nacional de Investigaciones Científicas y Técnicas2025-09-10T13:20:48Zoai:ri.conicet.gov.ar:11336/70260instacron:CONICETInstitucionalhttp://ri.conicet.gov.ar/Organismo científico-tecnológicoNo correspondehttp://ri.conicet.gov.ar/oai/requestdasensio@conicet.gov.ar; lcarlino@conicet.gov.arArgentinaNo correspondeNo correspondeNo correspondeopendoar:34982025-09-10 13:20:48.512CONICET Digital (CONICET) - Consejo Nacional de Investigaciones Científicas y Técnicasfalse
dc.title.none.fl_str_mv Fundamentals for the Automation of Object-Relationa Database Design
title Fundamentals for the Automation of Object-Relationa Database Design
spellingShingle Fundamentals for the Automation of Object-Relationa Database Design
Golobisky, María Fernanda
Object Relational Database
Design
Mapping
Uml Class Diagrams
title_short Fundamentals for the Automation of Object-Relationa Database Design
title_full Fundamentals for the Automation of Object-Relationa Database Design
title_fullStr Fundamentals for the Automation of Object-Relationa Database Design
title_full_unstemmed Fundamentals for the Automation of Object-Relationa Database Design
title_sort Fundamentals for the Automation of Object-Relationa Database Design
dc.creator.none.fl_str_mv Golobisky, María Fernanda
Vecchietti, Aldo
author Golobisky, María Fernanda
author_facet Golobisky, María Fernanda
Vecchietti, Aldo
author_role author
author2 Vecchietti, Aldo
author2_role author
dc.subject.none.fl_str_mv Object Relational Database
Design
Mapping
Uml Class Diagrams
topic Object Relational Database
Design
Mapping
Uml Class Diagrams
purl_subject.fl_str_mv https://purl.org/becyt/ford/2.2
https://purl.org/becyt/ford/2
dc.description.none.fl_txt_mv In the market there is a wide amount of CASE tools for the design of relational databases. Object-relational database management system (ORDBMS) emerged at the end of the 90?s to incorporate the object technology into the relational databases, allowing the treatment of more complex data and relationships than its predecessor. The design for this database model is not straightforward. Most of the works proposed in the literature fail because they do not provide consistent transformation formalization such that the mappings from the conceptual model to the logical schema can be automated to generate an ORDB design toolkit. This is one of the goals of this paper. For this purpose, UML class diagram metamodel for the conceptual design and SQL:2003 standard metamodel for logical schemas are considered. A characterization of the components involved in the ORDB design is made in order to propose mapping rules that can be further automated. The architecture of a CASE tool prototype is presented. Model Driven Architecture for software design and XML for the model definitions and transformations are employed.
Fil: Golobisky, María Fernanda. Consejo Nacional de Investigaciones Científicas y Técnicas. Centro Científico Tecnológico Conicet - Santa Fe. Instituto de Desarrollo y Diseño. Universidad Tecnológica Nacional. Facultad Regional Santa Fe. Instituto de Desarrollo y Diseño; Argentina
Fil: Vecchietti, Aldo. Consejo Nacional de Investigaciones Científicas y Técnicas. Centro Científico Tecnológico Conicet - Santa Fe. Instituto de Desarrollo y Diseño. Universidad Tecnológica Nacional. Facultad Regional Santa Fe. Instituto de Desarrollo y Diseño; Argentina
description In the market there is a wide amount of CASE tools for the design of relational databases. Object-relational database management system (ORDBMS) emerged at the end of the 90?s to incorporate the object technology into the relational databases, allowing the treatment of more complex data and relationships than its predecessor. The design for this database model is not straightforward. Most of the works proposed in the literature fail because they do not provide consistent transformation formalization such that the mappings from the conceptual model to the logical schema can be automated to generate an ORDB design toolkit. This is one of the goals of this paper. For this purpose, UML class diagram metamodel for the conceptual design and SQL:2003 standard metamodel for logical schemas are considered. A characterization of the components involved in the ORDB design is made in order to propose mapping rules that can be further automated. The architecture of a CASE tool prototype is presented. Model Driven Architecture for software design and XML for the model definitions and transformations are employed.
publishDate 2011
dc.date.none.fl_str_mv 2011-05
dc.type.none.fl_str_mv info:eu-repo/semantics/article
info:eu-repo/semantics/publishedVersion
http://purl.org/coar/resource_type/c_6501
info:ar-repo/semantics/articulo
format article
status_str publishedVersion
dc.identifier.none.fl_str_mv http://hdl.handle.net/11336/70260
Golobisky, María Fernanda; Vecchietti, Aldo; Fundamentals for the Automation of Object-Relationa Database Design; IJCSI; International Journal of Computer Science Issues; 8; 2; 5-2011; 9-22
1694-0814
CONICET Digital
CONICET
url http://hdl.handle.net/11336/70260
identifier_str_mv Golobisky, María Fernanda; Vecchietti, Aldo; Fundamentals for the Automation of Object-Relationa Database Design; IJCSI; International Journal of Computer Science Issues; 8; 2; 5-2011; 9-22
1694-0814
CONICET Digital
CONICET
dc.language.none.fl_str_mv eng
language eng
dc.rights.none.fl_str_mv info:eu-repo/semantics/openAccess
https://creativecommons.org/licenses/by-nc-sa/2.5/ar/
eu_rights_str_mv openAccess
rights_invalid_str_mv https://creativecommons.org/licenses/by-nc-sa/2.5/ar/
dc.format.none.fl_str_mv application/pdf
application/pdf
dc.publisher.none.fl_str_mv IJCSI
publisher.none.fl_str_mv IJCSI
dc.source.none.fl_str_mv reponame:CONICET Digital (CONICET)
instname:Consejo Nacional de Investigaciones Científicas y Técnicas
reponame_str CONICET Digital (CONICET)
collection CONICET Digital (CONICET)
instname_str Consejo Nacional de Investigaciones Científicas y Técnicas
repository.name.fl_str_mv CONICET Digital (CONICET) - Consejo Nacional de Investigaciones Científicas y Técnicas
repository.mail.fl_str_mv dasensio@conicet.gov.ar; lcarlino@conicet.gov.ar
_version_ 1842981138490982400
score 12.48226

Publicaciones similares