Data Model & Structure
From product structure to business rule. One model as the foundation.
Model products, services and licences in one flexible structure. Define their fields, relationships, rules and standards in one central data model. The result is one flexible foundation for your product data. Your organisation can grow while structure, control and consistency stay intact.
Product
Physical camera
These organisations structure their product data with ConnectingTheDots
The data model in practice
Products, services and licences.
Three different structures.
Fields, rules and channels differ per type. ConnectingTheDots gives each type its own structure within one coherent data model.
| Type | Fields | Rules | Channels |
|---|---|---|---|
| E-commerce product | EAN, weight, dimensions, stock, warranty | Required EAN, physical dimensions | Webshop, marketplaces, app |
| Service | Coverage, region, response time, terms | No EAN, policy terms required | Webshop, customer portal, app |
| Licence | Licence type, duration, number of users, platform | No stock, usage rights and validity period required | Webshop, member portal, app |
Each type has its own structure. One model provides the foundation.
DATA MODEL & STRUCTURE
You build new product types in the model.Not around it.
New product type? Define the entity, fields, relationships and rules in the model. Your own team can extend the structure without starting a separate custom project for every new type.
You define taxonomies, standards and business rules centrally and reuse them where it makes sense. Your data model stays manageable as products, channels and markets grow.
HOW IT WORKS
The building blocks behind one flexible data model.
Capture how products are built, how they relate to each other and which rules and standards apply. From product families and attributes to taxonomies, governance and units of measure.
Schema Management
Define entities, product families, attributes, variants and relations that together form your data model.
Golden Records Management
Define which entities and fields form the golden record and capture relations between records.
Classification & Structures
Manage categories, taxonomies and classifications for a consistent product structure across markets and channels.
Governance & Compliance
Capture business rules, ownership and validations so it is clear which product data must meet which requirements.
Unit of Measure
Manage units and conversions centrally, so sizes and quantities are interpreted the same way everywhere.
New product type? Extend the model instead of creating an exception.
Two choices we make differently.
Products, services and licences each get their own structure, rules and relationships. You don't have to force them into one shared product template.
Manage definitions, taxonomies, validation rules and governance centrally, and reuse them across product types, channels and markets.
Products, services and licences.
One model.
Does your data model grow
with your organisation?
Show us your current data model. In 30 minutes we look at product types, families, attributes, variants, relationships and rules, and at where structure or governance may become a constraint as you grow.
- We review your current data model
- You see where structure and rules may limit scalability
- Practical advice for a scalable data model