All Questions
12
questions
0
votes
2
answers
764
views
Is $lookup from MongoDB slower than a join in a SQL database, with indexes involve?
db.inventory.aggregate( [
{
$lookup:
{
from: "order",
localField: "_id",
foreignField: "item_id",
as: "...
0
votes
2
answers
346
views
gorethink inner join
I don't quit understand joins in RethinkDB and unfortunately there is very little documentation about it in German.
So i have a table 'categories' and there i have two docs:
{"id":1, "...
0
votes
1
answer
98
views
Clarification on multiple join syntax SQL/NoSQL
I am studying NoSQL databases, and came across a situation which shows the complexity of storing connected data in relational databases. Here's the table structure:
The two queries are:
Who are Bob'...
0
votes
2
answers
1k
views
What is the best way to create a subset of my data in Elasticsearch?
I have an index in elasticsearch containing apache log data. Here is what I want to do:
Identify all visitors (by ip number) that accessed a certain file (e.g. /signup.php).
Do a search/query/...
0
votes
2
answers
122
views
Parse.com equivalent to sql query
I want to know how can I achieve the following SQL query on parse,
e.g. assume we have 2 tables/classes in our DB: User, Profile with example values in brackets.
User
- email([email protected])
- Name(tt)
...
0
votes
1
answer
441
views
NoSQL Design Principles vs. Joins
I have a set of users (user_id, user_name), and a set of attributes (attribute_id, user_id, attribute_key, attribute_value), so that each user has a username and key-value attributes.
In SQL, when I ...
1
vote
0
answers
172
views
SQL Server and NoSQL interactions
I have a table A that contains 500,000 rows. Table is related with 5 other tables (B,C,D,E,F) (the size of 100,000 rows each).
I'd like to extract in a fast way a structured information as (key A, ...
1
vote
1
answer
374
views
How to simulate sql join?
Now I tried to use the sql join algorithms (Nested loop join) for simulating the operation that joining two (or more) tables in nosql.
If I have two tables TableA and TableB,now I want to join these. ...
4
votes
2
answers
275
views
join two query using SQL
SELECT test2.user_id,myTable1.myCol1 FROM testingtable2 test2 LATERAL VIEW
explode(test2.purchased_item.product_id) myTable1 AS myCol1;
I am getting the below output result using the above query.
...
2
votes
1
answer
477
views
MongoDB Schema Design, Coalesce, Merging user-specific fields with default fields
Given:
A database of objects that each have a default weighting for search order (perhaps a universal popularity rating).
As each user uses those objects, the user's personal weighting for search ...
2
votes
2
answers
206
views
Is it reasonable to create a join object when using a NoSQL database?
Let's say I want to tag various objects like companies, users, time-series data. I know ahead of time that I will want to do queries like find all companies with tag X.
Now, I could just add a tag ...
54
votes
4
answers
46k
views
Join operation with NOSQL
I have gone through some articles regarding Bigtable and NOSQL. It is very interesting that they avoid JOIN operations.
As a basic example, let's take Employee and Department table and assume the ...