4th Generation 4th Generation Obj Object Databases t D t b (we are - PowerPoint PPT Presentation

N � SQL Berlin N SQL Berlin Prof. Dr. Stefan Edlich 4th Generation 4th Generation Obj Object Databases t D t b (we are not alone 3 more nosql events to come in 2009 : ‐ ) (we are not alone. 3 more nosql events to come in 2009 : )

Object Databases Non Relational � � Distributed � � Open Source �� Open Source ��

1987 1987 – first ODBMS sold first ODBMS sold 1995 – oversized expectations 2000 2000 – consolidation consolidation 2009 – >15 years experience great performance & features „the right hammer“

Why Object Databases? Why Object Databases? Because you might have Objects!

A) No multiple data owners B) Better Refactoring B) Better Refactoring

1 No Impedance Mismatch 1. No Impedance Mismatch 2 Data Access Patterns 2. Data Access Patterns • Deep Object Graphs: Fast Object Navigation • N:M, Coll ‐ Coll, Polymorphism / Inheritance � the join hell?! j Associations are First Class Objects! AT (Associative Table) Mapping von OID to physical location in cache

> 500 classes > 3 levels of inheritance > navigational access

in memory db / cache semaphores schema evolution .NET / Java env mixing any class any class no enhancements encryption configurable B ‐ Trees g E Embedded < 1MB b dd d 1MB mobile ready callbacks open ‐ source blobs blobs LINQ alias Bi ‐ Directional Replication l l Native Queries Bi ‐ Replication to any RDBMS Bi ‐ Replication to any RDBMS QBE transparent activation SODA SODA self configurable activation pluggable file I/O

Use Use Cases Cases � launched May 09 � launched May 09 � 10 ‐ 100 times faster � most popular commercial RDBMS did not compete p p p

Performance & Scalability

How much time would you invest o uc t e ou d you est to feel a different technology i.e. Object Databases? Try 2 minutes! Try 2 minutes!

In parallel… start Eclipse li 45 sec

Unzip db4o file Copy Copy something to save into the project Add lib to classpath l th 1:30 min

{ 2:25 min

in memory db / cache semaphores schema evolution .NET / Java env mixing any class any class no enhancements encryption configurable B ‐ Trees g E Embedded < 1MB b dd d 1MB mobile ready callbacks open ‐ source blobs blobs LINQ alias Bi ‐ Directional Replication l l Native Queries Bi ‐ Replication to any RDBMS Bi ‐ Replication to any RDBMS QBE transparent activation SODA SODA self configurable activation pluggable file I/O

The world is diverse ! Act accordingly! OO ‐ Model! Document! R l ti Relational & SQL! l & SQL! Map & Coffee? Reduce! XML. Tupel! Graphs! Key ‐ Value! Excel! N � SQL SQL Polyglot Persistence

Summary Summary Object driven with a rich & complex OO Model ?! rich & complex OO ‐ Model ?! Object Navigation ?!

N � SQL Berlin More ODBMS Information : More ODBMS Information : http://odbms.org Product Info : • Versant.com & db4o.com (Thanks for Sponsoring this event!) • Objectivity.com • Progress.com • Progress com • Gemstone.com � open ‐ source or free test ‐ installations available for all! • Personal Info : • http:// edlich.de edlich@gmail.com • Creator of ICOODB .org Conference on Object Databases • Author of „The Definitive Guide to db4o“, Apress (and many more books) • Check out http://www.nosql ‐ databases.org