QuestionQ22

Data Architecture

Support o Gui des A large retail company currently uses a traditional relational database management system (RDBMS) to store and manage order data. However, it is encountering scalability and performance issues as the volume of orders continues to increase. The company is considering loading data into Adobe Real-Time CDP to use its Experience Data Model (XDM) data model and real-time data capabilities.

The company's order table contains the following attributes:

  • Order ID
  • Customer ID
  • Order date
  • Order status
  • Shipping address
  • Billing address

The company's order items table contains the following attributes:

  • Order ID
  • Item ID

How should the architect translate this data model into the Adobe Experience Platform XDM data model?

Explanation

An order is a timestamped commerce transaction and is modeled as an XDM ExperienceEvent. Its line items can be represented in the same event as a productListItems array, eliminating the need for a separate schema to reproduce the relational order-items table. The Commerce Details field group is designed for XDM ExperienceEvent commerce and order data.

Learn more

Community Discussion

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