R – Large/complex dataset for ORM validation

data modelingdatabaseorm

I'm looking for freely available sample data to do some ORM validation and performance testing on. My main requirements are:

Discriminated types: it needs to include some kind of inheritance eg Party -> Person and Organisation;
Reasonably complex data model;
Some reasonably large tables (in the hundreds of thousands of rows at least);
Multi-platform: at a minimum Oracle, MySQL and SQL Server;
Readily understandable. For example a CRM application is what I call readily understandable. People understand clients, customers and so forth.

Can anyone point me to anything like that?

Best Answer

The SQL Server AdventureWorks database fits most of your criteria. It has around 69 tables and a fair amount of data. It comes scripted, so with a bit of editing it could be made to work with Oracle and MySQL. There are business scenarios and use cases.

Not sure it has discriminated types though.

Related Solutions

The “N+1 selects problem” in ORM (Object-Relational Mapping)

Let's say you have a collection of Car objects (database rows), and each Car has a collection of Wheel objects (also rows). In other words, Car → Wheel is a 1-to-many relationship.

Now, let's say you need to iterate through all the cars, and for each one, print out a list of the wheels. The naive O/R implementation would do the following:

SELECT * FROM Cars;

And then for each Car:

SELECT * FROM Wheel WHERE CarId = ?

In other words, you have one select for the Cars, and then N additional selects, where N is the total number of cars.

Alternatively, one could get all wheels and perform the lookups in memory:

SELECT * FROM Wheel

This reduces the number of round-trips to the database from N+1 to 2. Most ORM tools give you several ways to prevent N+1 selects.

Reference: Java Persistence with Hibernate, chapter 13.

Php – Good PHP ORM Library

Look into Doctrine.

Doctrine 1.2 implements Active Record. Doctrine 2+ is a DataMapper ORM.

Also, check out Xyster. It's based on the Data Mapper pattern.

Also, take a look at DataMapper vs. Active Record.

Best Answer

Related Solutions

The “N+1 selects problem” in ORM (Object-Relational Mapping)

Php – Good PHP ORM Library

Related Topic