JSON in RDBMS
Autonomous
EnterpriseDB
Azure SQL
MariaDB
MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system, intended to remain free and open-source software
Hackolade has the unique ability to model complex semi-structured objects stored in columns of the longtext data type. The reverse-engineering function, if it detects JSON documents, will sample records and infer the schema to supplement the DDL table definitions.
Hackolade was specially adapted to support the data modeling of MariaDB, including databases, tables and views, indexes and constraints, plus the generation of DDL Create Table syntax.
Oracle and Autonomous
Oracle is a multi-model database management system commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads. It may be run by several service providers on-premises, on-cloud, or as hybrid cloud installation, as well as on Oracle hardware.
Hackolade has the unique ability to model complex semi-structured objects stored in columns of long text data type. The reverse-engineering function, if it detects JSON documents in BLOB and JSON columns, will sample records and infer the schema to supplement the DDL table definitions.
Hackolade was specially adapted to support the data modeling of Oracle, including schemas, tables and views, indexes and constraints, plus the generation of DDL Create Table syntax.
PostgreSQL and EnterpriseDB
PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It has earned a strong reputation for reliability, feature robustness, and performance.
Hackolade has the unique ability to model complex semi-structured objects stored in columns of long text data type. The reverse-engineering function, if it detects JSON documents in JSON or JSONB columns, will sample records and infer the schema to supplement the DDL table definitions.
Hackolade was specially adapted to support the data modeling of PostgreSQL, including schemas, tables and views, indexes and constraints, plus the generation of DDL Create Table syntax.
Microsoft SQL Server
and Azure SQL Database
SQL is aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users
Hackolade has the unique ability to model complex semi-structured objects stored in columns of the (N)VARCHAR(MAX) data type. The reverse-engineering function, if it detects JSON documents, will sample records and infer the schema to supplement the DDL table definitions.
Hackolade was specially adapted to support the data modeling of SQL Server and Azure SQL Database, including schemas, tables and views, indexes and constraints, plus the generation of DDL Create Table syntax.