SocialHub.AI
← Data Architecture
Database change capture

CDC turns business changes into a real-time data signal.

CDC listens to committed database changes and publishes them as ordered business events. It lets the platform react to member, order, coupon, product and inventory changes immediately without coupling AI workflows to the write path of the operational database.

Layer
CDC

CDC publishes business changes into the event bus; it does not receive raw API events directly.

Why it matters

The value is operational, not just technical.

Agency AI can respond when a business fact changes, not when a report refreshes. That means an AI agent can adjust a recommendation, suppress an invalid offer or trigger a recovery flow based on committed state.

Streams committed business changes with clear source-of-truth semantics.

Reduces polling, batch extraction and direct analytical pressure on OLTP.

Maintains a clean boundary between transactional writes and downstream consumers.

Makes business state changes observable for real-time processing and serving.

Architecture contract

What this layer is responsible for

1

CDC reads database logs after business writes are committed.

2

Each change is published into the event bus with ordering and replay semantics.

3

CDC does not accept SDK events, marketing callbacks or direct API payloads.

4

Downstream processing can rebuild state from the event stream when needed.

Retail signal coverage

What it makes usable

new member registration and profile updatesorder created, paid, shipped, returned or refundedcoupon issued, locked, redeemed, expired or canceledproduct, price, store and inventory updates
Agency AI impact

This is how the layer improves AI decisions.

Without CDC, teams usually fall back to scheduled extraction, which creates stale AI context, heavy database queries and unclear ownership between operational systems and analytics.

A high-value purchase can update customer value within seconds.

A refunded order can suppress an upsell or loyalty reward before it is sent.

A product status change can remove unavailable items from AI-generated recommendations.

Continue the architecture

Real-time capability comes from the complete chain.