Questions tagged [nosql]

NoSQL (sometimes expanded to "not only SQL") is a broad class of database management systems that differ from the classic model of the relational database management system (RDBMS) in some significant ways.

NoSQL (sometimes expanded to "not only ") is a broad class of database management systems that differ from the classic model of the relational database management system () in some significant ways.

NoSQL systems:

  • Specifically designed for high load
  • Natively support horizontal scalability
  • Fault-tolerant
  • Store data in a denormalized manner
  • Do not usually enforce strict database schema
  • Do not usually store data in a table
  • Sometimes provide eventual consistency instead of ACID transactions

In contrast to RDBMS, NoSQL systems:

  • Do not guarantee data consistency
  • Usually support a limited query language (a subset of SQL or another custom query language)
  • May not provide support for transactions/distributed transactions
  • Do not usually use some advanced concepts of RDBMS, such as triggers, views, stored procedures

NoSQL implementations can be categorized by their manner of implementation:

Free NoSQL Books

Related tags

13110 questions
4
votes
1 answer

Does AWS DocumentDB Support Joining 3+ Collections In a Single Query?

Is it possible to join 3 separate collections together in AWS DocumentDB with a single query (similar to the solution to the thread here: How can I perform nested “joins” (joining 3 or more collections) in a MongoDB aggregation pipeline? I feel like…
Greg Thomas
  • 397
  • 3
  • 13
4
votes
1 answer

How can I perform nested "joins" (joining 3 or more collections) in a MongoDB aggregation pipeline?

Let's say we have 3 hypothetical collections in MongoDB: customers, orders, and orderItems. Each customer has multiple orders, and each order has multiple order items. Here's some sample data for these 3 collections: customers [ { …
4
votes
1 answer

"Pointers" in MongoDB?

In the project I am currently working on, it seems to make more sense efficiency wise if I create a nested document that contains a list of "pointers" to information stored in other collections. That way this nested document can be easily used to…
Ben Kulbertis
  • 1,713
  • 4
  • 17
  • 30
4
votes
1 answer

What is the best way to handle database alteration in a No-SQL DB like Hive for Flutter?

Suppose you launch an App with the following DB schema with Hive: box.put('schema', {'foo': true, 'bar' : 2, 'baz': 'baz'}); Some time after you launch a new version of the app and suppose the schema changes the names as follows: box.put('schema',…
Nico Rodsevich
  • 2,393
  • 2
  • 22
  • 32
4
votes
2 answers

How to retrieve entities by passing array of IDs as input in Google datastore?

I am trying to implement the following SQL logic in the datastore, SELECT * from table where id in [1,2,3,4,5] Implementing this in datastore, I want to retrieve all the corresponding entities with these IDs as an array. let employees = [] try { …
Amy
  • 136
  • 1
  • 4
4
votes
2 answers

Firebase Firestore - Multiple array-contains in a compound query

Introduction I am adding a chat to my app (without groups, only individuals chats (between 2 users)) where if one user deletes his full chat with other user, both users will not be able to read their previous conversation, likes happens on…
4
votes
1 answer

Dynamic schema changes in Cassandra

I have lots of users(150-200 million). Each user has N(30-100) attributes. The attribute can be of type integer, text or timestamp. Attributes are not known, so I want to add them dynamically, on the fly. Solution 1 - Add new column by altering the…
lkatiforis
  • 5,703
  • 2
  • 16
  • 35
4
votes
2 answers

What is the best noSQL for Raspberry pi?

I'm looking for noSQL db for Rapsberry pi. I've tried MongoDB which is really terrible to install on Pi. 3+ version is not run on Pi (because it needs 64 bit version, and Pi is only 32). Older versions (2<) give a list of errors and problems during…
Wadkan
  • 87
  • 2
  • 6
4
votes
3 answers

Flutter Firebase: Retrieve a list of documents, limited to IDs in an array?

I'm working on a Flutter app where each user can create projects, and share projects with other users. I've created a 'shares' collection, where each user's ID is a document, and within that document, all project IDs that have been shared with that…
ConleeC
  • 337
  • 6
  • 13
4
votes
3 answers

Mongodb vs Timeseries Database for timeseries data

We have certain linux devices which send data like battery percentage, cpu utilization, ram utilization, etc. in certain intervals. We want to run analytics for this data. Should we capture this data in…
suraj shukla
  • 106
  • 1
  • 6
4
votes
2 answers

Database migrations support in play framework?

Ruby on Rails has ActiveRecord and migrations for database schema and data migrations. Does play framework has support like this (both schema and data migrations)? What if NoSQL database is used in play framework, does it still support database…
ace
  • 11,526
  • 39
  • 113
  • 193
4
votes
2 answers

MongoDB, change array of objects to an array of strings containing their ObjectId

I have an database full of objects that contain information, as well as other arrays of objects. I would like to change the inner arrays to only be arrays with each index as an ObjectId type with their respective ObjectId I am using the mongoose…
nmfb
  • 49
  • 2
4
votes
4 answers

Key-value store for Ruby & Java

I need a recommendation for a key-value store. Here's my criteria: Doesn't have to be persistent but needs to support lots of records (records are small, 100-1000 bytes) Insert (put) will happen only occasionally, always in large datasets…
Mladen Jablanović
  • 43,461
  • 10
  • 90
  • 113
4
votes
5 answers

Which NoSQL database for extremely high volumes of data

I'm looking at NoSQL for extremely high volumes of data. We're storing cached versions of web page text in MySQL at the moment, but it seems like the database will get huge very quickly. My requirements are: Durability, must not lose data on…
Filo Stacks
  • 1,951
  • 2
  • 20
  • 20
4
votes
2 answers

RethinkDB query based on multiple timestamps as secondary indices

I have a RethinkDB with a table 'events', each event has a 'from' and a 'to' column, both are timestamps. I want to mainly query this table by returning all events that are "active" in a time window, meaning the from column is before the end of the…
JoGr
  • 150
  • 1
  • 10
1 2 3
99
100