Catalogs and schemas in database systems - 7.1

Talend Data Management Platform Studio User Guide

Version
7.1
Language
English (United States)
Product
Talend Data Management Platform
Module
Talend Studio
Content
Design and Development

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 -