Assignment 4_1

Implemention of Statistics Class

Sharath Chandra Darsha UFID: 45194064

Suresh Koppisetty UFID: 18111766

./ ./README ./Makefile ./source/ ./bin/ ./bin/testcases/ ./DATA/10M/

starting from the root folder

1. make clean // Clean any previously compiled code
2. make all // Compile all the files necessary
3. cd bin
4. ./test [0-11] // to run the different queries in test.cc

1. gtesting.o
2. test

The following variables control the various file locations and they are declared in test.h (just after the #include header declarations): o dbfile_dir -- this is where the created heap db-files will be stored. By default, this is set to "" (thus all the heap dbfiles will be created in the "bin" directory). o tpch_dir -- this stores the directory path where the tpch-files can be found. The "/DATA/" directory already has the required table files generated by tpchgen and the path should be accessible by the program. We supplied only 10M data along with the code. o catalog_path -- this stores the catalog file path. By default this is set to "source" folder.

sharath@sharath-Lenovo-Z40-70:~/bearded-octo-batman/bin$ ./test 0

Estimation Result: 800000 Correct Answer: 800000

sharath@sharath-Lenovo-Z40-70:~/bearded-octo-batman/bin$ ./test 1

Your estimation Result 857316 Correct Answer: 8.5732e+5

sharath@sharath-Lenovo-Z40-70:~/bearded-octo-batman/bin$ ./test 2

Estimation Result: 1.5e+06 Correct Answer: 1500000

sharath@sharath-Lenovo-Z40-70:~/bearded-octo-batman/bin$ ./test 3

Estimation Result: 6e+07 Correct Answer: 60000000.0

sharath@sharath-Lenovo-Z40-70:~/bearded-octo-batman/bin$ ./test 4

Estimation Result: 3200 Correct Answer: 3200

sharath@sharath-Lenovo-Z40-70:~/bearded-octo-batman/bin$ ./test 5

Estimation Result: 400081 Correct Answer: 400081

sharath@sharath-Lenovo-Z40-70:~/bearded-octo-batman/bin$ ./test 6

Estimation Result: 32000 Correct Answer: 32000

sharath@sharath-Lenovo-Z40-70:~/bearded-octo-batman/bin$ ./test 7

Estimation Result: 2.00041e+06 Correct Answer: 2000405

sharath@sharath-Lenovo-Z40-70:~/bearded-octo-batman/bin$ ./test 8

Estimation Result: 48000 Correct Answer: 48000

sharath@sharath-Lenovo-Z40-70:~/bearded-octo-batman/bin$ ./test 9

Estimation Result: 4 Correct Answer: 4

sharath@sharath-Lenovo-Z40-70:~/bearded-octo-batman/bin$ ./test 10

Estimation Result: 2.0004e+06 Correct Answer: 2000405

sharath@sharath-Lenovo-Z40-70:~/bearded-octo-batman/bin$ ./test 11

Estimation Result: 21432.9 Correct Answer: 21432.9

sharath@sharath-Lenovo-Z40-70:~/bearded-octo-batman/bin$