Questions tagged [non-relational-database]

Non-relational databases is a generic descriptor for data stores which do not adhere to the relational database paradigm.

Non-relational databases is a generic descriptor for data stores which do not adhere to the relational database paradigm. Individual products classified as "non-relational" could be any data stores which would more-accurately be described under the "NoSQL" (Not only SQL), graph databases, or "NewSQL" classifications.

Examples of non-relational databases-

NoSQL: Cassandra, MongoDB, Bigtable, Dynamo

NewSQL: FaunaDB, Yugabyte, CockroachDB, Spanner

graph: Neo4j, JanusGraph, ArangoDB

175 questions
210
votes
9 answers

Why should I use document based database instead of relational database?

Why should I use document based database like CouchDB instead of using relational database. Are there any typical kinds of applications or domains where the document based database is more suitable than the relational database?
Bartosz Blimke
  • 6,498
  • 3
  • 24
  • 19
196
votes
8 answers

Storing time-series data, relational or non?

I am creating a system which polls devices for data on varying metrics such as CPU utilisation, disk utilisation, temperature etc. at (probably) 5 minute intervals using SNMP. The ultimate goal is to provide visualisations to a user of the system in…
117
votes
2 answers

Difference between Document-based and Key/Value-based databases?

I know there are three different, popular types of non-sql databases. Key/Value: Redis, Tokyo Cabinet, Memcached ColumnFamily: Cassandra, HBase Document: MongoDB, CouchDB I have read long blogs about it without understanding so much. I know…
never_had_a_name
  • 90,630
  • 105
  • 267
  • 383
85
votes
8 answers

What is the difference between a Relational and Non-Relational Database?

MySQL, PostgreSQL and MS SQL Server are relational database systems, and NoSQL, MongoDB, etc. are non-relational DBMSs. What are the differences between the two types of system?
marcamillion
  • 32,933
  • 55
  • 189
  • 380
55
votes
8 answers

The Next-gen Databases

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 the next database technologies to deal with?
Randin
  • 1,875
  • 3
  • 17
  • 14
43
votes
3 answers

Relational vs. Dimensional Databases, what's the difference?

I'm trying to learn about OLAP and data warehousing, and I'm confused about the difference between relational and dimensional modeling. Is dimensional modeling basically relational modeling, but allowing for redundant/un-normalized data? For…
32
votes
2 answers

What is the recommended equivalent of cascaded delete in MongoDB for N:M relationships?

Assuming the following "schema/relationship" design what is the recommended practice for handling deletion with cascade delete like operation? Relational Schema: +---------+ +--------+ | Student…
28
votes
23 answers

What is an example of a non-relational database? Where/how are they used?

I have been working with relational databases for sometime, but it only recently occurred to me that there must be other types of databases that are non-relational. What are some examples of non-relational databases, and where/how are they used in…
Kip
  • 107,154
  • 87
  • 232
  • 265
20
votes
1 answer

How to use Firebase as a relational database with generated keys (JS)?

I'm working on a simple JavaScript Twitter clone utilizing Firebase as the backend storage mechanism (JSON). I am familiar with relational databases (SQL) but not with non-relational databases. I am currently trying to work out how to design the…
Kendall
  • 1,992
  • 7
  • 28
  • 46
19
votes
3 answers

Relational vs Non-Relational Data Modeling

I have a user database with the following properties for each user: user id name zip city In a relational database I would model it in a table user: user id name location_id and have a second table called location: location id zip city and…
18
votes
5 answers

Do graph databases deprecate relational databases?

I'm new to DBs of any kind. It seems you can represent any relational database in graph form (although it might be a very flat graph), and any graph database in a relational database (with enough tables). A graph can avoid a lot of lookups in other…
David
  • 27,652
  • 18
  • 89
  • 138
16
votes
2 answers

Mongo db using result of query in another query using $in

I have the following model in mongo db: User collection { _id:12345, name:"Joe", age:15, } Addresses collection { _id:7663, userId:12345, Street:"xyz", number:"1235", city:"New York", state:"NY" } Now I want to get all the addresses of users above…
15
votes
2 answers

MongoDB / NOSQL: Best approach to handling read/unread status on messages

Suppose you have a large number of users (M) and a large number of documents (N) and you want each user to be able to mark each document as read or unread (just like any email system). What's the best way to represent this in MongoDB? Or any other…
Ian Mercer
  • 38,490
  • 8
  • 97
  • 133
14
votes
3 answers

Strategic issue: Mixing relational and non-relational db?

There has been a lot of talk about contra-revolutionary NoSQL databases like Cassandra, CouchDB, Hypertable, MongoDB, Project Voldemort, BigTable, and so many more. As far as I am concerned, the strongest pros are scalability, performance and…
Ta Sas
  • 9,573
  • 15
  • 51
  • 73
13
votes
4 answers

Deploying and hosting scala in the cloud?

I am starting a web app considering scalability as one of the top priorities. What would be the benefits of this: cassandra scala lift vs the traditional LAMP on the cloud? Since from what I've read, please correct me, the cloud itself is scalable I…
TiansHUo
  • 8,509
  • 7
  • 45
  • 57
1
2 3
11 12