TruTek

Course Overview:

This seminar is designed to conclusively justify one of most important technical decisions that can be made during the physical build of a data warehouse based on the Oracle RDBMS, regardless of size:  whether or not to use partitioning.  Using partitioning permits the full power of numerous advanced Oracle features to be brought to bear on the data warehouse, regardless of how large it grows or how busy it becomes in the future, which Mr Gorman characterizes as the "virtuous cycle".  Not starting with partitioning, regardless of how humble the beginnings, can lead to a deadly embrace of unfortunate circumstances that can doom the project to eventual -- almost inevitable -- failure, which Mr Gorman characterizes as the "death spiral".

This 2-day seminar provides all levels of database adminstrators, technical architects, and technical managers with a clear and detailed understanding of how partitioning is used, how it unlocks the features and power of the Oracle database in a decision-support application environment.

 

Course outline and proposed agenda:

 

 

Day One:

• Data warehousing "utopia":  how do we want the data warehouse to operate
  • optimized query processing using "star" transformations
  • continuous and non-intrusive data loading
  • infinite scalability and high availability
• Logical data model design
  • 3rd-normal form and transactional data models
  • dimensional data models
  • Data Vault
• Physical Database design
  • choosing a partitioning strategy
  • deciding on columns for partition keys
  • right-sizing the types of storage for the task
  • understanding the temporal database

Day Two:

• Data load Optimization
  • Insert-only processing versus Upsert processing
    • Temporal databases revisited
  • EXCHANGE PARTITION loading
  • Real-time or near-real-time ETL using CDC
  • Direct-path or APPEND inserts
  • Parallel Execution
  • NOLOGGING operations
• Query Optimization
  • Partition pruning
  • Indexing
  • Bitmap indexes
  • "Star" transformations
  • Materialized Views
  • Bitmap-join indexes
  • Parallel queries
  • Table and index compression
  • Analytic SQL

Testimonials:
 

• "I haven't worked on a large DW so the design piece was very good information.  I wish it could have been longer." - Todd Laubach, DBA, EDS 
• "Tim Gorman is one of the most refreshing speakers I've seen at a User Group meeting.  I thoroughly enjoyed listening to him!" - Michelle Ball, Sr. Account Executive, Quest Software 
  
• "Incredible job of applying several Oracle features to create the virtuous cycle. I won't be forgetting that one!" - Dennis Williams, DBA, Lifetouch Inc. 
  
• "Tim is a good speaker.  I'd like to make it to his upcoming three-day presentation and hear what else he has to say about scaling Oracle." - Andrew Monge, Sr. Data Warehouse Specialist, Park Nicollet Health Services 
  
• "Tim did a wonderful job on his lecture!  It  was very informative and interesting. Great job!" - Tim Johnson, DBA, GMAC-RFC 
  
• "Very good - got a lot out of it" - Rolf Benson, Database Administrator, Graco, Inc. 
  
• "Your seminar showed PROOF that if you do not design correct initially you pay later." - Brenda Gloe, DBA, Seagate Technology 
  
• "Excellent seminar.  I'm looking forward to trying the examples Tim gave.  His insights into the direction Oracle is moving are also appreciated when I consider what areas to concentrate on in the future." - Jeff Bates, Oracle Consultant, Talent Software Services

Not finding the course or date that you're looking for? Let us know!