Automated SuperSQL query formulation based on statistical characteristics of data

Jun Nemoto, Motomichi Toyama

Research output: Contribution to journalConference article

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.

Original languageEnglish
Pages (from-to)44-54
Number of pages11
JournalLecture Notes in Computer Science
Volume3588
Publication statusPublished - 2005 Oct 24
Event16th International Conference on Database and Expert Systems Applications, DExa 2005 - Copenhagen, Denmark
Duration: 2005 Aug 222005 Aug 26

    Fingerprint

ASJC Scopus subject areas

  • Theoretical Computer Science
  • Computer Science(all)

Cite this