100% agree, but "this is pick" doesn't mean disregard all rules of good DB design.
Fair enough, MVDBs are designed around not subscribing to the "1st norm form rule"; we should still present out data in the most structured manner possible, for this will give us the greatest flexibility if/when the system needs to be expanded. As I said though, it all comes down to how you need to work with your data. My form is not the most efficient for random access of individual items, but it does give you the flexibility of being able to sort and select on tag/value pairs. Additional benefits are that I could also index on tag names if required, which neither of the your original proposals can. I reiterate though, design all comes down to the intended purpose. Similar situations happen in SQL where you need determine if/where/how much you should denormalize your data. Work out the most important requirements/future requirements for your system and develop accordingly. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, 10 December 2010 2:00 PM To: [email protected] Subject: Re: [U2] Sparse array population in Pick But Dan you're just flattening the array. Boooo This is Pick! The point of a method of populating a sparse array is to address the efficient storage of data when your array is sparse. In your method, you'd have to do several disk reads in order to collect all the tags for one item in one spot. The method I displayed, is a single disk read :) _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ########################################################################################### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ########################################################################################### _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
