Kento Goto

GENERATE eHTML: Embedding SuperSQL Queries in HTML

SuperSQL is a database publishing/presentation extension of SQL that can generate various kinds of structured documents that contain values stored in RDBs. Thanks to a useful tools, it is becomes easily to creating web application. However, users need a lot of knowledge about various programing languages such as HTML, CSS, PHP, JavaScript, and so on to create Web applications. In this article, we propose a method to directly embed SuperSQL queries in a HTML file to facilitate the development of web applications.

Generating Desktop and Mobile Web Pages from a Single SuperSQL Query

Recently, a demand for a mobile-friendly web page is rising, but creating and maintaining separate sites for mobile and desktop is costly for web developers. At our laboratory, we have been designing and developing SuperSQL, an extension of SQL that can generate HTML files that contain values stored in RDBs. In this paper, we propose an approach to generate both mobile and desktop versions of a web page with just one SuperSQL query. We believe our approach can facilitate the laborious work of creating and maintaining separate sites for mobile and desktop environments.

Generating 3D virtual museum using superSQL

Virtual 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 language that lets users format relational data into different kinds of structured documents. In this paper we propose an extension of SuperSQL that generates a virtual reality scene from information about 3D objects stored in a relational database. This system enables users with no knowledge of virtual reality tools to create 3D scenes such as a virtual museum using a simple SQL-like query.

Modern Web Page Generation by Using Exclusively SuperSQL

Generation of modern web pages is a difficult task for novice programmers because requiring to be familiar with many programming languages, HTML, CSS, JavaScript, etc. SuperSQL, a project of Toyama laboratory, is an extension of SQL that automatically formats data retrieved from the database into various kinds of structured documents as an output of a query. In this paper, we propose an approach to generate a modern web page by uniquely using a single SuperSQL query. We propose to change the semantic of SuperSQL by defining 5 kinds of expressions: layout expression, function expression, design expression, dynamic expression, and responsive expression. By this approach, we show that we can generate modern web pages with various expressions by short query sentence.

Supporting Tools for Creating SuperSQL Queries

This 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 fine tune the layout and visual effects on HTML.

3D Visualization of data using SuperSQL and Unity

When exploring data or communicating it to other people, data is currently visualized through flat diagrams, tables, graphs, etc. Visualization of data in three dimensions (3D) offers more immersive and intuitive representations of the data and, through the added dimension, allows for more compact representations. Still, when representing large amounts of data in 3D, a fine control of the layout becomes a must. Current tools for 3D visualization do not allow for easy and fine tuned control of this layout. SuperSQL is an extension of the SQL language allowing users to declaratively and concisely specify the layout of, and generate structured documents such as web pages. In this work we extend SuperSQL to allow the generation of 3D data representations in the Unity game engine. With this system, users can represent their data through basic shapes, colors, and animations, or even their own custom 3D assets, by writing simple SQL-like queries.

Dictionary matching: review of the aho-corasick algorithm and vision for large dictionaries

Pattern-matching techniques have recently been applied to network security applications such as intrusion detection, virus protection, and spam filters. The widely used the Aho-Corasick algorithm can simultaneously match multiple patterns while providing a worst-case performance guarantee. The traditional Aho-Corasick algorithm has some problems on the large-scale dictionary matching, such as take a huge memory space, cost too much time when building trie, huge update cost (rebuild trie) and so on. In this paper, we summarize several recent works on the expansion of the AC algorithm: the original Aho-Corasick algorithm(AC), the parallel Aho-Corasick algorithm(PAC), and the parallel failure-less Aho-Corasick algorithm(PFAC). Among them, the PAC used muti-thread to process input text by divide input to few parts, but in this way, this is a problem called boundary detection problem. The PFAC which uses parallel processing, discarding the failure function and enhancing the AC processing capability by the power of GPU is relatively popular. The PFAC not only enhance the speed of matching process but also solve the boundary detection problem. In the original PFAC paper, only a small size dictionary pattern matching test was conducted. In this paper, we verify the feasibility of using PFAC for large-scale dictionary characters. And give a discussion on the possibility of using the PFAC algorithm to match large-scale pattern dictionaries. At last, we present our proposals for PFAC expansion for large-scale dictionary pattern matching. For example, the one called pattern cut approach is to cut the pattern from the common prefix with other words, and the other one is the large automaton is divided according to the input text by the prefix of words. And the sub-automatons are constructed separately. When the input text is processed, each word is processed by the sub-automaton that distributed according to the prefix of words. By this way, we can achieve the purpose of improving the parallel processing efficiency.

Generating Arbitrary Cross Table Layout in SuperSQL

In many Web site, various data presented in the form of a cross-table. Cross-table displays two sets of labels, typically on the top and left of the table, and attributes corresponding to the intersection of both labels in the middle. The simplest example of a cross table is a double entry table. In this work, we propose a formal model for cross-table and a way to describe cross-table from relational data. Using this model, we implement cross tables as a function of the SuperSQL system, an extension of the SQL language which generates structured documents from declarative queries on relational data. Using this method, we create elaborate and expressive cross tables that were not readily obtainable with other systems.

Non-procedural generation of web pages with nested infinite-scrolls in superSQL

Recently, infinite scrolling has become a trend in loading massive data in webpages. This feature allows contents of a webpage to be divided and loaded automatically as a user scrolls through the page. Integrating infinite scroll in webpages, however, can be a complex task. A developer needs to be proficient in client-side programming to design the webpages and server-side programming to be able to load data dynamically. In this study, we propose an approach based on SuperSQL to simplify the integration of infinite scroll in web pages. SuperSQL is an extension of SQL that outputs data extracted from a database in various types of structured documents such as HTML, directly as a result of a declarative query. We extend SuperSQL to implement infinite scrolling in an HTML query output. As a result, developing web pages with the infinite scroll feature can be achieved by running a single SuperSQL query.

Responsive HTML generation using SuperSQL

Purpose With the rapid spread of smartphones and tablets, it is becoming necessary for web developers to create responsive web pages which are visually appealing on devices of various sizes. However, building responsive UIs is a very challenging task, requiring deep knowledge of HTML and CSS. This paper aims to propose an approach to generate responsive web pages using SuperSQL, which is an extension of SQL that can format data retrieved from a database into various kinds of structured documents. Design/methodology/approach By incorporating the methodology of bootstrap, a grid-based framework for front-end development, the authors have made it possible to create responsive web pages from simple SuperSQL queries. In addition, by utilizing SuperSQL’s unique feature that can describe the structure of the output web page, the authors have proposed and implemented a mechanism to automatically optimize the web content’s size and position. Findings In the evaluation, the authors created some actual web applications with and without the use of SuperSQL and compared the code amount (number of lines). As a result, when using the proposed system, the amount of code was reduced to about 1/5. The authors also compared the layout generated by the proposed automatic layout generation mechanism with the responsive layout that was generated manually. As a result, the automatic layout generation mechanism created the same layout as the manually created layout 74.8 per cent of the time, and the user satisfaction level turned out to be 85.8 per cent. Originality/value The way to generate a responsive HTML by using a single SuperSQL query, and the mechanism for automatic responsive layout generation.