Hi all I have been searching for a method (and here is where I am stumped at the terminology to search for!) to dynamically add properties to some record.
Let me explain: In a CRM system, where you have a number of contacts (people) you would need the user to create new attributes for them (such as daughter's name or some such). You dont want to create a table that already has that column, but you want to design a database model that can support dynamically (i.e. the user doing it not a developer) adding columns. I would prefer if the underlying database structure didnt change (as FarCry does when you add new attributes) There is also another issue that this would be a HUGE list of people (lets say 1million records) and we would be doing dynamic quieries such as SELECT * from bla where daugher = "susan" and birthday IN "july" and hasboughtGift = "false" (not real SQL) Any pointers? This must be a problem that has been addressed a number of times (I saw this in a shopping application called Intershop a while ago, the problem was doing efficient searches on these fields especially if you are looking for nulls) and also in spectra (that sidestepped the issue and stored it all as WDDX which made it suck at quieries) Any help or pointers apreciated! -- Mark Drew http://www.markdrew.co.uk/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231074 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
