7
Modeling and Design

This chapter discusses the following topics:

• Selecting a Datatype
  • LOBs in Comparison to LONG and LONG RAW Types

  • Character Set Conversions: Working with Varying-Width Character Data

• Selecting a Table Architecture
  • Where are NULL Values in a LOB Column Stored?

  • Defining Tablespace and Storage Characteristics for Internal LOBs

  • LOB Storage Characteristics for LOB Column or Attribute

  • TABLESPACE and LOB Index

  • How to Create Gigabyte LOBs

• LOB Locators and Transaction Boundaries

• Binds Greater Than 4,000 Bytes in INSERTs and UPDATEs

• Open, Close and IsOpen Interfaces for Internal LOBs

• LOBs in Index Organized Tables (IOT)

• Manipulating LOBs in Partitioned Tables

• Indexing a LOB Column

• Best Performance Practices
  • Moving Data to LOB in Threaded Environment

Note: Examples used in this chapter are based on the multimedia schema and table Multimedia_tab described in Chapter 8, "Sample Application".