Implementação de um simulador de consultas em álgebra relacional

Abstract

A Relational Database is represented by a collection of tables, where each tuple represents a relation between a set of values. One of its advantages is the data access facility, enabling the user to use a wide range of approaches for information treatment. To submit queries in relational databases it can be used Relational Algebra, a formal query language. There are six fundamental operations in relational algebra, three unary and three binary. The result of any operation between relations, or tables, is a new relation. Because it is a formal language, few tools interpret queries in relational algebra format, making students learning harder. We analyzed two of these tools strengths and deficiencies in order to see what can still be done. This work proposes a relational algebra query simulator software to support relational algebra operations learning. We analyzed existent software needs and implemented a tool based on these requirements.