2Data Warehouse And Mining
Table of Contents
1 Task 1: Data Warehouse Design................................................................3
1.1 Design..................................................................................................3
1.2 Implementation....................................................................................3
1.2.1 Start SQL developer application.....................................................3
1.2.2 Create new connection...................................................................4
1.2.3 Give the connection name as “datawarehouse”............................4
1.2.4 Connect connection........................................................................5
1.2.5 Test the connection........................................................................5
1.2.6 Save connection.............................................................................6
1.2.7 Creating tables...............................................................................7
1.2.8 Inserting records in the database.................................................11
1.2.9..........................................................................................................13
2 Task 2: OLAP Queries...............................................................................13
2.1 Trades placed in July by “John Alan”.....................................................13
2.1.1 SQL codes.....................................................................................13
2.1.2 Results..........................................................................................13
2.2 Commission earned each quarter of 2003 for customer with 4/5 profit scores..........13
2.2.1 1st quater.....................................................................................13
2.2.2 SQL codes.....................................................................................13
2.2.3 Results..........................................................................................13
2.2.4 2nd quarter....................................................................................13
2.2.5 SQL codes.....................................................................................13
2.2.6 Results..........................................................................................14
2.2.7 3rd quarter.....................................................................................14
2.2.8 SQL codes.....................................................................................14
2.2.9 Results..........................................................................................14
3 Reference................................................................................................15

+13062052269

info@desklib.com

Data Warehouse And Mining

Contribute Materials

Related Documents

Online Brokerage Company Data Warehouse And Mining