Databases
StackOverflow2013
Postsdbo
POSuitability of MongoDB for hierarchial type queries
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSuitability of MongoDB for hierarchial type queries
    primarykey
    data
    text
    <p>I have a particular data manipulation requirement that I have worked out how to do in SQL Server and PostgreSQL. However, I'm not too happy with the speed, so I am investigating MongoDB.</p> <p>The best way to describe the query is as follows. Picture the hierarchical data of the USA: Country, State, County, City. Let's say a particular vendor can service the whole of California. Another can perhaps service only Los Angeles. There are potentially hundreds of thousands of vendors and they all can service from some point(s) in this hierarchy down. I am not confusing this with Geo - I am using this to illustrate the need.</p> <p>Using recursive queries, it is quite simple to get a list of all vendors who could service a particular user. If he were in say Pasadena, Los Angeles, California, we would walk up the hierarchy to get the applicable IDs, then query back down to find the vendors.</p> <p>I know this can be optimized. Again, this is just a simple query example.</p> <p>I know MongoDB is a document store. That suits other needs I have very well. The question is how well suited is it to the query type I describe? (I know it doesn't have joins - those are simulated).</p> <p>I get that this is a "how long is a piece of string" question. I just want to know if anyone has any experience with MongoDB doing this sort of thing. It could take me quite some time to go from 0 to tested, and I'm looking to save time if MongoDB is not suited to this.</p> <p><strong>EXAMPLE</strong></p> <p>A local movie store "A" can supply Blu-Rays in Springfield. A chain store "B" with state-wide distribution can supply Blu-Rays to all of IL. And a download-on-demand store "C" can supply to all of the US.</p> <p>If we wanted to get all applicable movie suppliers for Springfield, IL, the answer would be [A, B, C].</p> <p>In other words, there are numerous vendors attached at differing levels on the hierarchy.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USIvan
    1. USIamIC
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSuitability of MongoDB for hierarchial type queries
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSuitability of MongoDB for hierarchial type queries
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POSuitability of MongoDB for hierarchial type queries
      1. USentropo
      1. VTFavorite
    1. COTraditionally, a compound key could easily do this. However, that isn't the query style I'm looking for.
      singulars
      1. POSuitability of MongoDB for hierarchial type queries
      1. USIamIC
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload