Data modeling tools for Apache Hive

List of data modeling and database design tools.

Data modeling is the process of creating and analyzing data models for resources stored in a database. The Data Model is an abstract model that standardizes the data description, data semantic, and consistency constraints of data. Its main purpose is to represent the types of data within a system, the relationships between objects, and its attributes. The data model helps to understand what data is needed and how data should be organized. It is like a blueprint for an architect to better understand what is being created.

ER/Studio

https://www.idera.com/er-studio-enterprise-data-modeling-and-architecture-tools

ER/Studio provides robust logical and physical modeling and determines all data sources along with managing the transformation of data between the staging area and data warehouse. It helps to build out an enterprise data model and represent business concepts with full documentation of attributes, definitions, relationships, etc.

Desktop/Cloud:	Desktop
Commercial:	Commercial
Free edition:
ER Diagram:
Runs on: (for desktop):	Windows
Forward engineering:
Reverse enginering:
Synchronization:	-

Go to vendor website

The wider the scope of data works in an organization, the more advanced data modeling tool is needed. The functionality spectrum of these tools can be very broad. However, the core features of these tools include:

Data modeling tools for Apache Hive

ER/Studio

Categories

Databases