Structured entities form the core of a database schema, organizing data into rows and columns for efficient storage and retrieval. They capture essential details from various source systems, enabling smooth data integration and providing visibility from the data model to applications like Campaign+, Metrics, 360 Profile, and Interactive Queries.
The following are the relational entities:
- Customer: Stores key information about individual customers. It acts as a child table.
- Transaction: Records high-level details of each transaction. It acts as a fact table in a star schema.
- Product: Stores information about products. It acts as a dimension table.
- Product Category: Groups products into categories. It acts as a dimension table.
- Organization: Contains details about organizations or entities. It acts as a child table.
- Address: Stores address information for customers. It acts as a child reference table.
Use cases
The following are the use cases:
- Tracking customer profiles and activities: Upstream data from any source system to monitor customer interactions and behaviors.
- Recording detailed sales transactions: Upstream data to capture comprehensive sales records, including individual items purchased.
- Managing product information and categorization: Upstream product data for effective inventory management and sales analysis.
- Capturing and organizing address data: Upstream customer and organization address information for streamlined communication and logistics.
Relational Entities
Structured entities form the core of a database schema, organizing data into rows and columns for efficient storage and retrieval. They capture essential details from various source systems, enabling smooth data integration and providing visibility from the data model to applications like Campaign+, Metrics, 360 Profile, and Interactive Queries.
The following are the relational entities:
- Customer: Stores key information about individual customers. It acts as a child table.
- Transaction: Records high-level details of each transaction. It acts as a fact table in a star schema.
- Product: Stores information about products. It acts as a dimension table.
- Product Category: Groups products into categories. It acts as a dimension table.
- Organization: Contains details about organizations or entities. It acts as a child table.
- Address: Stores address information for customers. It acts as a child reference table.
Use cases
The following are the use cases:
- Tracking customer profiles and activities: Upstream data from any source system to monitor customer interactions and behaviors.
- Recording detailed sales transactions: Upstream data to capture comprehensive sales records, including individual items purchased.
- Managing product information and categorization: Upstream product data for effective inventory management and sales analysis.
- Capturing and organizing address data: Upstream customer and organization address information for streamlined communication and logistics.
Acquia CDP