Java Reference
In-Depth Information
The original data in PURCHASES is depicted in Table 6-1. The
transformed data in PURCHASES_V, depicted in Table 6-2, contains
new columns derived from the transactional format PURCHASES
table. We used the PRODUCT table, depicted in Table 6-3, to look up
the product ID by product name.
Table 6-1
Original PURCHASES table data, example
Customer_id
Transaction_id
Product_id
Quantity
1
1
1
1
1
2
2
2
1
3
3
5
2
1
1
3
2
2
4
7
3
1
3
1
3
2
4
2
4
1
2
6
5
1
1
4
5
2
3
3
Table 6-2
Transformed PURCHASES_V view data, example
Customer_id
Purchased_tads
Purchased_zads
Purchased_fads
1
1
1
1
2
1
0
0
4
0
1
0
5
1
0
1
3
0
0
1
Table 6-3
Transformed PRODUCTS table data, example
Product_id
Product_name
Product_price
1
Ta d s
30
2
Zads
20
3
Fads
10
4
Rads
40
Search WWH ::




Custom Search