home 
 
 
 
enfr
 
Home
Over ABIS
Diensten
Cursussen
Resources
Contact
MyABIS
C
Alle CursussenbalkjeAlgemeen Introductie HW & SW Soft skills TrajectenOperating Systems MVS - z/OS UNIX - Linux - AIX Mac OS X iPad en iPhone iOSDatabases en middleware Relationele databases & SQL DB2 for z/OS DB2 for LUW Oracle SQL Server MySQL & MariaDB IMS CICS IBM MQ WebSphere Big data en analyticsApplicatieontwikkeling Methoden en technieken TOGAF PRINCE2 Agile en Scrum Programmeertalen Internet development Object Oriented systems Java Development tools SAS XML SOA & web servicesSysteembeheer ITIL SecuritybalkjePraktischInschrijven 
Deze pagina is niet beschikbaar in het Nederlands.
Columnar storage: Oracle 12c In-Memory database

Objectives

During this course participants learn about one of the two most challenging new features of Oracle 12c - the In-Memory Database Option. Or more specifically: how to turn your 'traditional' Oracle database environment into a columnar data store ready for big data workloads.

At the end of this course, participants will be able to:

  • identify the core characteristics of the Oracle In-Memory database option
  • setup, monitor and administer Oracle columnar databases
  • advice application developers - and others - on its usefulness within an Oracle context

 

Main topics

  • Introduction: the concepts and theories behind columnar databases
  • The Oracle point-of-view: the In-Memory Database Option concepts

Introduction and Architecture

  • The In-Memory Database Option

Concepts - setup of the architecture - initialization parameters - row versus column format - the in-memory concept

Monitoring the In-Memory Database Option

  • DML and the In-Memory Database Option / Columnar Datastore

Data manipulation (scans, joins, aggregation) - Data loads - Partitioning - Hints

Compression

  • Use cases
 

Intended for

Experienced Oracle DBAs who need to setup, configure and manage the In-Memory Database Option.

Background

Knowledge of Oracle - level Oracle Database Administration - is required.

Training method

This is mainly a conceptual course. After a short theoretical introduction, some time is spent on the set-up and use in a theoretical context.

Course leader

Kris Van Thillo, Sandy Schillebeeckx.

Duration

1 day.

Schedule

Momenteel zijn er voor deze cursus geen publieke sessies gepland. Graag organiseren we een bedrijfssessie voor u of een extra publieke sessie (bij voldoende belangstelling). Geïnteresseerd ? Gelieve dan ABIS te contacteren.