http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Next series of posts would be "Giving Love to Raven - Raven Profiler" http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment13http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment13Wed, 19 May 2010 02:21:10 GMTSo, cart lines should have album titles for the same reason. Shouldn't it? http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment12http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment12Tue, 18 May 2010 15:46:31 GMTPetr, You are correct, and in the real implementation, they are there. http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment11http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment11Tue, 18 May 2010 14:21:35 GMTWhy Order lines don't contain Album titles? When I want display order I need "joining" with albums and when any album is modified/deleted I don't have it's (original) name. http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment10http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment10Tue, 18 May 2010 14:17:02 GMTCorey, No, I am using this; [http://jsonviewer.stack.hu/](http://jsonviewer.stack.hu/)http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment9http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment9Tue, 18 May 2010 13:47:07 GMTWhere's the fancy images of the model come from? Is that taken from the Raven UI? http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment8http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment8Tue, 18 May 2010 13:43:35 GMTAh you have changed the release dates of this series future posts ... I was looking forward to read some good information this whole day. Ah well, back to work it is ... http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment7http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment7Tue, 18 May 2010 09:32:31 GMTAles, That topic is covered in one of the future posts http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment6http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment6Tue, 18 May 2010 08:20:47 GMTAnd what about adding new Album from same artist? You will lookup all albums to create dropdown to select an Artist on new Album, or user will type in Artist again even he exists in DB so then in short time we can have artists like (Ozzy Osbourne, Ozzzy Osbourne, Ozy Osbourne) , or application does not enable adding new albums/artists into DB? Anyway thank you for post. I found RavenDB and other NoSQL DB interesting because of your work. A. http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment5http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment5Tue, 18 May 2010 08:15:47 GMTVery interesting. Another thing to think about is whether you want to de-normalize prices in the shopping cart. I think it might be a good business decision to allow the user to buy with "old" prices rather than silently swapping the prices upon checkout or showing an "error" while he was shopping. http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment4http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment4Tue, 18 May 2010 07:39:41 GMTNC, Precisely, this is also why I keep both the artist name and the artist id around. http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment3http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment3Tue, 18 May 2010 07:22:06 GMTI just wanted to say thanks for writing down your thoughts and modus operandi for how you would re-do this with Raven. For someone else like me used to thinking in SQL-terms it's very educating. Thanks. :) http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment2http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment2Tue, 18 May 2010 07:18:56 GMT"For the simple reason that the application does something with Genres (if only just displaying their description) where the only thing that is done with Artists is displaying their name in the context of an album." What happens if the store was to be extended to include Artist information at a later date. Photo, bio, etc. Would you create an Artist document that does not belong to the Album, and link from the album to the artist if a artist document happen to exist? http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment1http://ayende.com/4506/porting-mvc-music-store-to-raven-the-data-model#comment1Tue, 18 May 2010 07:08:07 GMT