Geração Automática de Visões de Objeto de Dados Relacionais Vânia Maria Ponte Vidal, Lineu Santos, Valdiana da Silva Araujo, and Fernando Lemos   View Paper (PDF)   Return to Consultas e Visões/Queries and Views Abstract Views are used to publish data from a database into a new structure or schema. The definition of object views over relational data allows this data to be published into an object oriented structure, without the need for changing the database schema. This paper proposes a three-step approach to generate object views of relational data. First, the user defines the view schema. Second, the user identifies the view correspondence assertions which formally specify the relationships between the view schema and the base relational schema. A simple graphical interface helps the user define the view correspondence assertions. Finally, based on the view assertions, it is generated the SQL query that carries out the mapping defined by the assertions. In this work, we present an algorithm that automatically generates the SQL view definition. ©2006 Association for Computing Machinery