Andrew Sillifant

Hybrid Analytics with Oracle 26ai and S3 Data

Oracle 26ai can join external tables backed by S3 Parquet files with regular internal tables in a single SQL statement, without data movement, ETL pipelines, or Spark. The optimizer treats S3-backed external tables as another data source and picks the right join strategy automatically. This post shows how to build a customer dimension table from

Hybrid Analytics with Oracle 26ai and S3 Data Read More »

HammerDB-Scale 2.0 and Why I Rebuilt the Whole Thing

I spent months building a tool that answers a question nobody else was asking: how many databases can your infrastructure actually handle before something breaks? HammerDB-Scale orchestrates parallel database benchmarks on Kubernetes, correlates application metrics with storage behaviour, and finds consolidation limits. I also overengineered it for the wrong user experience. But I thought it

HammerDB-Scale 2.0 and Why I Rebuilt the Whole Thing Read More »