All Questions
54
questions
55
votes
8
answers
12k
views
The Next-gen Databases [closed]
I'm learning traditional Relational Databases (with PostgreSQL) and doing some research I've come across some new types of databases. CouchDB, Drizzle, and Scalaris to name a few, what is going to be ...
37
votes
4
answers
22k
views
Database EAV Pros/Cons and Alternatives [closed]
I have been looking for a database solution to allow user defined fields and values (allowing an unlimited number). At first glance, EAV seemed like the right fit, but after some reading I am not ...
146
votes
8
answers
33k
views
Use cases for NoSQL [closed]
NoSQL has been getting a lot of attention in our industry recently. I'm really interested in what peoples thoughts are on the best use-cases for its use over relational database storage. What should ...
11
votes
3
answers
12k
views
Hamming Distance / Similarity searches in a database
I have a process, similar to tineye that generates perceptual hashes, these are 32bit ints.
I intend to store these in a sql database (maybe a nosql db) in the future
However, I'm stumped at how I ...
137
votes
3
answers
133k
views
SQL (MySQL) vs NoSQL (CouchDB) [closed]
I am in the middle of designing a highly-scalable application which must store a lot of data. Just for example it will store lots about users and then things like a lot of their messages, comments etc....
257
votes
10
answers
69k
views
What did MongoDB not being ACID compliant before v4 really mean?
I am not a database expert and have no formal computer science background, so bear with me. I want to know the kinds of real world negative things that can happen if you use an old MongoDB version ...
6
votes
2
answers
7k
views
Group by data intervals
I have a single table which stores bandwidth usage on the network over a period of time. One column will contain the date time (primary key) and another column will record the bandwidth. Data is ...
73
votes
7
answers
24k
views
When shouldn't you use a relational database? [closed]
Apart from the google/bigtable scenario, when shouldn't you use a relational database? Why not, and what should you use? (did you learn 'the hard way'?)
3
votes
2
answers
3k
views
insert speed in mysql vs cassandra
I have a lot of (about 1 million in second)structural data that must be insert to database
I see a lot of benchmark about sql vs noSql and type of Nosql then collect cassandra as database
but I ...
142
votes
7
answers
198k
views
Foreign keys in mongo?
How do I design a scheme such this in MongoDB? I think there are no foreign keys!
21
votes
2
answers
58k
views
Lightweight database (SQL or NoSQL)
I'm currently working on a website that must exist on a VM with very low memory availability (at the moment I am told to expect 512mb). Unfortunately, at least in the immediate future, the database ...
4
votes
2
answers
3k
views
Good database and structure to store synonyms
If you could choose the database you want and have to store (query and update) word synonyms then what database would you choose? And how would you store them? Let's assume that there will be a lot of ...
141
votes
21
answers
22k
views
Good reasons NOT to use a relational database?
Can you please point to alternative data storage tools and give good reasons to use them instead of good-old relational databases? In my opinion, most applications rarely use the full power of SQL--it ...
54
votes
3
answers
22k
views
Any detailed and specific reasons for Why MongoDB is much faster than SQL DBs?
Ok, there are questions about Why Is MongoDB So Fast
I appreciate those answers, however, they are quite general. Yes, I know:
MongoDB is document-based, then why being document-based can lead to
...
54
votes
4
answers
46k
views
Join operation with NOSQL
I have gone through some articles regarding Bigtable and NOSQL. It is very interesting that they avoid JOIN operations.
As a basic example, let's take Employee and Department table and assume the ...