ÇѱÛÁ¦¸ñ(Korean Title) |
°ü°èÇü µ¥ÀÌÅͺ£À̽º¿¡¼ PIVOT ¿¬»ê°ú Â÷µî ÆÄÀÏÀ» ÀÌ¿ëÇÑ ¼öÆò ºäÀÇ Á¡ÁøÀûÀÎ °ü¸® |
¿µ¹®Á¦¸ñ(English Title) |
Incremental Maintenance of Horizontal Views Using a PIVOT Operation and a Differential File in Relational DBMSs |
ÀúÀÚ(Author) |
½Å¼ºÇö
±èÁøÈ£
¹®¾ç¼¼
±è»ó¿í
Sung-Hyun Shin
Jinho Kim
Yang-Sae Moon
Sang-Wook Kim
|
¿ø¹®¼ö·Ïó(Citation) |
VOL 16-D NO. 04 PP. 0463 ~ 0474 (2009. 08) |
Çѱ۳»¿ë (Korean Abstract) |
OLAP À̳ª e-ºñÁî´Ï½º ȯ°æ¿¡¼´Â ´ÙÂ÷¿ø µ¥ÀÌÅÍÀÇ È¿À²ÀûÀÎ ºÐ¼®À» À§ÇÏ¿©, µ¥ÀÌÅ͸¦ ¿©·¯ ÇüÅ·ΠǥÇöÇϰųª ÀúÀåÇÑ´Ù. ÀÌ·¯ÇÑ ´ÙÂ÷¿ø ±¸Á¶ÀÇ µ¥ÀÌÅ͸¦ Â÷¿ø ¾ÖÆ®¸®ºäÆ®µéÀÇ °ªÀ¸·Î Ç¥½ÃµÇ´Â ³ÐÀº ÇüÅÂÀÇ ¼öÆò ºä·Î Ç¥ÇöÇÑ´Ù. ¼öÆò ºä´Â ¿©·¯ ¼Ò½º·ÎºÎÅÍ ¼öÁýÇÑ ¿ä¾à Á¤º¸¸¦ À¯ÁöÇϵµ·Ï ½Çü ºä·Î¼ ÀúÀåµÇ¸ç, º¹ÀâÇÑ ÁúÀǵéÀ» È¿À²ÀûÀ¸·Î ó¸®Çϱâ À§ÇØ »ç¿ëµÈ´Ù. ±×·¯³ª, ¼Ò½º µ¥ÀÌÅÍ°¡ º¯°æµÉ °æ¿ì ¼öÆò ºäµéÀÇ ³»¿ëµµ ¼öÁ¤ÇØ¾ß ÇÏ´Â µ¥, ¼Ò½º µ¥ÀÌÅ͵éÀÌ ¿©·¯ »çÀÌÆ®¿¡ ºÐ»êµÇ¾î Àֱ⠶§¹®¿¡ ¼öÆò ºä¸¦ °ü¸®ÇÏ´Â °ÍÀº ¾î·Æ´Ù. µû¶ó¼, º» ¿¬±¸¿¡¼´Â Á¡ÁøÀûÀÎ ºä °ü¸® ¹æ¹ý ÁßÀÇ Çϳª·Î Â÷µî ÆÄÀÏÀ» ÀÌ¿ëÇÏ¿© ¼öÆò ºä¸¦ °ü¸®ÇÏ´Â È¿À²ÀûÀÎ ¹æ¹ýÀ» Á¦½ÃÇÑ´Ù. ÀÌ·¯ÇÑ ¹æ¹ýÀº »ó¿ë RDBMS¿¡¼ Á¦°øÇÏ´Â PIVOT ¿¬»êÀ» ÀÌ¿ëÇÏ¿© ÀúÀåµÈ ¼öÁ÷ ÇüÅÂÀÇ ¼Ò½º Å×À̺íÀ» ¼öÆò ºä·Î º¯È¯ÇÏ°í, ¼öÁ÷ Å×À̺íÀÇ º¯°æ »çÇ×À» ¹Ý¿µÇÑ Â÷µî ÆÄÀÏÀ» ÀÌ¿ëÇÏ¿© ¼öÆò ºä¿¡¼µµ µ¿ÀÏÇÏ°Ô Àû¿ëÇÏ´Â ¹æ¹ýÀÌ´Ù. À̸¦ À§ÇØ, ¿ì¼± ÀúÀåµÈ ¼öÁ÷ Å×ÀÌºí¿¡¼ ¼öÆò ºä·Î º¯È¯ÇÏ¿© ó¸®ÇÏ´Â ÀüüÀûÀÎ ÇÁ·¹ÀÓ¿öÅ©¸¦ Á¦¾ÈÇÑ´Ù. Á¦¾ÈÇÑ ÇÁ·¹ÀÓ¿öÅ© ÇÏ¿¡¼ ¼öÁ÷ Å×À̺íÀ» ¼öÆò ºä·Î º¯È¯ÇÏ´Â PIVOT ¿¬»êÀ» Á¤ÀÇÇÑ´Ù. ´ÙÀ½À¸·Î, ¼öÁ÷ Å×À̺í·ÎºÎÅÍ µ¥ÀÌÅÍ°¡ º¯°æµÉ °æ¿ì, µ¥ÀÌÅÍ¿¡ ´ëÇÑ º¯°æ »çÇ×À» Â÷µî ÆÄÀÏ·Î ÀúÀåÇÑ ÈÄ, À̸¦ ÀÌ¿ëÇÏ¿© ¼öÆò ºä¸¦ °»½ÅÇÏ´Â ¹æ¹ýÀ» Á¦¾ÈÇÑ´Ù. ƯÈ÷, Â÷µî ÆÄÀÏÀÇ ±¸Á¶´Â ¼öÆò ºäÀÇ ±¸Á¶¿Í ´Ù¸£±â ¶§¹®¿¡, ¼öÆò ºä¿¡ ÀûÇÕÇϵµ·Ï º¯°æ »çÇ×À» º¯È¯ÇØ¾ß ÇÑ´Ù. ¸¶Áö¸·À¸·Î ½ÇÇèÀ» ÅëÇÏ¿© Á¦¾ÈÇÑ ¹æ¹ýÀº ´Ù¸¥ ¹æ¹ý¿¡ ºñÇؼ Æò±Õ 1.2¢¦5.0¹è±îÁö ¼º´ÉÀ» Çâ»ó½ÃÅ´À» º¸ÀδÙ. |
¿µ¹®³»¿ë (English Abstract) |
To analyze multidimensional data conveniently and efficiently, OLAP (On-Line Analytical Processing) systems or e-business are widely using views in a horizontal form to represent measurement values over multiple dimensions. These views can be stored as materialized views derived from several sources in order to support accesses to the integrated data. The horizontal views can provide effective accesses to complex queries of OLAP or e-business. However, we have a problem of occurring maintenance of the horizontal views since data sources are distributed over remote sites. We need a method that propagates the changes of source tables to the corresponding horizontal views. In this paper, we address incremental maintenance of horizontal views that makes it possible to reflect the changes of source tables efficiently. We first propose an overall framework that processes queries over horizontal views transformed from source tables in a vertical form. Under the proposed framework, we propagate the change of vertical tables to the corresponding horizontal views. In order to execute this view maintenance process efficiently, we keep every change of vertical tables in a differential file and then modify the horizontal views with the differential file. Because the differential file is represented as a vertical form, its tuples should be converted to those in a horizontal form to apply them to the out-of-date horizontal view. With this mechanism, horizontal views can be efficiently refreshed with the changes in a differential file without accessing source tables. Experimental results show that the proposed method improves average performance by 1.2¢¦5.0 times over the existing methods. |
Å°¿öµå(Keyword) |
OLAP
µ¥ÀÌÅÍ ¿þ¾îÇϿ콺
´ÙÂ÷¿ø µ¥ÀÌÅÍ
PIVOT
Â÷µî ÆÄÀÏ
OLAP
Data Warehouse
Multidimensional Data
PIVOT
Differential File
|
ÆÄÀÏ÷ºÎ |
PDF ´Ù¿î·Îµå
|