Data modeling: What is it, tools and types

Share on facebook
Share on twitter
Share on linkedin
Share on telegram
Share on whatsapp


Data modeling refers to the practice of documenting software and systems design.. business, using diagrams, symbols and textual references. Through these items that make up the data model Represents the way data flows through a software application or data architecture within a company.

data model


A data model is used to Document, establish, organize and show how they connect, Stored, access and process data structures within a database, architecture, particular application or platform. within the given system and among other systems.

There is a lot of related terminology that includes conceptual models, business models, logic models, physical models, entity linking models, object models, multidimensional models, knowledge graphs, statistical models, canonical data models, application data models, business requirements models, business. data models, integration models, business information models, Ontologies, Taxonomies, non-relational models, semantic models and many others.

What is the data model

Data modeling is the procedure of creating a data model through the application of formal data model descriptions using data modeling techniques that help organize information..

A data model is an abstract model, documenting and organizing business data for communication between team members. Often used as a model for application development, since it focuses on how they are stored and what ways there are to enter the data.

Types of Data Modeling Tools

To transform business requirements into a logical data model, and this in a physical data model, different data modeling tools can be used.. From the physical data model, these tools can receive instructions to generate the sql code that will be used to create the database.

In the market there are different types of data modeling tools, like the following:

  • Informatica Power Centerby Informatica.
  • Oracle Designer from Oracle Corporation
  • Rational Rose of IBM Corporation
  • Erwin of Computer Associates.
  • Embarcadero by Embarcadero Technologies.
  • Power Designer by Sybase Corporation

When selecting, it is essential to look for a reliable and expert supplier in the field, that offers a solution according to business needs.

Existing data modeling classes

There is no single format of data model because a data model instance can be of three different classes:

  1. Conceptual scheme: refers to entities and describes the semantics of a domain, being the scope of the model. the conceptual data model includes all the main entities and relationships and does not contain much detailed information about the attributes. Usually used at the initial planning stage.
  2. Logical scheme: focuses on attributes, describing the structure of some information domain. These are descriptions of tables and columns, classes focused on XML objects and tags, among others. This is the actual implementation and extension of a conceptual data model. A logical data model is the version of a data model that represents business requirements (total or partial) of an organization and is developed before the physical data model.
  3. Physical schematic: describes the physical means by which the data is stored. This refers to partitions, CPU, table spaces and the like. The physical data model includes all tables, columns, relations, database properties required for the physical deployment of databases. Database performance, the indexing strategy, physical storage and denormalization are important parameters of a physical model.

the data model is a necessary part of a pull procedure, transformation and loading; essential for working with big data and support for understanding data by defining and categorizing it, setting standard definitions and descriptors, that ensure that all information systems of the organization can benefit from their use.

Subscribe to our Newsletter

We will not send you SPAM mail. We hate it as much as you.