Chapter 10 Generating a Database from a PDM

Indicating average data type length

You can indicate the estimated average data type length for variable length data types. This average length value is then used instead of the maximum data type length when you estimate database size.

Note   Average size must be carefully selected
The average length value is particularly important for strings or long binary data types. A Binary Long OBject (BLOB) such as a picture can represent the largest portion of the space actually taken by a table.

Steps To indicate average data type length:

  1. Select Model→Tables.

    The List of Tables appears.
  2. Double-click a table name.

    The Table Properties sheet opens to the General page.
  3. Click the Columns tab.

    The Columns page appears.
  4. Double-click a column that uses a data type with variable length.

    The Column Properties sheet opens to the General page.
  5. Click the Detail tab.

    The Detail page appears.
  6. Type a value in the Average length box.
  7. Click OK in each of the dialog boxes.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.