Data Design

Reduce Complexity. Gain Business Value.

Mapping and Transformation

Data Linage

Data Profiling

Data Governance

Build Automation

The importance of Data Design

A design context is a subset of a schema or data model. It is especially valuable when dealing with large models, when views need to be created for a specific context.

Similarly, it can be used to define the context of individual interfaces to a model. An interface does not necessarily expose all the classes of a data model, or even all the properties or associations of the classes that it does expose. Design profiles are used to define the relevant constraints for such an interface or view.

Ask yourself if you have an intuitive modeling environment to manage and curate subsets of models and schemas?

"How do we ensure consistency across our data designs including our schemas?"

Information Technology Group


Remember that a “design context” is not the same as a “package” in a data model. An entity such as a class can only exist in a single package inside a model. It can, however, exist in multiple design contexts. Moreover, in a design context you can remove irrelevant properties and associations without affecting the underlying data model.

Where do you keep your designs?

3 steps to using Data Design

You might ask yourself how do I start using Affirma to create a Data Design? Consider using a consistent naming convention and remember to make use of available meta-data fields to help create context and an understanding of purpose for yourself and future users.

reference data

Define how to organize your Data Designs

Determine how you are going to organize the designs. You may elect to group by business system, business capabilities, business area, business domain or data object domains. Affirma gives you the flexibility to adapt to what best suits your organization.

enterprise semantic model

Define your context

Create a new design context or edit an existing one. Add entities from the data model to your context and curate the available properties and associations by removing, or adding back in, properties and associations relevant to the context.

Use your Data Designs

Import your design contexts into your enterprise semantic model or associate the design contexts with integration designs. You can also physicalize the design contexts by exporting to various DDL script formats, XSD schema’s, and a growing list of other formats.

Affirma allows you to define integration interfaces and physicalize your data designs with DDL scripts or message schema definitions.

affirma logo

Let's Talk!

We would like to know more about you.

What would you like do with Data Design?