Advanced Database Implementation and Benchmarking

This work focuses on a methodology to help bring many of our database prototypes to reside on the top of a common workbench platform that leads to uniformity and removes overlap across different subsystem. Subsystem currently included are: a runner for SQL on a variety of database platforms, a runner for Quilt queries, ElementalDB, an experimental database system used for instruction in a graduate database implementation course, our own XQuery engine which aims at handling data in terabyte range stored in our storage in paginated form using our pagination algorithm. An XML based framework has been developed for benchmarking subsystems to make experiments completely repeatable at click of a button starting from creation of storage, loading of data sets, execution of commands, collecting performance data in XML-based logs to reporting using XQuery queries on the XML logs. With a very small learning curve, the resulting workbench can be used by students, instructors, developers and researchers alike and managed easily.