Ayende @ Rahien

Hi!
My name is Oren Eini
Founder of Hibernating Rhinos LTD and RavenDB.
You can reach me by phone or email:

ayende@ayende.com

+972 52-548-6969

, @ Q c

Posts: 18 | Comments: 72

filter by tags archive

Geo Location & Spatial Searches with RavenDB–Part II–Modeling

time to read 1 min | 200 words

I mentioned in the previous post that the data is coming in a highly relational format, and that the MaxMind advice is to not load this into a relational database, because then queries take a long time. Instead, they have their own efficient binary format.

I decided to put this into RavenDB, and that brought the question, how are we actually going to work with this? How do we model the data?

In our code, we defined the following, which I guess would pretty closely match how you model the data in a relational database:

image

Except…

In this case, we are actually storing the whole thing as a single entry, like so:

image

This allows us to query things efficiently and easily. But before we can get there, we need to actually load the data in, which is the topic of my next post.


Comments

Bart

I rather see fewer, but complete posts, instead of these part 1-5 posts which have little value on their own. These part 1-5 posts should be chapters within one big post, not posts on their own.

Phillip Haydon

@Bart - While I completely agree, because by about the 3rd part I've lost interest in the series and most often never read them... If Ayende did that, he would only have about 300 posts, and not 5k+

Ayende Rahien

Philip and Bart, Look at the older posts. I did that for a while, and what I found is that I have a lot more participation and interest when I break things up in this fashion

tobi

Ayende,

I never consciously thought about that but you're right.

Also: I have never postponed reading one of your articles because they are always digestible in minutes. Valuable content in manageable chunks.

Comment preview

Comments have been closed on this topic.

FUTURE POSTS

  1. RavenDB 3.0 New Stable Release - 17 hours from now
  2. Production postmortem: The industry at large - about one day from now
  3. The insidious cost of allocations - 3 days from now
  4. Buffer allocation strategies: A possible solution - 6 days from now
  5. Buffer allocation strategies: Explaining the solution - 7 days from now

And 3 more posts are pending...

There are posts all the way to Sep 11, 2015

RECENT SERIES

  1. Find the bug (5):
    20 Apr 2011 - Why do I get a Null Reference Exception?
  2. Production postmortem (10):
    01 Sep 2015 - The case of the lying configuration file
  3. What is new in RavenDB 3.5 (7):
    12 Aug 2015 - Monitoring support
  4. Career planning (6):
    24 Jul 2015 - The immortal choices aren't
View all series

RECENT COMMENTS

Syndication

Main feed Feed Stats
Comments feed   Comments Feed Stats