The role of the data analyst has gained prominence in relation to the recognized criticality of processed and analyzed information as an integral...
ER/Studio

What is Logical Data Modeling?
Logical data modeling is the second of the three stages of data modeling and one of three types of data model. The three types of data model -...

How to schedule an automatic reverse-engineer from a database into a data model?
This blog post describes how you can run a macro to reverse engineer a database and call it from the Windows Task Scheduler. When you use ER/Studio...
Business Glossary Best Practices: The Do’s and Don’ts
An understanding of business glossary best practices - such as what goes into a business glossary and what should not - is a vital factor in...
Bringing the Development World under the Data Management Umbrella
We have Data at Rest, Data in Transit, and Data in Use. Data in Use has been covered pretty well by Data Architecture and Data Governance teams....

What Is a Data Ontology?
What Is an Ontology? An ontology is a model for organizing structured and unstructured information using entities, properties and the relationships...

Normalization and Data Modeling
Normalization comes in a number of different forms including first normal form (1NF), second normal form (2NF), and third normal form (3NF). In the...

Business Glossary vs. Data Dictionary
The terms business glossary and data dictionary refer to two different artifacts used by data-driven companies to make more effective use of data...

Building a Business Glossary: 7 Step Guide
Building a business glossary is an important facet of modern, data-driven business. A business glossary is a bank of business terms recorded...

What Is a Business Glossary?
A business glossary is a collection of business terms and definitions, documented as part of a data governance program. Business glossaries provide...

A Guide to Data Governance in Healthcare
Data governance in healthcare plays a critical role in regulatory compliance. However, the consequences of poor data governance aren’t limited...

How to Create and Implement a Data Governance Policy
Data-driven companies need to create and implement a data governance policy to make the most effective use of enterprise information resources. A...

What is a Data Governance Framework?
A data governance framework is a means of standardizing the use of data within the enterprise. This includes its classification, organization,...
Physical Data Modeling
Physical data modeling is the last of three stages (or types) of data modeling used to facilitate database design. It’s considered a data modeling...

Logical Data Modeling | IDERA Blog
Logical Data Modeling Logical data modeling is a vital procedure in database design and implementation. It is the second of three stages of data...

What is Conceptual Data Modeling?
Conceptual data modeling is one of three types of data modeling - also referred to as stages of data modeling. The process describes the creation of...

What is Data Democratization?
Data democratization refers to a method by which data-driven organizations can obtain the maximum value from their information resources. With the...

Top Five Open Source and Free Data Modeling Tools
Open source and free data modeling tools provide less mature data-driven organizations with the means to undertake data modeling projects with...

Top 8 Data Modeling Best Practices for Data-Driven Enterprises
A solid understanding of data modeling best practices can help ensure data-driven enterprises get maximum value from their data modeling...

Types of Data Models | IDERA Blog
Types of Data Models Conceptual, Logical, and Physical Data Models There are three stages of data modeling, and three types of data model - 1....

What is Data Modeling?
Data modeling is the process of creating a visual representation of components of an information system to graphically illustrate the connections...

How Big Data Modeling Can Improve Business Intelligence
Big data modeling helps organize the complexities of big data, improves Business Intelligence (BI), and allows organizations to benefit from...

Better Data Governance with These Data Modeling Tips
Data governance can be defined as a collection of practices and processes used to facilitate the formal management of enterprise data assets. The...

Better Data Models to Support Data Governance
Effective decision-making relies on high-quality information. Even the most prescient and fortunate business leaders need the right data when...