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 ÀÀ¿ëÇÁ·Î±×·¥À» »ç¿ëÇÏ¿© °ü°èÇü Å¥ºêÀÇ µ¥ÀÌÅÍ¿¡
¾×¼¼½ºÇÒ ¼ö ÀÖ½À´Ï´Ù.
[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]