- ÇöÀç À§Ä¡
- home > ÄÄÇ»ÅÍ¡¤ICT¡¤¾îÇÐ > ÄÄÇ»ÅÍ¡¤IT µµ¼ > µ¥ÀÌÅͺ£À̽º > DBA¶ó¸é ²À ¾Ë¾Æ¾ß ÇÒ Æ¼º£·Î ¿ÏÀüÁ¤º¹ °¡À̵å[ºñÆҺϽº]
Ŭ¶ó¿ìµå ¸ÂÃãÇü °í¼º´É DBMSÀΠƼº£·ÎÀÇ ¸ðµç °ÍÀÌ ´ã°Ü ÀÖ½À´Ï´Ù. ¡´µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ¸¦ À§ÇÑ Æ¼º£·Î ½ÇÀü °¡À̵塵°¡ ³ª¿Â ÀÌÈÄ 5³â µ¿¾È DB ´Ùº¯È¿Í Ŭ¶ó¿ìµå°¡ ´ë¼¼·Î ÀÚ¸®¸¦ Àâ°í ÀÖÀ¸¸ç, Ƽº£·Îµµ ±¹»ê Á¦Ç°À¸·Î½á ¾ÈÁ¤ÀûÀÎ ÀÔÁö¸¦ ±»È÷°í ÀÖ½À´Ï´Ù. ÀÌ Ã¥Àº ±âÁ¸ Ã¥À» ÀÌÇØÇϱ⠽±°Ô Ç®¾î ¾²°í, Ƽº£·Î 7ÀÇ »õ·Î¿î ±â´É°ú Ŭ¶ó¿ìµå ȯ°æ ±¸ÇöÀ» Ãß°¡·Î ´ã¾Ò½À´Ï´Ù. ¼³Ä¡, Ƽº£·Î ³»ºÎ±¸Á¶, TiberoStudio, °í±Þ ¾îµå¹Î ±â´ÉÀ» Æ÷ÇÔÇÑ ¾îµå¹Î, ¹é¾÷°ú º¹±¸, TAC, TSC, ¸¶À̱׷¹ÀÌ¼Ç ¹æ¹ý, AWS/KT/NCP¿¡¼ ±¸Çö ¹æ¹ýÀ» »ó¼¼ÇÏ°Ô ¼³¸íÇÏ°í ÀÖ½À´Ï´Ù. ÀÌ ÇÑ ±ÇÀ¸·Î Ƽº£·ÎÀÇ ¸ðµç °ÍÀ» ¹è¿ì°í È°¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
ÀúÀÚ: ¹ÚÁ¾Çö, Ƽ¸Æ½ºÆ¼º£·Î (ÁöÀºÀÌ)
1Àå ¾ÆÁÖ ½±°Ô Ƽº£·Î ¼³Ä¡Çϱâ
1. Áغñ »çÇ×
2. Ƽº£·Î7 ¼³Ä¡¸¦ À§ÇÑ VIRTUAL MACHINE ¸¸µé±â
3. Ƽº£·Î ¼³Ä¡Çϱâ
4. Ƽº£·Î ±âµ¿ ¹× Á¾·á
5. Ƽº£·Î ¼³Ä¡¸¦ À§ÇÑ ±Ç°í ¿ä±¸»çÇ×(LINUX, X86)
2Àå Ƽº£·Î ³»ºÎ ±¸Á¶ µÑ·¯º¸±â
1. Ƽº£·Î ÇÁ·Î¼¼½º
2. Ƽº£·Î ¸Þ¸ð¸®
3. Ƽº£·Î µð·ºÅ丮
3Àå Tibero Studio·Î Ƽº£·Î¸¦ °ü¸®ÇÏÀÚ
1. TIBERO STUDIO ¼Ò°³
2. ¼³Ä¡ Àü Áغñ»çÇ×
3. TIBERO STUDIO ¼³Ä¡
4. TIBERO STUDIO ±âµ¿
5. ȸ鱸¼º
6. ±âº» ±â´É
7. DBA ±â´É
8. °³¹ßÀÚ ±â´É
4Àå ÀÌÁ¦ ³ªµµ Ƽº£·Î DBAÀÌ´Ù
1. Ƽº£·Î ±¸¼º ÆÄÀÏ
2. »ç¿ëÀÚ¿Í º¸¾È
3. ¾ÏÈ£È
4. DBMS_SCHEDULER
5. ºÐ»ê Æ®·£Àè¼Ç(µ¥ÀÌÅͺ£À̽º ¸µÅ©, °ÔÀÌÆ®¿þÀÌ)
6. µ¥ÀÌÅÍ ÀÌ°ü À¯Æ¿¸®Æ¼
5Àå °í±Þ DBA°¡ µÇÀÚ
1. TPR(TIBERO PERFORMANCE REPOSITORY)
2. ¼¼¼Ç ¸ð´ÏÅ͸µ
3. SPINLOCK
4. WAIT EVENT
5. ¼öÇà Åë°èÄ¡
6. Åë°èÁ¤º¸ ¼öÁý
7. COMPRESSION
8. IMCS(IN MEMORY COLUMN STORE)
6Àå ¹é¾÷°ú º¹±¸µµ ôô
1. ¹é¾÷
2. º¹±¸
3. ½Ã³ª¸®¿À º° º¹±¸ ½Ç½À
4. TBRMGR(TIBERO RECOVERY MANAGER)
5. Ƽº£·Î FLAHBASK
7Àå TAC°¡ °í°¡¿ë¼ºÀ» Ã¥ÀÓÁø´Ù
1. TAC(TIBERO ACTIVE CLUSTER)
2. TBCM(TIBERO CLUSTER MANAGER)
3. TAS
4. TAC ±¸Ãà ½Ç½À
5. ·Îµå ¹ë·±½Ì°ú FAILOVER ¼³Á¤
6. ·Îµå ¹ë·±½Ì°ú FAILOVER Å×½ºÆ®
8Àå TSC·Î À糺¹±¸ »çÀÌÆ®¸¦ ±¸ÃàÇÏÀÚ
1. TSC(TIBERO STANDBY CLUSTER) ¼Ò°³
2. PRIMARY ±¸¼º ¹× ¿î¿µ
3. STANDBY ±¸¼º ¹× ¿î¿µ
4. TSC ¿ªÇÒ Àüȯ
5. CM OBSERVER ±¸¼º
6. TSC ±¸Ãà ½Ç½À
7. TSC Å×½ºÆ®
9Àå ÀÌÁ¦ Ƽº£·Î·Î ÀüȯÇÏÀÚ
1. Ƽº£·Î Àüȯ ½Ã °í·Á »çÇ×
2. »çÀü Á¡°Ë »çÇ×
3. Àüȯ µµ±¸
10Àå Ŭ¶ó¿ìµå¿¡ Ƽº£·Î ¼³Ä¡Çϱâ
1. Ŭ¶ó¿ìµå °³¿ä
2. KT CLOUD
3. NCP(NAVER CLOUD PLATFORM)
4. AWS
1. Áغñ »çÇ×
2. Ƽº£·Î7 ¼³Ä¡¸¦ À§ÇÑ VIRTUAL MACHINE ¸¸µé±â
3. Ƽº£·Î ¼³Ä¡Çϱâ
4. Ƽº£·Î ±âµ¿ ¹× Á¾·á
5. Ƽº£·Î ¼³Ä¡¸¦ À§ÇÑ ±Ç°í ¿ä±¸»çÇ×(LINUX, X86)
2Àå Ƽº£·Î ³»ºÎ ±¸Á¶ µÑ·¯º¸±â
1. Ƽº£·Î ÇÁ·Î¼¼½º
2. Ƽº£·Î ¸Þ¸ð¸®
3. Ƽº£·Î µð·ºÅ丮
3Àå Tibero Studio·Î Ƽº£·Î¸¦ °ü¸®ÇÏÀÚ
1. TIBERO STUDIO ¼Ò°³
2. ¼³Ä¡ Àü Áغñ»çÇ×
3. TIBERO STUDIO ¼³Ä¡
4. TIBERO STUDIO ±âµ¿
5. ȸ鱸¼º
6. ±âº» ±â´É
7. DBA ±â´É
8. °³¹ßÀÚ ±â´É
4Àå ÀÌÁ¦ ³ªµµ Ƽº£·Î DBAÀÌ´Ù
1. Ƽº£·Î ±¸¼º ÆÄÀÏ
2. »ç¿ëÀÚ¿Í º¸¾È
3. ¾ÏÈ£È
4. DBMS_SCHEDULER
5. ºÐ»ê Æ®·£Àè¼Ç(µ¥ÀÌÅͺ£À̽º ¸µÅ©, °ÔÀÌÆ®¿þÀÌ)
6. µ¥ÀÌÅÍ ÀÌ°ü À¯Æ¿¸®Æ¼
5Àå °í±Þ DBA°¡ µÇÀÚ
1. TPR(TIBERO PERFORMANCE REPOSITORY)
2. ¼¼¼Ç ¸ð´ÏÅ͸µ
3. SPINLOCK
4. WAIT EVENT
5. ¼öÇà Åë°èÄ¡
6. Åë°èÁ¤º¸ ¼öÁý
7. COMPRESSION
8. IMCS(IN MEMORY COLUMN STORE)
6Àå ¹é¾÷°ú º¹±¸µµ ôô
1. ¹é¾÷
2. º¹±¸
3. ½Ã³ª¸®¿À º° º¹±¸ ½Ç½À
4. TBRMGR(TIBERO RECOVERY MANAGER)
5. Ƽº£·Î FLAHBASK
7Àå TAC°¡ °í°¡¿ë¼ºÀ» Ã¥ÀÓÁø´Ù
1. TAC(TIBERO ACTIVE CLUSTER)
2. TBCM(TIBERO CLUSTER MANAGER)
3. TAS
4. TAC ±¸Ãà ½Ç½À
5. ·Îµå ¹ë·±½Ì°ú FAILOVER ¼³Á¤
6. ·Îµå ¹ë·±½Ì°ú FAILOVER Å×½ºÆ®
8Àå TSC·Î À糺¹±¸ »çÀÌÆ®¸¦ ±¸ÃàÇÏÀÚ
1. TSC(TIBERO STANDBY CLUSTER) ¼Ò°³
2. PRIMARY ±¸¼º ¹× ¿î¿µ
3. STANDBY ±¸¼º ¹× ¿î¿µ
4. TSC ¿ªÇÒ Àüȯ
5. CM OBSERVER ±¸¼º
6. TSC ±¸Ãà ½Ç½À
7. TSC Å×½ºÆ®
9Àå ÀÌÁ¦ Ƽº£·Î·Î ÀüȯÇÏÀÚ
1. Ƽº£·Î Àüȯ ½Ã °í·Á »çÇ×
2. »çÀü Á¡°Ë »çÇ×
3. Àüȯ µµ±¸
10Àå Ŭ¶ó¿ìµå¿¡ Ƽº£·Î ¼³Ä¡Çϱâ
1. Ŭ¶ó¿ìµå °³¿ä
2. KT CLOUD
3. NCP(NAVER CLOUD PLATFORM)
4. AWS
Ƽº£·Î¸¦ óÀ½ ½ÃÀÛÇϱ⿡ ¾È¼º¸ÂÃãÀԴϴ٠Ƽº£·Î ¼³Ä¡ ¹× °ü¸® ±â´ÉºÎÅÍ ÀÚ¼¼È÷ ¼³¸íÇÕ´Ï´Ù. ¶ÇÇÑ Æ¼º£·Î¸¦ ´õ ±íÀÌ ¾Ë¾Æ¾ß ÇÏ´Â DBA¿Í Æ©³Ê¿¡°Ô ÃÖÀûȵǾî ÀÖ½À´Ï´Ù DBMSÀÇ ±âº» °ü¸®¿¡ Àͼ÷ÇÏÁö¸¸ ¼º´É Æ©´×À̳ª °í°¡¿ë¼ºÀ̳ª Àç³ º¹±¸¿¡ ´É¼÷ÇÏÁö ¸øÇÑ ºÐµéÀ» À§ÇØ ¸¹Àº Áö¸éÀ» ÇÒ¾ÖÇؼ °³³ä°ú ½ÇÀü¿¡¼ÀÇ Àû¿ë ¹æ¹ýÀ» ½Ç½ÀÇÒ ¼ö ÀÖ°Ô ±¸¼ºµÇ¾î ÀÖ½À´Ï´Ù. Ŭ¶ó¿ìµå ȯ°æÀ» Áö¿øÇÕ´Ï´Ù KT CLOUD, AWS, NCP¿¡¼ Ƽº£·Î¸¦ ¿î¿ëÇÏ´Â ¹æ¹ýÀÌ ¼ö·ÏµÇ¾î ÀÖ½À´Ï´Ù »çÀÌÆ®¿Í ´Ù¸¥ Ã¥¿¡ ¾ø´Â ÀúÀÚµéÀÇ ³ëÇÏ¿ì°¡ ³ì¾Æ ÀÖ½À´Ï´Ù ÄÚµå ÇÑ...
´õº¸±â