ZACODERS
← All technologiesTechnology

The data model is the foundation of every system.

Screens can be redesigned in days. The structure of a system's data shapes everything it can do, and changing it after the fact is slow and risky. That's why, on every system we build, the data model is designed and agreed before the interface.

Definition

What is a data model?

A data model is the structure that describes what information a system stores and how those pieces relate — customers and their accounts, orders and their items, products and their locations. In a relational database, it's expressed as tables and the relationships between them.

A good data model reflects how the business actually works: one customer with several sites, one order with several deliveries, one product stocked in several places.

Worth knowing

Signs of a poor data model

Approach

How we design data

Migration

Data migration

Moving data from spreadsheets or old systems is often the riskiest part of a project:

  1. 1.Inventory existing sources
  2. 2.Clean duplicates and inconsistencies
  3. 3.Map old fields to the new model
  4. 4.Trial-migrate and check figures
  5. 5.Final migration at go-live
  6. 6.Reconcile against the old records during parallel running
Security

Protecting the data

Backups, access control, encrypted connections and least-privilege permissions for integrations.

Discuss your system