Abstract
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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Chen, W., Chung, K.: A Table Presentation System for Database and Web Applications. In: Proceedings of IEEE EEE 2004 International Conference on e-Technology, e-Commerce and e-Service, pp. 492–498 (2004)
Chakrabarti, K., Chaudhuri, S., Hwang, S.: Automatic Categorization of Query Results. In: Proceedings of ACM SIGMOD 2004 International Conference on Management of Data, pp. 755–766 (2004)
Maeda, Y., Toyama, M.: ACTIVIEW: Adaptive data presentation using SuperSQL. In: Proceedings of the VLDB 2001, pp. 695–696 (2001)
Papakonstantinou, Y., Petropoulos, M., Vassalos, V.: QURSED: Querying and Reporting Semistructured Data. In: Proceedings of ACM SIGMOD 2002 International Conference of Management of Data, pp. 192–203 (2002)
SuperSQL, http://ssql.db.ics.keio.ac.jp/
Toyama, M.: SuperSQL: An Extended SQL for Database Publishing and Presentation. In: Proceedings of ACM SIGMOD 1998 International Conference on Management of Data, pp. 584–586 (1998)
Weckerle, P.: Enterprise Data Publishing with Oracle Reports: Any Data, Any Format, Anywhere. In: Oracle Technology Network Technology Information (2003), http://otn.oracle.com/technology/products/reports/
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Nemoto, J., Toyama, M. (2005). Automated SuperSQL Query Formulation Based on Statistical Characteristics of Data. In: Andersen, K.V., Debenham, J., Wagner, R. (eds) Database and Expert Systems Applications. DEXA 2005. Lecture Notes in Computer Science, vol 3588. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11546924_5
Download citation
DOI: https://doi.org/10.1007/11546924_5
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-28566-3
Online ISBN: 978-3-540-31729-6
eBook Packages: Computer ScienceComputer Science (R0)