http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660John, You already have the list of tags, just count them.http://ayende.com/156770/ravendb-and-complex-tagging#comment13http://ayende.com/156770/ravendb-and-complex-tagging#comment13Sat, 07 Jul 2012 23:17:37 GMTIs it also possible to return the count of matching tags from the index?http://ayende.com/156770/ravendb-and-complex-tagging#comment12http://ayende.com/156770/ravendb-and-complex-tagging#comment12Sat, 07 Jul 2012 21:45:23 GMTI would denormalize the label here as well. A tags label is something that almost never changes and when it does, it is ok to have a batch operation that goes through all the albums and updates the label accordingly.http://ayende.com/156770/ravendb-and-complex-tagging#comment11http://ayende.com/156770/ravendb-and-complex-tagging#comment11Sat, 07 Jul 2012 17:32:38 GMTChanan, For example, it might have fields like: "Name", "Description", "IsAdult", etc. Users might want to follow a tag, and you want to track how many are doing so. It is an actual entity in the systemhttp://ayende.com/156770/ravendb-and-complex-tagging#comment10http://ayende.com/156770/ravendb-and-complex-tagging#comment10Thu, 05 Jul 2012 13:50:16 GMTIn this scheme, what is in the Tag document? Does it have a "purpose" here? Why not just store the tag name in the album instead of the id and remove the need for the tag document? I am guessing it has something to do with the first requirement, but I am not getting it.http://ayende.com/156770/ravendb-and-complex-tagging#comment9http://ayende.com/156770/ravendb-and-complex-tagging#comment9Thu, 05 Jul 2012 13:28:15 GMTThat's nice - I thought the include function works only for single doc references.http://ayende.com/156770/ravendb-and-complex-tagging#comment8http://ayende.com/156770/ravendb-and-complex-tagging#comment8Thu, 05 Jul 2012 09:51:12 GMTRafal, I won't have to do ANY join/distinct operation. Those are relational concepts. I can _include_ the related docs, and that is a cheap operationhttp://ayende.com/156770/ravendb-and-complex-tagging#comment7http://ayende.com/156770/ravendb-and-complex-tagging#comment7Thu, 05 Jul 2012 08:29:07 GMTBut with such design you have to perform a join/distinct operation to display tags for an album. Imho it would be better to modify the structure of the document like: Tags: [ { Id: 'tags/1', Name: 'Tag 1', Tagged: [{By: 'user/1', When: '2010-01-01'}, ...]}, (... and so on) ] http://ayende.com/156770/ravendb-and-complex-tagging#comment6http://ayende.com/156770/ravendb-and-complex-tagging#comment6Thu, 05 Jul 2012 08:04:13 GMTalexidsa, That is a reference to another document, not an internal id.http://ayende.com/156770/ravendb-and-complex-tagging#comment5http://ayende.com/156770/ravendb-and-complex-tagging#comment5Wed, 04 Jul 2012 23:08:31 GMT@henry - definitely a consideration. In my case, i don't anticipate there being more than 5 per document. But you are correct in that this can drive the decision of how documents are structured. For instance, i have a few document types which can be voted on, and there is a much higher probability that the number of votes could exceed the amount i'd like to keep in a single document. So voting information is split into a separate document.http://ayende.com/156770/ravendb-and-complex-tagging#comment4http://ayende.com/156770/ravendb-and-complex-tagging#comment4Wed, 04 Jul 2012 15:39:54 GMT@alexidsa - the reason ids are needed is that tag names can be ambiguous. If i add the tag "rock", am i talking about geology or music. Imagine you're a newspaper, with multiple sections (music, outdoors, etc). Searching for "rock" without context can return incorrect results. The ids in my case point to a Term which has a name, like "rock", but also a Vocabulary ("sports", "entertainment", or whatever) which helps to provide context and disambiguate the tag name.http://ayende.com/156770/ravendb-and-complex-tagging#comment3http://ayende.com/156770/ravendb-and-complex-tagging#comment3Wed, 04 Jul 2012 15:35:49 GMTWhat if 5000 users add 5 tags to a single doc. Isn't the album doc becoming pretty large (and slow to load/deserialize) with a Tags array of 25000 items then?http://ayende.com/156770/ravendb-and-complex-tagging#comment2http://ayende.com/156770/ravendb-and-complex-tagging#comment2Wed, 04 Jul 2012 14:27:02 GMTI thought you don't like when document child elements have ids...http://ayende.com/156770/ravendb-and-complex-tagging#comment1http://ayende.com/156770/ravendb-and-complex-tagging#comment1Wed, 04 Jul 2012 09:38:24 GMT