µ¥ÀÌÅͺ£À̽º ¿¬±¸È¸Áö(SIGDB)
ÇѱÛÁ¦¸ñ(Korean Title) |
µ¥ÀÌÅͺ£À̽º ·Î±× ºÐ¼®À» ÅëÇÑ µ¥ÀÌÅͺ£À̽º ½Ç½Ã°£ º¹Á¦ ±â¹ý ±¸Çö |
¿µ¹®Á¦¸ñ(English Title) |
An Implementation of The Real-time Database Replication Method Through Database Log Analysis |
ÀúÀÚ(Author) |
À̼®ÁÖ
ºóÁرæ
ÇѼöÁø
ÀΰæÁ¶
¹ÎÁرâ
Seok-Joo Lee
Jun-Kil Been
Su-Jin Han
Kyung-Jo In
Jun-Ki Min
|
¿ø¹®¼ö·Ïó(Citation) |
VOL 29 NO. 03 PP. 0075 ~ 0085 (2013. 12) |
Çѱ۳»¿ë (Korean Abstract) |
Åë½Å, ±ÝÀ¶ µî °í°´¿¡°Ô µ¥ÀÌÅ͸¦ ÀÌ¿ëÇÏ¿© ¼ºñ½º¸¦ Á¦°øÇÏ´Â »ê¾÷¿¡¼´Â µ¥ÀÌÅÍ ¼Õ½Ç·Î ÀÎÇÑ ¼ºñ½º Àå¾Ö ¹ß»ý½Ã ºü¸¥ º¹±¸°¡ ¹«¾ùº¸´Ù Áß¿äÇÏ´Ù. ±×·¯³ª ÀüÅëÀûÀÎ ¹æ½ÄÀº ½Ã½ºÅÛ º¹±¸¿¡ ¸¹Àº ½Ã°£À» ¼Ò¿äÇϸç, ÀúÀå °ø°£ÀÇ ¿À¹öÇìµå·Î ÀÎÇØ ¸¹Àº ºñ¿ëÀ» ¼Ò¸ðÇÑ´Ù. ºñ¿ëÀ» ÃÖ¼ÒÈÇÏ¸ç ºñÁî´Ï½ºÀÇ ¿¬¼Ó¼ºÀ» È®º¸Çϱâ À§ÇØ º» ³í¹®¿¡¼´Â ¼ºñ½º ÁßÀÎ µ¥ÀÌÅͺ£À̽º¿¡ ½É°¢ÇÑ Àå¾Ö°¡ ¹ß»ýÇÏ´õ¶óµµ º¹Á¦µÈ µ¥ÀÌÅͺ£À̽º¸¦ ÅëÇØ µ¥ÀÌÅÍÀÇ ¼Õ½ÇÀ» ¹æÁöÇÏ°í Áö¼ÓÀûÀ¸·Î ¼ºñ½º¸¦ Á¦°øÇÒ ¼ö ÀÖµµ·Ï ½Ç½Ã°£ µ¥ÀÌÅͺ£À̽º º¹Á¦ ±â¹ýÀ» Á¦¾ÈÇÑ´Ù. µ¥ÀÌÅͺ£À̽º¿¡¼´Â Æ®·£Àè¼Çó¸® ÈÄ °ü·Ã Á¤º¸¸¦ ·Î±×¿¡ ¸ÕÀú ±â·ÏÇÑ´Ù. µû¶ó¼ ·Î±×¸¦ ºÐ¼®ÇÏ¿© ÀÔ·ÂµÈ µ¥ÀÌÅÍ º¯°æ SQLÀ» ÃßÃâÇÏ°í, ÃßÃâµÈ SQLÀ» ´Ù¸¥ µ¥ÀÌÅͺ£À̽º¿¡ Àü¼ÛÇÏ¿© µ¿ÀÏÇÑ ÀÛ¾÷À» ½ÇÇàÇÏ¿´´Ù. ÀÌ·¯ÇÑ ¹æ½ÄÀ¸·Î ½Ç½Ã°£À¸·Î µ¥ÀÌÅͺ£À̽º º¹Á¦½Ã½ºÅÛÀ» ±¸ÇöÇÏ¿´´Ù.
|
¿µ¹®³»¿ë (English Abstract) |
In industries like communication, finance, and so on, wherein services using data are provided to customers, the most important thing is to restore rapidly a system if a system failure happens. However, the traditional method takes much time and costs a lot for storage overhead. In order to minimize the cost and to ensure business continuity, we proposed in this paper a real-time database replication method that would prevent data loss and support continuous service even though critical database disability occurs. After processing each transaction, the related data is recorded in the log in advance. Thus, by analyzing this log data, each SQL statement related to data modification from the log is extracted and sent to another database to conduct the same operation. In this way, we implement the real-time replication system for database systems.
|
Å°¿öµå(Keyword) |
µ¥ÀÌÅͺ£À̽º ·Î±×
·Î±× ºÐ¼®
µ¥ÀÌÅͺ£À̽º ½Ç½Ã°£ º¹Á¦
Database log
log analysis
database real-time replication
|
ÆÄÀÏ÷ºÎ |
PDF ´Ù¿î·Îµå
|