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

Why does mapping numeric data to a keyword improve retrieval times in ElasticSearch

I'm coming from a long-term SQL background -- NoSQL (and ElasticSearch) is very new to me. An engineer on my team is constructing a new index for document storage, and they have mapped all short/int/long values to strings for use in term…
Jake McGraw
  • 135
  • 4
  • 11
4
votes
2 answers

Trouble with getting a CouchApp to output the correct mime type for an appcache

So in CouchDB, you can supposedly change mime types. In Futon you just have to go and edit the source of the document and change the content_type field on attachments in the _attachment field. Trouble is, when I do this so that an appcache file has…
arjs
  • 2,835
  • 4
  • 22
  • 18
4
votes
2 answers

Initial DB structure / data for MongoDB + NodeJS web application

I'm developing a web application in Node.js with MongoDB as the back end. What I wanted to know is, what is the generally accepted procedure, if any exists, for creating initial collections and populating them with initial data such as a white list…
mhy
  • 455
  • 2
  • 6
  • 12
4
votes
1 answer

How to query on two arrays at the same time in MongoDB?

I have the following documents, where each document has fields values and dates, which are arrays. These arrays always have the same size in each document, meaning each value in dates corresponds to a value in values: [ { _id: "Stock1", …
4
votes
1 answer

DynamoDB on-demand scaling and throttling

Im currently researching on-demand settings for DynamoDB. We occasionally see some throttling during high traffic spikes, its across all indexes so not specific to a partition. All DynamoDB docs in relation to on-demand capacity mode seem to…
Person1
  • 109
  • 2
  • 10
4
votes
1 answer

Whats wrong with Mongo DBRef's?

Coming from a RDMBS background it's hard not to think of thinkgs like joins, especially when working with the schema-less MongoDB environemnt. I read on a blog that DBRefs were only useful when you do know the type of object that you're…
4
votes
3 answers

Python + MongoDB document versioning

I have an app in the works for use internally as a project/task tracker in the company that I'm working for. Playing around with MongoDB atm. I have the following pseudo-schema in mind: task _id name project initial_notes …
pocorschi
  • 3,605
  • 5
  • 26
  • 35
4
votes
1 answer

How to reduce document reads for Firestore

I am using Firestore (I am new to this) for small web application. Currently, each time when I refresh or go to another page, the function retrieves all the documents in the Firestore. But the data that it retrieves does not change often, Is there a…
4
votes
1 answer

DynamoDB Scan eventual consistency vs. GSI Query eventual consistency

I have a table, which previously I have been using the Scan API (with "ConsistentRead": false, i.e eventually consistent) for my purpose of filtering by a non-key attribute. Because it is quite costly, now I have decided to add a global secondary…
Azamat Abdullaev
  • 726
  • 9
  • 24
4
votes
4 answers

Running into problems installing MongoDB on MacOS Terminal

I am trying to install mongoDB as a macOS service but I am running to some errors I first put in the terminal brew tap mongodb Nothing really happens. But, when I run: brew install mongodb-community@5.0 I receive: Warning: No available formula…
4
votes
2 answers

What is the NOSQL Database of choice to use with Grails?

I'm about to start a project that has a DB that complies with what should be used in a NOSQL DB (Hadoop, MongoDB, Cassandra, etc). On the other hand I'd really like to use Grails as Web platform so if anyone could enlighten me with his/her…
xain
  • 13,159
  • 17
  • 75
  • 119
4
votes
1 answer

MongoDB Atlas search: sort by "searchScore"

I run the following aggregation pipeline and it works well: [ { $search: { text: { query: text, path: 'name', fuzzy: { maxEdits: 2, prefixLength: 0, maxExpansions: 256, }, …
4
votes
2 answers

Clarifying questions about MongoDB

These are newb questions, I'm sure, so let's get this out of the way sooner rather than later: I'm new to MongoDB. Does MongoDB guarantee that an entry will be saved? E.g. if I have a process load 1,000,000 objects into MongoDB, am I guaranteed…
Geoff
  • 9,470
  • 13
  • 52
  • 67
4
votes
3 answers

why all writes must go to the master and why writing to a slave makes no sense?

http://www.pcpro.co.uk/realworld/355477/understanding-the-nosql-movement: However, all writes must go to the master, because the data flow is one-way from master to slaves, and writing to a slave makes no sense. I'm having trouble understanding…
jaytufch
  • 227
  • 3
  • 8
4
votes
2 answers

Delete document that has size greater than a specific value

I have a collection which contains a multiple documents whose size has increased from 16MBs or is about to reach 16MBs. I want query that finds documents which have size greater than 10MBs and delete all of them. I am using following to find the…
sarosh
  • 107
  • 10