REPORTING TOOLS FOR OBJECT-RELATIONAL DATABASES

摘要

A view schema is generated from a view definition, wherein the view schema includes one or more relational views that are created by translating one or more object queries in the view definition into one or more relational queries. A report design schema is generated from the view definition by: creating one or more report tables that correspond to the one or more relational views of the view schema and extending the one or more report tables with one or more primary key constraints and one or more foreign key constraints. A reporting model is generated by reverse engineering the report design schema, wherein the reporting model includes the one or more primary key constraints and the one or more foreign key constraints. A report is generated using the reporting model, wherein the report includes the one or more primary key constraints and the one or more foreign key constraints.

主权项

1. A method, comprising:
generating, using a processor of a computer, a view schema from a view definition, wherein the view schema includes one or more relational views that are created by translating one or more object queries in the view definition into one or more relational queries; generating a report design schema from the view definition by:
creating one or more report tables that correspond to the one or more relational views of the view schema; andextending the one or more report tables with one or more primary key constraints and one or more foreign key constraints; generating a reporting model by reverse engineering the report design schema, wherein the reporting model includes the one or more primary key constraints and the one or more foreign key constraints; and generating a report using the reporting model, wherein the report includes the one or more primary key constraints and the one or more foreign key constraints.