Catalogs and schemas in database systems - 7.1

Talend Real-time Big Data Platform Studio User Guide

Talend Documentation Team
Talend Real-Time Big Data Platform
Design and Development
Talend Studio

The structure of a database defines how objects are organized in the database. Different data storage structures are used to store objects in databases. For example, the highest-level structure (such as "Catalog" followed by "Schema" and finally by "Table") is not applicable to all database types.

The table below describes the structure of some databases in terms of catalog and schemas:

Database name Version Catalog Schema
Oracle   no yes
MySQL   yes no
SQLServer 2000/2005/2008 yes yes
DB2   no yes
DB2 ZOS   no yes
Sybase   yes yes
Informix   yes yes
PointBase   no yes
PostgreSQL   yes yes
AS/400 V5R4 yes yes
Ingres   no yes
Teradata   no yes
Netezza   yes yes
SQLite   no no