Realização de consultas visuais a banco de dados temporais.

Abstract

The Temporal Visual Query Environment (TVQE) allows the formulation of queries to historical databases. This environment adopts a diagrammatic representation of the database schema (including classes and relationships, temporal or not) and a "graphic notebook" as interaction metaphor. The user can formulate conventional queries as well as temporal queries, for the temporal queries the environment offers a specific interaction with special operators used for the formulation of temporal conditions. In this dissertation, we present some modifications and extensions of TVQE, besides a component denominated Translator, that translates queries formulated by the user in the TVQE to SQL. The modifications are related to system interaction aspects with the user, such as: the inclusion of a messages panel and the syncronizing of graphic components (menus, icons and panels). The extensions were: the formulation of complex queries as a new query type, the visualization of the graphic schema of the query result and the migration of the environment TVQE to an Java applet.