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
520 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
248 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
841 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
380 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
194 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
712 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
431 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
192 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
535 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
541 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
441 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
739 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
475 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
359 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
159 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
407 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 ...
3
votes
1answer
47 views
Sharded key-value store using MongoDB
Would like to set up a key-value store that is sharded across multiple machines.
We are currently using MongoDB, is there a reason why we shouldn't use MongoDB for this purpose?
We also use Redis, ...
3
votes
2answers
162 views
Which database system can break me free?
I am currently running a MySQL Database for logging and analyzing those logs.
My current table schema looks like this:
CREATE TABLE `mylogs` (
`transfer_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ...
3
votes
1answer
39 views
Create Scheme that allows for fluidity between entities
We are a small rapidly evolving company and recently investigated switching databases from SQL Server to a graph database. We like the graph approach because of the fluidity and openness that it ...
2
votes
4answers
368 views
Advice on choosing a really fast DBMS
I am working on a project that does real-time monitoring of data being transmitted, and logs if there are any of the various type of errors, etc. The CRUD operations are real-time. We initially ...
2
votes
2answers
170 views
Should I use SQL or NoSQL for this specific design (surveys)?
Building a small web application to create satisfaction surveys with a default list of questions and responses. The application is for a small audience of people (5,000 max) with surveys sent out when ...
2
votes
1answer
49 views
What fillfactor for caching table?
I have heavily updated / accessed table where I store serialized java objects. They are in the table for 2-3 hours (also are being updated during that period) and then removed. Size of table is around ...
2
votes
2answers
173 views
How well, if at all, does Oracle NoSQL database integrate with Oracle RDBMS?
I currently have an application which runs on Oracle RDBMS and an area of new functionality which would be better supported by a NoSQL store. I am wondering if Oracle NoSQL Database may be a good ...
2
votes
1answer
159 views
Which database?
We have to launch a new service in my company with a big database.
And I currently don't have that much knowledge.
We did a small preview of the service and our biggest table had more than 2 100 000 ...
2
votes
1answer
148 views
Building a custom database in C with/without SQL? [closed]
Provide link or tutorials to build a custom database management in C. I am looking for Full Text Search options of about 10GB DB.
2
votes
1answer
310 views
How to store GPS coordinate and search places in a radius from a NoSQL DBMS (like DynamoDB)
My team need a DBMS like DynamoDB to store large amount of data, principally places and coordinates.
I've considered to use some GIS-based DBMS (like PostGIS) with an index on the POINT, but DynamoDB ...
2
votes
0answers
118 views
Strugling with updating a cassandra row in FluentCassandra
I have this problem with using Fluent Cassandra in a test application. All I want to do is set the IsOnline field to true inside the SignIn method, but I keep getting the exception supercolumn ...
2
votes
0answers
47 views
Membase data shared between users [closed]
I have begun writing a website using Membase (php memcached library) and I've come up against a conceptual wall. This is my scenario:
I have some data that is stored in a key-value pair which will ...
2
votes
0answers
117 views
Schema-less/flexible + ACID database? [duplicate]
Possible Duplicate:
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 ...
1
vote
1answer
413 views
Which NoSQL database(s) should be used for advertising platform? [closed]
What NoSQL database or combination of databases best meets these criteria?
Very fast writes and reads
Persistent data that won't get lost in a crash
Plays nice with PHP
Works well in the cloud (EC2)
...
1
vote
1answer
85 views
Is it possible to query “NOT IN” in NO SQL?
I asked the same thing about a specific NoSql engine (Big Table) on SO.
It seems that Big Table doesn't support NOT IN queries?
Is that possible in any other NoSQL databases?
Will it ever be possible ...
1
vote
1answer
103 views
is it reasonable to use NoSQL for my project
Imagine you want to write a webapp for selling your car online.
A car has a lot of attributes. Like how many doors, color, aircondition, etc. Some of them are simple boolean values, others might need ...
1
vote
3answers
117 views
Relational vs Non-Relational Database for Events Database
I'm trying to find out whether an SQL or no-SQL solution would be better for creating an events database. I'm creating a ticketing system, similar to ticket master. I know that for either ...
1
vote
2answers
142 views
To find a version for your pc check with the software publisher install mongodb
I want to install MongoDb on windows 8 but when i try to run C:\mongodb\bin\mongod.exeiget this error:
To find a version for your pc check with the software publisher.
1
vote
1answer
129 views
Books to start with big data [closed]
I would like to start learning about the big data technologies. I work in this area in the future. Does anyone know good books to start learning about it? Hadoop, HBase.
Beginner -
intermediate -
...
1
vote
1answer
484 views
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 ...
