Events tagged "Partitioning":

Double Tree Hilton, United Kingdom,London

Steve Hoberman

This seminar and workshop contains a complete explanation of data modelling concepts and terminology, along with techniques for producing solid relational and dimensional data models. This course is designed to give you a practical understanding of data modelling that can be applied to your current projects. It is for anyone who needs formal data modelling training. This includes those new to data modelling or in need of a refresher who need to be able to understand, build, or implement data models as part of their job. Read more »

Dusseldorf, Germany

At first sight table-partitioning seems very simple, but when an actual table needs to be partitioned, a number of alternative strategies may be used, with different consequences on performance, availability, backup and restore.

This seminar will discuss and show some of the more difficult aspects of partitioning – hard to locate in the manuals. We will show you how to change existing database tables to be partitioned, how read-consistency works together with exchange-partition, various special cases from new partition possibilities in 11g, block-compression, and how Materialized views may benefit from partitioning. Read more »

De Meern, Netherlands

In this session the speaker, a DBA of 14 years explains when you decide partitioning for tables and indexes, which partitioning options to choose depending on the problem you are trying to solve – purge, performance, archival, backup or whatever else; potential issues to watch out for and so on. Read more »

Oracle University Training Centre
De Meern, Netherlands

So you have heard about partitioning; but don’t know where to start. Or, you have familiar but want to double check on your design.

In this session the speaker, a DBA of 14 years explains when you decide partitioning for tables and indexes, which partitioning options to choose depending on the problem you are trying to solve – purge, performance, archival, backup or whatever else; potential issues to watch out for and so on. Read more »

Oracle University Training Centre
London, UK

Review and explain the most important new features in Oracle Essbase 11.x.

Day-1 focuses on features of interest to developers. These new features open up a new range of design options. New features such as ASO as the target of a partition help improve performance. Text and Date Measures and Varying Attributes allow developers to build new types of structures that overcome modeling challenges that were previously difficult to address. For example, Varying Attributes help model dimensional relationships that change over time. Essbase Studio and XOLAP allow tighter integration between Essbase and relational databases. Cubes can be built much faster. Dimensions and hierarchies can be shared and you can drill through to the underlying relational data in new ways. Read more »