DAMA DMBOK: Data Modeling Schemes

Hello everyone,

Welcome to my third article about data modeling. In this article I will try to explain modeling schemes of data modeling. Have fun!

Data modeling schemas are the schemas that determine the designs to be used in data modeling. A summary of the data modeling schemas provided in the DAMA DMBOK book can be made as follows:

Relational

A relational data model organizes data into tables (also called relations) with rows and columns. The columns represent attributes of the data, and the rows represent individual instances or records. The tables are typically connected to one another through relationships, which are defined using common attributes between the tables.

Dimensional

Dimensional data modeling is a method for organizing data for use in business intelligence. It involves organizing data into a series of dimensions and facts, with each dimension representing a different aspect of the data and each fact representing a measurable piece of data. On the dimensional relationship lines capture the navigation paths to answer business questions.

Object-oriented

An object-oriented data model represents data as objects with classes and specify their behaviors. Behaviors are certain operations and methods which certain classes has. Class behaviors could be public (Extarnally visible), internally visible (Visible to children object) and private (Hidden).

Fact-based

A fact-based data model organizes data around the “facts” or events that take place within an organization. These facts can include transactions, activities, or other events that are recorded and tracked.

Time-based

Time-based data modeling is a method for designing and organizing data in a database that takes into account the time element of the data. In this scheme, data is organized into tables and the relationships between them are defined using keys, with a focus on capturing and tracking the changes in the data over time.

NoSQL

NoSQL (short for “not only SQL”) is a type of database that does not use the traditional SQL (Structured Query Language) for querying and manipulating data. NoSQL databases are designed to handle large amounts of data that may not be well-structured or may not fit into a traditional relational model.

In next article I’ll be explaining “Deliverables and the steps of the Data Modeling Process”, see you soon :)