Estudo comparativo entre as linguagens procedurais PL/SQL e PL/pgSQL aplicadas aos bancos de dados Oracle 10g XE e PostgreSQL 8.4

This research aims to conduct a comparative study between the procedural languages PL/SQL and PL/pgSQL of the Oracle 10g XE and PostgreSQL 8.4 database management systems respectively, which are languages commonly used by a great number of developers, mainly in corporative structured applications....

ver descrição completa

Autor principal: Silva, Murilo André da
Formato: Trabalho de Conclusão de Curso (Graduação)
Idioma: Português
Publicado em: Universidade Tecnológica Federal do Paraná 2020
Assuntos:
Acesso em linha: http://repositorio.utfpr.edu.br/jspui/handle/1/13437
Tags: Adicionar Tag
Sem tags, seja o primeiro a adicionar uma tag!
Resumo: This research aims to conduct a comparative study between the procedural languages PL/SQL and PL/pgSQL of the Oracle 10g XE and PostgreSQL 8.4 database management systems respectively, which are languages commonly used by a great number of developers, mainly in corporative structured applications. Were approached the syntax differences and how the communication of the languages with Java is performed through its libraries. Also, was developed an application that worked by procedures and function callings created on the database. Were performed comparative performance tests utilizing database response time measuring tools.