Denormalization problem
From: Karel Miklav <karel_at_inetis.spppambait.com>
Date: Thu, 29 May 2003 15:50:30 +0200
Message-ID: <FeoBa.463$78.9565_at_news.siol.net>
I have a multilingual database with this design pattern:
Date: Thu, 29 May 2003 15:50:30 +0200
Message-ID: <FeoBa.463$78.9565_at_news.siol.net>
I have a multilingual database with this design pattern:
car ( PK(id), wheels, engine_id )
engine ( PK(id) , last_property)
engine_description ( PK(engine_id, language_id), description )
Objects have parts and parts have descriptions in different languages. Parts are generated in run time and descriptions in all languages are never known. When 'engine' loses it's 'last_property' I'm tempted to delete it, but thus I also lose referential integrity. What am I
supposed to do; denormalize and throw away the integrity, tolerate that id-only tables or something completely different?
Regards,
Karel Miklav
Received on Thu May 29 2003 - 15:50:30 CEST