Database which allows object to be "child" of any other object
From: <kuronekoyama_at_gmail.com>
Date: Thu, 9 Apr 2009 10:37:37 -0700 (PDT)
Message-ID: <b5402cb8-23fa-4360-b2ea-227aacafc78a_at_f19g2000yqh.googlegroups.com>
I'm working on a database-driven project and I'm trying to do some re- architecting of the system.
Date: Thu, 9 Apr 2009 10:37:37 -0700 (PDT)
Message-ID: <b5402cb8-23fa-4360-b2ea-227aacafc78a_at_f19g2000yqh.googlegroups.com>
I'm working on a database-driven project and I'm trying to do some re- architecting of the system.
I would like to cut down on the number of strictly-defined complex object types, instead forming them from a composition of attached atomic metadata objects. A user could have an attached phone number, an attached address, an attached photo; but furthermore, an address could have an attached photo or phone number.
My questions are:
- Is this a viable approach? Has it been done before, is there a
common name for it?
- Is the "generalized association table" idea compatible with automatic referential integrity checking? If so, how?
- Are there any systems out there implemented in this way that I could examine for research, open-source or not?