News for hackers. Stuff that matters.
Re:Aggregating NBA data, PostgreSQL vs MongoDB by chris_wot on Tuesday February 18, 2014 @07:35AM (#7257765)
So if I understand this correctly, the original article [1] shows that the mongodb queries being used rely on doing projections and selections on the data, then they apply aggregations.

However, unlike a relational engine which uses a query plan, you need to actually tell the aggregation engine in which order to process the data.

Doesn't this seem a little... backward? If the dataset is complex enough, the two things that come to mind are:

1. There would be a lot of redundancy in the hierarchical dataset.

and

2. That seems like a lot of futzing around to get the most optimal aggregation path!

What am I missing here?

p.s. I do tend to agree that the SQL syntax is rather more readable, but then again I've been looking at SQL for a lot longer than I have JSON style queries. The first query is not that unreadable!

1. http://thecodebarbarian.wordpress.com/2014/02/14/crunching-3...

There are no comments on this comment yet.