COMPREHENSION SUPPORT OF SQL STATEMENT USING DOUBLE-TREE STRUCTURE

Takehiko Murakawa, Masaru Nakagawa

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.

References

  1. Celko, J. (2005). Joe Celko's SQL for Smarties: Advanced SQL Programming, Third Edition. Morgan Kaufmann.
  2. Chan, H., Teo, H., and Zeng, X. (2005). An evaluation of novice end-user computing performance: Data modeling, query writing, and comprehension. Journal of the American Society for Information Science and Technology, 56(8):843-853.
  3. Chen, X. (2010). Extraction and visualization of traceability relationships between documents and source code. In IEEE/ACM international conference on Automated software engineering, pages 505-509.
  4. Davis, S. (2008). Automatic juxtaposition of source files. Master's thesis, University of British Columbia.
  5. Desmond, M., Storey, M.-A., and Exton, C. (2006). Fluid source code views for just in-time comprehension. In Workshop on Software Engineering Properties of Languages and Aspect Technologies.
  6. ISO9075. Information technology-database languagesSQL-part 1: Framework (SQL/framework). ISO/IEC 9075-1:1999.
  7. Liu, A., Yuan, Y., Wijesekera, D., and Stavrou, A. (2009). SQLProb: a proxy-based architecture towards preventing SQL injection attacks. In Proceedings of the 2009 ACM symposium on Applied Computing, pages 2054-2061.
  8. Murakawa, T., Kawasaki, T., Mizuochi, H., and Nakagawa, M. (2008). Formulation of clamshell diagram and its application to source code reading. In Proceedings of the 8th Joint Conference on Knowledge-Based Software Engineering (JCKBSE 2008), pages 474-483.
  9. Murakawa, T. and Nakagawa, M. (2010). Graphical expression of SQL statements using clamshell diagram. IEICE TRANSACTIONS on Information and Systems, E93-D(4):713-720.
  10. Murakawa, T., Tsujimoto, A., Matsuo, K., and Nakagawa, M. (2010). Automatic conversion of SQL statement into clamshell diagram. In Proceedings of the 9th Joint Conference on Knowledge-Based Software Engineering (JCKBSE'10), pages 100-101.
  11. DB2 9.1 Visual Explain tutorial.
  12. VisualExplain (2006). IBM.
Download


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