OLAP ¼³Ä¡ ¹× »ç¿ëÀÚ ¾È³»¼­

¿ë¾î

´ÙÀ½ ¿ë¾î´Â ÀÌ Ã¥ Àü¹Ý¿¡ °ÉÃÄ »ç¿ëµË´Ï´Ù. "¿ë¾îÁý"ÀÇ ¿ë¾îÁý¿¡¼­ Ãß°¡ÀûÀÎ DB2 OLAP Server ¿ë¾î¿¡ ´ëÇÑ Á¤ÀǸ¦ ãÀ» ¼ö ÀÖ½À´Ï´Ù.

Application Manager
DB2 OLAP Server¿Í ÇÔ²² Á¦°øµÇ´Â Essbase ¼ÒÇÁÆ®¿þ¾î·Î, Essbase ÀÀ¿ëÇÁ·Î±×·¥À» ÀÛ¼ºÇϰí À¯Áöº¸¼öÇÏ´Â µ¥ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.

OLAP ÀÀ¿ëÇÁ·Î±×·¥
Essbase Application Manager ¶Ç´Â Essbase ¸í·É(DB2 OLAP ServerÀÇ °æ¿ì)À» »ç¿ëÇϰųª Starter Kit¿¡ ÀÖ´Â DB2 OLAP Integration Server µ¥½ºÅ©Å¾À¸·Î ÀÛ¼ºÇÑ ÀÀ¿ëÇÁ·Î±×·¥. Essbase ÀÀ¿ëÇÁ·Î±×·¥¿¡´Â Çϳª ÀÌ»óÀÇ Essbase µ¥ÀÌÅͺ£À̽º¿Í ÀÌ¿¡ ¿¬°üµÇ´Â ¸ðµç °è»ê ½ºÅ©¸³Æ®, º¸°í¼­ ½ºÅ©¸³Æ® ¹× µ¥ÀÌÅÍ ·Îµå ±ÔÄ¢ÀÌ Æ÷Ç﵃ ¼ö ÀÖ½À´Ï´Ù. ¸¹Àº Essbase ÀÀ¿ëÇÁ·Î±×·¥À» ÇϳªÀÇ °ü°èÇü µ¥ÀÌÅͺ£À̽º¿¡ ÀúÀåÇÒ ¼ö ÀÖ½À´Ï´Ù.

¸ÞŸÀ±°û(Metaoutline)
OLAP ¸ðµ¨¿¡¼­ µ¥ÀÌÅͺ£À̽º À±°û(outline)À» ÀÛ¼ºÇÒ ¶§ »ç¿ëµÇ´Â ±¸Á¶ ¹× ±ÔÄ¢ÀÌ ÀÖ´Â ÅÛÇø®Æ®. ¸ÞŸÀ±°ûÀ» »ç¿ëÇÏ¸é µ¥ÀÌÅͺ£À̽º À±°ûÀ» ÀÛ¼ºÇÏ°í ¿©±â¿¡ µ¥ÀÌÅ͸¦ ·ÎµåÇÒ ¼ö ÀÖ½À´Ï´Ù. DB2 OLAP Integration Server µ¥½ºÅ©Å¾¿¡´Â OLAP MetaoutlineÀ̶ó´Â µµ±¸°¡ ÀÖ½À´Ï´Ù. ÀÌ µµ±¸¸¦ »ç¿ëÇϸé OLAP ¸ðµ¨¿¡¼­ ¸ÞŸÀ±°ûÀ» Çϳª ÀÌ»ó ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.

¸ðµ¨
°ü°èÇü µ¥ÀÌÅͺ£À̽ºÀÇ Å×ÀÌºí ¹× ¿­¿¡¼­ ÀÛ¼ºÇÑ ³í¸® ¸ðµ¨(½ºÅ¸ ½ºÅ°¸¶). OLAP ¸ðµ¨À» »ç¿ëÇÏ¸é ´ÙÂ÷¿ø µ¥ÀÌÅͺ£À̽ºÀÇ ±¸Á¶¸¦ »ý¼ºÇÏ´Â ¸ÞŸÀ±°ûÀ» ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù. DB2 OLAP Integration Server µ¥½ºÅ©Å¾¿¡´Â OLAP MetaoutlineÀ̶ó´Â µµ±¸°¡ ÀÖ½À´Ï´Ù. ÀÌ µµ±¸¸¦ »ç¿ëÇÏ¸é °ü°èÇü µ¥ÀÌÅÍ ¼Ò½º¿¡ ±âÃÊÇÑ OLAP ¸ðµ¨À» ¼³°èÇϰí ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.

´ÙÂ÷¿ø µ¥ÀÌÅÍ
´ÙÂ÷¿ø µ¥ÀÌÅͺ£À̽ºÀÇ µ¥ÀÌÅÍ. µ¥ÀÌÅͷδ µ¥ÀÌÅͺ£À̽º Â÷¿ø¿¡¼­ ÃÖÇÏÀ§ ·¹º§ÀÇ ±¸¼º¿ø Á¶ÇÕÀ» ³ªÅ¸³»´Â ¿ÜºÎ ¼Ò½º¿¡¼­ ·ÎµåµÈ ±âº» µ¥ÀÌÅÍ °ª, ±âº» µ¥ÀÌÅÍ °ªÀ¸·ÎºÎÅÍ °è»êµÇ´Â µ¥ÀÌÅÍ °ª, ±×¸®°í Â÷¿ø °èÃþ ±¸Á¶¿¡ ÀÖ´Â ±¸¼º¿øµéÀÇ °ªµéÀ» °áÇÕÇÏ¿© ÀÛ¼ºµÇ´Â ·Ñ¾÷(roll-up)µÈ µ¥ÀÌÅÍ °ªÀÌ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù.

´ÙÂ÷¿ø µ¥ÀÌÅͺ£À̽º
Application Manager ¶Ç´Â ¸í·É(DB2 OLAP ServerÀÇ °æ¿ì)À» »ç¿ëÇϰųª Starter Kit¿¡ ÀÖ´Â DB2 OLAP Integration Server µ¥½ºÅ©Å¾À¸·Î ÀÛ¼ºÇÏ´Â OLAP µ¥ÀÌÅͺ£À̽º. ´ÙÂ÷¿ø µ¥ÀÌÅͺ£À̽º¿¡´Â µ¥ÀÌÅͺ£À̽º À±°û(outline), µ¥ÀÌÅÍ, ¿¬°áµÈ ¼±ÅÃÀû °è»ê ½ºÅ©¸³Æ®, ¼±ÅÃÀû º¸°í¼­ ½ºÅ©¸³Æ® ¹× µ¥ÀÌÅÍ ·Îµå ±ÔÄ¢ÀÌ ÀÖ½À´Ï´Ù. °ü°èÇü ÀúÀ念¿ª °ü¸®ÀÚ´Â °ü°èÇü µ¥ÀÌÅͺ£À̽ºÀÇ Å×ÀÌºí¿¡ ½ÇÁ¦ µ¥ÀÌÅÍ ¹× µ¥ÀÌÅͺ£À̽º À±°ûÀÇ À½¿µÀ» ÀúÀåÇÕ´Ï´Ù. ¿©·¯ ´ÙÂ÷¿ø µ¥ÀÌÅͺ£À̽º¸¦ ´ÜÀÏ °ü°èÇü µ¥ÀÌÅͺ£À̽º¿¡ ÀúÀåÇÒ ¼ö ÀÖ½À´Ï´Ù. ´ÙÂ÷¿ø µ¥ÀÌÅÍ ÀúÀ念¿ª °ü¸®ÀÚ´Â ÆÄÀÏ ½Ã½ºÅÛ¿¡ À±°û ¹× µ¥ÀÌÅ͸¦ ÀúÀåÇÕ´Ï´Ù.

°ü°èÇü µ¥ÀÌÅͺ£À̽º
µ¥ÀÌÅÍ Ç׸ñµé°£ÀÇ °ü°è¿¡ µû¶ó ±¸¼ºµÇ°í ¾×¼¼½ºµÇ´Â µ¥ÀÌÅͺ£À̽º. °ü°èÇü µ¥ÀÌÅͺ£À̽º´Â °ü°èÇü Å×À̺í, ºä ¹× »öÀÎÀÇ ÁýÇÕÀ» Æ÷ÇÔÇÕ´Ï´Ù. ¿©·¯ ´ÙÂ÷¿ø ÀÀ¿ëÇÁ·Î±×·¥ ¹× µ¥ÀÌÅͺ£À̽º¸¦ ´ÜÀÏ °ü°èÇü µ¥ÀÌÅͺ£À̽º¿¡ ÀúÀåÇÒ ¼ö ÀÖ½À´Ï´Ù.

°ü°èÇü Å¥ºê
´ÙÂ÷¿ø µ¥ÀÌÅͺ£À̽º¸¦ Á¤ÀÇÇÏ´Â °ü°èÇü µ¥ÀÌÅͺ£À̽ºÀÇ µ¥ÀÌÅÍ ¹× ¸ÞŸµ¥ÀÌÅÍ ¼¼Æ®. °ü°èÇü Å¥ºê´Â ´ÙÂ÷¿ø µ¥ÀÌÅͺ£À̽º¿Í ºñ½ÁÇÏÁö¸¸ °ü°èÇü µ¥ÀÌÅͺ£À̽º¿¡ ÀúÀåµÈ ´ÙÂ÷¿ø µ¥ÀÌÅͺ£À̽ºÀÇ ÀϺθ¦ ÀǹÌÇÕ´Ï´Ù.

½ºÅ¸ ½ºÅ°¸¶
»ç½Ç Å×À̺í(fact table)°ú ÀÏ·ÃÀÇ Â÷¿ø Å×À̺í. »ç½Ç Å×ÀÌºí¿¡´Â µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ ½ÇÁ¦ µ¥ÀÌÅÍ °ªÀÌ ÀÖ°í, Â÷¿ø Å×ÀÌºí¿¡´Â ±¸¼º¿ø°ú ±× ±¸¼º¿øµéÀÇ °ü°è¿¡ °üÇÑ µ¥ÀÌÅͰ¡ ÀÖ½À´Ï´Ù. Application Manager¸¦ »ç¿ëÇÏ¿© ´ÙÂ÷¿ø µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇÏ¸é °ü°èÇü µ¥ÀÌÅͺ£À̽º¿¡¼­ ÀÌ À¯ÇüÀÇ °ü°èÇü µ¥ÀÌÅͺ£À̽º ½ºÅ°¸¶¸¦ ÀÛ¼ºÇÕ´Ï´Ù.

SQL ÀÀ¿ëÇÁ·Î±×·¥
SQL(Structured Query Language) ¸í·É¹®À» »ç¿ëÇÏ´Â ÀÀ¿ëÇÁ·Î±×·¥. SQL ÀÀ¿ëÇÁ·Î±×·¥À» »ç¿ëÇÏ¿© °ü°èÇü Å¥ºêÀÇ µ¥ÀÌÅÍ¿¡ ¾×¼¼½ºÇÒ ¼ö ÀÖ½À´Ï´Ù.


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]