DB2REST: A Solution for Integration between Legacy Databases and RESTful Web Services

• Bruno Oliveira Instituto Federal Da Bahia (IFBA)
• Sandro Andrade Instituto Federal Da Bahia (IFBA)

Abstract

The integration between computational systems implies challenges commonly related to incompatible interfaces and technologies. A particular case of this difficulty is the integration between RESTful web services and legacy databases, whose data structures are divergent. In this context, this paper presents DB2REST, a software solution that assists in the integration between RESTful web servers and legacy databases. To evaluate the solution experiments were performed with and without the DB2REST, aiming to analyze the productivity, complexity and density of bugs in each scenario.

References

Coelho, C. and Sartorelli, R. (2004). Persistência de objetos via mapeamento objeto-relacional. Bacharelado em Sistemas de Informação, São Paulo.

Galvão, A. et al. (2009). Alternatives development software, without cost, for micro and small enterprises. Revista ADMpg Gestão Estratégica, 2(2):119–123.

Gantan, X. (2014). Python’s sqlalchemy vs other orms. Acesso em: Junho 15, 2017.

Lapolli, P. C. (2003). Implantação de sistemas de informações gerenciais em ambientes educacionais. Dissertação de Mestrado, Florianópolis-SC.

Pinto, H. L. M. and Braga, J. L. (2005). Sistemas legados e as novas tecnologias: técnicas de integração e estudo de caso. Informática Pública, 7:47–69.

Płuciennik-Psota, E. (2012). Object relational interfaces survey. Studia Informatica, 33(2A):299–310.