Requesting Schema Suggestions

[Bobby Johnson]

I am working on my first serious project with RavenDB and would like to solicit suggestions. I currently have two concepts in my domain, Presenters and Presentations. Presenters can present many times and a Presentation has one Presenter currently. In a relational model I would have two tables, but am not sure how to select document schema.

I would like to be able to show up coming presentations with some minimal info about the presenter as well as have a presenters page that shows info about all of their presentations.

What I have come up with is located here:

Presenter: https://github.com/ssdnug/Public-Site/blob/master/src/Web/Models/Presenter.cs

Presentation: https://github.com/ssdnug/Public-Site/blob/master/src/Web/Models/Presentation.cs

Anyone have suggestions on a better schema?

Thanks,

Bobby

--
"The explanation requiring the fewest assumptions is most likely to be correct."

- Occam’s Razor
http://en.wikipedia.org/wiki/Occam's_Razor

[Oren Eini (Ayende Rahien)]

You don't need the Presenter.Presentations property. You are very rarely, if ever, going to have to try to load the presentations from the presenter, and when you do, you'll want to make this with paging,sorting,etc.

De-normalizing the Presenter in the presentation is good. You won't need to update the presenter name ever.

For example, I used to go mainly as Ayende Rahien, now I go as Oren Eini. Old presentations don't need to change, though.

[Bobby Johnson]

Excellent, thanks the advice Oren.

For anyone else struggling withis this topic and trying to break the relational mindset here are a couple good blog posts taht helped me understand yesterday.

http://daniellang.net/how-to-handle-relations-in-ravendb/

http://codeofrob.com/entries/ravendb---document-design-with-collections.html

[Dody Gunawinata]

The great thing about RavenDB especially for new development is that
it's pretty easy to fix your schema during development. It is trivial
to refactor a schema and leave the old test data behind.

--
nomadlife.org