Home » Developer & Programmer » Designer » inheritance in table design
inheritance in table design [message #129819] Tue, 26 July 2005 17:39
Messages: 29
Registered: June 2005
Junior Member
what is the best way to design tables which data has inheritance relationship? It seems to me there are two options out there:
1. put all the attributes in one table, but as the children grows and new attributes add up, the table columns will grow indefinitely, this makes the dml very clumsy.
2. use one base table for the parent class and a separate table for each child class, but this way you most likely will have to make a join to get information, this will slow down the query

i will have very big tables and the query performance is the primary concern, what is your suggestion? or do you have better solution? thanks
Previous Topic: Database Sizing Template
Next Topic: Error using Designer6i
Goto Forum:

Current Time: Wed Sep 30 15:02:17 CDT 2020