Á¤º¸°úÇÐȸ ³í¹®Áö B : ¼ÒÇÁÆ®¿þ¾î ¹× ÀÀ¿ë
Current Result Document : 4 / 5
ÇѱÛÁ¦¸ñ(Korean Title) |
Áý°è Çü¼ººä¸¦ ÀÌ¿ëÇÑ È®ÀåµÈ ÁúÀÇ À籸¼º ±â¹ý |
¿µ¹®Á¦¸ñ(English Title) |
An Extended Technique for Query Reformulation using Aggregated Materialized Views |
ÀúÀÚ(Author) |
ÀåÀ翵
ÀÌÅÂÈñ
ÀÌ»ó±¸
Jae-young Chang
Tae-hee Lee
Sang-goo Lee
|
¿ø¹®¼ö·Ïó(Citation) |
VOL 25 NO. 11 PP. 1594 ~ 1607 (1998. 11) |
Çѱ۳»¿ë (Korean Abstract) |
Çü¼ººä´Â ºäÀÇ ¿¬»ê °á°ú¸¦ ¹Ì¸® ÀúÀåÇÑ ÇüÅ·μ ÁúÀÇ ¼º´ÉÀ» Çâ»ó½ÃÅ°±â À§ÇØ ÁúÀÇ Ã³¸®°úÁ¤¿¡ È°¿ëµÉ ¼ö ÀÖ´Ù. ÁúÀÇ Ã³¸®¿¡ Çü¼ººä°¡ ÀÌ¿ëµÉ ¼ö ÀÖ´ÂÁöÀÇ ¿©ºÎ´Â ÁúÀÇ¿Í Çü¼ººäÀÇ °ü°è¿¡ µû¶ó °áÁ¤µÉ ¼ö Àִµ¥, Áö±Ý±îÁöÀÇ ¿¬±¸´Â Çü¼ººä°¡ ÁúÀÇ¿¡ ´ëÇؼ ÀÏ´ëÀÏ ´ëÀÀÀ̳ª Æ÷ÇÔ ´ëÀÀÀÇ °ü°è°¡ Á¸ÀçÇÏ´Â °æ¿ì¸¸À» °í·ÁÇÏ¿´´Ù. µû¶ó¼ ¸¹Àº ÀáÀçÀûÀ¸·Î À¯¿ëÇÑ Çü¼ººä°¡ °í·Á ´ë»ó¿¡¼ Á¦¿ÜµÇ¾ú´Ù. º» ³í¹®¿¡¼´Â Áý°è ÇÔ¼ö°¡ Æ÷ÇÔµÈ ÁúÀÇ¿¡ ´ëÇؼ Çü¼ººä¸¦ ÀÌ¿ëÇÏ¿© ÁúÀǸ¦ À籸¼ºÇÏ´Â »õ·Î¿î ¹æ¹ýÀ» Á¦¾ÈÇÑ´Ù. Á¦¾ÈµÈ ¹æ¹ýÀº ÁúÀÇ¿¡ ¾ð±ÞµÇÁö ¾Ê´Â Å×À̺íÀ» Æ÷ÇÔÇÑ Çü¼ººä±îÁö °í·ÁÇÏ¿´À¸¸ç Çü¼ººä¿¡ Æ÷ÇÔµÇÁö ¾ÊÀº ¼Ó¼ºµéÀ» º¹±¸ÇÏ¿© ÁúÀÇ Ã³¸®¿¡ ÀÌ¿ëÇÔÀ¸·Î½á Çü¼ººäÀÇ ÀÌ¿ë ¹üÀ§¸¦ È®ÀåÇÏ¿´´Ù. À̸¦ À§ÇØ ÁúÀÇ À籸¼º¿¡ ÀÌ¿ëÇÒ Çü¼ººä¸¦ Ž»öÇÏ´Â Á¶°Ç°ú ÁúÀǸ¦ À籸¼ºÇÏ´Â È¿À²ÀûÀÎ ¾Ë°í¸®ÁòÀ» Á¦½ÃÇÑ´Ù. ÀÌ ¹æ¹ýÀº ±âÁ¸ÀÇ Çü¼ººäÀÇ ÀÌ¿ë ¹üÀ§¸¦ È®´ëÇÏ¿© ÇâÈÄ ÁúÀÇ Ã³¸® ½Ã½ºÅÛ¿¡ È¿À²ÀûÀ¸·Î Àû¿ëµÉ ¼ö ÀÖÀ» °ÍÀÌ´Ù.
|
¿µ¹®³»¿ë (English Abstract) |
Materialized views which are stored views of the database offer opportunities for significant performance gam in query evaluation by providing fast access to pre-computed data. Whether a materialized view can be used in answering a query depends on the relationship between the view and the query. In previous works, only one-to-one or containment mapping from views to a query has been used and, as a result, certain potential1y useful materialized views were excluded from consideration. Proposed in this paper are new ways of utilizing materialized views in answering a query with "group-by" clause and aggregation. Views including relations not referred to in the given query are utilized. Attributes missing from a view can be recovered under certain conditions. We identify the conditions where a view can be used in reformulating a query and the algorithms that can effectively test these conditions and reformulate the query. The proposed conditions and corresponding algorithms provide a significant and practical extension to the usability of materialized views in query processing.
|
Å°¿öµå(Keyword) |
|
ÆÄÀÏ÷ºÎ |
PDF ´Ù¿î·Îµå
|