Benchmark
Test
Designed a benchmark for evaluating the performance of a distributed environment containing heterogeneous data sources
o Transformed the relational TPC-H model into a hybrid database containing relational & structured XML data sources
o Modified the TPC-H data generator program in C to generate valid data for scale factors less than 1 GB
o Implemented the hybrid database in Oracle 11g, SQL Server and MySQL 5.5 with varying scale factors
o Optimized and translated the 22 complex SQL queries into LINQ queries to access the heterogeneous data sources
o Benchmarked the queries over different sizes of the databases with and without caching and published the results in a referred journal
o Enhanced the database curriculum at Arizona State University to include the benchmarking theory and practical
o Transformed the relational TPC-H model into a hybrid database containing relational & structured XML data sources
o Modified the TPC-H data generator program in C to generate valid data for scale factors less than 1 GB
o Implemented the hybrid database in Oracle 11g, SQL Server and MySQL 5.5 with varying scale factors
o Optimized and translated the 22 complex SQL queries into LINQ queries to access the heterogeneous data sources
o Benchmarked the queries over different sizes of the databases with and without caching and published the results in a referred journal
o Enhanced the database curriculum at Arizona State University to include the benchmarking theory and practical