Data Processing Types

Oracle LSH offers four different basic types of data processing to accommodate the different technologies used for loading data into Oracle LSH and operating on data within Oracle LSH: transactional, reload, staging, and transactional high throughput. The types are described in the following sections.

The type of processing the system uses depends on the processing type specified for the target Table instance, not the Program. However, you must be careful to choose a processing type for a Table instance that is compatible with the Program that writes to it:

• If the processing type is Transactional, the source code must explicitly update, insert, and delete records.

• If the processing type is Reload, the source code must simply ensure that all records from the source are loaded (as Inserts) into the target Table instance.

Program instances need to be compatible only with Table instances they write to. Any Program instance can read from a Table instance of any processing type.

Although only one Program instance can write to a particular Table instance, some data processing types allow more than one execution of that Program to run at the same time.

This section contains the following topics:

• Processing Types Summary
  
• Transactional Processing
  
• Reload Processing
  
• Staging Processing
  
• Transactional High Throughput Processing
  
• SQL*Loader Processing for SAS Programs
  
• Using Tables as Pass-Through Views