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....
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. |
---|