Oracle Audio Technologies Retail Data Warehouse 13 - Manual (Page 5)

v
Contents
Preface ............................................................................................................................. vii
Audience ............................................................................................................................... vii
Related Documents.............................................................................................................. vii
Customer Support................................................................................................................ vii
Review Patch Documentation ............................................................................................ vii
Oracle Retail Documentation on the Oracle Technology Network............................... vii
Conventions.........................................................................................................................viii
1 Preinstallation Tasks ................................................................................................... 1
Implementation Capacity Planning......................................................................................2
Check Database Server Hardware Requirements ..............................................................2
Check Database Server Software Requirements.................................................................3
Other Software Requirements for the Data Warehouse ....................................................4
Check Client System Requirements .....................................................................................4
Create UNIX User Accounts..................................................................................................4
Create UNIX Directories ........................................................................................................4
Alter Directory Ownership and Privileges..........................................................................5
Copy Profiles for RDW User .................................................................................................6
2 Installation Tasks......................................................................................................... 7
Establish Data Warehouse Partitioning Strategy................................................................7
Create the RDW Database and Tablespaces........................................................................8
Create the Database as Follows......................................................................................8
Create RDW Tablespaces................................................................................................8
Load RDW Database ..............................................................................................................9
Create RDW Schema Owners.........................................................................................9
Create RDW Datamart-level tables ...............................................................................9
Set up RDW User Permissions .......................................................................................9
Configure RETL ....................................................................................................................10
Data Population ....................................................................................................................10
Populate Datamart Default Data .................................................................................11
Populate Time Dimension ............................................................................................12
Populate Static Dimension Data ..................................................................................14
Install Oracle Configuration Manager ...............................................................................15
A Appendix: Development Database Schema Implementation ................................ 17
B Appendix: RDW Code Tree ....................................................................................... 19
C Appendix: Oracle 10g Database Creation Scripts.................................................. 21
D Appendix: Tablespace Creation Scripts.................................................................. 25
E Appendix: Installation Order .................................................................................... 27