OT: DB design

From: Elia Morling (elia.list..amiljen.se)
Date: Wed Jan 19 2005 - 03:21:11 EST

Next message: Jürgen Saar: "Re: Cayenne and JasperReport"

Previous message: Gary Affonso: "Pluralization of Object Names"
In reply to: Gary Affonso: "Pluralization of Object Names"
Next in thread: Jürgen Saar: "Re: Pluralization of Object Names"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

What is your preferred implementation regarding OO approach to databses?
I have inherited objects 10-20 that differ in 1-3 fields. As I see it there at least two approaches.
Make a common table for the superclass and have a column called "attributes" that stores any uncommon fields as a string.
I.e. "Height, 23, Width 11"
Or make a unique table for each subclass.
On the other hand does Cayenne support some type of inheritance?

Thx
Elia

Next message: Jürgen Saar: "Re: Cayenne and JasperReport"
Previous message: Gary Affonso: "Pluralization of Object Names"
In reply to: Gary Affonso: "Pluralization of Object Names"
Next in thread: Jürgen Saar: "Re: Pluralization of Object Names"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Wed Jan 19 2005 - 03:21:16 EST