Different data modeling tools list

 

===========================================
AIR TABLE : (3jul 2025)

Data modeling tool with AI data options and self creating data model 

===========================================

===========================================

Tool	Creator	Target Business Size	License	Supported Database Platforms	Supported OSs	Standalone or bundled into a larger toolkit	Launch Date
Astah	Change Vision	Enterprises	Proprietary	MySQL, Oracle,	Windows, macOS, Linux	Standalone	2006
Database Workbench	Upscene Productions	SMBs and enterprises	Proprietary	MS SQL Server, MySQL, Oracle, Firebird, InterBase, SQL Anywhere, NexusDB, MariaDB	Windows, Linux and FreeBSD (both through Wine)	Standalone	2001
DbSchema	Wise Coders GmbH	SMBs and enterprises	Proprietary	MS SQL Server, MySQL, Oracle, Firebird, InterBase, SQL Anywhere, NexusDB, MariaDB, SQLite, PostgreSQL, Sybase	Windows, Linux, macOS	Standalone	2018
Enterprise Architect	Sparx Systems	SMBs and enterprises	Proprietary	IBM Db2, Firebird, InterBase, Informix, Ingres, Access, MS SQL Server, MySQL, SQLite, Oracle, PostgreSQL, Sybase	Windows, Linux (Wine), macOS (via CrossOver)	Data modeling is supported as part of a complete modeling platform.	2000
ER/Studio	Embarcadero (acquired by IDERA)	SMBs and enterprises	Proprietary	Access, Snowflake, Microsoft Azure IBM Db2, Informix, Hitachi HiRDB, Firebird, Interbase, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, Teradata, Visual Foxpro and others via ODBC/ANSI SQL	Windows	Standalone	1998
Erwin Data Modeler	Logic Works (now Quest)	SMBs and enterprises	Proprietary	Access, IBM Db2, Informix, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, and others via ODBC/ANSI SQL	Windows	Standalone	1998
MagicDraw	No Magic	Enterprises, SMBs, personal	Proprietary	MS SQL Server, Oracle, MySQL, PostgreSQL, IBM Db2	Windows, Linux, macOS	Standalone	1995
SQL Server Management Studio	Microsoft	Un­known	Proprietary	MS SQL Server	Windows	Standalone	2005
ModelRight	ModelRight	Enterprises, SMBs, personal	Proprietary	Access, MS SQL Server, Oracle, MySQL, PostgreSQL, IBM Db2	Windows	Standalone	2005
MySQL Workbench	MySQL (An Oracle Company)	SMBs - personal	Proprietary or GPL	MySQL	Linux, Windows, macOS	Standalone	2006
Navicat Data Modeler	PremiumSoft	SMBs and enterprises	Proprietary	MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite	Windows, macOS, Linux	Standalone	2012
NORMA Object-Role Modeling	Terry Halpin	SMBs and enterprises	Open source (CPL)	MySQL, MS SQL Server, PostgreSQL, Oracle, IBM Db2	Windows	Visual Studio Extension	2005
Open ModelSphere	Grandite	Enterprises - SMBs - personal	Open source (GNU GPL3)	MS SQL Server, MySQL, PostgreSQL, Oracle, IBM Db2	Windows, macOS, Linux	Standalone with Data, UML, and process modeling	2008
Oracle SQL Developer Data Modeler	Oracle	Enterprises	Proprietary	Oracle, MS SQL Server, IBM Db2	Cross-platform	Standalone	2009
PowerDesigner	SAP	SMBs and enterprises	Proprietary	Access, Greenplum, Apache Hive, HP Neoview, IBM Db2, Informix, Ingres, Interbase, MySQL, Netezza, NonStop SQL, Oracle, PostgreSQL, Red Brick Warehouse, SAP business Suite, SAP Hana, SAP Adaptive Server Enterprise, SAP IQ, SAP SQL Anywhere, MS SQL Server, Teradata	Windows	Standalone	1989
Software Ideas Modeler	Dusan Rodina	Enterprises, SMBs, personal	Proprietary	MS SQL Server, MySQL	Windows	Standalone	2009
SQLyog	Webyog, Inc.	Enterprises, SMBs, personal	Proprietary	MySQL, MariaDB	Windows and Linux (using Wine)	Standalone	2001
Toad Data Modeler	Quest Software	SMBs and enterprises	Proprietary	Access, IBM Db2, Informix, MySQL, MariaDB, PostgreSQL, MS SQL Server, SQLite, Oracle	Windows	Standalone	2005 (before this date known as CaseStu

inner join and outer join queries and results

 

 

--  // Create database //

 use db1;

show tables;

 

create table t1 ( id int , name varchar(44) ) ;

create table t2 ( id int , name varchar(44) ) ;

 

 

--  // insert data  into tables  //

 

insert into t1 values( 1, "x1");

 

insert into t1 values( 2, "x2");

insert into t1 values( 3, "x3");

insert into t1 values( 4, "x4");

 

select * from t1;

 

insert into t2 values( 1, "x1");

insert into t2 values( 2, "x2");

insert into t2 values( 5, "x5");

insert into t2 values( 6, "x6");

 

 

select * from t2;

 ------------------

 

-- // inner join //

select * from t1 join t2 on t1.id = t2.id

 

 

-- // left join //

select * from t1 left join t2 on t1.id = t2.id

 

 

-- // Right  join //

 

select * from t1 right join t2 on t1.id = t2.id

 

 

- // fuill outer  join //

 

 select * from t1 left join t2 on t1.id = t2.id

union

 select * from t1 right join t2 on t1.id = t2.id

 

 

Parquet datatypes

 

Parquet Data Types and Transformation Data Types

Parquet data types map to transformation data types that the Data Integration Service uses to move data across platforms.

The following table compares the Parquet data types that the Data Integration Service supports and the corresponding transformation data types:

Parquet	Transformation	Range
Binary	Binary	1 to 104,857,600 bytes
Binary (UTF8)	String	1 to 104,857,600 characters
Boolean	Integer	-2,147,483,648 to 2,147,483,647 Precision of 10, scale of 0
Date	Date/Time	January 1, 0001 to December 31, 9999.
Decimal	Decimal	Decimal value with declared precision and scale. Scale must be less than or equal to precision. For transformations that support precision up to 38 digits, the precision is 1 to 38 digits, and the scale is 0 to 38. For transformations that support precision up to 28 digits, the precision is 1 to 28 digits, and the scale is 0 to 28. If you specify the precision greater than the maximum number of digits, the Data Integration Service converts decimal values to double in high precision mode.
Double	Double	Precision of 15 digits.
Float	Double	Precision of 15 digits.
Int32	Integer	-2,147,483,648 to 2,147,483,647 Precision of 10, scale of 0
Int64	Bigint	-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision of 19, scale of 0
Map	Map	Unlimited number of characters.
Struct	Struct	Unlimited number of characters.
Time	Date/Time	Time of the day. Precision to microsecond.
Timestamp	Date/Time	January 1, 0001 00:00:00 to December 31, 9999 23:59:59.997. Precision to microsecond.
group (LIST)	Array	Unlimited number of characters.

The Parquet schema that you specify to read or write a Parquet file must be in smaller case. Parquet does not support case-sensitive schema.

Parquet Timestamp Data Type Support

The following table lists the Timestamp data type support for Parquet file formats:

Timestamp Data type	Native	Spark
Timestamp_micros	Yes	No
Timestamp_millis	Yes	No
Time_millis	Yes	No
Time_micros	Yes	No
int96	Yes	Yes

Unsupported Parquet Data Types

The Developer tool does not support the following Parquet data types:

Timestamp_nanos
Time_nanos
Timestamp_tz