电信收费计费系统BI项目

一、数据仓库体系架构图

二、在Oracle数据库中创建三个用户

用户	代表数据仓库层级
bi_oltp	oltp
bi_ods	ods
bi_edw	edw

• 创建用户bi_oltp

create user bi_oltp identified by bi_oltp default tablespace users temporary tablespace temp profile default account unlock;
grant connect to bi_oltp;
grant dba to bi_oltp;
grant resource to bi_oltp;
grant unlimited tablespace  to bi_oltp;
grant select any table to bi_oltp;
alter user bi_oltp default role all;

• 创建用户bi_ods

create user bi_ods identified by bi_ods default tablespace users temporary tablespace temp profile default account unlock;
grant connect to bi_ods;
grant dba to bi_ods;
grant resource to bi_ods;
grant unlimited tablespace  to bi_ods;
grant select any table to bi_ods;
alter user bi_ods default role all;

• 创建用户bi_edw

create user bi_edw identified by bi_edw default tablespace users