"My class benefits very much from your web site."

-- Professor Alfonso Cardenas, UCLA.

Free Downloads and Links

In this section you can download resources covering the following topics:

Big Data and Analytical Data Platforms

Cloud Data Stores

Object Databases

NoSQL Data Stores

Graphs and Data Stores

Object-Oriented Programming

Entity Framework (EF) Resources

ORM Technology

Object-Relational Impedance Mismatch

NewSQL, XML, RDF Data Stores, RDBMS

You will find links and downloads to

blog posts

free software

lecture notes

tutorials

articles and papers

user reports

persistence patterns

journals

videos

portals

Advanced expert articles can be found in our expert section.

You can also search ODBMS.ORG to look for specific keywords.

Big Data and Analytical Data Platforms

Big Data and Analytical Data Platforms - Blog Posts

Analytics:
Blog Posts | English | Posts tagged "Analytics" |

Analytical Data Platforms:
Blog Posts | English | Posts tagged "Analytical Data Platforms" |

Big Data:
Blog Posts | English | Posts tagged "Big Data" |

Big Data Analytics:
Blog Posts | English | Posts tagged "Big Data Analytics" |

BigInsights:
Blog Posts | English | Posts tagged "BigInsights" |

Brisk:
Blog Posts | English | Posts tagged "Brisk" |

Cassandra:
Blog Posts | English | Posts tagged "Cassandra" |

Cloudera:
Blog Posts | English | Posts tagged "Cloudera"|

EMC/Gredenplum:
Blog Posts | English | Posts tagged "EMC/Greenplum"|

HBase:
Blog Posts | English | Posts tagged "HBase"|

Hadoop:
Blog Posts | English | Posts tagged "Hadoop"|

Hadoop Distributed File Sytem:
Blog Posts | English | Posts tagged "Hdfs"|

MapReduce:
Blog Posts | English | Posts tagged "MapReduce"|

MapR:
Blog Posts | English | Posts tagged "MapR"|

Pig:
Blog Posts | English | Posts tagged "Pig"|

Big Data and Analytical Data Platforms - Free Software

Stream processing:
Storm is a freeand open source distributed realtime computation system. Storm makesit easy to reliably process unbounded streams of data, doing for realtime processing what Hadoopd is for batch processing.
|Software |Open Source| LINK| 2013|

Stream processing:
S4 is a general-purpose, distributed, scalable, fault-tolerant, pluggable platform that allows programmers to easily develop applications for processing continuous unbounded streams of data.
|Software |Open Source| LINK| 2013|

Distributed system::
Apache Kafka - distributed publish-subscribe messaging system. Apache Kafka is a distributed publish-subscribe messaging system. It is designed to support the following: - Persistent messaging with O(1) disk structures that provide constant time performance even with many TB of stored messages. - High-throughput: even with very modest hardware Kafka can support hundreds of thousands of messages per second. - Explicit support for partitioning messages over Kafka servers and distributing consumption over a cluster of consumer machines while maintaining per-partition ordering semantics.Support for parallel data load into Hadoop.
|Software |Open Source| LINK Web site| LINK Dowloads.| 2013|

Distributed system::
Drill-- Apache Drill is a distributed system for interactive analysis of large-scale datasets. Drill is similar to Google’s Dremel, with the additional flexibility needed to support a broader range of query languages, data formats and data sources. It is designed to efficiently process nested data. It is a design goal to scale to 10,000 servers or more and to be able to process petabyes of data and trillions of records in seconds.
Many organizations have the need to run data-intensive applications, including batch processing, stream processing and interactive analysis. In recent years open source systems have emerged to address the need for scalable batch processing (Apache Hadoop) and stream processing (Storm, Apache S4). In 2010 Google published a paper called “Dremel: Interactive Analysis of Web-Scale Datasets,” describing a scalable system used internally for interactive analysis of nested data. No open source project has successfully replicated the capabilities of Dremel.
|Software |Open Source|LINK| 2013|

List of companies providing products that include Apache Hadoop. (Link- open new tab).
 List of companies providing products that include Apache Hadoop, a derivative work thereof, commercial support,  and/or tools and utilities related to Hadoop (Link- open new tab). 
From wiki.apache.org | LINK (open new tab)| 2013|

Cloudera’s Distribution Including Apache Hadoop (CDH).
Cloudera, the leader in Apache Hadoop-based software and services, enables enterprises to easily derive business value from all their data. With tens of thousands of nodes under management, Cloudera's Distribution including Apache Hadoop (CDH) is the #1 open source Apache Hadoop distribution in commercial and non-commercial environments.
Software | English | LINK Download (registratiom not required) | 2013

IBM InfoSphere BigInsights.
InfoSphere BigInsights is IBM`s analytical platform for Big Data. BigInsights helps firms discover and analyze business insights hidden in large volumes of a diverse range of data that`s often ignored or discarded because it´s too impractical or difficult to process using traditional means. The Basic Edition is available for free download.
Software | English | LINK Download (registratiom required)| 2013

IBM`s Public forum for BigInsights users:| LINK | 2013

BigInsights InfoCenter (product technical documentation): LINK | 2013

BigInsights Demo center for BigSheets, a spreadsheet-like visualization tool now shipping with BigInsights Enterprise Edition: LINK | 2011

MapR Apache Hadoop Distribution.
MapR M3 Edition: Free and available for unlimited production use.
Software | English | LINK Download (registratiom not required) | 2013

Stratosphere.
Stratosphere is an open-source system for Big Data Analytics that can be deployed in a local cluster using HDFS or in the Amazon cloud. Stratosphere extends the MapReduce programming model, making it easy to write complex analytic queries that include binary operators such as joins. Stratosphere contains a cost-based optimizer, that automatically picks the best parallel schedule for a program, relieving the programmer from the task of hand-optimizing jobs. The platform is jointly developed by TU Berlin, HU Berlin, and HPI, three Universities in the greater Berlin area.
Software | English | LINK Download | | LINK Download and build instruction page. | 2012

Big Data and Analytical Data Platforms - Articles

How In-Memory Data Grids Can Analyze Fast-Changing Data in Real Time
by Dr. William Bain and Dr. Mikhail Sobolev, ScaleOut Software, Inc.
Abstract: ScaleOut’s latest whitepaper presents the problem of ‘real-time’ data analysis that enterprises are facing and demonstrates how In-Memory Data Grids (IMDGs) are a solution that has ‘real-time’ capabilities which are not addressed in widespread, batch-oriented solutions like Hadoop.
Paper | Advanced| English | DOWNLOAD(PDF)| May 2013|

ActianVectorwise 3.0: Fast Analytics and Answers from Hadoop.
Actian Corporation
Abstract: Actian's latest whitepaper focuses on Vectorwise 3.0 and how it now includes support for structured as well as unstructured data stored in Hadoop clusters. Leveraging fast, cost-effective Big Data technologies such as ActianVectorwise and Hadoop, this technical white paper outlines how organizations are finding new ways to extract value from structured and unstructured data and monetize Big Data.
Paper | Technical | English | DOWNLOAD(PDF)| May 2013|

Virtualized HadoopPerformance with VMware vSphere® 5.1
byJeff Buell, Staff Engineer, Performance Engineering, VMware
Abstract: A cluster of 32 high-performance hosts was used to run three demanding Hadoop applications. The performance of native and several VMware vSphere® configurations was compared. Theapples-to-apples case of a single virtual machine per host shows performance close to that of native. Improvements in elapsed time of up to 13% can be achieved by partitioning each host into two or four virtualmachines, resulting in competitive or even better than native performance. The origins of the improvements areexamined and recommendations for optimal hardware and software configuration are given. Paper | Advanced| English | DOWNLOAD(PDF)|May 2013|

Spanner: Google’s Globally-Distributed Database.
James C. Corbett, Jeffrey Dean, Michael Epstein, Andrew Fikes, Christopher Frost, JJ Furman, Sanjay Ghemawat, Andrey Gubarev, Christopher Heiser, Peter Hochschild, Wilson Hsieh, Sebastian Kanthak, Eugene Kogan, Hongyi Li, Alexander Lloyd, Sergey Melnik, David Mwaura, David Nagle, Sean Quinlan, Rajesh Rao, Lindsay Rolig, Yasushi Saito, Michal Szymaniak, Christopher Taylor, Ruth Wang, Dale Woodford, Google, Inc.
Abstract Spanner is Google’s scalable, multi-version, globally- distributed, and synchronously-replicated database. It is the first system to distribute data at global scale and support externally-consistent distributed transactions. This paper describes how Spanner is structured, its feature set, the rationale underlying various design decisions, and a novel time API that exposes clock uncertainty. This API and its implementation are critical to supporting external consistency and a variety of powerful features: non- blocking reads in the past, lock-free read-only transactions, and atomic schema changes, across all of Spanner.
Published in the Proceedings of OSDI 2012.
|Paper |Advanced| English | LINK DOWNLOAD (PDF)| 2012|
Alex Lloyd’stalkfrom Berlin Buzzwords 2012 about Google’s Spanner, Video| 2012|

Daniel J. Abadi, Yale University
Abstract The CAP theorem’simpact on modern distribute databa sesystem design is more limited than is often perceived. Another tradeoff—between consistency and latency —has had a more direct influence on several well-known DDBSs. A proposed new formulation, PACELC, unifies this trade off with CAP.
© 2012 IEEE Publishedbythe IEEE Computer Society FEBRUARY 2012
LINK DOWNLOAD (PDF)| 2012|

Record Setting Hadoop in the Cloud
M.C. Srivas, CTO, MapR Technologies
AbstractWhen MapR was invited to provide Hadoop on Google Compute Engine, we ran a lot of mini tests on the virtualized hardware to figure out how to tune our software. The results of those tests were surprisingly good. The speed and consistent performance provided by Google Compute Engine even at the 99th percentile was very impressive. So we decided to run a TeraSort benchmark just to see how well we could do in a virtualized, shared environment where we didn't control the hardware, nor control the other non-MapR tenants.
Paper | Advanced| English | DOWNLOAD (PDF)| December 2012|

Big Data: Challenges and Opportunities
Roberto V. Zicari
Abstract: In this presentation I review three current aspects related to Big Data: 1. The business perspective, 2. The Technology perspective, and 3. Big Data for social good.
Presentation (89 pages) | Intermediate| English | DOWNLOAD (PDF)| October 2012|

Big Data for Good.
A distinguished panel of experts discuss how Big Data can be used to create Social Capital.
by Roberto V. Zicari, Editor ODBMS.org.
June 5, 2012.
Abstract: Every day, 2.5 quintillion bytes of data are created. This data comes from digital pictures, videos, posts to social media sites, intelligent sensors, purchase transaction records, cell phone GPS signals to name a few. This is Big Data. There is a great interest both in the commercial and in the research communities around Big Data. It has been predicted that “analyzing Big Data will become a key basis of competition, underpinning new waves of productivity growth, innovation, and consumer surplus”, according to research by MGI and McKinsey’s Business Technology Office.
But very few people seem to look at how Big Data can be used for solving social problems. Most of the work in fact is not in this direction. Why this? What can be done in the international research community to make sure that some of the most brilliant ideas do have an impact also for social issues?
I have invited a panel of distinguished well known researchers and professionals to discuss this issue. The list of panelists include:
- Roger Barga, Microsoft Research, group lead eXtreme Computing Group, USA
- Laura Haas, IBM Fellow and Director Institute for Massive Data, Analytics and Modeling IBM Research, USA
- Alon Halevy, Google Research, Head of the Structured Data Group, USA
- Paul Miller, Consultant, Cloud of Data, UK
This Q&A panel focuses exactly at this question: is it possible to conduct research for a corporation and/or a research lab, and at the same time make sure that the potential output of our research has also a social impact?
We take Big Data as a key example. Big Data is clearly of interest to marketers and enterprises a like who wish to offer their customers better services and better quality products. Ultimately their goal is to sell their products/services.
This is good, but how about digging into Big Data to help people in need? Preventing / predicting natural catastrophes, helping offering services “targeting” to people and structures in social need?
Hope you`ll find this interview interesting, as well as eye-opening. RVZ
Blog Panel | Intermediate | English | DOWNLOAD (PDF)| June 2012|

MapR Apache Hadoop Distribution: Resources.
MapR Hadoop: Software Datasheets, Product Description, White Papers
Software | English | LINK Download (registratiom not required) | 2012

Stratosphere
Stratosphere is an open-source system for Big Data Analytics that can be deployed in a local cluster using HDFS or in the Amazon cloud. The platform is jointly developed by TU Berlin, HU Berlin, and HPI, three Universities in the greater Berlin area.
Collection of Papers | Advanced | English | LINK| 2012|

   Kafka: a Distributed Messaging System for Log Processing. > 
Jay Kreps, NehaNarkhede,Jun Rao,LinkedIn Corp.
ABSTRACTLog processing has become a critical component of the data pipeline for consumer internet companies. We introduce Kafka, a distributed messaging system that we developed for collecting and delivering high volumes of log data with low latency. Our system incorporates ideas from existing log aggregators and messaging systems, and is suitable for both offline and online message consumption. We made quite a few unconventional yet practical design choices in Kafka to make our system efficient and scalable. Our experimental results show that Kafka has superior performance when compared to two popular messaging systems. We have been using Kafka in production for some time and it is processing hundreds of gigabytes of new data each day.NetDB'11, Jun. 12, 2011, Athens, Greece. Copyright 2011 ACM
Paper | Advanced| English | LINK (.PDF)| 2011|

Performance Comparison of InterSystems Caché and Oracle in a Data Mart Application.
Mark Massias, System Engineer, InterSystems.
A global provider of mobile telecommunications software tested the performance of Intersystems Caché and Oracle as the database in a simulated data mart application.
Paper | Introductory | English | DOWNLOAD (PDF)| 2011

Understanding InfoSphere BigInsights An introduction for software architects and technical leaders.
Cynthia M. Saracco, Senior Solution Architect IBM.
Perhaps you've heard about InfoSphere® BigInsights, IBM®'s software platform for storing and analyzing “big data,” and you may be wondering what all the buzz is about. This article provides an introduction to BigInsights and explains what the product was designed to do, when it can be useful, and how it can complement other software you may already have.
Paper | Introductory | English | DOWNLOAD (PDF)| Oct 2011|

  Dremel: Interactive Analysis of Web-Scale Datasets  
Sergey Melnik, Andrey Gubarev, JingJing Long, Geoffrey Romer, Shiva Shivakumar, Matt Tolton, Theo Vassilakis Google, Inc.
ABSTRACT Dremelis a scalable, interactive ad-hoc query system for analysis of read-only nested data. Proceedings of the VLDB Endowment, Vol. 3, No. 1. Copyright 2010 VLDB.
LINK DOWNLOAD (PDF)| 2010|

ParStream- Turning Data Into Knoledge
Abstract: ParStream offers a new approach to high-performance data analysis. It addresses the problems arising from rapidly increasing data volumes in modern business, as well as scientific application scenarios. Close-to-real-time analysis is obtained through simultaneous importing, indexing and querying of data.
White Paper | Intermediate | English | DOWNLOAD (PDF)| November 2010|

Joseph Foley.
Comparison of Data Warehousing DBMS Platforms.
An analysis of the advantages and disadvantages of relational, columnar and correlation databases for complex and demanding analytics environments.
Article | Intermediate | English | DOWNLOAD (PDF)| 2009 |

Joshua Greenbaum.
Rethinking Data Analysis and Reporting.
Unlike relational database management systems, which use a records-based storage approach, or column-oriented databases which use a column-based storage method, a correlation database uses a value-based storage (VBS) architecture in which all data is indexed -- every value in every field -- and unique data values are stored once and only once, no matter how often the value appears and regardless of its original location, all in one giant data store.
Article | Intermediate | English | DOWNLOAD (PDF) | June 2009 |

Joseph Foley.
When Standard SQL Queries Can’t Get the Job Done.
A Correlation database is a database management system (DBMS) that is data model independent and designed to efficiently handle unplanned, ad hoc queries in an analytical system environment. Queries are performed using natural language instead of SQL.
Article | Basic | English | DOWNLOAD (PDF) | 2009 |

Big Data and Analytical Data Platforms - Lecture Notes.

Analyzing Big Data With Twitter.
A special UC Berkeley iSchool course.
Link to course material, including video of the lectures

Big Data and Analytical Data Platforms - PhD and Master Thesis

StreamCloud: An Elastic Parallel-Distributed Stream Processing Engine
Language: English
Author: Vincenzo Massimiliano Gulisano
Affiliation: Universidad Politecnica de Madrid (U.P.M.) - Polytechnic University of Madrid
Abstract: The thesis proposes a novel stream processing engine, StreamCloud, that overcomes limitations of existing centralized and distributed stream processing engines introducing parallelism, elastic capabilities (self provisioning and decommissioning), load balancing and fault tolerance. The proposed stream processing engine has been fully implemented and tested with real world use cases such as fraud detection (in the context mobile phones networks and credit card transactions) and in network monitoring applications to detect and mitigate DDoS attacks.
Type of work: PhD
No of Pages:232
Year of completion:2012
Name of supervisor: Professor Ricardo Jiménez Peris (codirector: Professor Patrick Valduriez)
PhD | Advanced| English | Download 232 pages (.pdf) |2012 |

User Behaviour Modelling in a Multi-Dimensional Environment for Personalization and Recommendation”
Dr. Rakesh Rawat,
Senior Research Assistant (Faculty of Science & Technology)
CRC-Queensland University of Technology
Brisbane, Australia-4000
Author: Rakesh Rawat
Abstract: The thesis discusses methods of modelling user’s Web server search log data for personalization. Various user profile building strategies are discussed that provide highly effective recommendations to users.
Type of work: PhD, No of Pages: 270.
Year of completion: Accepted & PhD conferred on 22nd November 2011.
Supervisors: Associate Professor Richi Nayak (Principal Supervisor). Professor Yuefeng Li (Assoc. Supervisor).
PhD Thesis | Advanced| English | DOWNLOAD (PDF)| March 2012|

Searching Web Data: An Entity Retrieval Model
Author: Dr. Renaud Delbru
Digital Enterprise Research Institute, National University of Ireland, Galway, Ireland
Abstract: More and more (semi) structured information is becoming available on the Web in the form of documents embedding metadata. This calls for large scale systems providing effective means of searching and retrieving this semi-structured information. Towards this goal, we define an entity retrieval model, develop novel methodologies for sup-porting this model, and design a web-scale retrieval system around this model.
Type of work (PhD, Master): PhD
Area: Entity Framework (EF), Graphs and Data Stores, NoSQL Data Stores
No of Pages: 213
Year of completion: 2011
Supervisor: Dr. Giovanni Tummarello / Digital Enterprise Research Institute, National University of Ireland, Galway
PhD Thesis | Advanced| English | DOWNLOAD (PDF)| December 14, 2011|

Scalable Parallelization of Expensive Continuous Queries over Massive Data Streams.
Author: Dr. Erik Zeitler
Language: English
Affiliation: Uppsala University, Sweden
Abstract:For applications that require execution of non-trivial Continuous Queries (CQs) over data streams of high rate, the execution of the CQs must be parallelized. Declarative stream splitting functions are introduced in this Thesis, allowing the user to specify customized parallelization in the query language, similar to fragmentation and replication of distributed databases. It is shown how to automatically generate parallel execution plans for stream splitting functions that enable CQs to be processed at stream rates close to network speed.
Type of work: PhD
Area: Big Data: Analytics, Data Stream Management Systems
No of Pages: 152
Year of completion: 2011
Name of supervisor/affiliation: Tore Risch/Uppsala University, Sweden
PhD Thesis | Advanced| English | Download (.PDF)| 2011|
|

Cloud Data Stores

Blog Posts | Lecture Notes| Articles and Presentations| PhD and Master Thesis|

Cloud Data Stores - Blog Posts

Cloud:
Blog Posts | English | Posts tagged "Cloud" |

Cloud Stores:
Blog Posts | English | Posts tagged "Cloud Stores" |

Cloud Data Stores - Lecture Notes

Data Management in the Cloud.
Michael Grossniklaus, David Maier, Portland State University
Course Description: "Cloud computing has recently seen a lot of attention from research and industry for applications that can be parallelized on shared-nothing architectures and have a need for elastic scalability. As a consequence, new data management requirements have emerged with multiple solutions to address them. This course will look at the principles behind data management in the cloud as well as discuss actual cloud data management systems that are currently in use or being developed.
The topics covered in the courserange from novel data processing paradigms (MapReduce, Scope, DryadLINQ), tocommercial cloud data management platforms (Google BigTable, Microsoft Azure, Amazon S3 and Dynamo, Yahoo PNUTS) and open-source NoSQL databases (Cassandra, MongoDB, Neo4J). The world of cloud data management is currently very diverse and heterogeneous. Therefore, our course will also report on efforts to classify, compare and benchmark the various approaches and systems. Students in this course will gain broad knowledge about the current state of the art in cloud data management and, through a course project, practical experience with a specific system."
Lecture Notes | Intermediate/Advanced | English | DOWNLOAD ~280 slides (PDF)| 2011-12|

Cloud Data Stores - Articles and Presentations

The Curriculum Forecast for Portland: Cloudy with a Chance of Data.
Michael Grossniklaus, David Maier Computer Science Department Portland State University
Abstract: With the advent of cloud computing, new data manage- ment technologies and systems have emerged that differ from existing databases in important ways. As a con- sequence, universities are currently facing the challenge of integrating these topics into their curriculum in order to prepare students for the changed IT landscape. In this report, we describe the approach we have taken at Port- land State University to teach data management in the cloud. We also present our experiences with this effort and give an outlook on how it could be adapted to suit the requirements of other universities.
Article(SIGMOD Record, March 2012 (Vol. 41, No. 1)| Intermediate | English | DOWNLOAD (PDF)| March 2012|

Cloud Data Stores - PhD and Master Thesis

A Distributed Approach to Privacy on the Cloud
Author: Francesco Pagano
Language :English
Affiliation:Università di Milano, Italy
Abstract: The increasing adoption of Cloud-based data processing and storage poses a number of open privacy issues. To handle them, I present a novel approach where confidential data is stored in a highly distributed partitioned database, partly located on the Cloud and partly on the clients.
Type of work: PhD
Area: Cloud data stores
No of Pages:173
Year of completion: 2012
Name of supervisor/affiliation: Prof. Ernesto Damiani.
PhD | Intermediate | English | DOWNLOAD (.PDF) | 2011-12| ***

Object Databases

Object Databases - Free Software

Eclipse Foundation: Indigo-CDO Model Repository.
Eclipse Modeling: The CDO Model Repository 4.0 integrates with several NoSQL databases such as Objectivity/DB, MongoDB, and db4o.
Software | Advanced | English | LINK | 2011|

OO7J benchmark
Pieter van Zyl and Espresso Research Group.
OO7J is a Java version of the original OO7 benchmark (written in C++) from Mike Carey, David DeWitt and Jeff Naughton = Univ Wisconsin-Madison. The original benchmark tested ODBMS performance. This project also includes benchmarking ORM Tools. Currently there are implementations for Hibernate on PostgreSQL and MySQL, db4o and Versant.
Software | Advanced | English | User Manual.(LINK)| The code is available on Sourceforge.(LINK)| Access is through SVN directory.(LINK) | February 2010.

db4objects
db4o Open Source Object Database
Open source object database for Java and .NET. Free GPL download includes an interactive tutorial to get started quickly.
Software | Basic | English | LINK | 2010

Objectivity
Objectivity/DB - Trial download
A 60 day free trial download of the scalable, high performance distributed ODBMS product for C++, Java, Python, Smalltalk or SQL/ODBC applications running on Linux or Windows.
Software | Basic | English | LINK (registration required) | 2010

Intersystems
Caché Post-relational Database
A free, fully-functional, non-expiring, single-user version of Caché.
Software | Basic | English | LINK | 2010

Intersystems
eXTreme Java framework.
Download Caché eXTreme for Java (Registration required): provides an API to store and retrieve structured data over JDBC (JDBC over JNI), unstructured data and Java Objects.
Software | Intermediate | English | LINK. | 2010

Progress Software
ObjectStore PSE Pro for Java or C++ - Trial downloads
Develop high-performance ODBM environments in Java or C++
Free eval of PSE Pro, single process version of ObjectStore Enterprise
Software | Basic | English | LINK (registration required) | 2010

Versant
Versant's ODBMSs - Trial downloads
Versant Object Database: for complex data storage in C++ and Java.
Versant FastObjects .NET: for .NET applications with complex object models
Software | Basic | English | LINK (registration required) | 2009

EyeDB Object Oriented Database Management System
Advanced object model, object definition language based on ODMG ODL, an object query and manipulation language based on ODMG OQL and programming interfaces for C++ and Java.
Software | Basic | English | LINK | 2009

GemStone Systems
GLASS a free ODBMS for the Seaside web framework.
GLASS: GemStone, Linux, Apache, Seaside, and Smalltalk.
Software | Basic | English | LINK | 2009

McObject
Download an open source / evaluation copy of the Perst™ embedded database for Java or .NET.
Software | Basic | English | LINK | 2009

Peter Baumann, Jacobs University
Rasdaman: An open-source array DBMS with an OQL-style query language and ODMG-conformant C++ and Java APIs for retrieving and manipulating multi-dimensional arrays (rasters) of unlimited size.
Software | Basic | English | LINK | May 2009 | ***

Tilburg University--ConceptBase
ConceptBase is a multi-user deductive and object-oriented database system for meta modeling and method engineering (FreeBSD-style license)
Software | Basic | English | LINK | 2008

Kazimierz Subieta
Asking SBQL queries addressing imported XML files
This project allows you to import any number of XML files to the ODRA store in the M0 store model (no classes). After the import you can ask SBQL queries and observe their results.
Software | Advanced | English | LINK | 2006 | ***

Awais Rashid (Principal Investigator)
AspOEv: An Aspect Oriented Evolution Framework for ODBMS
This project aims at employing an aspect-oriented approach to facilitate customisation, extension and exchange of the schema modification, structural and behavioural consistency strategies in an object database evolution framework.
Software | Advanced | English | LINK | 2004 | ***

Suzanne Dietrich, Dan Suceava, Chakrapani Cherukuri, Susan Urban
ObjectManager for Objectivity/DB
provides a reusable graphical user interface written in Java(Swing) for populating and browsing an Objectivity/DB object-oriented database.
Software | Basic | English | LINK | 2001 | ***

Object Databases - Lecture Notes

Michael Grossniklaus, Moira Norrie, ETH Zürich
Object-Oriented Databases (Version 2010)
NEW IN 2010: Updated slides on db4o to reflect the API of the latest version. Extended the discussion of OQL in the lecture about ODMG 3. In-depth presentation of commercial systems (Versant Object Database, ObjectStore and Objectivity/DB) in completely new and dedicated lectures #8, #9 and #10. To increase diversity, Versant is coupled with Java, ObjectStore with C++ and Objectivity/DB with C#. Finally, LINQ has been introduced into the course as part of the Objectivity/DB lecture.

PART 1: BASICS OF OBJECT DATABASES
Lecture #1: Introduction (Course Overview; Evolution/History of Database Management Systems; Requirements of Object-Oriented Data Management Systems)
Lecture #2: Object Persistence (Object-Relational Mappings and Frameworks; Serialisation; Persistent Programming Languages)
Lecture #3: db4o: Part 1 (Basics: Managing databases, Storing and Retrieving Objects; Querying Objects: Query by Example, Native Queries, SODA; Simple and Structured Objects; Object Hierarchies; Activation; Transactions: Concurrent Transactions, Semaphores)
Lecture #4: db4o: Part 2 (Configuration and Tuning: Configuration Interface, Indexes; Distribution and Replication: Client/Server Model, dRS; Schema Evolution: Refactoring, Inheritance Evolution; Callbacks and Translators)
PART 2: ADVANCED CONCEPTS OF OBJECT DATABASES
Lecture #5: Version Models (Temporal Databases; Engineering Databases (CAD and CAM); Software Configuration Systems (CASE))
Lecture #6: Storage and Indexing (Type Hierarchy Indexing; Aggregation Path Indexing; Collection Operations)
Lecture #7: ODMG Standard (Object Model; Object Definition Language (ODL); Object Query Language (OQL); Programming Language Bindings)
Lecture #8: Commercial OODBMS: Versant (Versant Object Database for Java; Java Versant Interface (JVI); Versant Query Language (VQL))
Lecture #9: Commercial OODBMS: ObjectStore (ObjectStore PSE Pro for C++; Virtual Memory Mapped Architecture; Managing Persistent Object Data)
Lecture #10: Commercial OODBMS: Objectivity/DB (Objectivity/DB for .NET; Logical Storage Model: Federated Databases; Language Integrated Queries (LINQ))
PART 3: THE OMS FAMILY OF OBJECT DATABASES
Lecture #11: The OM Data Model (Multiple Inheritance, Instantiation and Classification; Collections and Associations; Cardinality, Classification and Evolution Constraints)
Lecture #12: Object Model Language: OML (Collection Algebra; Language Design; Data Definition, Manipulation and Query Language)
Lecture #13: Design and Implementation: OMS Avon (Architecture; Storage, Model and Interface Layer; Database Modules)
Lecture #14: Course Review (Exam Information; Summary; OODBMS Architectures)
COURSE DESCRIPTION: The course examines the principles and techniques of providing data management in object-oriented programming environments. It is divided into three parts that cover the road from simple object persistence, to object database management systems and to advanced data management. The lecture notes contain 446 slides that are split into 14 lectures of 90 minutes each. At ETH Zurich, the course is accompanied by weekly exercises based on db4o, Versant Object Database, ObjectStore, Objectivity/DB and OMS Avon. Further details are available at http://www.globis.ethz.ch/education/oodb.
TARGET GROUP: Students of Computer Science in the 5th semester or higher.
PREREQUISITES: Database design and implementation, Object-oriented design and programming.
Lecture | Intermediate | English | DOWNLOAD (zip-PDF)| 2010 | ****

Martin Hulin, Hochschule Ravensburg-Weingarten.
Modern Database Techniques.
Excellent, Complete and up to date lecture note series (397 slides).
Content and Course Structure:
Learning module 0: Course Information, Welcome: 1 h
Learning module 1: Introduction to Object Oriented Databases: 4 h
Learning module 2: Concepts of Object Oriented Databases: 40 h
Learning module 3: Client Application and Language Binding: 20 h
Learning module 4: Advanced storage concepts, performance tuning: 10 h
Learning module 5: System Management: 20 h
Learning module 6: Security in Databases: 10 h
Learning module 7: Distributed and Mobile Databases: 25 h
Web conference: Exam Preparation: 2 h
Target group: Students of Computer Science in 5th semester or higher. Prerequisites: Relational Databases, SQL, Object Oriented Programming, UML. Duration: Student workload: 120 h –150 h. Lecture and supervised exercises: 64 lessons (45 min).
For all exercises, Martin uses the object oriented database management system Caché from InterSystems.
Lecture| Intermediate|English| DOWNLOAD (PDF)| 2010 | ****

Beat Signer, Vrije Universiteit Brussel.
Introduction to Databases Object and Object-Relational Databases.
This lecture notes (40 slides) describe the problem of Impedance Mismatch, and then present the basic concepts of Object Databases and Object-Relational Databases.
Lecture | Introductory | English | DOWNLOAD (.PDF) | June 2010 |

Adrian Marriott
Persistent OO Patterns.
Lecture notes given at ICODB 2009, presents several Common Persistent Model Patterns for Performance and/or Scalability Optimization, among them “Query Visitor” which received the ODBMS.ORG Best Persistent Model Patterns Awards 2009. Query Visitor represents a query to be performed on the elements of a persistent object structure. Query Visitor allows you to define new result set formats without changing the underlying persistent object model, and avoids polluting the persistent classes with rendering logic.
Lecture | Intermediate | English | DOWNLOAD (PDF). | July 2009 |

Michael Grossniklaus, Moira Norrie, ETH Zürich
Object Oriented Databases - Excellent, Complete and up to date lecture series(Version 2009).
For the 2009 version of ETH Zurich's lecture on Object-oriented databases a number of additions and updates have been made:
- New lecture providing a Versant tutorial - New lecture discussing different OODBMS architectures - Updated lectures on db4objects incorporating new features such as transparent persistence and activation. - Updated lectures on the OM model of data, OML and OMS Avon - Many corrections of errata throughout the whole course.

Lecture 1: 035.01 Introduction: • Course Overview • Evolution/History of Database Management Systems • Requirements of Object-Oriented Data Management Systems.
Lecture 2: 035.02 Object Persistence• Object-Relational Mappings and Frameworks •Serialisation • Persistent Programming Languages
Lecture 3: 035.03 db4o Part1 • Basics: Managing databases, • Storing and Retrieving Objects Querying Objects: Query by Example, • Native Queries, • SODA Simple and Structured Objects, • Object Hierarchies, Activation Transactions: Concurrent Transactions, • Semaphores
Lecture 4: 035.04 db4o Part2 • Configuration and Tuning: Configuration Interface, • Indexes Distribution and Replication: Client/Server Model, • dRS Schema Evolution: Refactoring, Inheritance Evolution Callbacks and Translators
Lecture 5: 035.05 ODMG Standard • Object Model Object Definition Language (ODL) • Object Query Language (OQL) • Programming Language Bindings
Lecture 6* part I: 035.06 Commercial OODBMS: Part 1 • Objectivity/DB for C++ • ObjectStore PSE Pro for Java
Lecture 6 part II: 035.06 Commercial OODBMS: Part 2 • Versant Object Database for Java • OODBMS Architectures
Lecture 7: 035.07 Storage and Indexing • Type Hierarchy Indexing • Aggregation Path Indexing • Collection Operations
Lecture 8: 035.08 Version Models • Temporal Databases •Engineering Databases • Software Configuration Systems
Lecture 9: 035.09 The OM Data Model• Multiple Inheritance, • Instantiation and Classification Collections and Associations Cardinality, • Classification and Evolution Constraints
Lecture 10: 035.10 Object Model Language: OML • Collection Algebra Language Design Data Definition, • Manipulation and Query Language
Lecture 11**: 035.11 Avon Implementation•Architecture: Storage • Model and Interface Layer • Object Identifiers • Query Processor
Lecture 12: 035.12 Support for Context Aware Data Management
Lecture 13: 035.12 Course Review • Ongoing Research • Student Projects • Exam Information
*with Beat Signer
Lecture | Intermediate | English | DOWNLOAD (PDF) | 2009 | ****

Object Databases - Tutorials

Object Databases
Michael Grossniklaus, Politecnico di Milano.
Tutorial slides presented at ICOODB Frankfurt 2010.This tutorial is intended to give an overview and introduction to object databases, providing necessary background to professionals in order to make informed decision in the future.
Tutorial | Intermediate | English | DOWNLOAD (PDF 75 pages) | September 2010|

Patterns of Data Modeling
Michael R. Blaha, Modelsoft Consulting Corp.
Tutorial slides presented at ICOODB Frankfurt 2010. Data modeling is an aspect of software engineering and is important when building database applications.
Tutorial | Intermediate | English | DOWNLOAD (PDF 49 pages) | September 2010|

db4objects
Formula 1 Tutorial for Java or .NET
New version of the db4o tutorials: with new features and a new OME. The quick start to get up and running with db4o's object database in 5 minutes or less.
Tutorial | Basic | English | DOWNLOAD for JAVA (PDF) or .NET (PDF) | 2009 | ****

GemStone
Learning Web Development with Seaside.
Seaside is a free, open-source (MIT License) web application development framework written in Smalltalk. This tutorial covers Seaside, GLASS, and persistence using the GemStone/S ODBMS.
Tutorial | Basic | English | LINK | 2009 |

McObject
Tutorial: Introduction to Perst Lite and ProScout Example MIDlet.
Perst Lite is an open source, object-oriented embedded database system for Java ME-based mobile devices.
Tutorial | Basic | English | LINK | 2009 |

ConceptBase
Manfred Jeusfeld, Tilburg University
Metamodeling for Method Engineering, Slides of a course based on ConceptBase
The slides are under a permissive Creative Commons license.
Tutorial | Basic | English | LINK | 2008 |

Object Databases - Articles and Papers

Evaluating NoSQL for Enterprise Applications
Dirk Bartels, VP of Product Strategy, Versant
Abstract: Learn how and why NoSQL technologies are becoming part of the database evaluation process even for complex enterprise applications. Examine the core value proposition of technologies such as key-value, document, and graph stores and correspondingly their respective use cases and potential drawbacks for more complex enterprise application requirements.
WebSeminar Paper | Intermediate | English | DOWNLOAD (PDF)| 2012|

So you think you know JPA? Think again.
Dirk Bartels, VP of Product Strategy, Versant Matthew Barker - Director of Professional Services, Versant
Abstract: JPA is known as the standard Java programming language framework managing relational data in applications. But can you imagine using your JPA skills for this new era of Big Data and NoSQL? In this webinar, we introduce a new JPA implementation for Big Data andNoSQL applications. We will compare the performance of Versant JPA to other NoSQL and relational JPA products and provide essential guidelines to evaluate the products for different types of applications, workloads and class models. Get the facts on JPA ,NoSQL and Big Data.
WebSeminar Paper | Intermediate | English | DOWNLOAD (PDF)| 2012|

Beyond Java ORM with Versant JPA (Part 1)  
German Viscuso, Developer Relations Manager, Versant Corporation.  
Abstract: The JPA specification draws on ideas, concepts and standards from leading persistence frameworks such as TopLink, Hibernate, and Java Data Objects (JDO), as well as on earlier EJB container-managed persistence. But JPA itself is just a specification; a set of interfaces, and requires an implementation and a database to persist to. The Versant team reviewed the state-of-the-art of JPA technology to bring to you Versant JPA, the JPA 2.0 provider for Versant Database technology. In this multi-part article I will introduce the basic building blocks of the Java Persistence API as I walk you through the Versant JPA implementation from a user (developer) perspective.
Paper | Intermediate | English | DOWNLOAD (PDF)| March 2012|

The logic of group operations on complex objects in RxO-system.
Evgeniy Grigoriev, 2011
Abstract. Group operations (queries and methods) on RxO-system complex objects are described in the paper. Thesis on object complexity presumes that state of any enterprise object can be representing as set of relation values. Operations are given which realize base principle of representing complex object data into relations. Translation statement as formal base of class method group execution is proved. Conclusion is drown that described transformations can be created on existing relational system base.
Paper | Intermediate | English | DOWNLOAD (PDF)| 2011|

The PicoLisp 'edit' Function: Browsing a Distributed Database With a Text Editor.
Alexander Burger, Software-lab
The 'edit' function in PicoLisp can edit the value and properties of any Lisp symbol, and follow references to symbols referred from these data. As database objects (including those of remote/distributed systems) are nothing more than Lisp symbols (mapped transparently into the current scope), a single edit session can possibly span the whole system.
Paper | Intermediate | English | DOWNLOAD (PDF)| 2011|

Benchmarking the Versant Object Database and MySQL with the FOKUS open IPTV Ecosystem.
Stefan Arbanowski, Fraunhofer Institute, FOKUS.
This white paper presents the result of user benchmarks between the Versant Object Database and MySQL conducted by the Fraunhofer Institute, FOKUS.
Paper | Introductory | English | DOWNLOAD (PDF)| March 2011|

European Space Agency: Charting the Galaxy with the GAIA satellite and InterSystems Caché.
William O´Mullane, European Space Agency, and Vik Nagjee, InterSystems.
This report shows the proof-of-concept conducted by the European Space Agency and InterSystems, where sample astrometic data (5 billion Java objects) were inserted into Caché at a speed of 112,000 objects/sec within 12 hours.
Paper | Intermediate | English | DOWNLOAD (PDF)| February 2011|

New db4o Replication System v8 in a Nutshell .
Carl Rosenberger, db4o Chief Software Architect, Versant Corporation
A new improved version of the db4o Replication System (dRS) is available as part of db4o’s general db4o 8.0 production release. dRS now also supports replicating objects with the Versant Object Database (VOD).
Paper | Introductory | English | DOWNLOAD (PDF)| March 2011|

Data From Outer Space. .
Versant.
This short paper describes a case study: the handling of telemetry data and information of the “Herschel” telescope from outer space with the Versant object database. The telescope was launched by the European Space Agency (ESA) with the Ariane 5 rocket on 14 May 2009.
Paper | Introductory | English | DOWNLOAD (PDF)| 2010|

Object-Oriented or Object-Relational? An Experience Report from a High-Complexity, Long-Term Case Study.
Peter Baumann, Jacobs University Bremen
Object-Oriented or Object-Relational? We unroll this question based on our experience with the design and implementation of the array DBMS rasdaman which offers storage and query language retrieval on large, multi-dimensional arrays such as 2-D remote sensing imagery and 4-D atmospheric simulation results. This information category is sufficiently far from both relational tuples and object-oriented pointer networks to achieve a "fair" comparison where no approach has an immediate advantage.
Paper | Intermediate | English | DOWNLOAD (PDF)| July 2010|

Unifying Remote Data, Remote Procedures and Web Services.
William Cook, University of Texas at Austin.
KEYNOTE presented at ICOODB Frankfurt 2010.
Presentation | Intermediate | English | DOWNLOAD (PDF)| September 2010|

Objects, Tables and Performance .
Stefan Wittmann, InterSystems.
This short paper presented at ICOODB Frankfurt 2010, compares Cache` with respect to classical relational databases and NoSQL data stores.
Paper | Intermediate | English | DOWNLOAD (PDF)| November 2010|

Efficient Development of Event-Driven Systems with Versant Object Database.
Guenter Ressell-Herbert, Versant.
Slides presented at ICOODB Frankfurt 2010.
Presentation | Intermediate | English | DOWNLOAD (PDF)| September 2010|

Accelerating Application Development with Objects.
Eric Falsken, German Viscuso, Roman Stoffel, db4objects.
Slides presented at ICOODB Frankfurt 2010. Example projects based on NerdDinner.com but implemented in multiple platforms using popular ODBMSs as data backends. All of the code is going online at objectdinner.com
Presentation | Intermediate | English | DOWNLOAD (PDF)| September 2010|

The Synergy Between the Object Database, Graph Database, Cloud Computing and NoSQL Paradigms.
Leon Guzenda, Objectivity.
Slides presented at ICOODB Frankfurt 2010.
Presentation | Intermediate | English | DOWNLOAD (PDF)| September 2010|

Unified Database Theory.
Reinhard Karge ,run Software-Werkstatt.
The paper provides a common mathematical database theory that unifies relational databases, data warehouse models and object-oriented database models.
Paper | Intermediate | English | DOWNLOAD (PDF)| November 2010|

A terminology model approach for defining and managing statistical metadata .
Reinhard Karge ,run Software-Werkstatt.
The paper considers the structure of a terminology model based on essential aspects of knowledge representation.
Paper | Intermediate | English | DOWNLOAD (PDF)| November 2010|

Pieter van Zyl, University of Pretoria.
Performance investigation into selected object persistence stores.
This dissertation presents OO7J, a Java version of the original OO7 benchmark. The original benchmark tested ODBMS performance. This work also includes benchmarking ORM Tools and compares Hibernate on PostgreSQL and MySQL, db4o and Versant.
Dissertation | Advanced| English | DOWNLOAD (187 pages PDF) |February 2010.| ***

Moira Norrie, Michael Grossniklaus, et. al., ETH Zürich
Semantic Data Management for db4o
The paper, a submission to ICOODB 2008, presents a semantic data management layer for db4o which supports role modelling, associations and a declarative query language
Paper | Intermediate | English | DOWNLOAD (PDF) | March 2008 | ***

Ruihua Jin, Marco Piccioni, ETH Zürich
Eiffel for .NET Binding for Db4o
The paper, a submission to ICOODB 2008, describes the implementation of the necessary Db4o framework classes to make it usable within Eiffel applications
Paper | Intermediate | English | DOWNLOAD (PDF) | March 2008 | ***

Kazimierz Subieta, Polish-Japanese Institute of Information Technology
Stack-Based Approach (SBA) and Stack-Based Query Language (SBQL)
Introduction to object-oriented concepts in programming languages and databases, SBA and SBQL
New sections on persistence, impedance mismatch, and collections. Portal | Intermediate | English | LINK | 2008 | ***

Kazimierz Subieta et. al., Polish-Japanese Institute of Information Technology
Stack-Based Architecture and Stack-Based Query Language
The paper, a submission to ICOODB 2008, presents fundamental ideas and topics of SBA and SBQL
Paper | Intermediate | English | DOWNLOAD (PDF) | 2008 | **

Kazimierz Subieta et. al., Polish-Japanese Institute of Information Technology
SQBL Object Views - Unlimited Mapping and Updatability
The paper, a submission to ICOODB 2008, focuses on SQBL object views to enable unlimited mapping and updatability
Paper | Intermediate | English | DOWNLOAD (PDF) | 2008 | **

I.E. Shanthi, R. Kirutthika, R. Nadarajan
An Indexing Method for Handling Queries on Setvalued Attributes in ODBMS
The paper, a submission to ICOODB 2008, proposes a signature-based indexing method for object-oriented query handling
Paper | Intermediate | English | DOWNLOAD (PDF) | March 2008 | ***

Jiang Li, Ram M. Narayanan, Austin Peay State University
Integrated Information Mining and Image Retrieval in Remote Sensoring
This White Paper describes the application of ODBMS to deal efficiently with very complex data.
Paper | Intermediate | English | DOWNLOAD (PDF) | October 2007 | ***

Jiang Li, Austin Peay State University
Hierarchical Land Cover Information Retrieval in Object-Oriented Remote Sensing Image Databases with Native Queries
This White Paper describes the application of Native Queries in complex image databases.
Paper | Intermediate | English | DOWNLOAD (PDF) | November 2007 | ***

Dan Weinreb
The Technology and Business of ObjectStore.
Daniel Weinreb.
An old but interesting blog post by Daniel Weinreb (co-founder of ObjectStore) giving his thoughts on the technical story behind the creation of the ObjectStore object-oriented database management system.
Blog | Basic | English | LINK | 2007 | ***

Kazimierz Subieta, Polish-Japanese Institute of Information Technology
030.01 Odra - Object-oriented Rapid Database Application Development
Odra is a next-generation object-oriented environment for rapid database application development. This paper describes the motivation, general assumptions and Odra's architecture
Paper | Intermediate | English | DOWNLOAD (PDF) | January 2007 | ***

Christian Merenda, OOMEGA
036.01 Lost in Translation
The author explains the benefits of ODBMS by differentiating the various concepts and discussing them separately. Itturns out that object and relational databases are on the way to converge to each other.
Paper | Basic | English | DOWNLOAD (PDF) | November 2007 | ***

William Cook et.al.
OOPSLA Panel Objects and Databases
Transcript of a high ranking panel on objects and databases at the OOPSLA conference 2006, with representatives from BEA, db4objects, GemStone, Microsoft, Progress, Sun, and Versant.
Transcript | Basic | English | PDF | 2006 | ****

Stefan Edlich, Jim Paterson, et. al.
The Definite Guide to db4o
Chapter 3: 002.02 Comparing the Object and the Relational Data Model
Chapter 5: Quick Start
Chapter 8: 002.03 Client/Server Mode
3 free chapters, Apress, 2006, ISBN 1-59059-656-0.
Book | Basic | English | DOWNLOAD Chapter 3 (PDF), LINK Chapter 5, DOWNLOAD Chapter 8 (PDF) | June 2006 | ***

Leon Guzenda, Objectivity Inc.
025.01 The Evolution of a Distributed, Federated Object Query Engine
This White Paper describes the evolution of the general purpose Objectivity/DB object database from a homogeneous, navigational object access tool to a distributed, federated (heterogeneous) query engine.
Paper | Basic | English | DOWNLOAD (PDF) | June 2006 | ***

Andrew Wade, Objectivity Inc.
029.01 Hitting the Relational Wall
This paper makes the case for selecting an object database when the applications require information models to support relationships, new data types, extensible data types, and direct support of objects.
Paper | Basic | English | DOWNLOAD (PDF) | 2005 | ***

Ouri Wolfson et. al., University of Illinois at Chicago
Managing Uncertainty in Moving Objects Databases
This article covers the problem of managing objects that can change location. Applications for such approach are for example spatial databases.
Article | Advanced | English | LINK (PDF) | September 2004 | ***

Serge Shumilov, Armin B. Cremers, University of Bonn
eXtensible Database Adapter
This paper describes the first hand experience gained in implementing remote CORBA access for the object-oriented database ObjectStore.
Paper | Basic | English | LINK (PDF) | 2000 | ***

Thad Scheer, Theresa Smith, Lockheed-Martin Mission System
032.01 Accelerating Your Object-Oriented Development
The article presents a user experience of implementing object persistence using a relational database and illustrates the technical problems related this choice and the alternative of using an object database.
Article | Intermediate | English | DOWNLOAD (PDF) | 1999 | ***

Joe Celko and Jackie Celko, Byte
Debunking Object-Database Myths
A defense for ODBMS at the height of the battle against RDBMS that cleans up with some common misconceptions of ODBMSs. Though old still true.
Article | Basic | English | LINK | October 1997 | ***

Daniel F. Lieuwen, Alcatel-Lucent
Optimizing And Parallelizing Loops In Object-Oriented Database Programming Languages
The purpose of this section is not to exhaustively enumerate the types of queries that can be optimized, but rather to demonstrate that the ideas in this thesis can be implemented and can significantly improve performance.
Paper | Advanced | English | DOWNLOAD (PDF) | 1992 | ***

Daniel F. Lieuwen, David F. DeWitt, Manish Mehta
Parallel Pointer-based Join Techniques for Object-Oriented Databases
This paper describes four parallel pointer-based join algorithms for set-valued attributes. Pointer-based joins will be common in next-generation object-oriented database systems, so efficiently supporting them is crucial to the performance of such systems.
Paper | Advanced | English | DOWNLOAD (PDF) | 1993 | ***

Daniel F. Lieuwen, David F. DeWitt
Optimizing Loops in Database Programming Languages
Database programming languages like O 2 , E, and O++ include the ability to iterate through a set. Nested iterators can be used to express joins. We describe compile-time optimizations of such programming constructs that are similar to relational transformations like join reordering.
Paper | Advanced | English | DOWNLOAD (PDF) | 1991 | ***

Object Databases - PhD and Master Thesis

System Query Language (SyQL): An Abstraction Layer for Querying Software Models
Mirco Bianco;
Free University of Bolzano/Bozen (formerly); Dini, Garavelli & Partners / Metroconsult Genova (Now), Italy.
Abstract: Improving the efficiency of the software development process is a goal of Software Engineering. In the last decade, several Automated In-process Software Engineering Measurement and Analysis (AISEMA) systems have been specifically designed and implemented, in order to automatically collect software process data by storing them in a relational schema. General-purpose query languages like SQL introduce a competence and cost barrier to reporting of software process information. In turn, such barrier hinders the adoption of the AISEMA systems. In this dissertation, we describe the implementation of a special-purpose query language, System Query Language (SyQL), mainly but not exclusively designed for software process data. SyQL significantly lowers the competence barrier by providing a query interface tailored to software process data.
 Type of work: PhD Thesis, No of Pages:253.
Area:Object Databases, Object-Relational Technology
Language : English;
Year of completion: 2011/2012
Supervisor: Prof. Ernesto Damiani (University of Milan); Prof. Werner Nutt (Free University of Bolzano/Bozen)
PhD Thesis | Intermediate | English | DOWNLOAD (PDF)| April 2012|

GreenIT and Databases (in German)
Tobias Gontermann, Adam Hermann, Marten Rosselli,
DBIS, Goethe University Frankfurt, Germany.
Abstract: How "Green" is a database? Aim of this research is to explore the relationships between Green Computing and Databases. We started by using classical database benchmarking and measuring the resulting energy consumptions of Cache´.  Work in cooperation with InterSystems.
 Type of work: Diploma Thesis, No of Pages:205.
Supervisor: Prof. Roberto V. Zicari.
Master Thesis | Intermediate | English | DOWNLOAD (PDF)| June 2011|

Object Databases - User Reports

Persistence Patterns

The following are the Common Persistent Model Patterns submitted to the ODBMS.ORG Awards:

Matthew Barker, Director of System Engineering, Versant Corp.
Large Persistent Collection.
Intent: This pattern sub-divides a large persistent collection into smaller component collections using a balanced tree structure.
1 Pattern | Intermediate | English | DOWNLOAD (PDF)| May 2009 |

Lenny Hoffman, Todd Stavish, Dr Nic Caine, Brian Clark. Objectivity, Inc.
Dynamic Schemas in object database management systems (ODBMS)
Through the lifetime of a system processing and data requirements change resulting in changes to the underlying object model. Managing these changes without having to take the application down is a key requirement in many of these systems. This paper discusses ways to manage these changes.
1 Pattern | Intermediate | English | DOWNLOAD (PDF) | May 2009 |

Richard Lingeh, Principal Consultant, Versant
Schema Builder 2nd Best ODBMS.ORG Pattern Awards!
This paper presents 1 Pattern which allows any further evolution of a database after a complete modification of the client application model to be done by a separate schema process and not by the client application or by the schema it generates. This separate process generates a database schema that matches the complex evolving client application model.
1 Pattern | Intermediate | English | DOWNLOAD (PDF)| May 2009 |

Adrian Marriott , Principal Consultant, Progress Software Inc.
14 Persistent Object-Oriented Patterns.
This paper outlines a series of common OO patterns (13 patterns and 1 anti-pattern) that have been encountered in the past decade working with ObjectStore based systems on major projects across all industry sectors:
[] Bespoke Indexes, 3rd Best ODBMS.ORG Pattern Awards!
[] Compress Persistent Data,
[] Database Manager,
[] Evolver,
[] Frame,
[] Head/Body,
[] OO Anti-Patterns,
[] Persistent Mutex,
[] Persistent Queue,
[] Persistent Singleton,
[] Query Visitor, Best ODBMS.ORG Pattern Awards!
[] Small Object Pool Allocator,
[] String Table,
[] Transaction Memento.
14 Patterns | Intermediate | English | DOWNLOAD (PDF) | May 2009 |

Eugenia Stathopoulou, Panos Vassiliadis
Design Patterns for Relational Databases.
Presents 4 patterns for relational databases on top of which, object-relational or other structures can be applied.
[] Querying,
[] Schema Modifications,
[] Storage,
[] Updates,
4 Patterns | Intermediate | English | DOWNLOAD (PDF)| May 2009 |

Object Databases - Videos

Part I of the Video of the Keynote Panel: "New and old Data stores" held at ICOODB 2010 Frankfurt on September 29, 2010.
Part II of the Video of the Keynote Panel: "New and old Data stores", held at ICOODB 2010 Frankfurt on September 29, 2010.
Panelists: Ulf Michael (Monty) Widenius, main author of the original version of the open source MySQL database. Michael Keith, architect at Oracle. Patrick Linskey, Apache OpenJPA project. Robert Greene, Chief Strategist Versant. Leon Guzenda, Chief Technology Officer Objectivity. Peter Neubauer. COO NeoTechnology. Moderators: Alan Dearle, University of St. Andrew. Roberto V. Zicari, Goethe University Frankfurt.
The world of data management is changing. The linkage to service platforms, operation within scalable (cloud) platforms, object-relational bindings, NoSQL databases, and new approaches to concurrency control are all becoming hot topics both in academia and industry. The name NoSQL databases attempts to label the emergences of such growing number of non-relational, distributed data stores that often did not attempt to provide ACID properties. ACID properties are the key attributes of classic relational database systems. Such “new data stores” differ from classic relational databases, they may not require fixed table schemas, and usually avoid join operations and typically scale horizontally. The panel discussed the pros and cons of new data stores with respect to classical relational databases.
Video | Intermediate | English | DOWNLOAD Part I of the Video of the Keynote Panel: "New and old Data stores".| Download Part II of the Video of the Keynote Panel: "New and old Data stores". | September 2010|

Robert Greene
Using Versant - hands on distributed objects.
This 45 ` demo presents the use of the Versant object database. In particular, it shows how to take a pure in-memory Java application and make it fully persistent using Eclipse IDE. Further it shows how to make the application fault tolerant via synchronous replication with literally the click of a button, demonstrates object migration across physical databases while maintaining a fully connected object model in the application space, shows how to build and use a parallel query over a logical sub-grouping of physical databases. Finally, the demo ends with a quick into performance optimization and removal of the N+1 problem of network access to connected data.
Demo Video | Intermediate | English | LINK | February 2010

Object Databases - Blog Posts

Common Persistent Model Patterns
Blog Posts | English | Posts tagged "Common Persistent Model Patterns"|

Object Databases
Blog Posts | English | Posts tagged "Object Databases" |

ODBMS
Blog Posts | English | Posts tagged "ODBMS" |

ODBMS.ORG
Blog Posts | English | Posts tagged "ODBMS.ORG" |

Object Persistence
Blog Posts | English | Posts tagged "Object Persistence" |

Objects in Space:
Blog Posts | English | Posts tagged "Objects in Space" |

Standards for ODBMS:
Blog Posts | English | Posts tagged "Standards" |

Object Databases - Portals

NoSQL Data Stores

Blog Posts | Free Software | Articles, Papers, Presentations| Documentations, Tutorials, Lecture Notes | PhD and Master Thesis

NoSQL Data Stores - Blog Posts

Amazon Dynamo:
Blog Posts | English | Posts tagged "Amazon Dynamo" |

Apache Cassandra:
Blog Posts | English | Posts tagged "Apache Cassandra" |

Document Stores:
Blog Posts | English | Posts tagged "Document Stores" |

Google Big Table:
Blog Posts | English | Posts tagged "Google BigTable" |

HBase:
Blog Posts | English | Posts tagged "HBase"|

Key-value Stores:
Blog Posts | English | Posts tagged "Key-value Stores"|

YCSB Benchmark:
Blog Posts | English | Posts tagged "YCSB Benchmark" |

New and Old Data Stores:
Blog Posts | English | Posts tagged "New and Old Data Stores" |

NoSQL Databases:
Blog Posts | English | Posts tagged "NoSQL Databases" |

Map Reduce:
Blog Posts | English | Posts tagged "Map Reduce" |

MongoDB:
Blog Posts | English | Posts tagged "MongoDB" |

Voldemort:
Blog Posts | English | Posts tagged "Voldemort" |

NoSQL Data Stores - Free Software

vFabric SQLFire --free trial download (LINK)| 2012

vFabric GemFire-- free trial download (LINK) | 2012

InterSystems (Globals)-- a free database from InterSystems).
At its core, the Globals database is powered by an extremely efficient multidimensional data engine. The exposed interface support access to the multidimensional structures – providing the highest performance and greatest range of storage possibilities. A multitude of applications can be implemented entirely using this data engine directly.
There is no data dictionary, and thus no data definitions, for the multidimensional data engine.
Globals (v2012.296) release introduces the .NET API for the Globals Database, along with improvements and corrections to the existing Java & Node.js APIs.
Globals v2012.296 is available for the following platforms:
• Apple Mac OS X 10.6, 10.7 for x86-64
• Microsoft Windows XP Pro, Server 2003 SP2, Server 2008, Vista, 7, 7 SP1 forx86-32
• Microsoft Windows Server 2003 SP2, Server 2008, Vista, 7, 7 SP1 for x86-64
• Red Hat Enterprise Linux Advanced Platform 5, 6, 6.1 for x86-32
• Red Hat Enterprise Linux Advanced Platform 5, 6, 6.1 for x86-64
• SUSE Linux Enterprise Server 11 SP1 for x86-32
• SUSE Linux Enterprise Server 11 SP1 for x86-64
• Ubuntu 11.04 for x86-64|
Link to Getting Started for Globals (v2012.296)| 2012 |
Link to Globals Release Notes - v2012.296 | 2012 |

Google Open Source Software.
Google did open source some low-level pieces of software that are useful for building storage systems (among other things). Among these are:

LevelDB: is a library that implements a fast persistent key-value store: LevelDB key/value store (LINK), 2011.

Protocol Buffers: are a way of encoding structured data in an efficient yet extensible format. Google uses Protocol Buffers for almost all of its internal RPC protocols and file formats: Protocol Buffers (LINK), 2011.

Snappy: is a compression/decompression library. Snappy is widely used inside Google, in everything from BigTable and MapReduce to internal RPC systems: Snappy compression library (LINK), 2011.

Globals.
Globals is a free database from InterSystem. Globals offer multi-dimensional storage. The first version is for Java. Software | Intermediate | English | LINK | May 2011

db4o as Storage Provider in Voldemort.
Voldemort’s local persistence component allows for different storage engines to be plugged in. This software creates a new storage engine that uses db4o as storage engine in Voldemort. The source code is available under the Apache 2.0 license. Software | Intermediate | English | LINK | September 2010

Memcached:
Free & open source, high-performance, distributed memory object caching system.
Software | Intermediate | English | LINK | 2011

MongoDB
(from "humongous") is a scalable, high-performance, open source, document-oriented database.
Software | Intermediate | English | LINK | 2011

Hypertable
Hypertable: Modeled after Google's Bigtable project, Hypertable is an open source software designed to manage the storage and processing of information on a large cluster of commodity servers, providing resilience to machine and component failures. Download Hypertable 0.9.2.7 (September 18, 2009)
Software | Basic | English | LINK | 2009

Databeans
Databeans is a fully object oriented persistence framework for java, based on the use of javabeans accessor methods to read/write data on disk in place of in class instance fields, available under GPL.
Software | Basic | English | LINK | 2009

NoSQL Data Stores - Articles, Papers, Presentations

What's new in Couchbase Server 2.0
Couchbase
Abstract: Couchbase is now a document-oriented database as well as a key-value store. Couchbase Server 2.0 adds new features, including support for JSON documents, indexing and querying, incremental Map Reduce and cross datacenter replication. These new features are in addition to the existing capabilities of easy scalability, high- performance and always-on characteristics. In this whitepaper we share more details about the new features.
Paper | Advanced| English | DOWNLOAD (PDF)| April 2013|

Inside MarkLogic Server
Jason Hunter, Chief Architect, MarkLogic
Abstract: This paper describes MarkLogic Server internals: its data model, indexing system, update model, and operational behaviors. It's intended for a technical audience — either someone new to MarkLogic wanting to understand its capabilities, or someone already familiar with MarkLogic who wants to understand what's going on under the hood.
Paper | Advanced| English | DOWNLOAD (PDF)| April 2013|

NoSQL Failover Characteristics: Aerospike, Cassandra, Couchbase, and MongoDB.
Ben Engber, CEO, Thumbtack Technology
Abstract:
Thumbtack's latest whitepaper focuses on how NoSQL databases perform during hardware failures. This paper follows our previous study of NoSQL performance and explores how different consistency and durability models affect hardware planning and application design.
Paper | Advanced| English |DOWNLOAD (PDF)| MARCH 2013

Building Content-Driven Apps
Couchbase
Abstract: Whether you're building an online publication, a product catalog or a third-party data aggregation app, a NoSQL document database is a great match for your platform. In this white paper you will learn how Couchbase Server document database technology, integrated with full-text search from Elasticsearch, provide a great combination for building rich, content-centric applications.
Paper | Advanced| English | DOWNLOAD (PDF)| March 2013|

Returning Transactions to Distributed Data Stores
David Rosenthal and Stephen Pimentel, FoundationDB
Abstract: The first generation of NoSQL databases achieved horizontal scalability and fault tolerance, while falling short on other engineering goals. In the wake of the first generation, a more accurate understanding of the CAP theorem has emerged, making possible a new generation of NoSQL that restores transactions and strong consistency while consolidating previous advances.
Paper | Intermediate | English| DOWNLOAD (PDF)| March 2013|

The Transaction Manifesto
FoundationDB
Abstract: The power of full ACID transactions and the advantages they can deliver have not been widely understood in the NoSQL community. To develop applications using modern distributed databases, transactions are simply essential.
Paper | Intermediate | English | DOWNLOAD (PDF)| March 2013|

A write-performance improvement of ZABBIX with NoSQL databases and HistoryGluon.
MIRACLE LINUX CORPORATION
February 13, 2013
Abstract This paper presents our research progress for improving write performance of ZABBIX with a NoSQL database for storing histories whose write frequency is increased as the number of monitoring targets. The benchmark results shows that write performance with our proposed method is increased by approximately three times compared to that with the original.
Paper | Advanced| English | DOWNLOAD (PDF)| 2013|

Ultra-High Performance NoSQL Benchmarking: Analyzing Durability and Performance Tradeoffs.
Ben Engber, CEO, Thumbtack Technology, JANUARY 2013
Abstract:
One question that comes up a lot in our discussions with customers is "Tell me which NoSQL database is best." Of course, the answer to this depends on the use cases and the transactional needs of the specific customer. We regularly go through this analysis with customers, but one thing we find as we start is often the basic questions of how much consistency is needed and what are the tradeoffs involved that have not been answered. Ultra-High Performance NoSQL Benchmarking: Analyzing Durability and Performance Tradeoffs is a benchmark report created to help organizations answer exactly those questions pertaining to NoSQL databases. Our goal was to create a benchmark that addressed a specific class of real-world problems with big data, unlike other published reports that are out there. We focused on how the durability and consistency needs affected raw performance.
Paper | Advanced| English | DOWNLOAD (PDF)| 2013|

Optimizing MongoDB with Fractal Tree Indexes.
Tokutek
Abstract: Tokutek benchmarked standard MongoDB indexing against MongoDB with Tokutek`s Fractal Tree Indexes. This paper presents the results of such benchmarking.
Paper | Advanced| English | DOWNLOAD (PDF)| 2012|

VMware-vFabric-GemFire.pdf

Inside MarkLogic Server. Its data model, indexing system, update model, and operational behaviors. Revision 6.
Jason Hunter, MarkLogic Corp.
This paper describes the MarkLogic Server internals: its data model, indexing system, update model, and operational behaviors. It's intended for a technical audience — either someone new to MarkLogic wanting to understand its capabilities, or someone already familiar with MarkLogic who wants to understand what's going on under the hood.
Paper (64 pages) | Introductory | English | DOWNLOAD (PDF)| 2011|

NoSQL Database Technology.
White Paper, Couchbase.
This white paper introduces the basic concepts of NoSQL Database technology and compares them with RDBMS.
Paper | Introductory | English | DOWNLOAD (PDF)| March 2011|

Approaches to Data Modeling in Non-Relational Systems Using Apache Cassandra.
Gary Dusbabek, Rackspace
Presentation slides presented at ICOODB Frankfurt 2010.
Presentation | Intermediate | English | DOWNLOAD (PDF)| September 2010|

Scale Out vs. Scale In- a face-off between Cassandra and Redis.
Tim Lossen, wooga.
Presentation slides presented at the NoSQL Workshop, ICOODB Frankfurt 2010.
Presentation | Intermediate | English | DOWNLOAD (PDF) | September 2010|

Mastering Massive Data Volumes with Hypertable.
Doug Judd, Hypertable Inc..
Presentation slides presented at the NoSQL Workshop, ICOODB Frankfurt 2010.
Presentation | Intermediate | English | DOWNLOAD (PDF)| September 2010|

German Viscuso.
Using Object Database db4o as Storage Provider in Voldemort.
Voldemort’s local persistence component allows for different storage engines to be plugged in. In this article it will be shown how to create a new storage engine that uses db4o as storage engine in Voldemort.
Paper | Intermediate | English | DOWNLOAD (PDF). | September 2010 |

Jeff Dean Google Fellow.
Designs, Lessons and Advice from Building Large Distributed Systems.
This talk, given at the Large and Distributed Systems workshop (LADIS2009), has some information near the end about a new storage system being worked on at Google called Spanner.
Presentation | Intermediate | English | DOWNLOAD (PDF) | 2009| ***

NoSQL Data Stores - Documentations, Tutorials and Lecture Notes

DataStax
Apache Cassandra Documentation (DOWNLOAD .PDF 141 pages)
Apache Cassandra Documentation.
Documentation | Intermediate | English | DOWNLOAD (PDF) | February 16, 2012.

DataStax
DataStax Enterprise Documentation (DOWNLOAD .PDF 39 pages)
DataStax Enterprise Documentation.
Documentation | Intermediate | English | DOWNLOAD (PDF) | February 16, 2012.

Michael Dirolf,10gen
MongoDB Lecture Notes (DOWNLOAD .PDF)
MongoDB: Open source, high performance,document oriented database.
Lecture | Intermediate | English | DOWNLOAD (PDF) | 20 April 2010

Databeans
Fully object oriented persistence for java version 2.0
Tutorial | Basic | English | DOWNLOAD (PDF) | 2009

NoSQL Data Stores - PhD and Master Thesis

Cellular DBMS: Customizable and autonomous data management using a RISC-style architecture
Author:Dr. Syed Saif ur Rahman
Affiliation: Otto-von-Guericke University, Magdeburg, Germany.
Abstract:We present the Cellular DBMS architecture, which is designed according to the RISC-style self-tuning database architecture proposed by Chaudhuri and Weikum in their VLDB 2000 paper. The Cellular DBMS architecture proposes to construct a large DBMS by using multiple RISC-style cells in concert, where each cell is atomic, customized, and autonomous instance of an embedded database.
Type of work: PhD
Area: In-Memory Databases, NoSQL Data Stores
No of Pages: 152
Year of completion: 2011
Name of supervisor/affiliation: : Prof. Dr. Gunter Saake/Otto-von-Guericke University, Magdeburg, Germany
PhD Thesis | Advanced| English | DOWNLOAD (PDF)| September 6, 2011|

Heuristic Optimization of SPARQL queries over Column-Store DBMS
Language: English
Author: Petros Anagnostopoulos - Tsialiamanis, University of Crete, Greece
Affiliation: Data StoresNoSQL
Abstract: In this thesis we describe a new Heuristic SPARQL Planner (HSP) that is capable of exploiting the syntactic and the structural variations of the triple patterns in a SPARQL query in order to choose an execution plan without the need of any cost model. For this, we define the variable graph and we show a reduction of the SPARQL query optimization problem to the maximum weight independent set problem. We implemented our planner on top of the MonetDB open source column-store and evaluated its effectiveness against the state-of-the-art RDF-3X engine as well as comparing the plan quality with a relational (SQL) equivalent of the benchmarks.
Type of work: Master
No of Pages: 92
Year of completion: 2011
Name of supervisor: Vassilis Christophides
Master Thesis | Advanced| English | DOWNLOAD (PDF)| September 2011|

Graphs and Data Stores

Blog Posts | Free Software | Articles, Papers, Presentations| Tutorials, Lecture Notes

Graphs and Data Stores - Blog Posts

Graph Databases:
Blog Posts | English | Posts tagged "Graph Databases"|

Tinker Pop:
Blog Posts | English | Posts tagged "Tinker Pop"|

Graphs and Data Stores - Free Software

HyperGraphDB
HyperGraphDB: A general purpose, extensible, portable, distributed, embeddable, open-source data storage mechanism (available under LGPL license). Download HyperGraphDB.
Software | Intermediate | English | LINK| 2010

InfiniteGraph
InfiniteGraph is a distributed graph database product that enables large-scale graph processing, data analytics and discovery. Download InfiniteGraph.
Software | Intermediate | English | LINK | 2010

InfoGrid
InfoGrid: an open-source internet graph database with REST-ful web frontend. Represents information as nodes and edges which may be dynamically typed according to freely definable conceptual models. Choice of storage backends. Can dynamically include and keep up-to-date externally-managed information "as-if" it was native to InfoGrid. Software | Intermediate | English | LINK| 2010

Neo4j
Neo4j: a high performance open-source embeddable or standalone graph database. Good integration via Java, Grails, PHP, .NET, REST, Rubyetc. High Availability and Online-backup available. Software | Intermediate | English | LINK | 2010

OrientDB
OrientDB: Scalable Document based DBMS that uses the features of the Graph Databases to handle links. 100% Java. It can work in schema-less mode, schema-full or a mix of both. Supports indexing, fluent and SQL-like queries. It handles JSON and XML documents. Software | Intermediate | English | LINK | 2010

TinkerPop: an open-source graph software group, provide a stack of technologies (called the TinkerPop stack). The stack starts just above the database layer (just above the graph persistence layer) and connects to various graph database vendors. TinkerPop facilitates the application of graphs to various problems in engineering.
TinkerPop Project.
TinkerPop: Blueprints.
TinkerPop:Frames.
TinkerPop: Pipes.
TinkerPop: Gremlin.
TinkerPop:Rexster.

Graphs and Data Stores - Articles, Papers, Presentations

“A Path Algebra for Multi-Relational Graphs.”
Rodriguez, M.A., Neubauer, P.
2nd International Workshop on Graph Data Management (GDM’11), International Conference on Data Engineering Proceedings, pages 128-131, doi:10.1109/ICDEW.2011.5767613, IEEE, Hannover, Germany, April 2011.
Paper | Advanced | English | LINK (arXiv preprint) | 2011|

Neo4j for deep spatial and social intelligence.
Peter Neubauer, Neo Technology.
Presentation slides presented at the NoSQL Workshop, ICOODB Frankfurt 2010.
Presentation | Intermediate | English | DOWNLOAD (PDF)| September 2010|

Brian Clark.
Cloud Computing and Advanced Relationship Analytics.
Graph technology offers a superior solution for relationship analytics requirements, enabling organizations to traverse any number and complexity of relationships in virtually any amount of distributed data, from any number of sources and types, in near real time, and on the same commodity hardware obtained through cloud computing platform providers.
Article | Basic | English | DOWNLOAD (PDF). | April 2010 |

Marko A. Rodriguez and Peter Neubauer.
The Graph Traversal Pattern.
In applied computing, since the late 1960s, the interlinked table structure of the relational database has been the predominant information storage and retrieval model. With the growth of graph/network-based data and the need to efficiently process such data, new data management systems have been developed. In contrast to the index-intensive, set-theoretic operations of relational databases, graph databases make use of index-free, local traversals. This article discusses the graph traversal pattern and its use in computing.
Article | Advanced | English | DOWNLOAD (PDF) | April 2010 |

“Constructions from Dots and Lines.”
Rodriguez, M.A., Neubauer, P.,
Bulletin of the American Society for Information Science and Technology, American Society for Information Science and Technology, volume 36, number 6, pages 35-41, doi:10.1002/bult.2010.1720360610, ISSN:1550-8366, August 2010.
Paper | Introductory | English | LINK (arXiv preprint) | 2010|

“The Graph Traversal Pattern,”
Rodriguez, M.A., Neubauer, P.,
Graph Data Management: Techniques and Applications. Eds. S. Sakr, E. Pardede, IGI Global, December 2010.
Paper | Intermediate | English | LINK (arXiv preprint) | 2010|

“Exposing Multi-Relational Networks to Single-Relational Network Analysis Algorithms.”
Rodriguez M.A., Shinavier, J.
Journal of Informetrics, volume 4, number 1, pages 29-41, ISSN:1751-1577, Elsevier, doi:10.1016/j.joi.2009.06.004, LA-UR-08-03931, December 2009.
Paper | Advanced | English | LINK (arXiv preprint) | 2009|

“Grammar-Based Random Walkers in Semantic Networks.”
Rodriguez, M.A. .
Knowledge-Based Systems, volume 21, number 7, pages 727-739, ISSN:0950-7051, Elsevier, doi:10.1016/j.knosys.2008.03.030, LA-UR-06-7791, October 2008.
Paper | Advanced | English | LINK (arXiv preprint) | 2008|

Graphs and Data Stores - Tutorials and Lecture Notes

“Memoirs of a Graph Addict: Despair to Redemption.”
Rodriguez, M.A.
Invited Lectures, Winterland Whirlwind Tour, Chicago-USA to Malmo-Sweden, January 2011.
Lecture Notes | Intermediate | English | LINK (slideshare) | 2011|

“Problem-Solving using Graph Traversals: Searching, Scoring, Ranking, and Recommendation”
Rodriguez, M.A.
Technical Talk Seminar, AT&T Interactive, Glendale, California, July 2010.
Lecture Notes | Intermediate | English | LINK (slideshare)| 2010|

“The Path-o-Logical Gremlin.”
Rodriguez, M.A.
2nd International Workshop on Graph Data Management: Techniques and Applications (GDM’11), Hannover, Germany, April 2011.
LINK (slideshare)| 2010|

Object-Oriented Programming

Blog Posts | Free software | Lecture notes | Tutorials | Articles and papers

OO Programming - Blog Posts

Java:
Blog Posts | English | Posts tagged "Java" |

Java Object Persistence:
Blog Posts | English | Posts tagged "Java Object Persistence" |

LINQ:
Blog Posts | English | Posts tagged "LINQ" |

OO Programming - Free Software

OO Programming - Lecture Notes

Serge Shumilov, University of Bonn
Persistenz von Objekten
Very comprehensive (197 pages) lecture notes on Object Persistence strategies incl. ODBMS, RDBMS, JDBC, SQLj, OR-Mappers incl. Hibernate, JDO, EJB
Lecture | Basic | German | DOWNLOAD (PDF) | September 2004 | ***

OO Programming - Tutorials

Sun, The Java Tutorial
Object-Oriented Programming Concepts
A great tutorial to get acquainted with OOP.
Tutorial | Basic | English | LINK | ****

Giuseppe Castagna, Ecole Normale Superieure
Foundation of Object-Oriented Programming - A Full Day Tutorial
Provides the theoretical background needed to study foundation of object-oriented programming and gives a unified presentation of several theoretical models of object-oriented languages.
Tutorial | Basic | English | LINK | ***

OO Programming - Articles and Papers

SyQL: Querying Software Process Data Through an Object-Oriented Metamodel .
Mirco Bianco, Faculty of Computer Science, Free University of Bolzano-Bozen, Italy
Abstract. The effective usage of the automatically collected software process data may be challenging. By using general purpose query languages like SQL, retrieval of software process information introduces a cost and competence barrier, which limits the adoption of Automated In-process Software Engineering Measurement and Analysis (AISEMA) systems, since it requires a considerable effort for query writing as well as a deep understanding of process data collection and representation. In this paper, we describe the implementation of a query language, SyQL, mainly but not exclusively designed for software process data. SyQL significantly reduces the competence barrier by providing a query interface aimed to software process data.
Paper | Intermediate | English | DOWNLOAD (PDF)| October, 2011|

Ajay Deshpande, Pratik Soares Sameer Thakur.
Persistence Model Patterns A Practitioner’s View
This article discusses a solution for building complex systems using an Object Relational Model.
Paper | Basic | English |DOWNLOAD (PDF) | 2009 |

Epaminondas Kapetanios, Sue Black, University of Westminster
041.01 On the Notion of Semantic Metric Spaces for Object and Aspect Oriented Software Design
This paper discusses a theoretical framework for software design metrics, which conceives parameters as dimensions of a metric space.
Article | Intermediate | English | DOWNLOAD (PDF) | March 2008 | ***

Stephanie Balzer, Swiss Federal Institute of Technology Zurich (ETHZ)
Contracted Persistent Object Programming
This paper introduces a new approach to persistent programming, that is based on orthogonal persistence, but constrained to the object-oriented case.
Paper | Intermediate | English | LINK (PDF) | November 2005 | ***

Entity Framework (EF) Resources.

Software and Tools | Articles and Presentations

Entity Framework - Software and Tools

Entity Framework 6, and future versions, are being developed in an open source code base on CodePlex| 2013|
See the open source announcement from the Entity Framework team for more details.

EntityFramework 5.0.0-beta2.
Download EntityFramework 5.0.0-beta2. This is a prerelease version of EntityFramework.
LINK| April 2012|

Entity Framework Power Tools Beta 2.
Download Entity Framework Power Tools Beta 2- Preview of useful design-time features for DbContext.
LINK| April 2012|

Entity Framework - Articles and Presentations

Entity Framework.
Entity Framework is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write..
Paper | Intermediate | English | LINK| April 2012|

Performance Considerations for Entity Framework 5.
David Obando, Eric Dettinger et al,
Abstract: Object-Relational Mapping frameworks are a convenient way to provide an abstraction for data access in an object-oriented application. For .NET applications, Microsoft's recommended O/RM is the Entity Framework. With any abstraction though, performance can become a concern. This whitepaper was written to show the performance considerations when developing applications using the Entity Framework, to give developers an idea of the Entity Framework internal algorithms that can affect performance, and to provide tips for investigation and improving performance in their applications that use the Entity Framework. There are a number of good topics on performance already available on the web, and we've also tried pointing to these resources where possible. Performance is a tricky topic. This whitepaper is intended as a resource to help you make performance related decisions for your applications that use the Entity Framework. We have included some test metrics to demonstrate performance, but these metrics aren't intended as absolute indicators of the performance you will see in your application. For practical purposes, this document assumes Entity Framework 4 is run under .NET 4.0 and Entity Framework 5 is run under .NET 4.5. Many of the performance improvements made for Entity Framework 5 reside within the core components that ship with .NET 4.5.
White Paper | Intermediate | English | LINK| April 2012|

Building an MVC 3 App with Code First and Entity Framework 4.1.
Julie Lerman , March 2011.
Microsoft’s ADO.NET Entity Framework (EF) simplifies data access by allowing you to avoid working directly with the database in your code. Instead you can retrieve data by writing queries against strongly typed classes letting the Entity Framework handle the database interaction on your behalf. EF can also persist changes back to the database for you. In addition to this benefit, you will also benefit from the EF’s comprehension of relationships. This means you will not be required to write extra code to specify joins between entities whenexpressing queries or simply working with your objects in memory. EF provides you with three ways to describe the model of your entities. You can begin with a legacy database to create a model. You can design a model in a designer. Or you can simply define classes and let EF work with those. This last tactic is referred to as code first, because the first thing you do is write code to describe your entities. In this whitepaper, I will walk you through creating a simple MVC 3 application using Entity Framework’s code first technology to describe your classes and manage all of your data access.
Paper | Intermediate | English | DOWNLOAD (PDF)| March 2011|

Miguel Garcia, Rakesh Prithiviraj, TU Hamburg
047.01 Rethinking the Architecture of OR Mapping for EMF in terms of LINQ
This paper focusses on demands placed on Object-Relational Mapping (ORM) in order to support comprehensive queries, as known from LINQ and Scala.
Paper | Intermediate | English | DOWNLOAD (PDF) | October 2008 | ***

Erik Meijer, José Blakeley
The Microsoft perspective on ORM
Interview in ACM Queue Magazine with Erik Meijer and José Blakeley. With LINQ (language-integrated query) and the Entity Framework, Microsoft divided its traditional ORM technology into two parts: one part that handles querying (LINQ) and one part that handles mapping (Entity Framework).
Article | Basic | English | LINK | September 2008 | ****

Next-Generation Data Access: Making the Conceptual Level Real .
Jose_ Blakeley, David Campbell, Jim Gray, S. Muralidhar, Anil Nori June 2006.
Eliminate the impedance mismatch for both applications and data services like reporting, analysis, and replication offered as part of the SQL Server product by raising the level of abstraction from the logical (relational) level to the conceptual (entity) level. (31 printed pages).
Paper | Intermediate | English | DOWNLOAD (PDF)| 2006|

ORM Technology

Blog Posts | Articles and Presentations |

ORM Technology - Blog Posts

ORM:
Blog Posts | English | Posts tagged "ORM" |

ORM Technology - Articles and Presentations

Mikael Kopteff, Haaga-Helia-University
The Usage and Performance of Object Databases Compared with ORM Tools in a Java Environment
The paper, a submission to ICOODB 2008, presents an empirical comparison of various ORM tools and object databases for Java
Paper | Intermediate | English | DOWNLOAD (PDF) | March 2008 | ***

George Feuerlicht, et. al.
Object-Relational Database Design: Can Your Application Benefit from SQL:2003?
Proceedings of the 16th International Conference on Information Systems Development (ISD2007) Galway, Ireland, August 29-31, 2007.
Paper | Intermediate | English | LINK | 2007 | ***

Ted Neward, Oren "Ayende" Eini
ORM Smackdown - Transcript
Transcripts of the Panel discussion "ORM Smackdown" on different viewpoints on Object-Relational Mapping (ORM) systems, courtesy of FranklinsNet.
Article | Basic | English | DOWNLOAD (PDF) | May 2007 | ***

Object-Relational Impedance Mismatch

Blog Posts | Articles and Presentations |

Object-Relational Impedance - Blog Posts

Java Object Persistence:
Blog Posts | English | Posts tagged "Java Object Persistence" |

Impedance Mismatch:
Blog Posts | English | Posts tagged "Impedance Mismatch" |

Object Persistence:
Blog Posts | English | Posts tagged "Object Persistence" |

Object-Relational Impedance - Articles and Presentations

Impedance Mismatch is not an “Objects vs. Relations” Problem.(DRAFT)
EvgeniyGrigoriev, Grigoriev.E@gmail.com
The problem of impedance mismatch between applications written in OO languages and relational DB is not a problem of discrepancy between object-oriented and relational approaches themselves. Its real causes can be found in usual implementation of the ОО approach. Direct comparison of the two approaches cannot be used as a base for the conclusion that they are discrepant or mismatched. Experimental proof of the absence of contradiction between the object-oriented paradigm and the relational data model is also presented in the paper. Paper | Intermediate | English | DOWNLOAD(PDF)| August 2012|

Ted Neward
The Vietnam of Computer Science
Article discussing the problems of the O/R mismatch in the light of the Vietnam war analogy.
Article | Basic | English | PDF | 2006 | ****

Dan Shusman, Intersystems
Oscillating Between Objects and Relational: The Impedance Mismatch
Paper describes the use of the post-relational database Caché to overcome the object-relational impedance mismatch.
Paper | Basic | English | DOWNLOAD (PDF) | 2002 | ***

Relational Databases, NewSQL, XML Databases, RDF Data Stores

Databases - Blog Posts

Database Design Patterns:
Blog Posts | English | Posts tagged "Database Design Patterns" |

MariaDB:
Blog Posts | English | Posts tagged "MariaDB" |

MySQL:
Blog Posts | English | Posts tagged "MySQL" |

NuoDB:
Blog Posts | English | Posts tagged "NuoDB" |

PostgreSQL:
Blog Posts | English | Posts tagged "PostgreSQL" |

vFabric SQLFire:
Blog Posts | English | Posts tagged "vFabric SQLFire" |

VoltDB:
Blog Posts | English | Posts tagged "VoltDB" |

Databases - Free Software

NuoDB 1.0 Launch (January 15, 2013),Watch Video.
NuoDB is a NewSQL Cloud Database (launched January 15, 2013. SQL compliant, ACID trnsactions, scale out/in elastically on decentralized resources in the Cloud.
Link to the NuoDB 1.0 Download Request form
LINK Download form

VoltDB 3.0 release (released date, January 22, 2013)
VoltDB is an in-memory relational database designed specifically to solve the big data velocity problem LINK VoltDB 3.0 is currently available download.

Open Source Database Benchmark Project (OSDB).
The OSDB project`s aim is to define an object-oriented, database-independent, and system-independent benchmark to enable individuals to analyze the performance of a variety of database and system configurations. The MySQL DBMS plugin is available.
LINK (Sourceforge)

XML Database Benchmark: "Transaction Processing over XML (TPoX)": TPoX is an application-level XML database benchmark based on a financial application scenario. It is used to evaluate the performance of XML database systems, focusing on XQuery, SQL/XML, XML Storage, XML Indexing, XML Schema support, XML updates, logging, concurrency and other database aspects.
Download TPoX (LINK), July 2009. |
TPoX Results (LINK), April 2011.

Free version of DB2:
DB2 Express-C: Get Started LINK(IBM)
Download DB2 Express-C LINK(IBM)

Raima Inc.(embedded database):
Download RDM Embedded (Registration required)
Download RDM Server (Registration required)

Databases - Articles and Presentations

VoltDB Technical Overfview
VoltDB,
Abstract
Designed by DBMS pioneer Mike Stonebraker for organizations that have reached the price/performance limitations of general purpose SQL databases, VoltDB is a NewSQL database that combines the proven power of relational processing with blazing speed, linear scalability and uncompromising fault tolerance. VoltDB is the ideal solution for high velocity database applications that require 100% accuracy and real-time analytics.
White paper | Intermediate | English | DOWNLOAD (PDF)| 2012|

Data Modeling and Functional Modeling – Which Comes First?
Peretz Shoval, Dept. of Information Systems Engineering, Ben-Gurion University, Beer-Sheva, Israel
Abstract
In the analysis phase of the information system development (ISD), the users' requirements are studied and defined. In most ISD methodologies, the requirements are defined by two models: a conceptual data model in form of e.g. an entity-relationship (ER) diagram or a class diagram; and a functional model in form of e.g. data flow diagrams (DFD) or use cases. Different ISD methodologies prescribe different orders of carrying out these modeling activities but there is no commonly agreed order for performing them.
In order to find out whether the order of analysis activities makes any difference, and which order leads to better results, we have conducted two independent comparative experiments in laboratory settings. The subjects in the two experiments were asked to create data models and functional models of a certain system while working in the two opposite orders. In each experiment we used a different ISD methodology and different subjects, but assigned the same modeling tasks. The main results of the experiments are that the data models are of better quality when created as the first modeling task, and that analysts prefer to first create the data model and then the functional model. The results of the two experiments have been reported in Shoval & Kabeli (2005) and in Shoval et al. (2009). This paper provides an overview of the two studies.
Paper | Intermediate | English | DOWNLOAD (PDF)| February 2012|

Benchmarking XML Databases: New TPoX Benchmark Results Available.  
Abstract: TPoX stands for “Transaction Processing over XML” and is an XML database benchmark that  Intel and IBM developed several years ago and then released as open source. A couple of months ago,  the project published some new results. To learn more about this I interviewed the main leaders of the TPoX project,  Dr. Matthias Nicola, Senior engineer for DB2 at IBM and Dr. Agustin Gonzalez, Senior Staff Software Engineer at Intel® Corporation.  RVZ
Interview | Intermediate | English | DOWNLOAD (PDF)| 2011|

RDM Embedded 10.1 Architecture and Features.
Wayne Warren, Chief Technology Officer, Raima Inc.
RDM Embedded is a cross-platform, small footprint database designed for applications with demanding performance and scalability requirements. RDM Embedded 10.1 (RDMe) can be used for meaningful solutions in multiple industries, including Industrial Automation, Aerospace and Defense, Telecommunications, and Medical. This paper is for those who want more than “what” RDMe can do, but also “how” it does it.
Technical Whitepaper | Intermediate | English | DOWNLOAD (PDF)| September, 2011|

The Short Guide to MySQL HA Options.
Schooner Information Technology. >
An analysis of today’s MySQL high-availability challenges and what asynchronous, semi-synchronous and fully synchronous replication offer toward reducing downtime, achieving full data consistency, automating failover, and simplifying administration.
White Paper | Introductory | English | DOWNLOAD (PDF)| 2011|

Agile and Industrialized IT Management.
Dr. Reinhold Thurner, Metasafe GmbH and Dr. Wolfgang Martin, Wolfgang Martin Team.
Agile and industrialized IT Management creates sustainable value to the business. It is a best practice and gives the ultimate answer to the classical question: Does IT matter?
Paper | Introductory | English | DOWNLOAD (PDF)| March 2011|

Improving Data Quality Through Data Modeling.
William McKnight.
The paper explains the causes of poor data quality and how it can be improved using data modeling.
Paper | Intermediate | English | DOWNLOAD (PDF)| 2010|

Michael (Monty) Widenious, MariaDB
State of MariaDB, Dynamic Column in MariaDB
Describes MariaDB 5.1 a branch of MySQL 5.1. It also introduces the new features in versions 5.2(beta) and 5.3 (alpha). Copy of the presentation given at ICOODB Frankfurt 2010.
Presentation | Intermediate | English | DOWNLOAD (.PDF) | September 2010| ***

"A Matter of Time: Temporal Data Management in DB2 for z/OS".
Cindy Saracco, Matthias Nicola, Lenisha Gandhi, IBM Silicon Valley Lab.
Paper | Advanced | English | LINK (.PDF)

Ouri Wolfson, Hu Cao, Goce Trajcevski, University of Illinois at Chicago
Spatio-temporal Data Reduction with Deterministic Error Bounds
Proc. of the ACM DIALM-POMC Joint Workshop on Foundations of Mobile Computing, San Diego CA
Paper | Advanced | English | DOWNLOAD (PDF) | 2003 | ***

Databases - Lecture Notes

Web Data Management
by Serge Abiteboul, Ioana Manolescu, Philippe Rigaux, Marie-Christine Rousset, Pierre Senellart;
Published by Cambridge University Press 2011. For personal use only, not for distribution.
The present site aims to provide a consistent material to describe the structure of information found on the Web, and to explain how this information can be efficiently represented, described and accessed. The primary audience are students interested in data management issues, and teachers who want to set-up a course on Web Data Modeling and large-scale data management in distributed and heterogeneous environments.
You will find class material including slides, exercices, and documentation on the sofwares that can support practical learning sessions and projects. We also supply many examples of data, code and programs. Lecture Notes | Intermediate| English | LINK | 2011 | ***

Databases - Tutorials

Tutorial: Learn JDBC in 10 minutes.
Raima
Creating a good JDBC application can be a very tough job. If you are new to JDBC, or even Java itself, this is a good place to start. Below is a guide to create your very first JDBC application using the famous Hello World! JDBC Tutorial.
Turorial| Intermediate | English | LINK Web | 2012 |

Databases - Journals

The VLDB Journal
The International Journal on Very Large Data Bases
Springer Berlin Heidelberg
This journal is all about the advancement of information system architectures and the development of novel database applications. Impact Factor: 6.8 (2008)
Download free sample copy (LINK).
Journal | Advanced | English | LINK (for more information and to subscribe to ToC alert)| 2010 |

Distributed and Parallel Databases, An International Journal.
Springer US.
Distributed and Parallel Databases provides a focus for the presentation and dissemination of new research results, systems development efforts, and user experiences in distributed and parallel database systems.
Download free sample copy (LINK).
Journal | Advanced | English | LINK (for more information and to subscribe to ToC alert)| 2010 |

New Generation Computing.
Ohmsha Ltd.
Supporting the development of new computational paradigms stemming from the cross-fertilization of various research fields, such as programming (logic, constraint, functional, object-oriented), distributed/parallel computing, knowledge-based systems and agent-oriented systems. The journal presents theoretical and practical papers. Download free sample copy (LINK).
Journal | Advanced | English | LINK (for more information and to subscribe to ToC alert) | 2010 |

Journal of Intelligent Information Systems
Integrating Artificial Intelligence and Database Technologies
Springer US
A forum wherein academics, researchers and practitioners may publish high-quality, original and state-of-the-art papers describing theoretical aspects, systems architectures, analysis and design tools and techniques, and implementation experiences in intelligent information systems.
Download free sample copy (LINK).
Journal | Advanced | English | LINK (for more information and to subscribe to ToC alert) | 2010 |

World Wide Web
Internet and Web Information Systems
Springer US
An international forum for researchers, professionals, and industrial practitioners to share their rapidly developing knowledge and report on new advances in Internet and web-based systems. The journal also focuses on all database- and information-system topics that relate to the Internet and the Web, particularly on ways to model, design, develop, integrate, and manage these systems.
Download free sample copy (LINK).
Impact factor: 1.763 (in 2009)
Journal | Advanced | English | LINK (for more information and to subscribe to ToC alert) | 2010 |

Link Partners

ODBMS.ORG in Japanese

SPONSORED BY

SEARCH

NEWS

EVENTS