Tablespaces and Storages (PDM)

Tablespaces and storages are generic objects used to represent physical locations (in named partitions) of tables and indexes in a database or storage device.

For some DBMSs, a tablespace can use a specified storage in its definition.

The following table lists the DBMSs that use concepts that are represented by tablespaces and storages in PowerDesigner:

DBMS

Tablespace represents...

Storage represents...

ADABAS

NA

NA

IBM DB2 UDB Common Server

tablespace

create tablespace

buffer pool

create bufferpool

IBM DB2 UDB for OS/390

table space

create tablespace

storage group

create stogroup

Informix

NA

NA

Ingres

NA

NA

InterBase

NA

NA

Microsoft Access

NA

NA

Microsoft SQL Server

NA

filegroup

alter database add filegroup...

MySQL

NA

NA

Oracle

tablespace

create tablespace

storage structure (not physical storage)

PostgreSQL

NA

NA

Sybase ASA

database space

create dbspace

NA

Sybase ASE

NA

segment

sp-addsegment

Sybase AS IQ

database space

create dbspace

NA

Teradata

NA

NA

Note: When tablespace or storage options are not applicable for a DBMS, the corresponding model menu item is not available.