COMPREHENSION SUPPORT OF SQL STATEMENT USING DOUBLE-TREE STRUCTURE

Takehiko Murakawa, Masaru Nakagawa

2011

Abstract

SQL is a practical programming language used mainly in the query to relational database. However there have been rarely met support tools for database programmers’ understanding with relation to SQL statements. We have proposed a framework where a clamshell diagram which looks like a symmetrical, double tree is drawn given an SQL statement. In this paper, we report an automatic conversion system of SQL statements into clamshell diagrams. The system parses the given statement and arranges the configuration which differs slightly from the well-known syntax tree. Moreover we actually generated some dozens of diagrams for SQL statements using the system to make sure that it can readily draw diagrams.

Paper Citation

in Harvard Style

Murakawa T. and Nakagawa M. (2011). COMPREHENSION SUPPORT OF SQL STATEMENT USING DOUBLE-TREE STRUCTURE . In Proceedings of the 3rd International Conference on Computer Supported Education - Volume 1: CSEDU, ISBN 978-989-8425-49-2, pages 318-323. DOI: 10.5220/0003346103180323

in Bibtex Style

@conference{csedu11,
author={Takehiko Murakawa and Masaru Nakagawa},
title={COMPREHENSION SUPPORT OF SQL STATEMENT USING DOUBLE-TREE STRUCTURE},
booktitle={Proceedings of the 3rd International Conference on Computer Supported Education - Volume 1: CSEDU,},
year={2011},
pages={318-323},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003346103180323},
isbn={978-989-8425-49-2},
}

in EndNote Style

TY - CONF
JO - Proceedings of the 3rd International Conference on Computer Supported Education - Volume 1: CSEDU,
TI - COMPREHENSION SUPPORT OF SQL STATEMENT USING DOUBLE-TREE STRUCTURE
SN - 978-989-8425-49-2
AU - Murakawa T.
AU - Nakagawa M.
PY - 2011
SP - 318
EP - 323
DO - 10.5220/0003346103180323