WarehouseArchitect - User's Guide

Home

WarehouseArchitect - User's Guide

Part 3 WarehouseArchitect Model

Chapter 22: Database Creation and Modification

Configuring tablespace and storage

Tablespace and storage indicate the physical location of database objects (tables and indexes). The definition of tablespace and storage is DBMS-specific. Different DBMS use different terms for tablespace and storage.

The terms tablespace and storage both refer to named partition that stores tables and indexes. Tablespace refers to a partition in a database. Storage refers to a partition on a storage device.

For some DBMS, a tablespace can use a declared storage in its definition.

Sample tablespace and storage commands

The following table lists commands that implement PowerDesigner tablespace and storage options in a selection of DBMS:

DBMS

Tablespace

Storage

Allbase

CREATE DBEFILESET

CREATE DBEFILE

DB2

CREATE TABLESPACE

CREATE STOGROUP

Oracle 5

CREATE SPACE

Not applicable

Oracle 6 or 7

CREATE TABLESPACE

Storage structure

RDB 4 to 6

CREATE STORAGE MAP

CREATE STORAGE AREA

SQLBase

Not applicable

CREATE STOGROUP

Sybase System 10
System 11
SQL Server

Not applicable

SP-ADDSEGMENT

SQL Anywhere
Watcom 3 or 4

CREATE DBSPACE

Not applicable

Tablespace or storage not applicable
When tablespace or storage options are not applicable for a DBMS, you do not have access to the corresponding Database menu item.

DBMS	Tablespace	Storage
Allbase	CREATE DBEFILESET	CREATE DBEFILE
DB2	CREATE TABLESPACE	CREATE STOGROUP
Oracle 5	CREATE SPACE	Not applicable
Oracle 6 or 7	CREATE TABLESPACE	Storage structure
RDB 4 to 6	CREATE STORAGE MAP	CREATE STORAGE AREA
SQLBase	Not applicable	CREATE STOGROUP
Sybase System 10 System 11 SQL Server	Not applicable	SP-ADDSEGMENT
SQL Anywhere Watcom 3 or 4	CREATE DBSPACE	Not applicable

Defining tablespace and storage

The lists of tablespace and storage options offers pre-defined parameters for each DBMS where applicable. The lists show default values and value lists for certain parameters which correspond to the recommended values for the DBMS.

For information on tablespace and storage options for a particular DBMS, see its reference manual.

To define tablespace and storage:
1. Select Database-->List of Tablespaces.
  or
  Select Database-->List of Storages.
  The list of codes for tablespace or storage appears.
  
  Menu item not available
  When tablespace or storage options are not applicable for a DBMS, you do not have access to the corresponding Database menu item.
2. Click a blank line in the list.
  An arrow appears at the beginning of the line.
3. Type a code in the Code column.
4. Select an option from the option list.
  Below the list, the name of the option appears next to a text box which contains its default parameters.
5. Type parameter values in the text box.
6. If you want to include more options in the tablespace or storage definition, select other options and type their parameter values.
7. Select the Use checkbox.
8. Click OK.

Previewing tablespace and storage commands

You can preview tablespace and storage commands before you generate them.

To preview tablespace and storage commands:
1. Select Database-->Tablespace.
  or
  Select Database-->Storage.
  The list of tablespace or storage options appears.
2. Click an option code in the list.
  An arrow appears at the beginning of the line.
3. Select the Use checkbox.
4. Click the Preview button.
  The preview window shows the corresponding command for the target DBMS.
5. Click Close.
6. Click OK.


	Expand Search