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 Ö§³Ö¡¢¿É´«Êä±í¿Õ¼ä¡¢½»»¥Ê½Ï
Ïà¹ØÎĵµ£º
×î½ü×öÁËÒ»¸öÊý¾ÝÕï¶ÏµÄÏîÄ¿£¬ÀïÃæ×Ô¼ºÐ´ÁËÒ»¸öÊý¾Ý¿âµÄ²Ù×÷À࣬°üº¬£ºÁ¬½ÓÊý¾Ý¿â¡¢¶ÁÊý¾Ý±í¡¢Ö´ÐÐSQL²Ù×÷£¬ÊÍ·ÅÊý¾Ý¿âµÈ×é³É£¬Ï£Íû¶Ô´ó¼ÒÓÐÓã¬ÓÉÓÚˮƽÓÐÏÞ£¬ÈôÓдíÎó»òÕß´úÂë²»×ãµØ·½»¶ÓÖ¸Õý£¬Ð»Ð»¡£
ADOOperate.H
//////////////////////////////////////////////////////////////////////
// ......
´´½¨±í
create table person (pid int,name varchar2(20) unique,
age int check(age between 0 and 150),sex varchar(4) default 'ÄÐ',tp int,
address varchar(200),constraint person_pid_pk primary key(pid));
²åÈëÊý¾Ý
insert into person values(0011,'ÁõÈý½ã',25,'ÄÐ',13930123021,'ºÓ±±Ê¡ÇúÑôÏØ');
´´½¨×Ó±í ......
Ê×ÏÈÓÃÒ»¸öÃüÁÓèuserÓû§connect½ÇÉ«ºÍresource½ÇÉ«£º
grant connect,resource to user;
ÔËÐгɹ¦ºóÓû§°üÀ¨µÄȨÏÞ:
CONNECT½ÇÉ«£º --ÊÇÊÚÓè×îÖÕÓû§µÄµäÐÍȨÀû£¬×î»ù±¾µÄ
ALTER SESSION --Ð޸ĻỰ
CREATE CLUSTER --½¨Á¢¾Û´Ø
CREATE DATABASE LINK --½¨Á¢Êý¾Ý¿âÁ´½Ó
CREATE SEQUENCE --½¨Á¢ÐòÁÐ
CREAT ......
oracle ½ø³Ì »á»°£¬Óα꣬ÊÂÎñµÄ¹Øϵ
Èç¹ûÔÚLINUX Ï ÊÇÓÃTOP ¿ÉÒÔ¿´µ½ÕýÔÚÅܵÄORACLE ½ø³Ì¡£ORACLE ³ýÁ˺ǫ́½ø³ÌÍ⻹ÓÐÓû§½ø³Ì¡£
¼ÈÊÇ¿ªÆôÁ˲¢ÐУ¬Ò²Êǵ¥¶ÀµÄ½ø³Ì¡£
PL/SQL DEVELOPER ÀïµÄ¶à¸ö²éѯ´°¿Úʵ¼ÊÉÏÊǽø³Ì¡£
Ò»¸ö½ø³Ì¿ÉÒÔ°üº¬¶à¸ö»á»°£¬µ±ËüÃÇÖ»ÄÜ´®ÐÐÔËÐС£±ÈÈçÔÚÒ»¸ö²éѯ´°¿ÚÖÐÖ´ÐÐÈý¸öSELECT²éѯ¡£
ÏÂÃæ ......