SuperSQL: an extended SQL for database publishing and presentation
SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
QURSED: querying and reporting semistructured data
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
ACTIVIEW: Adaptive data presentation using SuperSQL
Proceedings of the 27th International Conference on Very Large Data Bases
A Table Presentation System for Database and Web Applications
EEE '04 Proceedings of the 2004 IEEE International Conference on e-Technology, e-Commerce and e-Service (EEE'04)
Automatic categorization of query results
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
| Hi-index | 0.01 |
In this paper, we propose an automated SuperSQL query formulating method based on statistical characteristics of data so that the end-users can obtain the desired information more easily without burden of web application development side. SuperSQL is an extension of SQL to generate various kinds of structured presentations and documents. In our method, first, web producers prepare a provisional SQL query and send it to a relational database. Next, the automated algorithm formulates a SuperSQL query based on statistical information of the query result. Finally the resulting SuperSQL query is executed to return the categorized table to end-users. Experimental results demonstrate that the implemented system enables web producers to construct data-intensive web sites, which have better structure with respect to the recognition of the data by end-users.