| Tim Gorman
Evergreen Database Technologies, Inc. |
About Tim Gorman has worked in IT with relational databases since 1984, as an Oracle application developer since 1990, as an Oracle DBA since 1993, and managing/designing very large data warehouses on Oracle since 1994. He is an independent contractor (www.EvDBT.com) specializing in performance tuning, database administrator (particularly availability), and data warehousing. Mr Gorman is an active member of the Rocky Mtn Oracle Users Group (www.RMOUG.org) since 1993, has co-authored five books, performed technical review on six more books, is an Oracle ACE, a member of the Oak Table Network, and has presented at Oracle Open World, Collaborate, and Oracle users groups in lots of wonderful places. |
| Website/Blog Twitter: http://twitter.com/TimGorman |
Video N/A |
| Track: ORA | |
Session title |
Session description |
Scaling to Infinity: Partitioning Data Warehouses on Oracle |
Partitioning is crucial to data warehouses, but how do you use this functionality effectively? What other advanced DW features of Oracle does partitioning enable, and how, and why? Is there even a "linkage" between data warehousing features within Oracle? The answer is very much a resounding "YES", with the corrollary that if you start off with the wrong set of design assumptions, then your data warehouse is in serious (if not fatal) difficulty right from the start.. This presentation is the result of over 15 years of experience in logical and physical database design for data warehouses on Oracle, driven by diverse combinations of business requirements and systems capabilities. It will change (or validate) the way you think about building, designing, and loading data warehouses on Oracle. Managing data warehouses, especially very large ones, does in fact require a re-thinking of many basic assumptions database designers and administrators have carried for years, and participants find the opportunity and guidance to rethink, with this presentation.Scaling to Infinity: Partitioning Data Warehouses on Oracle |