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

419 questions
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
  • 1
  • 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
15
votes
1 answer

CAP Theorem vs. BASE (NoSQL)

CAP Theorem vs. BASE (NoSQL) Hi, I’m trying to write a small paper for my work about NoSQL and have described the CAP Theorem as, if not all, then most NoSQL databases adheres to. I later read a paper about the difference between NoSQL and RDBMS…
Mestika
  • 253
  • 1
  • 2
  • 5
15
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
  • 443
  • 3
  • 10
15
votes
3 answers

What are the canonical NoSQL resources for people who never used this technology?

I am getting more and more interested by the NoSQL technology and I can read several posts on SE about how it works and the different products available. However, I wonder if there are some canonical references, books or articles, which we can site…
SRKX
  • 267
  • 1
  • 6
14
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
  • 149
  • 1
  • 1
  • 3
9
votes
3 answers

Can NoSQL databases cause occasional data loss?

I am currently evaluating databases to use for a new project, which will require insertion and querying of large amounts of trading data. Our team is leaning towards Cassandra, but then I read this article that seems to suggest using non-ACID…
del
  • 191
  • 1
  • 2
7
votes
1 answer

How do you design schema for tracking change history in NoSQL?

I'm thinking of trying a document store db for a project that needs to keep track of changes. I'd like to prototype with firebase, but I think the schema/implementation would be the same in MongoDb The (simplified) setup is that I have three…
Daniel
  • 185
  • 1
  • 5
5
votes
1 answer

How do relations work in NOSQL?

I was using SQL in all my previous application and to understand the Parse.com db storage, I wanted to know NOSQL. I tried searching the differences between SQL and NOSQL for past 2 days & I still don't understand how a relation works in NOSQL. I…
Yuva Raj
  • 151
  • 1
  • 1
  • 3
4
votes
1 answer

Any suggestions on having master-master replications around the world by nosql solutions?

I would like to set up databases that are put at different data centres around the world. For this, I think some nosql solutions may suit the case. For example, couchdb, maybe. Eventual consistency is ok for this. The case does not limit to document…
Harold Chan
  • 204
  • 2
  • 7
3
votes
1 answer

Would elasticsearch or RavenDB be better for fueling a statistics engine/random forest?

(Note: this question exists on StackOverflow as well but I thought it might have a better reception here. If it proves this is the better place, I'll close/ask to migrate/link to this. Also, if it doesn't really belong here, I'd be happy to delete…
casperOne
  • 301
  • 2
  • 13
2
votes
1 answer

Microsoft Column Store Database?

Using Microsoft technologies/products is it possible to create a column store database with column family sets, where each row being able to have a different number and type of columns (a different column family).
Edmund
  • 703
  • 2
  • 10
  • 22
2
votes
1 answer

Understanding DB Throughput Calculations

I'm trying to understand more about databases and am taking a course that calculates throughput throughout. An example for a DynamoDb table looks like... our application requires us to read 10 items of 6KB / second, what should we set the…
JackB
  • 21
  • 1
1
vote
1 answer

NoSQL DBs and 2-way synchronization

I've been told that MongoDb does not, but do any NoSQL DBs support this functionality?
Paul ryan
  • 23
  • 1
  • 4
1
vote
4 answers

Use SQL or NoSQL?

I'm designing a system that checks a given website for any security vulnerabilities. The system includes a client (firefox plugin) and a server. The server does all the scanning while the client just relays that info to the user. If a website is…
Chris
  • 111
  • 3
1
2