## 4 Experimental Results and Discussion
### Experimental Environment in Case 2  
Case 2 shows test data collected from the real-world use case, as listed in Table 12. Each use case had its own a specific SQL command making sense of statistics used to measure the average execution time as per request. The test environment is as shown in Table 5. The test tool is shown in Table 8. The real-world data with various use cases are listed as follows: (1) world-famous masterpiece, (2) load of production machine: underload, (3) load of production machine: overload, (4) qualified rate of semiconductor products, (5) correlation between temperature and electricity use per capita, (6) correlation between rainfall and electricity use per capita, (7) flight information in the airport, (8) traffic violation/accidents, and their related information are as follows: \begin{table}
\begin{tabular}{c c c c} \hline \hline
**Operation** & **FCFS-SP-Hive** & **FCFS-SP-Impala** & **FCFS-SP-SparkSQL** & **FCFS-PS** \\ \hline Environment I & - & - & - & - \\ Environment II & 0.5436 & 0.9940 & 0.7573 & 1.0000 \\ Environment III & 0.3414 & 0.6082 & 0.9934 & 1.0000 \\ \hline \hline \end{tabular} Note: Symbol “-” indicates the datum was not available.  
\end{table} 
Table 10: Normalized performance index for Case 1. \begin{table}
\begin{tabular}{c c c c} \hline \hline
**Method** & **Average Normalized PI** & **Performance Index** \\ \hline FCFS-SP-Hive & 0.443 & 44 \\ FCFS-SP-Impala & 0.801 & 80 \\ FCFS-SP-SparkSQL & 0.875 & 88 \\ FCFS-PS & 1.000 & 100 \\ \hline \hline \end{tabular}
\end{table} 
Table 11: Average normalized performance index for Case 1. \begin{table}
\begin{tabular}{c c c c} \hline \hline
**No.** & **Data Size** & **Use Case** & **Codename** \\ \hline
1 & 10 GB & World-famous masterpiece & WC \\
2 & 250 GB & Load of production machine: Overloading & OD \\
3 & 250 GB & Load of production machine: Underloading & UD \\
4 & 1 TB & Qualified rate of semiconductor products & YR \\
5 & 750 GB & Correlation among temperature and people’s power utilization & TE \\
6 & 750 GB & Correlation among rainfall and people’s power utilization & RE \\
7 & 100 GB & Flight information in the airport & AP \\
8 & 500 GB & Traffic violation/accidents & TA \\ \hline \hline \end{tabular}
\end{table} 
Table 12: Test use case. \begin{table}
\begin{tabular}{c c c c} \hline \hline
**Method** & **Environment I** & **Environment II** & **Environment III** &
\begin{tabular}{c} **Weighted Average** \\ **Execution Time** \\ \end{tabular} \\ \hline FCFS-SP-Hive & 22,834 & 3604 & 3530 & 3567 \\ FCFS-SP-Impala & - & 2047 & 2033 & 2040 \\ FCFS-SP-SparkSQL & - & 2681 & 1257 & 1969 \\ FCFS-PS & 24,325 & 2169 & 1340 & 1755 \\ \hline \hline \end{tabular} Note: Symbol “-” indicates the datum was not available.  
\end{table} 
Table 9: Performance comparison among the methods for Case 1 (unit: s). The data of use case WC is read from the real world-famous masterpiece--_Alice-in-Wonderland Art-of-War, Huckleberry-Finn, Sherlock-Holmes_, and _Tom-Sawyer_, and we carried out the work of Word Count in this experiment. The second and third use cases, OD and UD, collected the data from a certain large semiconductor factory in Taiwan that included the goods number, responsible employee, name of production machine, and so on, and the file format was a standard xls format of EXCEL to find out the machine with a too high or too low use frequency in the production scheduling. The fourth use case YR received the data including various semiconductor test items and PASS or FAIL results in which the file format was a standard csv format from another big semiconductor factory in Taiwan, and the experiment was to calculate the yield rate of the products to see whether it reached the qualified standard of the company (99.7%). The fifth and sixth use cases, TE and RE, acquired the data set out of the official website at the Taipower company (Taipei, Taiwan), Taiwan's biggest electricity supply firm, and collect the information about Taiwan's area rainfall and temperature data from the Central Weather Bureau website as well.