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

±¸¼º ÆÄÀÏ ÆíÁý

ÀÌ Àý¿¡´Â ±¸¼º ÆÄÀÏÀÇ ¼­½Ä°ú, ±× ÆÄÀÏ¿¡ Æ÷Ç﵃ ¼ö ÀÖ´Â ¸Å°³º¯¼öµéÀÇ ±¸¹®¿¡ °üÇÑ ÀÚ¼¼ÇÑ Á¤º¸°¡ ¼ö·ÏµÇ¾î ÀÖ½À´Ï´Ù. ¶ÇÇÑ, °¢ ¸Å°³º¯¼ö¿¡ ´ëÇØ ÁöÁ¤ÇÒ ¼ö ÀÖ´Â ¿Ã¹Ù¸¥ °ª¿¡ °üÇÑ ÀÚ¼¼ÇÑ Á¤º¸µµ ¼ö·ÏµÇ¾î ÀÖ½À´Ï´Ù.

±¸¼º ÆÄÀÏ¿¡´Â ¸Å°³º¯¼ö¸¦ ÁöÁ¤ÇÏ´Â ¼¼ °¡Áö Á¾·ùÀÇ ¼½¼ÇÀÌ ÀÖ½À´Ï´Ù.

rsm.cfg ÆÄÀÏÀÇ ÀÌ ¼¼ °¡Áö ¼½¼ÇÀº °¢ ·¹º§¿¡¼­ ´ëü °ªÀ» ÁöÁ¤ÇÒ ¼ö ÀÖ´Â °èÃþ ±¸Á¶¸¦ Çü¼ºÇÕ´Ï´Ù. DB2 OLAP Server´Â µ¥ÀÌÅͺ£À̽º³ª ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼Ç¿¡ ´ëü°ªÀ» ÁöÁ¤ÇÏÁö ¾ÊÀ¸¸é RSM ¼½¼ÇÀÇ ¼³Á¤°ªÀ» »ç¿ëÇÕ´Ï´Ù. ÀÀ¿ëÇÁ·Î±×·¥À» ÀÛ¼ºÇϰųª ½ÃÀÛÇÒ ¶§, DB2 OLAP Server´Â ±× ÀÀ¿ëÇÁ·Î±×·¥¿¡ ´ëÇÑ ±¸¼º ÆÄÀÏÀÇ ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼ÇÀ» ã¾Æ¼­ RSM ¼½¼Ç¿¡ ÀÖ´Â °ªÀ» ±× ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼Ç¿¡¼­ ¹ß°ßµÇ´Â °ªÀ¸·Î ´ëüÇÕ´Ï´Ù. µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇϰųª ½ÃÀÛÇÒ ¶§, DB2 OLAP Server´Â ÇöÀç ÀÀ¿ëÇÁ·Î±×·¥¿¡ ´ëÇÑ ¼½¼Ç ³»ÀÇ ÇØ´ç µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ ±¸¼º ÆÄÀÏ¿¡¼­ µ¥ÀÌÅͺ£À̽º ¼½¼ÇÀ» ã¾Æ¼­ ÀÀ¿ëÇÁ·Î±×·¥¿¡ ÀÖ´Â °ªÀ» ±× µ¥ÀÌÅͺ£À̽º ¼½¼Ç¿¡¼­ ¹ß°ßµÇ´Â °ªÀ¸·Î ´ëüÇÕ´Ï´Ù.

±¸¼º ÆÄÀÏ¿¡¼­ ¸Å°³º¯¼ö Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.

tag=value

tag´Â ¸Å°³º¯¼ö À̸§À̰í, value´Â º¯¼ö(¿¹: µ¥ÀÌÅͺ£À̽º À̸§, ¹øÈ£ ¶Ç´Â ¹®ÀÚ¿­)ÀÇ °ªÀ̳ª °¡´ÉÇÑ °ªÀÇ ¸ñ·Ï(¿¹: ºÐ¸® ·¹º§ÀÇ ¸ñ·Ï)¿¡¼­ ¼±ÅÃÇÏ´Â °ªÀÔ´Ï´Ù. ÅØ½ºÆ® °ªÀº µû¿ÈÇ¥·Î ¹­Áö ¾Ê½À´Ï´Ù.

¼±ÅÃÇÑ ÆíÁý±â¸¦ »ç¿ëÇÏ¿© ±¸¼º ÆÄÀÏÀ» ÆíÁýÇÒ ¼ö ÀÖ½À´Ï´Ù.

»ùÇà ±¸¼º ÆÄÀÏ

´ÙÀ½ ÀÏ·ÃÀÇ ¿¹´Â Windows NT, UNIX ¹× OS/390¿ë ±âº» ¹× °í±Þ »ùÇà ±¸¼º ÆÄÀÏÀ» º¸¿©ÁÝ´Ï´Ù.

±×¸² 7ÀÇ »ùÇÃÀº Windows NT ¶Ç´Â UNIX¿ë ±âº» ±¸¼º Å×À̺íÀÔ´Ï´Ù. ½Ã½ºÅÛ °ü¸®ÀÚ´Â DB2 OLAP Server°¡ TSOLAP¿¡ ¸ðµç Å×ÀÌºí µ¥ÀÌÅ͸¦ ÀúÀåÇÏ°í ¸ðµç »öÀÎ µ¥ÀÌÅͰ¡ TSOLAPX°¡ µÇµµ·Ï Ãʱ⠱¸¼º ÆÄÀÏÀ» ¼³Á¤ÇÕ´Ï´Ù. »ç¿ëÀÚÀÇ ¸ðµç Å¥ºê¸¦ °°Àº µ¥ÀÌÅͺ£À̽º ¹× Å×ÀÌºí °ø°£¿¡ À§Ä¡½ÃŰ·Á°í ÇÒ ¶§ ÀÌ ±¸¼º ÆÄÀϰú °°Àº ±âº» ±¸¼º ÆÄÀÏÀ» »ç¿ëÇϽʽÿÀ.

±×¸² 7. Windows NT ¶Ç´Â UNIX¿¡¼­ÀÇ ±âº» ±¸¼º ÆÄÀÏ

                /* Config file - system defaults */
                [RSM]                        /* Required tag to start the main section */
                RDB_NAME     = OLAP          /* Default to using the OLAP database */
                RDB_USERID   = ROLAP         /* Specify the userid */
                RDB_PASSWORD = xxxxxxxx      /* Specify the password */
                TABLESPACE   = IN TSOLAP INDEX IN TSOLAPX  /* All tables will go in this */
                                                           /* one tablespace */
 

±×¸² 8Àº ¼±ÅÃÀû ¸Å°³º¯¼ö°¡ OLAP ÀÀ¿ëÇÁ·Î±×·¥ ¹× ´ÙÂ÷¿ø µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ ´ëüµÇ´Â Windows NT ¹× UNIX¿ë ±¸¼º ÆÄÀÏÀ» º¸¿©ÁÝ´Ï´Ù. ´õ ¸¹Àº µ¥ÀÌÅͺ£À̽º¿¡ ¸Âµµ·Ï ´õ ¸¹Àº Å×ÀÌºí °ø°£À» »ç¿ëÇÏ·Á°í ÇÒ °æ¿ì ÀÌ¿Í °°Àº ±¸¼º ÆÄÀÏÀ» »ç¿ëÇϽʽÿÀ. ÀÌ ¿¹¿¡¼­, ±Þ¿© µ¥ÀÌÅÍ´Â TSPR¿¡ ÀÖ°í, ±Þ¿© Å×ÀÌºí »öÀÎÀº TSPRX¿¡ ÀÖ½À´Ï´Ù. ÀÌÀÍ ¹× ¼Õ½Ç µ¥ÀÌÅÍ´Â TSPL¿¡ ÀÖ°í ÀÌÀÍ ¹× ¼Õ½Ç Å×ÀÌºí »öÀÎÀº TSPLX¿¡ ÀÖ½À´Ï´Ù. ´Ù¸¥ ¸ðµç Å×À̺íÀº TSOLAP¿¡ »óÁÖÇϸç, ÇØ´çµÇ´Â »öÀεéÀº TSOLAPX¿¡ »óÁÖÇÕ´Ï´Ù. ¶ÇÇÑ °¢ ´ÙÂ÷¿ø µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ º°µµÀÇ »ç½Ç Å×ÀÌºí ¹× »ç½Ç Å×ÀÌºí »öÀÎÀÌ ÀÖ½À´Ï´Ù.

±×¸² 8. Windows NT ¶Ç´Â UNIX¿¡¼­ÀÇ °í±Þ ±¸¼º ÆÄÀÏ

               /* Config file - system defaults */
               [RSM]                        /* Required tag to start the main section */
               RDB_NAME     = OLAP          /* Default to using the OLAP database */
               RDB_USERID   = ROLAP         /* Specify the userid */
               RDB_PASSWORD = xxxxxxxx      /* Specify the password */
               TABLESPACE   = IN TSOLAP INDEX IN TSOLAPX  /* Tables go here unless */
                                                          /* overridden below */
 
               /* Application - Accounts */
               [ACCOUNTS]
               RDB_NAME     = ACCTS         /* Application uses its own database */
 
               /* Application - Accounts : Database - Payroll */
               <Payroll>
               TABLESPACE   = IN TSPR  INDEX IN TSPRX   /* Non-fact tables have their */
                                                        /* own tablespaces */
               FACTS        = IN TSPRF INDEX IN TSPRFX  /* Fact table has its own */
                                                        /* tablespaces */
 
               /* Application - Accounts : Database - Profit and Loss */
               <PandL>
               TABLESPACE   = IN TSPL  INDEX IN TSPLX   /* Non-fact tables have their*/
                                                        /* own tablespaces */
               FACTS        = IN TSPLF INDEX IN TSPLFX  /* Fact table has its own */
                                                        /* tablespaces */
 

±¸¼º ÆÄÀÏ¿¡ ÁÖ¼® ÀÔ·Â

±¸¼º ÆÄÀÏ¿¡ ÁÖ¼®À» ÀÔ·ÂÇÏ·Á¸é, ´ÙÀ½ ±ÔÄ¢À» µû¸£½Ê½Ã¿À.

RSM ¼½¼Ç

±¸¼º ÆÄÀÏÀº ´ÙÀ½ÀÇ Çì´õ ű׷Π½ÃÀÛÇÕ´Ï´Ù.

[RSM]

±¸¼º ÆÄÀÏ¿¡´Â ´ÙÀ½ ¸Å°³º¯¼öµµ µé¾î ÀÖ¾î¾ß ÇÕ´Ï´Ù.

RDB_NAME = databasename

¿©±â¼­ databasenameÀº DB2 OLAP Server¿¡¼­ OLAP ÀÀ¿ëÇÁ·Î±×·¥ ¹× µ¥ÀÌÅͺ£À̽º¸¦ ÀúÀåÇÒ °ü°èÇü µ¥ÀÌÅͺ£À̽ºÀÇ À̸§ÀÔ´Ï´Ù.

±¸¼º ÆÄÀÏ ¸Å°³º¯¼ö¿¡ ¼³¸íµÇ¾î ÀÖ´Â ¸ðµç ¸Å°³º¯¼ö°¡ RSM ¼½¼Ç¿¡¼­ À¯È¿ÇÕ´Ï´Ù.

ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼Ç

RSM ¼½¼Ç¿¡ ÀÖ´Â ¸Å°³º¯¼ö ¼¼Æ®¸¦ ´ëüÇÒ ¸Å°³º¯¼ö°¡ µé¾î ÀÖ´Â ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼ÇÀ» ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.

ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼ÇÀº ÀÀ¿ëÇÁ·Î±×·¥ÀÇ À̸§À» ³ªÅ¸³»´Â ű׷Π½ÃÀÛÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, ÀÀ¿ëÇÁ·Î±×·¥ À̸§ÀÌ SAMPLEÀ̸é, ±×¸² 7¿¡ ³ª¿Í ÀÖ´Â °Íó·³, [SAMPLE] ű׸¦ »ç¿ëÇÏ¿© ±× ÀÀ¿ëÇÁ·Î±×·¥¿¡ ´ëÇÑ ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼ÇÀ» Æ÷ÇÔ½Ãų ¼ö ÀÖ½À´Ï´Ù.

ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼ÇÀº RSM ¼½¼ÇÀÇ ¸¶Áö¸· ¸Å°³º¯¼ö ´ÙÀ½¿¡ ½ÃÀ۵Ǿî¾ß ÇÕ´Ï´Ù.

´ÙÀ½ ¸Å°³º¯¼ö°¡ ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼Ç¿¡ ´ëÇØ À¯È¿ÇÕ´Ï´Ù.

°¢ ¸Å°³º¯¼ö¿¡ ´ëÇÑ ¼³¸íÀº ±¸¼º ÆÄÀÏ ¸Å°³º¯¼ö¸¦ ÂüÁ¶ÇϽʽÿÀ.

µ¥ÀÌÅͺ£À̽º ¼½¼Ç

ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼Ç¿¡¼­ ¼³Á¤µÈ ¸Å°³º¯¼ö¸¦ ´ëüÇÒ ¸Å°³º¯¼ö°¡ µé¾î ÀÖ´Â µ¥ÀÌÅͺ£À̽º ¼½¼ÇÀ» ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.

µ¥ÀÌÅͺ£À̽º ¼½¼ÇÀº <database> ű׷Π½ÃÀÛÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, SAMPLE ÀÀ¿ëÇÁ·Î±×·¥¿¡ BASIC µ¥ÀÌÅͺ£À̽º°¡ ÀÖÀ¸¸é, <BASIC>À» »ç¿ëÇÏ¿© ±× µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ µ¥ÀÌÅͺ£À̽º ¼½¼ÇÀ» ½ÃÀÛÇÕ´Ï´Ù.

µ¥ÀÌÅͺ£À̽º ¼½¼ÇÀº ÇØ´çµÇ´Â ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼ÇÀÇ ¸¶Áö¸· ¸Å°³º¯¼ö ´ÙÀ½¿¡ ½ÃÀ۵Ǿî¾ß ÇÕ´Ï´Ù.

TABLESPACE, FACTS, PARTITIONING, FINDEX, KINDEX ¸Å°³º¯¼ö¸¸ÀÌ µ¥ÀÌÅͺ£À̽º ¼½¼Ç¿¡¼­ À¯È¿ÇÕ´Ï´Ù. ÀÌ ¸Å°³º¯¼öµé¿¡ ´ëÇØ¼­´Â ±¸¼º ÆÄÀÏ ¸Å°³º¯¼ö¿¡ ¼³¸íµÇ¾î ÀÖ½À´Ï´Ù.


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