Oracle Audio Technologies Retail Data Warehouse 13 User Manual

Page 5

Advertising
background image

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

Advertising