HYDRA Database Regenerator

Database Systems Lab
Indian Institute of Science

[About] [Download] [Publications] [Team] [Contact]

Welcome to the HYDRA Database Regenerator software developed at the Database Systems Lab, Indian Institute of Science. HYDRA is an easy-to-use graphical tool for the automated regeneration of client data processing environments at vendor sites. It is written entirely in Java and is operational on the PostgreSQL database engine.

A core requirement of database engine testing is the ability to create synthetic versions of the customer's data warehouse at the vendor site. HYDRA is a workload-dependent database regenerator that leverages a declarative approach to data regeneration to assure volumetric similarity, a crucial aspect of statistical fidelity. It uses an optimized linear programming (LP) formulation based on a novel region-partitioning approach. This spatial strategy drastically reduces the LP complexity, enabling it to handle query workloads on which contemporary techniques fail. Second, Hydra incorporates deterministic post-LP processing algorithms that provide high efficiency and improved accuracy. Third, Hydra introduces theconcept of dynamic regeneration by constructing a minuscule database summary that can on-the-fly regenerate databases ofarbitrary size during query execution, while obeying volumetric specifications derived from the query workload. Finally, a detailed experimental evaluation on standard OLAP benchmarks demonstrates that Hydra can efficiently and dynamically regenerate large warehouses that accurately mimic the desired statistical characteristics.

Technical Report pdf

Poster pdf.

Demo Video (8 MB)

Hydra 0.1 beta codebase zip (47 MB)

Scalable and Dynamic Regeneration of Big Data Volumes
Anupam Sanghi, Raghav Sood, Jayant Haritsa, Srikanta Tirthapura
Proc. of 21st International Conference on Extending Database Technology (EDBT), Vienna, Austria, March 2018

Email: haritsa [AT] iisc [dot] ac [dot] in

Primary Hydra Contributors (in chronological order of participation)

  • Jayant Haritsa (Project Lead)
  • Anupam Sanghi (PhD, CSA, IISc)
  • Raghav Sood (ME, CSA, IISc)
  • Dharmendra Singh (M. Tech, CSA, IISc)