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. A tablespace is a partition in a database. A storage is a partition on a storage device. Some DBMSs, allow a tablespace to 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 |
|
SAP® SQL Anywhere® |
database space create dbspace |
NA |
|
SAP® Adaptive Server® Enterprise |
NA |
segment sp-addsegment |
|
SAP® 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.