Tim Gorman
He is an independent consultant (www.EvDBT.com) specialising in performance optimisation, database administration (particularly high-availability), and data warehousing. His website is a valuable source of free papers and tools.
He has co-authored three books, "Oracle8 Data Warehousing", "Essential Oracle8i Data Warehousing" (both from John Wiley & Sons) and "Oracle Insights: Tales of the Oak Table" (from Apress), has written and delivered seminars on data warehousing, UNIX and Oracle administration, performance tuning, and high-availability, contributed to journals and conferences for companies and Oracle users groups around the world.
Tim has been an active member of the Rocky Mountain Oracle Users Group (www.RMOUG.org) since 1992, has been an RMOUG board member since 1995.
|
Exclusive Seminar in New Zealand
Build of a Data Warehouse
Based on the Oracle RDBMS with Tim Gorman
12 - 13 March 2009, Auckland
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: how best to implement 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 administrators, 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.
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
| Date: |
12 - 13 March 2009 |
| Location: |
Auckland |
| Price: |
NZ $2250 |
|
|
