Stack Overflow
Stack Overflow

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
121
votes
3 answers

What's the best way of structuring data on firebase?

I am new to firebase and I want to know what's the best way of structuring data on it. I have a simple example: There are Applicants and Applications on my project. 1 applicant can have several applications. How can I relate this 2 objects on…
hopper
  • 4,230
  • 8
  • 36
  • 49
115
votes
6 answers

How to Add a Column in DynamoDB

Is there a way to add a new column to existing table in DynamoDB in Amazon's AWS? Google didn't help, UpdateTable Query in http://docs.aws.amazon.com/cli/latest/reference/dynamodb/update-table.html?highlight=update%20table doesn't have any…
Arun Selva Kumar
  • 2,593
  • 3
  • 19
  • 30
114
votes
25 answers

MongoDB dot (.) in key name

It seems mongo does not allow insertion of keys with a dot (.) or dollar sign ($) however when I imported a JSON file that contained a dot in it using the mongoimport tool it worked fine. The driver is complaining about trying to insert that…
Michael Yagudaev
  • 6,049
  • 3
  • 48
  • 53
114
votes
5 answers

Non-Relational Database Design

I'm interested in hearing about design strategies you have used with non-relational "nosql" databases - that is, the (mostly new) class of data stores that don't use traditional relational design or SQL (such as Hypertable, CouchDB, SimpleDB, Google…
Ian Varley
  • 9,227
  • 5
  • 29
  • 34
112
votes
4 answers

How does column-oriented NoSQL differ from document-oriented?

The three types of NoSQL databases I've read about is key-value, column-oriented, and document-oriented. Key-value is pretty straight forward - a key with a plain value. I've seen document-oriented databases described as like key-value, but the…
Luke
  • 13,678
  • 7
  • 45
  • 79
109
votes
7 answers

Cassandra port usage - how are the ports used?

When experimenting with Cassandra I've observed that Cassandra listens to the following ports: TCP *:8080 TCP *:8888 TCP *:57311 TCP *:57312 TCP 127.0.0.1:7000 TCP 127.0.0.1:9160 UDP 127.0.0.1:700 How does Cassandra use each of the ports listed?
knorv
  • 49,059
  • 74
  • 210
  • 294
105
votes
2 answers

Differences between OT and CRDT

Can someone explain me simply the main differences between Operational Transform and CRDT? As far as I understand, both are algorithms that permits data to converge without conflict on different nodes of a distributed system. In which usecase would…
Sebastien Lorber
  • 89,644
  • 67
  • 288
  • 419
103
votes
1 answer

Query with match by multiple fields

I'm pretty new to elastic search and would like to write a query that is concerned about two fields. I mean the content of the fields contains the specified substring. I have a document containing fields, like this: name: n tag: t I tried…
user3663882
  • 6,957
  • 10
  • 51
  • 92
101
votes
7 answers

Delete all nodes and relationships in neo4j 1.8

I know this question is asked by many people already for my research, here's some questions asked before How to delete all relationships in neo4j graph? https://groups.google.com/forum/#!topic/neo4j/lgIaESPgUgE But after all, still can't solve our…
Huei Tan
  • 2,237
  • 3
  • 23
  • 34
100
votes
9 answers

NoSql Crash Course/Tutorial

I've seen NoSQL pop up quite a bit on SO and I have a solid understanding of why you would use it (from here, Wikipedia, etc). This could be due to the lack of concrete and uniform definition of what it is (more of a paradigm than concrete…
Chris Thompson
  • 35,167
  • 12
  • 80
  • 109
100
votes
3 answers

MongoDB with redis

Can anyone give example use cases of when you would benefit from using Redis and MongoDB in conjunction with each other?
tonyl7126
  • 1,548
  • 3
  • 14
  • 19
97
votes
11 answers

Best data store for billions of rows

I need to be able to store small bits of data (approximately 50-75 bytes) for billions of records (~3 billion/month for a year). The only requirement is fast inserts and fast lookups for all records with the same GUID and the ability to access the…
Jody Powlette
  • 1,573
  • 2
  • 17
  • 21
92
votes
5 answers

SQL versus noSQL (speed)

When people are comparing SQL and noSQL, and concluding the upsides and downsides of each one, what I never hear anyone talking about is the speed. Isn't performing SQL queries generally faster than performing noSQL queries? I mean, for me this…
Janko
  • 8,985
  • 7
  • 34
  • 51
87
votes
3 answers

Large scale data processing Hbase vs Cassandra

I am nearly landed at Cassandra after my research on large scale data storage solutions. But its generally said that Hbase is better solution for large scale data processing and analysis. While both are same key/value storage and both are/can run…
Gary Lindahl
  • 5,341
  • 2
  • 19
  • 18
83
votes
11 answers

Transactions in NoSQL?

I'm looking into NoSQL for scaling alternatives to a database. What do I do if I want transaction-based things that are sensitive to these kind of things?
Timmy
  • 12,468
  • 20
  • 77
  • 107
1 2 3
…
99 100