Bug 8304 - Schema Denormalization
: Schema Denormalization
Status: NEW
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 7.4.0
: PC Other
: P3 normal (vote)
: New Schema
Assigned To: Brandon Black
: new_schema
Depends on: 8303
Blocks:
  Show dependency treegraph
 
Reported: 2008-06-02 11:08 UTC by Brandon Black
Modified: 2009-07-30 14:02 UTC (History)
1 user (show)

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Brandon Black 2008-06-02 11:08:44 UTC
When considering the schema rework, we should consider the denormalization idea.  Basically denormalization is a bad idea so long as we have persistent, important user data in the database.  But it seems like most of our DB functionality isn't in this category to begin with.  If we can move the important user data out of the DB, it becomes an cache/index of the library, which certainly could be denormalized for speed and erased/rebuilt at will without affecting the user in the long run.
Comment 1 Chris Owens 2008-06-19 09:55:01 UTC
Would you like me to publicize this bug to get more attention to it, Brandon?  Or is it just a note to yourself?