Graphical Expression of SQL Statements Using Clamshell Diagram
Summary :
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.
- Publication
- IEICE TRANSACTIONS on Information Vol.E93-D No.4 pp.713-720
- Publication Date
- 2010/04/01
- Publicized
- Online ISSN
- 1745-1361
- DOI
- 10.1587/transinf.E93.D.713
- Type of Manuscript
- Special Section PAPER (Special Section on Knowledge-Based Software Engineering)
- Category
- Software Development Techniques
Authors
Keyword
Latest Issue
Copyrights notice of machine-translated contents
The copyright of the original papers published on this site belongs to IEICE. Unauthorized use of the original or translated papers is prohibited. See IEICE Provisions on Copyright for details.
Cite this
Copy
Takehiko MURAKAWA, Masaru NAKAGAWA, "Graphical Expression of SQL Statements Using Clamshell Diagram" in IEICE TRANSACTIONS on Information,
vol. E93-D, no. 4, pp. 713-720, April 2010, doi: 10.1587/transinf.E93.D.713.
Abstract: 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.
URL: https://global.ieice.org/en_transactions/information/10.1587/transinf.E93.D.713/_p
Copy
@ARTICLE{e93-d_4_713,
author={Takehiko MURAKAWA, Masaru NAKAGAWA, },
journal={IEICE TRANSACTIONS on Information},
title={Graphical Expression of SQL Statements Using Clamshell Diagram},
year={2010},
volume={E93-D},
number={4},
pages={713-720},
abstract={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.},
keywords={},
doi={10.1587/transinf.E93.D.713},
ISSN={1745-1361},
month={April},}
Copy
TY - JOUR
TI - Graphical Expression of SQL Statements Using Clamshell Diagram
T2 - IEICE TRANSACTIONS on Information
SP - 713
EP - 720
AU - Takehiko MURAKAWA
AU - Masaru NAKAGAWA
PY - 2010
DO - 10.1587/transinf.E93.D.713
JO - IEICE TRANSACTIONS on Information
SN - 1745-1361
VL - E93-D
IS - 4
JA - IEICE TRANSACTIONS on Information
Y1 - April 2010
AB - 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.
ER -
English
