QuestionQ19

Data Architecture

A leading clothing retailer is migrating from a relational database management system (RDBMS) to Adobe's Real-Time CDR. Its current RDBMS contains appropriately related tables for Customers, Orders, and Items. The customer table holds customer profiles, the order table contains details of orders placed by customers, and the items table contains information about the purchased items.

Adobe Real-Time CDP uses Experience Data Model (XDM), a standard schema model that enables users to combine, capture, and process customer data. The goal is to integrate the existing RDBMS data into Adobe Real-Time CDP's XDM schema while preserving the data's integrity and relationships.

What is the most efficient way to structure the RDBMS data in Adobe Real-Time CDP's XDM data model?

Explanation

Separate XDM schemas for the customer, order, and item entities preserve their distinct structures. Relationship fields that reference identifier fields in related schemas maintain the links among those records, rather than duplicating data through flattening or leaving entities unconnected. Adobe Experience Platform documents schema relationships as fields that reference the identity of a related reference schema.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!