Catalogs and schemas in database systems - 7.1

Talend Data Management Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Data Management Platform
task
Design and Development
EnrichPlatform
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 -
MySQL -
SQLServer 2000/2005/2008
DB2 -
DB2 ZOS -
Sybase -
Informix -
PointBase -
PostgreSQL -
AS/400 V5R4
Ingres -
Teradata -
Netezza -
SQLite -