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 |