Abstract
Truck Data Warehouse (TDW) System is a web-based application developed at the California State University Sacramento for the California Department of Transportation (Caltrans). The TDW System allows Caltrans to use this web-based application system to generate online reports on various statistics related to truck data that passes through the different weigh stations across California. The current prototype system of TDW was developed using Oracle 10g database and SUSE Linux 9.0 as the operating system. It also uses Oracle Business Intelligence (BI) tools such as Oracle Discoverer Plus to generate the BI reports. Moreover, this application uses Google Maps API and JSP to locate the weight station on the map. SQL loader utility was used for loading ASCII files in a very specific format to populate the database. In this project, the existing prototype application is being recreated in a virtualized environment by using VMware ESXi 4.0 Update 1 as the virtualization software and Oracle Enterprise Linux 4.0 as the operating system. Oracle 10g Release 2 v and MySQL-server-5.1.45-1 databases are setup to compare the execution time analyze the efficiency and behavior of these databases in a virtualized environment. The described scenario is being created on a single physical machine where execution times of the pre-defined reports in these two environments are compared and analyzed.