Graphical Expression of SQL Statements Using Clamshell Diagram

Takehiko MURAKAWA  Masaru NAKAGAWA  

IEICE TRANSACTIONS on Information and Systems   Vol.E93-D   No.4   pp.713-720
Publication Date: 2010/04/01
Online ISSN: 1745-1361
DOI: 10.1587/transinf.E93.D.713
Print ISSN: 0916-8532
Type of Manuscript: Special Section PAPER (Special Section on Knowledge-Based Software Engineering)
Category: Software Development Techniques
program understanding,  software inspection,  SQL,  diagram,  information representation,  

Full Text: PDF>>
Buy this Article

Thinking process development diagram is a graphical expression from which readers can easily find not only the hierarchy of a given problem but the relationship between the problem and the solution. Although that has been developed as an idea creation support tool in the field of mechanical design, we referred to the restricted version as clamshell diagram to attempt to apply to other fields. In this paper we propose the framework for drawing the diagram of the SQL statement. The basic idea is to supply the hierarchical code fragments of a given SQL statement in the left side of the diagram and to put the meaning written in a natural language in the right. To verify the usefulness of the diagram expression, we actually drew several clamshell diagrams. For three SQL statements that are derived from the same specification, the resulting diagrams enable us to understand the difference visually.