Big Data, Data Warehouses, and Business Intelligence Systems - Database Processing: Fundamentals, Design, and Implementation - page 575

12.54 What is Cassandra, and what is the history of the development of Cassandra to its cur-
rent state?

12.55 As illustrated in Figure 12-33, what is structured storage and how are structured
storage systems organized? How do structured storage systems compare to RDBMS
systems?

12.56 Explain MapReduce processing.

12.57 What is Hadoop, and what is the history of the development of Hadoop to its current
state? What are HBase and Pig?

Project Questions

12.58 Based on the discussion of the Heather Sweeney Designs operational database (HSD)
and dimensional database (HSD-DW) in the text, answer the following questions.

A. Using the SQL statements shown in Figure 12-13, create the HSD-DW database in
a DBMS.

B. What possible transformations of data were made before HSD-DW was loaded
with data? List some possible transformations, showing the original format of the
HSD data and how they appear in the HSD-DW database.

C. Write the complete set of SQL statements necessary to load the transformed data
into the HSD-DW database.

D. Populate the HSD-DW database, using the SQL statements you wrote to answer
part C.

e. Figure 12-35 shows the SQL code to create the SALES_FOR_RFM fact table shown
in Figure 12-18. Using those statements, add the SALES_FOR_RFM table to your
HSD-DW database.

Figure 12-35
The HSD-DW SALES_FOR_
RFM SQL Statements

&5($7( 7$%/( 7,0(/,1(
&5($7( 7$%/( 6$/(6B)25B5)0
7LPH,'

,QW 12718//

&XVWRPHU,' ,QW 12718//

,QYRLFH1XPEHU ,QW 12718//

3UH7D[7RWDO6DOH 1XPHULF 127 18//

&21675$,17 6$/(6B)25B5)0B3.

35,0$5<.(< 7LPH,' &XVWRPHU,' ,QYRLFH1XPEHU

&21675$,17 65)0B7,0(/,1(B). )25(,*1 .(< 7LPH,'

5()(5(1&(6 7,0(/,1( 7LPH,'
2183'$7(12$&7,21
21 '(/(7( 12 $&7,21

&21675$,17 65)0B&86720(5B). )25(,*1 .(< &XVWRPHU,'

5()(5(1&(6 &86720(5 &XVWRPHU,'
2183'$7(12$&7,21
21 '(/(7( 12 $&7,21