OLAP ¼³Ä¡ ¹× »ç¿ëÀÚ ¾È³»¼
»õ ¶Ç´Â ±âÁ¸ DB2 Universal Database ¶Ç´Â ´ÙÂ÷¿ø ÀúÀ念¿ª °ü¸®ÀÚ¿¡
DB2 OLAP Server¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. Dual Storage Manager¸¦ ÅëÇØ ÀúÀ念¿ª
°ü¸®ÀÚ¸¦ »ç¿ëÇÏ´Â ÀÀ¿ëÇÁ·Î±×·¥À» ÀÛ¼ºÇϰí, ±âÁ¸ ÀÀ¿ëÇÁ·Î±×·¥¿ë
ÀúÀ念¿ª °ü¸®ÀÚ¸¦ ÀüȯÇÒ ¼ö ÀÖ½À´Ï´Ù. "Storage Manager ¼±ÅÃ"À»
ÂüÁ¶ÇϽʽÿÀ.
DB2 OLAP Server¸¦ ¼³Ä¡ÇÑ ÈÄ RDBMS¸¦ »ç¿ëÇÏ·Á´Â °æ¿ì º°µµ·Î RDBMS¸¦
¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù. DB2 OLAP Server¸¦ ¼³Ä¡Çϱâ Àü ¶Ç´Â ÈÄ¿¡ DB2 ¹× DB2
Universal Database¸¦ ¼³Ä¡ÇÒ ¼ö ÀÖ½À´Ï´Ù. DB2 Universal Database¸¦
¼³Ä¡ÇÑ °æ¿ì http://www.ibm.com/software/data/db2/db2tech/ÀÇ DB2 ¼ºñ½º
¹× Áö¿ø À¥ ÆäÀÌÁö¿¡¼ »ç¿ë °¡´ÉÇÑ ÃֽŠDB2 Universal Database¸¦
¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù.
°°Àº ½Ã½ºÅÛ¿¡ DB2 OLAP Server ¹× Information Catalog Manager¸¦ ¼³Ä¡ÇÏ·Á´Â
°æ¿ì µ¿½Ã¿¡ µÎ Á¦Ç°À» ¼³Ä¡ÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù.
¼³Ä¡ Áß ±¸ÀÔÇÑ
°³Á¤ÆÇ ¹× ¿É¼ÇÀ» ¹¯´Â ¸Þ½ÃÁö°¡ Ç¥½ÃµË´Ï´Ù. ÀÌ Á¤º¸´Â DB2 OLAP Server¿¡ ´ëÇÑ
»ç¿ë±Ç ۸¦ ÀÛ¼ºÇÏ´Â µ¥ »ç¿ëµË´Ï´Ù.
óÀ½ ¼³Ä¡Çϰųª ±âÁ¸ RDBMS ±¸¼º
ÆÄÀÏ(rsm.cfg)ÀÌ ¾ø´Â °æ¿ì °ü°èÇü
µ¥ÀÌÅͺ£À̽º À̸§, »ç¿ëÀÚ ID À̸§ ¾ÏÈ£¿¡ ´ëÇÑ Á¤º¸¸¦ ¹¯´Â ¸Þ½ÃÁö°¡
Ç¥½ÃµË´Ï´Ù. ¼³Ä¡ Áß ÀÌ Á¤º¸¸¦ Ãß°¡Çϰųª ¼³Ä¡ ¿Ï·á ÈÄ
rsm.cfg ÆÄÀÏÀ» °»½ÅÇÒ ¼ö ÀÖ½À´Ï´Ù.
DB2 ¶Ç´Â DB2 Universal Database¸¦ »ç¿ëÇÒ °æ¿ì ´ÙÀ½ Á¤º¸°¡ ÇÊ¿äÇÕ´Ï´Ù.
- °ü°èÇü µ¥ÀÌÅͺ£À̽º À̸§
- ´ÙÂ÷¿ø µ¥ÀÌÅ͸¦ ÀúÀåÇÏ·Á´Â °ü°èÇü µ¥ÀÌÅͺ£À̽ºÀÇ À̸§.
- °ü°èÇü µ¥ÀÌÅͺ£À̽º »ç¿ëÀÚ ID
- DB2 OLAP Server°¡ »ç¿ëÀÚÀÇ °ü°èÇü µ¥ÀÌÅͺ£À̽º¿¡ ·Î±×¿ÂÇÒ ¶§
»ç¿ëÇÏ·Á´Â »ç¿ëÀÚ ID.
- °ü°èÇü µ¥ÀÌÅͺ£À̽º ¾ÏÈ£
- DB2 OLAP Server°¡ »ç¿ëÀÚÀÇ °ü°èÇü µ¥ÀÌÅͺ£À̽º¿¡ ·Î±×¿ÂÇÒ ¶§ »ç¿ëÇϵµ·Ï
ÇÒ »ç¿ëÀÚ ID¿¡ ´ëÇÑ ¾ÏÈ£. ÀÌ ¾ÏÈ£´Â °ü°èÇü ÀúÀ念¿ª °ü¸®ÀÚ ±¸¼º
ÆÄÀÏ(rsm.cfg)¿¡ ¾ÏȣȵÇÁö ¾ÊÀº ä ÀúÀåµË´Ï´Ù. »ç¿ëÀÚ ID ¹× ¾ÏÈ£ Çʵ带
°ø¹éÀ¸·Î ³²°Ü µÑ ¼ö ÀÖ½À´Ï´Ù. »ç¿ëÀÚ ID ¶Ç´Â ¾ÏÈ£¸¦ ÁöÁ¤ÇÏÁö ¾ÊÀº °æ¿ì
DB2 OLAP Server¿¡¼ »ç¿ëÀÚ°¡ ¿öÅ©½ºÅ×À̼ǿ¡ ·Î±×¿ÂÇÏ´Â µ¥ »ç¿ëÇÑ »ç¿ëÀÚ ID
¹× ¾ÏÈ£¸¦ »ç¿ëÇÏ¿© °ü°èÇü µ¥ÀÌÅͺ£À̽º¿¡ ·Î±×¿ÂÇÏ·Á ÇÕ´Ï´Ù. ÀÌ »ç¿ëÀÚ ID¿¡
°ü°èÇü µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ ¾×¼¼½º°¡ ¾ø´Â °æ¿ì °ü°èÇü µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ
¾×¼¼½º°¡ °ÅºÎµË´Ï´Ù.
DB2 OLAP Server ¹öÀü 7.1ÀÇ ±¸¼º¿ä¼Ò
- ¹®¼
- Information Catalog Manager
- Ŭ¶óÀÌ¾ðÆ® ±¸¼º¿ä¼Ò
- Hyperion Essbase Server
- ESSCMD ¸í·ÉÇà ÀÎÅÍÆäÀ̽º
- ´ÙÂ÷¿ø ÀúÀ念¿ª °ü¸®ÀÚ(MDSM)
- IBMÀÇ °ü°èÇü ÀúÀ念¿ª °ü¸®ÀÚ
- Application Manager
- ½ºÇÁ·¹µå½ÃÆ® Ãß°¡ ±â´É
- ÅëÇÕ ¼¹ö µ¥½ºÅ©Å¾
- ¼¹ö ±¸¼º¿ä¼Ò
- DB2 OLAP Server
- »ùÇà ÀÀ¿ëÇÁ·Î±×·¥
- ±¸ÀÔÇÒ ¼ö ÀÖ´Â Ãß°¡ ±¸¼º¿ä¼Ò´Â ´ÙÀ½°ú °°½À´Ï´Ù.
- Administration Manager¸¦ Æ÷ÇÔÇÑ DB2 OLAP Integration Server
- DB2 OLAP Integration Server¿ë ODBC µå¶óÀ̹ö
- ODBC µå¶óÀ̹ö¸¦ Æ÷ÇÔÇÑ SQL Interface
- API
- ÅëÈ º¯È¯
- Extended Spreadsheet ŸŶ
- À¥ °ÔÀÌÆ®¿þÀÌ
- Objects
- Allocations Manager
- ÆÄƼ¼Ç
Windows¿¡¼ DB2 OLAP Server¸¦ ¼³Ä¡ÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ½ÇÇàÇϽʽÿÀ.
- ¼¹ö¿¡¼ CD-ROM µå¶óÀ̺꿡 CD-ROMÀ» ³Ö¾î ¼³Ä¡ ·±Ä¡ÆÐµå¸¦
Ç¥½ÃÇϽʽÿÀ. ·±Ä¡ÆÐµå°¡ ³ªÅ¸³ªÁö ¾ÊÀ¸¸é ·çÆ® µð·ºÅ丮¿¡¼
setup.exe¸¦ ½ÇÇàÇÒ ¼ö ÀÖ½À´Ï´Ù.
- ·±Ä¡ÆÐµå¿¡¼ ¼³Ä¡¸¦ ¼±ÅÃÇϽʽÿÀ. ¾ðÁ¦µç ¼³Ä¡¸¦ Ãë¼ÒÇÏ·Á¸é
Ãë¼Ò¸¦ ´©¸£½Ê½Ã¿À. ¾ðÁ¦µç µµ¿ò¸»À»
Ç¥½ÃÇÏ·Á¸é F1À» ´©¸£½Ê½Ã¿À.
- ÇÁ·ÒÇÁÆ®°¡ Ç¥½ÃµÇ¸é ±¸ÀÔÇÑ DB2 OLAP ServerÀÇ °³Á¤ÆÇÀ» ¼±ÅÃÇϽʽÿÀ.
- ÇÁ·ÒÇÁÆ®°¡ Ç¥½ÃµÇ¸é ±¸ÀÔÇÑ ¼±ÅÃÀû ±¸¼º¿ä¼Ò¸¦ ¼±ÅÃÇϽʽÿÀ. ¼±ÅÃÀû
±¸¼º¿ä¼ÒÀÇ ¸ñ·Ï¿¡ ´ëÇØ¼´Â "DB2 OLAP Server ±¸¼º¿ä¼Ò ¹× Ãß°¡ ±â´É"À» ÂüÁ¶ÇϽʽÿÀ.
- ±ÇÀå»çÇ×. °°Àº ½Ã½ºÅÛ¿¡ DB2 OLAP Server ¹× Information Catalog Manager¸¦
¼³Ä¡ÇÏ·Á´Â °æ¿ì µ¿½Ã¿¡ µÎ Á¦Ç°À» ¼³Ä¡ÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù.
- ³ª¸ÓÁö ¼³Ä¡ â¿¡ ¿äûµÈ Á¤º¸¸¦ Á¦°øÇϽʽÿÀ.
- ¼±ÅÃÀû. ¼³Ä¡°¡ ¿Ï·áµÇ¸é Windows ȯ°æ º¯¼ö¸¦ Á¡°ËÇϽʽÿÀ.
ȯ°æ º¯¼ö ¼öµ¿ °»½ÅÀ» ÂüÁ¶ÇϽʽÿÀ.
- ¼¹ö¸¦ ´Ù½Ã ½ÃÀÛÇϽʽÿÀ.
- ¼±ÅÃÀû. DB2 OLAP Integration Server Ãß°¡ ±â´ÉÀ» ¼³Ä¡ÇϽʽÿÀ.
"DB2 OLAP Integration Server ¼³Ä¡"¸¦ ÂüÁ¶ÇϽʽÿÀ.
- ¼±ÅÃÀû. SQL Interface¸¦ ¼³Ä¡ÇϽʽÿÀ. SQL Interface¿¡´Â ODBC
µå¶óÀ̹ö°¡ Æ÷ÇԵ˴ϴÙ. "SQL Interface¿¡ ´ëÇÑ ODBC ·Îµå ¹× ±¸¼º"À»
ÂüÁ¶ÇϽʽÿÀ.
- ¼±ÅÃÀû. ÀÓÀÇÀÇ Ãß°¡ ±â´É ±¸¼º¿ä¼Ò¸¦ ´õ ¼³Ä¡ÇϽʽÿÀ.
- »ùÇà ÀÀ¿ëÇÁ·Î±×·¥À» ¼³Ä¡ÇÑ °æ¿ì Application Manager¸¦ »ç¿ëÇÏ¿©
µ¥ÀÌÅ͸¦ ·ÎµåÇϽʽÿÀ. Application Manager ¿Â¶óÀÎ µµ¿ò¸» ¹× Essbase
¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
DB2 OLAP Server ¼³Ä¡ ÇÁ·Î±×·¥¿¡¼ ´ÙÀ½°ú °°Àº Á¶Ä¡¸¦ ¼öÇàÇÕ´Ï´Ù.
- ÇÏµå µð½ºÅ©ÀÇ c:\program files\essbase\bin
µð·ºÅ丮(¶Ç´Â »ç¿ëÀÚ°¡ ÁöÁ¤ÇÑ ´Ù¸¥ µð·ºÅ丮)·Î DB2 OLAP Server ÆÄÀÏÀ»
º¹»çÇÕ´Ï´Ù. µð·ºÅ丮°¡ ¾ø´Â °æ¿ì ¼³Ä¡ ÇÁ·Î±×·¥¿¡¼ µð·ºÅ丮¸¦
ÀÛ¼ºÇÕ´Ï´Ù. µð·ºÅ丮 ±¸Á¶´Â ´ÙÀ½°ú °°½À´Ï´Ù.
ESSBASE
BIN
APP
BIN ¼ºêµð·ºÅ丮¿¡´Â DB2 OLAP Server ¼ÒÇÁÆ®¿þ¾î°¡
ÀÖ½À´Ï´Ù.
APP ¼ºêµð·ºÅ丮¿¡´Â ÀÛ¼ºÇÑ
°¢ DB2 OLAP ServerÀÇ ¼ºêµð·ºÅ丮°¡ ÀÖ½À´Ï´Ù. ÀÀ¿ëÇÁ·Î±×·¥À̳ª
ÀÀ¿ëÇÁ·Î±×·¥ ³»ÀÇ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ ¼öÇàÇÑ ¸ðµç »ç¿ëÀÚ ¿äûÀ»
ÃßÀûÇϴ Ȱµ¿ ·Î±× ÆÄÀÏÀº °¢ ÀÀ¿ëÇÁ·Î±×·¥¿¡ ´ëÇÑ ¸Ç À§ µð·ºÅ丮¿¡
ÀúÀåµË´Ï´Ù.
- Åë½Å ÇÁ·ÎÅäÄÝ Áö¿øÀ» ¼³Ä¡ÇÕ´Ï´Ù.
- Windows ·¹Áö½ºÆ®¸® ¹× ȯ°æ º¯¼ö¸¦ °»½ÅÇÕ´Ï´Ù. »ç¿ëÀÚ´Â ³¯Â¥°¡
Áö³ Ç׸ñÀ» ¸ðµÎ Á¦°ÅÇØ¾ß ÇÕ´Ï´Ù.
- Windows ¿öÅ©½ºÅ×À̼ÇÀÇ °°Àº ·çÆ® Essbase µð·ºÅ丮¿¡ ¼¹ö ¹×
Ŭ¶óÀÌ¾ðÆ® ±¸¼º¿ä¼Ò°¡ ¼³Ä¡µÇ¾î ÀÖ¾î¾ß Çϰí, ARBORPATH ȯ°æ º¯¼ö¿¡¼
°°Àº µð·ºÅ丮¸¦ Áö½ÃÇØ¾ß ÇÕ´Ï´Ù.
[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]