In the last two blogs, we went through the architecture of Informatica MDM MDE and its core & optional components and why we need to use MDM solutions in the first place. If you have not seen our earlier blogs, do check it out to get those basic understanding before diving deep into Database Modelling and Schema Viewer.
In this blog, we will try to understand and answer the below queries:
“A database model (or) a data model is a logical representation/diagram that shows the logical structure of the database.”
With this model, we can understand and define how data will be stored, accessed and updated in a database management system.
This model organizes data into a tree-like structure, with a single root / parent node and all other nodes are linked.
It expands like a tree, adding child nodes below parent nodes.
There will be only one parent for a child node.
Book index, computer filesystems are all hierarchical model examples.
This is a natural extension of the hierarchical data model.
Here a child node can have multiple parent nodes. (i.e.) This model suits many-to-many relationships.
Since there are multiple relationships, traversing nodes become fasters and hence retrieving information will be easy and faster in this model.
Entity Relationship (ER) Model Diagram
There are also other data models such as Dimensional Model, Graph Model and Object-Oriented Data Model which are also used according to specific business use-cases.
Graph Data Model
Entities, Attributes and Relationships are 3 key components of relational database design.
Entity: Entity may be a object (Ex: Contact, Person, Product) or object with conceptual existence (Ex: company, Course, Job)
Attributes: Attributes are properties which define the Entity Type. (Ex: Id, Name, Service and Cost are attributes of Partner Entity.
Relationships: Relationship are associations between Entities. Relationship can be one-to-one, many-to-one and many-to-many.
Database models are basically known as database schemas, which are used to represent database structure and the format of database which is managed by the database management system
Entity-relationship model is a model used for design and representation of relationships between data in Informatica MDM MDE.
Below diagram represents the Entity-Relationship data model implementation in Informatica MDM MDE Hub Console after defining the base objects, landing tables, and staging tables that make up the sample ORS.
Sample Entity-Relationship data model for “Product” Entity - “Schema Viewer” in MDM Hub Console UI.
Here "Product" Entity is used to address product Master Data. Similarly in this diagram, there can be multiple entities and a relationships will be established between Entities.
For Example: A "Party" data model can be defined to address the master data needs for Individual, Organization and their relationship to "Account" entity.
Rajesh is a content writer focused on delivering the information in a digestible format to improve the understanding of his readers. He is a techie who is passionate about traveling and finding ways of using technology to deliver value for everyone
We will reach out when exciting new posts are available. We won’t send you spam. Unsubscribe at any time.