Data modeling tools

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.

Data dictionary tools

List of tools that enable design and building of data dictionaries.

Data Dictionary is a set of important information about data used within an organization (metadata). This information includes names, definitions, and attributes about data, owners, and creators of assets. Data Dictionary tools provide insights into meaning and purposes of data elements. They add useful aliases about the scope and characteristics of data elements, as well as the rules for their usage and application.

Database design tools

List of tools that allow for the design of a database.

Database design is a set of activities aimed at improving the development, implementation, and maintenance of an enterprise data management system. Its main goal is to reflect the outline of the database system into real models: physical and logical. Database designers determine what data is to be stored inside the database, and how objects are to be related to each other.

Database diagram / Reverse Engineering tools

List of database ER diagram (ERD) / schema visualization / reverse engineering tools for popular databases.

GDPR compliance software

List of GDPR compliance tools

Collecting, storing, and processing data of the EU citizens have changed on May 25, 2018, when European Parliament decided to replace Data Protection Directive 95/46/EC with General Data Protection Regulation (GDPR). This new law has placed more emphasis on consumer data protection and gave consumers greater control over their personal information. Complying with these rules gets complex as more customers’ data is collected and processed. Following GDPR Compliance software can help to simplify and speed up this tedious process.

Metadata Management tools

List of metadata management tools

Metadata management tool is a solution that supplements the data stored by the enterprise environment with useful information. Proper metadata management is a crucial factor to make information searchable, easy to locate and understand. Such tools add meaningful context to raw data, making it convenient to discover even by non-IT members of an organization.

Schema compare tools

List of database schema compare and synchronization tools.

Sensitive data discovery tools

List of sensitive data discovery tools

In recent years many international organizations, countries, states etc. have introduced strict regulations regarding sensitive data storing and processing (GDPR in EU, CCPA in California state or PDBP in India just to name a few) to ensure that companies and organizations handle personal information correctly. This should motivate organizations to revise their data protection policies and identify all private data they collect and process. Invaluable help with this tedious task are sensitive data discovery tools.