ABSTRACT
SuperSQL is an extension of SQL that allows query results presented in various media for publishing and presentations with simple but sophisticated formatting capabilities. SuperSQL query can generate various kinds of materials, for example, a LaTeX source file to publish query results in a nested table, HTML or Java source files to present the result on WWW browsers, and other media including MS-Excel worksheet, Tcl/Tk, O2C, etc. O2C is a data manipulation language of O2 and thus useful to migrate data in a relational database to an object oriented database.
SuperSQL is meant to provide a theoretical and practical foundation for 4GL-type applications such as report writers and DB/WWW coordinators.
In this demonstration, we show how TFE reorganize the query results into various media in a universal way, first by grouping tuples according to an arbitrary tree structured schema, and by translating them with the constructors available in the target media.
- 1.P. Atzeni, G. Mecca, P. Merialdo, Semistructured and Structured Data in the Web: Going Back and Forth, in SIGMOD Record, 26(4), ACM (1997), 16-23. Google ScholarDigital Library
- 2.P-C. Kim, http://grigg, chungnam, ac.kr/projects/ UniWeb/document s/www_dbms .htmlGoogle Scholar
- 3.C. Lang, J. Chow, Database Publishing on the Web and lntranets, Coriolis Group Books (1996). Google ScholarDigital Library
- 4.T. Seto, T. Nagafuji, M. Toyama, Generating HTML Sources with TFE Enhanced SQL, in Proc. A CM Syrup. on Applied Computing (SAC '97), ACM (1997), 96-105. Google ScholarDigital Library
- 5.M. Toyama, Three Dimensional Generalization of Target List for Simple Database Publishing and Browsing, in Research and Practical Issues in Database (Proc. 3rd Australian Database Conference), World Scientific Pub. Co. (1992), 139-153.Google Scholar
- 6.M. Toyama, Dynamic and Structured Presentation of Database Contents on the Web, to appear in Proc. EDBT '98. Google ScholarDigital Library
Index Terms
- SuperSQL: an extended SQL for database publishing and presentation
Recommendations
SuperSQL: an extended SQL for database publishing and presentation
SuperSQL is an extension of SQL that allows query results presented in various media for publishing and presentations with simple but sophisticated formatting capabilities. SuperSQL query can generate various kinds of materials, for example, a LaTeX ...
Generating 3D virtual museum using superSQL
iiWAS '17: Proceedings of the 19th International Conference on Information Integration and Web-based Applications & ServicesVirtual Reality is gaining traction as a medium. But generating virtual reality scenes is still a challenge as manipulating and arranging 3D objects is a complex task requiring the mastery of specialized tools. SuperSQL is an extension of the SQL query ...
Supporting Tools for Creating SuperSQL Queries
IDEAS '15: Proceedings of the 19th International Database Engineering & Applications SymposiumThis paper introduces a pair of query editors for SuperSQL: SSedit and SSvisual. SSedit is a structured editor specialized for SuperSQL, which is mainly used to create a query statement from scratch. SSvisual is a WYSIWYG editor, which is mainly used to ...
Comments