Manipulation of Memory Data Using SQL

SQL을 이용한 메모리 데이터 조작

  • 나영국 (서울시립대학교 전자전기컴퓨터학부) ;
  • 우원석 (이화여자대학교 국제학부)
  • Received : 2011.11.03
  • Accepted : 2011.12.05
  • Published : 2011.12.28


In database application developments, data coexists in memory and disk spaces. To manipulate the memory data, the general programing languages are used and to manipulate the disk data, SQL is used. In particular, the procedural languages for the memory manipulation are difficult to create and manage than declarative languages such as SQL. Thus, this paper shows that a particular structure of memory data, tree structured, can be manipulated by SQL. Most of all, the model data of the user interfaces can be represented by a tree structure and thus, it can be processed by SQL except non set computations. The non set computations could be done by helper classes. The SQL memory data manipulation is more suited to the database application developments which have few complex computations.


SQL;Database Application Development;Declarative Language;Procedural Language;User Interface;Model


Supported by : 서울시립대학교


  1. 나영국, "자동 생성 폼과 SQL을 이용한 ERD 표현", 한국콘텐츠학회논문지, 제9권, 제5호, pp.63-75, 2009.
  2. C. Bauer, Hibernate in Action, Manning Pub, 2007.
  3. C. Begin, IBatis in Action, Manning Pub, 2007.
  4. P. L. Zhou and B. Z. Xu, "Visualization of Data Structure on MVC Framework," Tech Report, Monash University.
  5. B. Johnson and B. Shneideman, "Tree-Maps: A Space-Filling Approach to the Visualization of Hierarchical Information Structures," Visualization '91, Proceedings of IEEE Conference on Visualization, 1991.
  6. C. Cavaness, Programming Jakarta Struts, O'Reilly, 2005.
  7. C. Walls and R. Breidenbach, Spring in Action, Manning Pub, 2005.
  8. S. Sanderson, Pro ASP.NET MVC Framework, APress, 2009.
  9. B. Tate, Ruby on Rails: Up and Running, O'Reilly, 2006.
  10. K Haller, "White-box testing for databasedriven applications: a requirement analysis," DB Test Proceedings of the Second International Workshop on Testing Database Systems, 2009.
  11. D. M. Self, M. Carrillo, and M. Del Rocio Boone, "A Database and Web Application Based on MVC Architecture," Electronics, Communications and Computers, pp48-48, 2006.
  12. Arthur M. Keller, "Algorithms for Translating View Updates to Database Updates for View Involving Selection, Projections, and Joins," Proceedings of the fourth ACM SIGACTSIGMOD symposium on Principles of database systems, 1985.
  13. E. J. O'Neil, "Object/relational mapping 2008: hibernate and the entity data model (edm)," SIGMOD 2008.
  14. C. Ireland, D. Bower, M. Newton, K. Waugh, "A Classfication of Object-Relational Impendence Mismatch," First International Conference on Advances in Databases, Knowledge, and Data Applications, 2009.
  15. J. S. Gero and M. Balachandran, "A Comparison of Procedural and Declarative Programming Languages for the Computation of Pareto Optimal Solutions," Engineering Optimization, Vol.9, pp.131-142, 1985.