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 |
When tablespace or storage options are not applicable for a DBMS, the corresponding model menu item is not available.