A catch-all term describing database systems using various non-relational models. Such systems are usually engineered to be high-performance.
41
votes
5answers
7k views
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 ...
33
votes
5answers
2k views
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 ...
26
votes
5answers
2k views
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 ...
22
votes
5answers
23k views
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. ...
13
votes
2answers
829 views
CouchDB vs MongoDB [closed]
Evaluating document-oriented storage, what are the pros and cons of CouchDB vs MongoDB?
13
votes
2answers
4k views
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 ...
11
votes
2answers
521 views
NoSQL and RDBMS together?
I was wondering if there are any good solutions for recording data in a NoSQL database and then converting them over to an RDBMS?
For example, if you wanted to capture some data quickly, like ...
11
votes
3answers
249 views
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 ...
11
votes
1answer
218 views
Highly Concurrent Storage System
Imagine your requirement is that you have 3 huge tables (structured data) with say 30 billion rows in each (total size of 4TB) and your many concurrent users (which are parallel os threads on remote ...
10
votes
1answer
844 views
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 ...
9
votes
3answers
3k views
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?
http://en.wikipedia.org/wiki/CouchDB
...
9
votes
2answers
381 views
What are some good resources for learning about document oriented databases?
I'm interested in learning about NoSQL databases and I decided to start with document oriented databases. What are some good resources to learn the concepts and good design of this type of database?
8
votes
2answers
592 views
Schema-less/flexible + ACID Database?
I am looking at rewriting a VB based on-premise (locally installed) application (invoicing+inventory) as a web based Clojure application for small enterprise customers. I am intending this to be ...
7
votes
3answers
204 views
Choosing a database for storing large amount of data and allowing for thousands of writes
I am working on a project that has some serious requirements regarding its database and having hard time choosing the best solution. The details are:
Database will easily reach tens of terabytes of ...
6
votes
3answers
714 views
Is NoSQL a replacement for traditional SQL, or an addition?
I've been reading up on NoSQL, but I can't figure out one thing. Is it meant to be a replacement for traditional SQL, or is it meant to be used in conjunction with it?
Basically, what I'm asking (I ...
6
votes
1answer
433 views
Why can't we perform joins in a distributed database like Bigtable?
From this answer to What database does Google use?,
BigTable is not a relational database. It does not support joins nor does it support rich SQL-like queries.
Is this obvious? I do not ...
6
votes
2answers
193 views
Is there any way to efficiently perform the equivalent of DENSE_RANK in MongoDB?
SQL Server and Oracle both have DENSE_RANK functions. Is there a way to do something similar in MongoDB without having to resort to MapReduce? In other words, suppose you have a T-SQL select clause ...
6
votes
2answers
441 views
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 ...
6
votes
1answer
539 views
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 ...
6
votes
1answer
543 views
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 ...
5
votes
3answers
1k views
Database suggestion for a social network/ knowledge base community?
I am looking into various database types and DBMS's for a new project I am wanting to start in the summer.
I have built systems in MySQL and postgreSQL , now I am wanting to expand my knowledge and ...
5
votes
1answer
442 views
How to handle “reference tables” in CouchDB?
What's the best way to handle "reference tables", tables that contain static data, for example a list with various kinds of ingredients for food?
Multiple documents, one for each ingredient
One ...
4
votes
2answers
1k views
“phpMyAdmin” for Cassandra
Is there a tool like phpMyAdmin for RDBMS-MySQL for a Cassandra DB?
I know that there is less "runtime" config possible (column families can not be edited at runtime etc.). Nevertheless, it would be ...
4
votes
2answers
741 views
Are there any in-memory NoSQL databases?
Given that NoSQL databases are designed to support horizontal scalability by throwing in more servers, are there any that are designed to do entirely without persistent disk storage?
I'm looking at ...
4
votes
1answer
476 views
What are your use-cases for HandlerSocket?
There's a bit of hype around: HandlerSocket
It seems like faster, nosql access to MySQL data is becoming more desirable. Percona Server is now shipping with HandlerSocket built in.
My question is, ...
3
votes
1answer
171 views
to what “scale” of applications does nosql support?
Recently i came across the Nosql database concept, though i learnt how to and why of it, i did not get a proper answer to the question , to what scale of project does it support?
Will it support ...
3
votes
1answer
360 views
noSQL ACID and consistency for banking
We are building a real time banking platform and app.
Our prime concern is safety and consistency of our data across multiple db servers. We need transactions and we can't afford to risk power ...
3
votes
2answers
160 views
Database choices for big data
I have many text files, their total size is about 300GB ~ 400GB. They are all in this format
key1 value_a
key1 value_b
key1 value_c
key2 value_d
key3 value_e
....
each line is composed by a key and ...
3
votes
3answers
408 views
Should I use MongoDB or a NoSQL solution at all for this?
I apologize if this belongs in web applications or something.
I'm creating a web application that is sort of a similar concept to github. Basically I plan to allow someone to create a design of ...
3
votes
2answers
376 views
Scalable DBaaS that can scale to hundreds of terabytes with easy backup and restore
I've gone over many DBaaS solutions, including Xeround (limited to 50G, in memory), NuoDB (currently in beta 7), DrawnToScale (not out yet), MongoDB (in memory), RavenDB (for ASP.NET, but NoSQL) and ...