Oracle Warehouse Builder 11g ʹÓÃÈëÃÅ
ÔÚ±¾½Ì³ÌÖУ¬Äú½«Ê¹ÓÃÉèÖÃÎļþÅäÖà Oracle Warehouse Builder 11g µÚ 1 °æ (OWB 11gR1) µÄÏîÄ¿»·¾³¡£È»ºó£¬Äú½«´´½¨Ò»¸ö Warehouse Builder Óû§²¢µÇ¼¡£
ËùÐèʱ¼ä
´óÔ¼ 30 ·ÖÖÓ
×¢£º OWB 11g ÉèÖýű¾µÄÏÂÔØ˵Ã÷ÔÚ±¾½Ì³ÌÉԺ󲿷ÖÌṩ¡£±¾½Ì³Ì¼°ÆäÉèÖýű¾½öÖ§³Ö OWB 11g µÚ 1 °æ¡£¸Ã Oracle ʾÀý½Ì³ÌµÄÔçÆÚ°æ±¾¿ÉÓÃÓÚ OWB 10g µÚ 1 °æºÍµÚ 2 °æ¡£
Ö÷Ìâ
±¾¿Î³ÌÌÖÂÛÒÔÏÂÖ÷Ì⣺
¸ÅÊö
Ç°ÌáÌõ¼þ
²Î¿¼×ÊÁÏ
Warehouse Builder 11g Ìåϵ½á¹¹ºÍ×é¼þ
ÉèÖÃÏîÄ¿»·¾³
½éÉÜ OWB ³ÌÐò×é×é¼þ
µÇ¼µ½ Design Center
×ܽá
¸ÅÊö
ÔÚ±¾½Ì³ÌÖУ¬Äú½«Ñ§Ï°ÈçºÎÏÂÔز¢Ö´ÐÐÉèÖÃÎļþÒÔÅäÖà Warehouse Builder »·¾³¡£Äú»¹½«Ê¹Óà OWB Repository Assistant ´´½¨Ò»¸öÓû§£¬ÒԵǼµ½´æ´¢²Ö¿âÉè¼ÆÔªÊý¾ÝµÄ Oracle Warehouse Builder ÐÅÏ¢¿â¡£
Ç°ÌáÌõ¼þ
Ϊʹ±¾½Ì³Ì˳Àû½øÐУ¬ÄúÓ¦¸ÃÏÈÍê³ÉÒÔÏÂ×¼±¸¹¤×÷£º
1.
Íê³É Oracle Êý¾Ý¿â£¨ÆóÒµ°æ£©10g µÚ 2 °æ£¨°üº¬ 10.2.0.3 ²¹¶¡ÒÔÖ§³Ö OLAP£©»ò 11g µÚ 1 °æ (11.1) µÄ°²×°¡£½¨ÒéÄúΪ±¾½Ì³Ì´´½¨Ò»¸öÃûΪ orcl µÄÊý¾Ý¿â¡£·ñÔò£¬Ã¿µ±Äú¿´µ½±¾½Ì³ÌÌáµ½ orcl ʱ£¬¾ÍÐèÒªÌæ»»Êý¾Ý¿âµÄ Oracle ·þÎñÃû³Æ¡£
×¢£º±¾ÉÏ»ú²Ù×÷½Ì³ÌÒѾʹÓà OWB 11g µÚ 1 °æÔÚ Oracle Êý¾Ý¿â 10g µÚ 2 °æ (10.2.0.3) ʵÀýÉϽøÐÐÁ˲âÊÔ¡£Äú¿ÉÒÔÑ¡ÔñʹÓà Oracle Êý¾Ý¿â 10g µÚ 2 °æ (10.2.0.3) »ò 11g µÚ 1 °æÔËÐиÃÉÏ»ú²Ù×÷¡£
ΪÁ˼ò»¯ÉèÖ㬱¾½Ì³Ì¼ÙÉèÊý¾Ý¿âºÍ Warehouse Builder λÓÚͬһ̨¼ÆËã»úÉÏ¡£¶ÔÓÚ±¾½Ì³Ì£¬Ç¿ÁÒ½¨ÒéÄú½«Êý¾Ý¿âºÍ Warehouse Builder °²×°ÔÚͬһ̨¼ÆËã»úÉÏ¡£
×¢£ºÈç¹ûÄú½« Warehouse Builder 11g µÚ 1 °æÓëÊý¾Ý¿â 10g µÚ 2 °æÅäºÏʹÓã¬È·±£½« Warehouse Builder °²×°µ½Ò»¸ö¿Õ°×µÄ Oracle Ö÷Ŀ¼£¨¶ø·ÇÊý¾Ý¿âµÄ Oracle Ö÷Ŀ¼£©ÖС£
2.
Íê³É Oracle Warehouse Builder 11g µÚ 1 °æµÄ°²×°¡£
×¢£ºWarehouse Builder ÏÖÔڵijÌÐò°üÓëÒÔÇ°²»Í¬£¬Ëü°üº¬ÒÔÏÂËĸö×é¼þ£º
ETL ºËÐÄÌØÐÔ£ºETL ºËÐÄÌØÐÔÔÚÊý¾Ý¿â±ê×¼°æ¡¢±ê×¼°æ 1 ºÍÆóÒµ°æÖÐÃâ·ÑÌṩ¡£ETL ºËÐÄÌØÐÔÖ¼ÔÚ½«ºËÐÄÅú´¦Àí ETL ¹¦ÄÜ×÷ΪÊý¾Ý¿âÐí¿ÉµÄÒ»²¿·ÖÌṩ¡£Ãâ·ÑÌṩµÄºËÐÄÌØÐÔ´ú±íÁË Warehouse Builder µ±Ç°µÄ 10g µÚ 1 °æÌṩµÄ¹¦ÄÜÔÙ¼ÓÉϓרҵ”ÌØÐÔ¡£
ÆóÒµ ETL Ñ¡¼þ£ºÆóÒµ ETL Ñ¡¼þÖ¼ÔÚͨ¹ýÌá¸ßÌáÈ¡/ת»»/¼ÓÔØ (ETL) ×÷ÒµµÄ¿ÉÉìËõÐÔºÍÐÔÄÜÀ´Ö§³Ö´óÐͺ͸´ÔӵIJ¿Ê𡣸ÃÑ¡¼þÖаüº¬µÄijЩÌØÐÔÓн¥±äά¶ÈÀàÐÍ 2 ºÍ 3 Ö§³Ö¡¢¿É´«Êä±í¿Õ¼ä¡¢½»»¥Ê½Ï
Ïà¹ØÎĵµ£º
1,Áгö×îµÍн½ð´óÓÚ1500µÄ¸÷ÖÖ¹¤×÷¼°´ÓÊ´˹¤×÷µÄÈ«²¿¹ÍÔ±ÈËÊý¡£
select job,count(empno) from emp
where job in(select job from emp group by job having min(sal)>1500)
group by job;
2£¬Áгöн½ð¸ßÓÚ¹«Ë¾Æ½¾ùн½ðµÄËùÓÐÔ±¹¤ËùÔÚ²¿ÃÅ£¬Éϼ¶Áìµ¼£¬¹«Ë¾µÄ¹¤×ʵȼ¶¡£
select e.ename,d.dname,m.ename,e.sal,sa. ......
×ÛºÏÁ·Ï°
ѧÉúÔ˶¯»á±ÈÈüÐÅÏ¢Êý¾Ý¿â
1£¬Ô˶¯Ô±sporter£¨Ô˶¯Ô±±àºÅsporterid£¬Ô˶¯Ô±ÐÕÃûname£¬Ô˶¯Ô±ÐÔ±ðsex£¬ËùÊôϵºÅdepartment£©
2£¬ÏîÄ¿item£¨ÏîÄ¿±àºÅitemid£¬ÏîÄ¿Ãû³Æitemname£¬ÏîÄ¿±ÈÈüµØµãlocation£©
3£¬³É¼¨grade£¨Ô˶¯Ô±±àºÅsporterid£¬ÏîÄ¿±àºÅitemid£¬»ý·Ömark£©
½¨±í
1£¬¶¨Òå¸÷¸ö±íµÄÖ÷ÂëÍâÂëÔ¼Êø
2£¬ ......
http://www.oracle.com/technology/global/cn/obe/2day_dba/index.html
¿Î³ÌÁбí
1
¹ÜÀíÊý¾Ý¿âµÄÒªËØÊÇʲô£¨Ã»Óб¾Õ¶ÔÓ¦µÄ¸½¼Ó×ÊÁÏ£©
2
°²×° Oracle ºÍ¹¹½¨Êý¾Ý¿â
3
Oracle Enterprise Manager Êý¾Ý¿â¿ØÖÆÈëÃÅ
4
ÅäÖÃÍøÂç»·¾³
5
¹ÜÀí Oracle Àý³Ì
6
¹ÜÀíÊý¾Ý¿â´æ´¢½á¹¹
7
¹ÜÀíÓû§ºÍ°²È«ÐÔ
8
¹ÜÀíģʽ¶ ......
oracle ½ø³Ì »á»°£¬Óα꣬ÊÂÎñµÄ¹Øϵ
Èç¹ûÔÚLINUX Ï ÊÇÓÃTOP ¿ÉÒÔ¿´µ½ÕýÔÚÅܵÄORACLE ½ø³Ì¡£ORACLE ³ýÁ˺ǫ́½ø³ÌÍ⻹ÓÐÓû§½ø³Ì¡£
¼ÈÊÇ¿ªÆôÁ˲¢ÐУ¬Ò²Êǵ¥¶ÀµÄ½ø³Ì¡£
PL/SQL DEVELOPER ÀïµÄ¶à¸ö²éѯ´°¿Úʵ¼ÊÉÏÊǽø³Ì¡£
Ò»¸ö½ø³Ì¿ÉÒÔ°üº¬¶à¸ö»á»°£¬µ±ËüÃÇÖ»ÄÜ´®ÐÐÔËÐС£±ÈÈçÔÚÒ»¸ö²éѯ´°¿ÚÖÐÖ´ÐÐÈý¸öSELECT²éѯ¡£
ÏÂÃæ ......