You are here

Declarative, Graphical Construction of Complex Report Queries

Project Description: 

Many use cases for business-oriented databases involve the creation of tailor-made summaries known as "reports". Report development is tedious because multiple SQL queries may be required to generate a single report, because queries may include complex combinations of formulas and aggregate functions (e.g. averages of totals), and because the visual output layout of non-tabular results must be manually defined through the use of templating languages or a graphical form editor. This project aims to reduce the user input required for report development by combining a visual query system generating hierarchical data with a system for automatic creation of report page layouts.

Team: 
Eirik Bakke, David R. Karger, Robert C. Miller