Questions tagged [nosql]

A catch-all term describing database systems using various non-relational models. Such systems are usually engineered to be high-performance.

NoSQL is a catch-all term to describe various types of databases that use non-relational models. Some database paradigms grouped under the 'NoSQL' label include:

  • Key-Value pair and distributed key value store databases that store and retrieve a record based on a main or supplementary key.
  • Document databases that store a structured document based on a key, possibly with supplementary indexes.
  • Graph and object databases.

Commonly cited strengths of NoSQL systems include easy scale-out capabilities, flexibility with schema structure and making trade-offs against ACID properties (for example 'eventual consistency' semantics) for performance.

May also sometimes be referred to as Not Only SQL

423 questions
121
votes
5 answers

Best database and table design for billions of rows of data

I am writing an application that needs to store and analyze large amounts of electrical and temperature data. Basically I need to store large amounts of hourly electricity usage measurements for the past several years and for many years to come for…
Gecata
  • 1,313
  • 3
  • 9
  • 5
92
votes
5 answers

Why can't RDBM's cluster the way NoSQL does?

One of the big plusses for nosql DBMS is that they can cluster more easily. Supposedly with NoSQL you can create hundreds of cheap machines that store different pieces of data and query it all at once. My question is this, why can't relational…
fregas
  • 1,051
  • 1
  • 9
  • 7
85
votes
5 answers

Which database could handle storage of billions/trillions of records?

We are looking at developing a tool to capture and analyze netflow data, of which we gather tremendous amounts of. Each day we capture about ~1.4 billion flow records which would look like this in json format: { "tcp_flags": "0", "src_as":…
somecallmemike
  • 965
  • 1
  • 7
  • 5
71
votes
6 answers

What are the differences between NoSQL and a traditional RDBMS?

What are the differences between NoSQL and a traditional RDBMS? Over the last few months, NoSQL has been frequently mentioned in the technical news. What are its most significant features relative to a traditional RDBMS? At what level (physical,…
Spredzy
  • 2,248
  • 2
  • 20
  • 25
58
votes
5 answers

What is a Key/Value store database?

I've been looking at the wikipedia page for NoSQL and it lists several variations on the Key/Value store database, but I can't find any details on what it means by Key/Value store in this context. Could someone explain or link an explanation to me?…
indyK1ng
  • 1,111
  • 2
  • 12
  • 11
34
votes
2 answers

Timeseries: SQL or NoSQL?

I don't care about the general differences between SQL and NoSQL (or their traditional differences). I am currently looking at altering the storage of our internal time series. They all contain financial data from a number of different sources.…
Nicolas
  • 443
  • 1
  • 5
  • 6
26
votes
4 answers

If NoSQL stands for "Not only SQL", is SQL a subset of NoSQL?

The definition is a bit confusing - basically I'm asking if SQL is a subset of the NoSQl family: I'm asking this because "Not-only" means NoSQL is much larger, but still includes SQL as a part of it. On the other hand, since we can't do typical sql…
ERJAN
  • 483
  • 5
  • 7
24
votes
4 answers

What does horizontal scaling mean?

In database context, I have come across horizontal scalability as one of the advantages of the NOSQL databases. What does the term mean? CouchDB on Wikipedia NoSQL on Wikipedia How would it compare to vertical scaling?
Lazer
  • 3,361
  • 15
  • 43
  • 53
19
votes
2 answers

Redis takes up all the Memory and Crashes

A redis server v2.8.4 is running on a Ubuntu 14.04 VPS with 8 GB RAM and 16 GB swap space (on SSDs). However htop shows that redis alone is taking up 22.4 G of memory! redis-server eventually crashed due to out of memeory. Mem and Swp both hits 100%…
Nyxynyx
  • 1,131
  • 6
  • 18
  • 29
18
votes
2 answers

redis newbie - how to create hash within a hash?

I want to create this type of a structure in redis: (its basically json data) { "id": "0001", "name":"widget ABC", "model": "model123", "service":"standard", "admin_password": 82616416, "r1": { …
Happydevdays
  • 355
  • 1
  • 2
  • 9
18
votes
2 answers

CouchDB vs MongoDB

Evaluating document-oriented storage, what are the pros and cons of CouchDB vs MongoDB?
Abie
  • 885
  • 1
  • 8
  • 9
17
votes
1 answer

How do databases store index key values (on-disk) for variable length fields?

Context This question pertains to the low-level implementation details of indexes in both SQL and NoSQL database systems. Actual structure of the index (B+ tree, hash, SSTable, etc.) is irrelevant as the question pertains specifically to the keys…
Riyad Kalla
  • 338
  • 2
  • 7
16
votes
1 answer

Amount of data per node in Neo4j

I need to store substantial amounts of data per node in Neo4j. The data is Unicode chunks of text. Actually not every node will have big chunks, but many of them will. I waded through the documentation but didn't find any mention on the Node size –…
treecoder
  • 263
  • 2
  • 6
16
votes
2 answers

What is the point of column families?

I've seen that NoSQL database systems like RocksDB offer a feature called column families. I believe I understand what the concept refers to, but what are the actual (practical) benefits of using them? I presume they can improve look-up performance…
Noldorin
  • 453
  • 1
  • 3
  • 10
15
votes
5 answers

Why are NoSQL databases not ACID compliant?

Not having ACID properties means that the database works well on clusters. But ACID is something very fundamental. How can a database work well if there is no atomicity, consistency, isolation and durability (ACID)?
Krekurul
  • 159
  • 1
  • 1
  • 3
1
2 3
28 29