Data Warehouse And Mining

1Data Warehouse And Mining
DATA WAREHOUSE AND MINING
[Student name]
[University name]
[Professor Name]
[Date]

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

3
Account table
Accountid
Customerid
Tradeid
Transactiondate
Securitydetails
Scores
Date
Customer
Account
Security
Tradetype
Dimensions Fact table Dimensions
Data Warehouse And Mining
1 Task 1: Data Warehouse Design
1.1 Design
Implementation
1.2 Implementation
1.2.1 Start SQL developer application

4Data Warehouse And Mining
1.2.2 Create new connection
1.2.3 Give the connection name as “datawarehouse”