µ¥ÀÌÅͺ£À̽º ¿¬±¸È¸Áö(SIGDB)
Current Result Document :
ÇѱÛÁ¦¸ñ(Korean Title) |
WAL ·Î±ë ±â¹ýÀ» ÅëÇÑ SQLite ÃÖÀûÈ |
¿µ¹®Á¦¸ñ(English Title) |
SQLite Optimization using Physiological WAL Logging Technique |
ÀúÀÚ(Author) |
±¸µ¿Çö
ÀÌ»ó¿ø
Dong-hyun Koo
Sang-Won Lee
|
¿ø¹®¼ö·Ïó(Citation) |
VOL 30 NO. 01 PP. 0029 ~ 0038 (2014. 04) |
Çѱ۳»¿ë (Korean Abstract) |
ÃÖ±Ù ¿¬±¸¿¡ µû¸£¸é ¸ð¹ÙÀÏ ±â±âµéÀÇ Ã³¸®¼Óµµ¿Í ³×Æ®¿öÅ© ¼Óµµ´Â ÃæºÐÈ÷ ºü¸¥ ¹Ý¸é, ÀúÀå ÀåÄ¡ ÀÔÃâ·Â ¼Óµµ°¡ »ó´ëÀûÀÎ ¼º´É º´¸ñÀÇ ¿øÀÎÀ¸·Î ¾Ë·ÁÁ® ÀÖ´Ù. ¶ÇÇÑ, ½º¸¶Æ® Æù µîÀÇ ¸ð¹ÙÀÏ ±â±â¿¡¼ 70% ÀÌ»óÀÇ IO°¡ SQLite¿¡ ÀÇÇØ À¯¹ßµÈ´Ù. º» ³í¹®¿¡¼´Â SQLite¿¡¼ Æ®·£Àè¼Ç ±â´É Áö¿øÀ» À§ÇØ Ã¤ÅÃÇÏ°í ÀÖ´Â ±âÁ¸ Àú³Î ±â¹ýµéÀÇ ¹®Á¦Á¡À» ¹ÙÅÁÀ¸·Î, µ¥ÀÌÅͺ£À̽ºÀÇ ÀüÅëÀûÀÎ WAL ·Î±ë ±â¹ýÀ» Àû¿ëÇÑ SQLite ÃÖÀûÈ ¹æ¾ÈÀ» Á¦½ÃÇÏ°í, ÀÌµé ¼º´ÉÀ» ºñ±³ÇÑ´Ù. ½ÇÁ¦ ±¸Çö°ú Ç÷¡½Ã¸Þ¸ð¸® ÀúÀåÀåÄ¡¿¡¼ ¼öÇàÇÑ °á°ú, Á¦¾È ±â¹ýÀÌ ±âÁ¸ SQLite ·Ñ¹é Àú³Î ´ëºñ ¾à 4¹è, WAL ´ëºñ ¾à 2¹èÀÇ Á¤µµÀÇ ¼º´É °³¼± È¿°ú°¡ ÀÖÀ½À» È®ÀÎÇÏ¿´´Ù. |
¿µ¹®³»¿ë (English Abstract) |
According to recent researches, while the speed of processor and network in mobile devices is fast enough to meet the user requirements, the IO speed is recognized as the main performance bottleneck. Meanwhile, it is known that more than 70 percent of IOs are issued from SQLite database. In this paper, based on the observations made in two existing journaling techniques adopted by SQLite, we suggest to apply the traditional physiological WAL logging technique to SQLite for better write performance, and compare its performance with those two existing journaling techniques in SQLite. Our experiments using WAL-embodied SQLite on real flash storage show that WAL-based SQLite can outperform the rollback journal approximately by four times, and the SQLite WAL journal by two times.
|
Å°¿öµå(Keyword) |
¸ð¹ÙÀÏ
µ¥ÀÌÅͺ£À̽º
·Î±ë
Physiological logging
SQLite
Mobile
DBMS
Logging
Physiological Logging
SQLite
|
ÆÄÀÏ÷ºÎ |
PDF ´Ù¿î·Îµå
|