Monday, September 18, 2017

3 Approaches to Creating a SQL-Join Equivalent in MongoDB

DZone Database Zone
3 Approaches to Creating a SQL-Join Equivalent in MongoDB
3 Approaches to Creating a SQL-Join Equivalent in MongoDB

While there's no such operation as a SQL-style table join in MongoDB, you can achieve the same effect without relying on table schema. Here are three techniques for combining data stored in MongoDB document collections with minimal query-processing horsepower required.

The signature relational-database operation is the table join: Combine data from table 1 with data from table 2 to create table 3. The schemaless document-container structure of MongoDB and other non-relational databases makes such table joins impossible.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...