ozgune

25 ms·

241.
SQL on MongoDB: A Look at Performance(citusdata.com)
39 points by ozgune 14y ago|0 comments
242.
by ozgune 14y ago
I wonder if this article has some sort of selection bias. After all, communities that have the lowest and highest rates of cancer in the US are small towns of <100 people. It's easy to find several small towns in the US where people h
243.
by ozgune 14y ago
Hi there - the collection doesn't need to be homogenous; if the query references a missing field in a document, the wrapper interprets that value as null. For nested documents, we have some ideas on how to make that accessible, and talk abo
244.
by ozgune 14y ago
Behind the covers, we convert filtering expressions in the WHERE clause to Mongo's query API, and send that query over. We found that translating the rest of SQL amounted to writing a database query executor, and instead opted for leaving t
245.
by ozgune 14y ago
Hi there, we are mostly targeting analytic use-cases with this. SQL already has a lot of analytics functionality built into the language, so we thought it might be interesting to enable it. * We find that in the context of analytics, transa
246.
by ozgune 14y ago
We measured performance across several SQL queries, and found that it depends. Assuming that the working set fits into memory: * If the query goes over a single table and doesn't have filter clauses, then the cost of converting BSON data to
247.
Run SQL on MongoDB(citusdata.com)
103 points by ozgune 14y ago|34 comments
248.
by ozgune 14y ago
It seems like they had their "Facebook branch" open for ten months now. I wonder if they had any security issues. Either way, it's cool seeing kids withdraw cash from ATMs by typing in their SMS PIN numbers. Kind of makes you feel young, an
249.
by ozgune 14y ago
In all honesty, I'd have to check. The worker nodes in our architecture will be able to use PostGIS indexes just like regular PostgreSQL instances, and the master node should correctly handle (partition) most PostGIS functions. Still, we'd
250.
by ozgune 14y ago
It's doable, but the paradigm doesn't naturally fit into SQL. Users typically need to use sub-selects and self-joins for this kind of "A", "B" & "C" analysis; and that introduces inefficiencies.
251.
by ozgune 14y ago
There's value in both types of analyses. For knowing what users do after they perform action "A", "B" & "C", many people currently rely on implementing Map/Reduce programs. That can be a bit heavyweight if you want to simply compare peo
252.
by ozgune 14y ago
Hey, we currently don't have an SQL/MapReduce language extension, but we do have the Map & Reduce execution primitives implemented under the covers (for parallel query processing). For the distributed query processor, we can efficiently
253.
by ozgune 14y ago
Congrats guys on the launch! Looking forward to giving it a spin.
254.
by ozgune 14y ago
This has nothing to do with the secular military. In fact, the current pro-Islamic administration has imprisoned more than 10% of the generals in the military (trial ongoing for four years); and recently started "cracking down" on liberal j
255.
Turkey charges pianist Fazil Say over Twitter posts(nytimes.com)
63 points by ozgune 14y ago|45 comments