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
71
votes
5 answers

What's the difference between insert(), insertOne(), and insertMany() method?

What's the difference between insert(), insertOne(), and insertMany() methods on MongoDB. In what situation should I use each one? I read the docs, but it's not clear when use each one.
Marcos Mendes
  • 1,091
  • 1
  • 8
  • 15
71
votes
4 answers

How reliable is ElasticSearch as a primary datastore against factors like write loss, data availability

I am working on a project with a requirement of coming up with a generic dashboard where a users can do different kinds of grouping, filtering and drill down on different fields. For this we are looking for a search store that allows slice and dice…
Harshit Agrawal
  • 903
  • 1
  • 7
  • 11
70
votes
3 answers

Practical example for each type of database (real cases)

There are several types of database for different purposes, however normally MySQL is used to everything, because is the most well know Database. Just to give an example in my company an application of big data has a MySQL database at an initial…
daniel__
  • 11,633
  • 15
  • 64
  • 91
69
votes
9 answers

NoSQL for mobile apps?

Is there any established noSQL database solution to be used for developing native mobile applications (Android and/or iOs)?
Jeff
  • 14,365
  • 8
  • 30
  • 30
69
votes
3 answers

MongoDB normalization, foreign key and joining

Before I dive really deep into MongoDB for days, I thought I'd ask a pretty basic question as to whether I should dive into it at all or not. I have basically no experience with nosql. I did read a little about some of the benefits of document…
egervari
  • 22,372
  • 32
  • 121
  • 175
67
votes
7 answers

Azure Table Vs MongoDB on Azure

I want to use a NoSQL database on Windows Azure and the data volume will be very large. Whether a Azure Table storage or a MongoDB database running using a Worker role can offer better performance and scalability? Has anyone used MongoDB on Azure…
Shiju
  • 1,313
  • 2
  • 12
  • 14
66
votes
6 answers

Why are document stores like Lucene / Solr not included in NoSQL conversations?

All of us have come across the recent hype of no-SQL solutions lately. MongoDB, CouchDB, BigTable, Cassandra, and others have been listed as no-SQL options. Here's an…
Jon Davis
  • 6,562
  • 5
  • 43
  • 60
65
votes
17 answers

Mongodb: Failed to connect to 127.0.0.1:27017, reason: errno:10061

Here is my mongod.cfg file: bind_ip = 127.0.0.1 dbpath = C:\mongodb\data\db logpath = C:\mongodb\log\mongo-server.log verbose=v Here is my mongod service command: mongod -f c:\mongodb\mongod.cfg --install I have installed MongoDB about a week ago…
Michael
  • 15,386
  • 36
  • 94
  • 143
65
votes
5 answers

Storing null vs not storing the key at all in MongoDB

It seems to me that when you are creating a Mongo document and have a field {key: value} which is sometimes not going to have a value, you have two options: Write {key: null} i.e. write null value in the field Don't store the key in that document…
Zaid Masud
  • 13,225
  • 9
  • 67
  • 88
64
votes
5 answers

What's The Best Practice In Designing A Cassandra Data Model?

And what are the pitfalls to avoid? Are there any deal breaks for you? E.g., I've heard that exporting/importing the Cassandra data is very difficult, making me wonder if that's going to hinder syncing production data to development…
Jerry
  • 2,497
  • 4
  • 22
  • 31
63
votes
2 answers

anybody tried neo4j vs titan - pros and cons

Can anybody please provide or point out to a good comparison between Neo4j and Titan? One thing i can see is in terms of scale - Titan is scaleout and requires an underlying scalable datastore like cassandra. Neo4j is only for HA and has its own…
DevD
  • 1,201
  • 2
  • 12
  • 20
62
votes
4 answers

Why isn't RDBMS Partition Tolerant in CAP Theorem and why is it Available?

Two points I don’t understand about RDBMS being CA in CAP Theorem : 1) It says RDBMS is not Partition Tolerant but how is RDBMS any less Partition Tolerant than other technologies like MongoDB or Cassandra? Is there a RDBMS setup where we give up CA…
Glide
  • 20,235
  • 26
  • 86
  • 135
62
votes
6 answers

Can relational database scale horizontally

After some googling I have found: Note from mysql docs: MySQL Cluster automatically shards (partitions) tables across nodes, enabling databases to scale horizontally on low cost, commodity hardware to serve read and write-intensive workloads,…
Maksym
  • 4,434
  • 4
  • 27
  • 46
61
votes
3 answers

How to get all rows in Azure table Storage in C#?

I am trying to get a list of all entities inside an azure table. Any idea of how I would write this query?
SKLAK
  • 3,825
  • 9
  • 33
  • 57
60
votes
5 answers

How to get Schema of mongoose database which defined in another model

This is my folder structure: +-- express_example |---- app.js |---- models |-------- songs.js |-------- albums.js |---- and another files of expressjs My code in file songs.js var mongoose = require('mongoose') , Schema = mongoose.Schema ,…
Huy Tran
  • 4,371
  • 10
  • 34
  • 38