What question did this study set out to answer?

March 29, 2026Open Access

Git-Database Branch Integration with DDL Versioning and Webhook Automation

Key Points

The aim is to create a seamless integration between Git version control and database branching for enhanced automated workflows.
Developed LinkManager for Git to DB branch mapping.
Implemented CommitTracker to record database states at Git commits.
Created DdlVersioning for automatic DDL capture from WAL.
Designed DiffEngine for comprehensive schema and data comparisons.
Established HookManager and WebhookServer for GitHub/GitLab automation.
DiffEngine supports schema-only and full data comparisons with varying speeds.
Automatic DDL captures facilitate easier database management.
Integration reduces manual efforts in managing database states with Git.

Abstract

We present a deep integration between Git version control and database branching, comprising six sub-systems: (1) LinkManager for bidirectional Git-branch to DB-branch mapping, (2) CommitTracker for recording database state at Git commits, (3) DdlVersioning for automatic WAL-based DDL capture with schema snapshots, (4) DiffEngine for schema and data comparison between branches at arbitrary LSN/SCN points, (5) HookManager for Git hooks (post-checkout, pre-commit, post-merge) that auto-switch database branches, and (6) WebhookServer for GitHub/GitLab PR lifecycle automation. The DiffEngine supports three levels: schema-only (<100ms), schema plus sampled data (1-5s), and full data diff (scales with data size). Diff targets include branch current state, branch-at-LSN, and branch-at-SCN, enabling cross-branch time-travel comparisons. No existing database links Git branches to database branches with automatic DDL capture from WAL monitoring and PR webhook automation.

Read Full Paperexternally

AI에게 질문

Bookmark

View Full Paper