CASE tool for object-relational database designs

Author

De Castro, Thiago Rais ; De Souza, Solange N Alves ; De Souza, Luiz Sergio

Author_Institution

Petrobras Co., Rio de Janeiro, Brazil

fYear

2012

Firstpage

1

Lastpage

6

Abstract

In 1999, the SQL standard version presented new features to manipulate objects in relational database which has since been called Object-Relational Database (ORDB). Nowadays, many Object-Relational Database Management Systems (ORDBMS) offer resources to manipulate object in database. However, for these resources to become really utilized in corporate environment, it is necessary, among other things, to have CASE tools to aid in object-relational database design. An extension made in ArgoUML tool that permits developers to build graphics schemas to ORDBs is presented. These schemas can be generated using an ORDB profile presented here in. This profile is an extension of the UML class diagram and contains elements to represent the new resources to manipulate object in databases. The tool maps the graphic schema to SQL:2003 code and SQL code to Oracle dialect.

Keywords

SQL; Unified Modeling Language; computer aided software engineering; object-oriented databases; relational databases; ArgoUML tool; CASE tool; ORDB profile; ORDBMS; Oracle dialect; SQL code; SQL standard version; SQL:2003 code; UML class diagram; computer-aided software engineering; graphics schemas; object manipulation; object-relational database designs; object-relational database management systems; Arrays; Computer aided software engineering; Databases; Graphics; Load modeling; Proposals; Unified modeling language; Object-Relational Database; SQL:2003; UML class diagram;

fLanguage

English

Publisher

ieee

Conference_Titel

Information Systems and Technologies (CISTI), 2012 7th Iberian Conference on

ISSN

2166-0727

Print_ISBN

978-1-4673-2843-2

Type

conf

Filename

6263183