|
Speeding Oracle Utility Operations
sponsored by Innovative Routines International, Inc.
|
|
|
Posted:
|
25 Mar 2008
|
|
Published:
|
01 Jan 2007
|
|
Format:
|
PDF
|
|
Length:
|
16
Page(s)
|
|
Type:
|
White Paper
|
|
Language:
|
English
|
|
|
ABSTRACT:
Making Oracle-related ETL (and database reorganization) processing more efficient can start with the simple premise of optimizing the performance of each step, and the movement of data between the steps. This document explains the importance of speed in each case, and recommends offline (external) processing to improve speed. File-based staging unburdens the database, ETL and BI tools in which high volume transforms need not, and should not, occur. At the end of the document is a step-by-step example of IRI's methodology for faster extraction of data into this file system, combined with large transforms, advanced reporting, and pre-sorted bulk loads.
|
|
|
|
 |
BROWSE RELATED
RESOURCES
Business Intelligence | Business Intelligence Software | Data Auditing | Data Synchronization | Data Warehouses | DBA | Operations | Oracle (Product)
|
View All Resources
sponsored by Innovative Routines International, Inc.
|
|
|
|
|
Cramsession Research Library Copyright © 1998-2008 Bitpipe, Inc. All Rights Reserved. Designated trademarks and brands are the property of their respective owners. TechTarget · 117 Kendrick St · Needham, MA · 02494
Use of this web site constitutes acceptance of the Bitpipe Terms and Conditions and Privacy Policy. cramsession@bitpipe.com
|