The role of the data analyst has gained prominence in relation to the recognized criticality of processed and analyzed information as an integral...
data modeling
Improve data modeling with Aqua Data Studio
Data architects spend a major time of their job on data modeling. As such, they need to ensure that change to their data stores is controlled and...
Best IDE for data analysts
Data analysts need good visibility to the right data to make good business decisions. They also require easy access to the appropriate data, and a...
Manage data and result sets, and SQL queries with Aqua Data Studio
Aqua Data Studio improves access and consistency by accessing data sources from a single tool to minimize the learning curve and maximize the...
Easier database management with Aqua Data Studio
Database administrators spend most of their time keeping databases running with little time to focus on performance and future-proof the...
Aqua Data Studio: IDE with visual analytics and automation
Aqua Data Studio accelerates data management processes by simplifying common tasks and automating routine operations. Visual analytics Run visual...
Manage schema, models, files and servers with confidence
Aqua Data Studio simplifies data-centric tasks by working on data sources without exposure to complex technical elements, detailed technical skills,...
Manage data with Aqua Data Studio
Aqua Data Studio is the industry-leading, multiple-platform, integrated development environment (IDE) for data. It provides many benefits to a...

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...
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....
We are pleased to announce the general availability (GA) of IDERA ER/Studio 19.2
ER/Studio 19.2 delivers a whole new approach to modelling hierarchical structures such as document-based NoSQL platforms and file formats, with...

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...

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...

ER/Studio 19.1 General Availability
We are pleased to announce the general availability (GA) of IDERA ER/Studio 19.1 ER/Studio 19.1 is a minor release with some hotly anticipated new...
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...

ER/Studio 19.0 General Availability
We are pleased to announce the general availability (GA) of IDERA ER/Studio 19.0 ER/Studio 19.0 is a major release with some huge new features. This...

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...