Software Engineering Stack Exchange
Software Engineering Stack Exchange

Questions tagged [nosql]

Databases that propose alternative solution to SQL (Relational) Database which can be document oriented, key/value, graph, objects,...

NoSQL Database means "Not Only SQL" not "No SQL". Those are alternatives to classic relational Database which has been mainly designed to answered to the scaling/performance problem of SQL Databases by loosing some cons of SQL (consistency,...)

Unlike SQL which is standardized and fit only for relational databases. NoSQL database proprose various type of databases :

  1. Key/Value
  2. Document/métadata
  3. Graphs
  4. Objects
  5. ...

Be really carefull about comparing SQL to NoSQL, because since they're many type of NoSQL database and Many Distributor for each of this concept you can't just generally compare them bluntly.

If you need some information about which system to use, write what your system needs and answerers will guide you accordingly to your need.

222 questions
241
votes
13 answers

Why use a database instead of just saving your data to disk?

Instead of a database I just serialize my data to JSON, saving and loading it to disk when necessary. All the data management is made on the program itself, which is faster AND easier than using SQL queries. For that reason I have never understood…
MaiaVictor
  • 5,820
  • 7
  • 27
  • 45
171
votes
9 answers

When would someone use MongoDB (or similar) over a Relational DBMS?

I'm a bit confused about the whole NoSQL thing and such. When would you choose to use something like MongoDB over something like Oracle or MySQL? I don't really understand the "difference" as far as usage goes between them. From my understanding…
user6791
161
votes
4 answers

why are noSQL databases more scalable than SQL?

Recently I read a lot about noSQL DBMSs. I understand CAP theorem, ACID rules, BASE rules and the basic theory. But didn't find any resources on why is noSQL scalable more easily than RDBMS (e.g. in case of a system that requires lots of DB…
ducin
  • 1,729
  • 3
  • 11
  • 7
65
votes
8 answers

Why is NoSQL faster than SQL?

Recently I was asked: Why is NoSQL faster than SQL? I didn't agree with the premise of the question... it's just nonsense for me personally. I can't see any performance boost by using NoSQL instead of SQL. Maybe SQL over NoSQL, yes but not in that…
cnd
  • 1,874
  • 1
  • 14
  • 19
54
votes
8 answers

Is the use of NoSQL Databases impractical for large datasets where you need to search by content?

I've been learning about NoSQL Databases for a week now. I really understand the advantages of NoSQL Databases and the many use cases they are great for. But often people write their articles as if NoSQL could replace Relational Databases. And there…
Leo Lindhorst
  • 862
  • 1
  • 7
  • 8
46
votes
4 answers

Is there anything groundbreaking about NoSQL?

I am a very solid Relational Database guy and understand all the way to 3rd normal form, appreciate the algebraic set theory roots of SQL, and can probably relationalize a broken heart (or not). I haven't figured out a relational database structure…
Samuel Fullman
  • 363
  • 3
  • 8
43
votes
2 answers

best practices for NoSQL database design

I have just started using a NoSQL document based database (MongoDB) and i'm curious about the best practices for designing databases. I presume the architecture should be different from relational databases? Should I still aim for a normalized…
Tom Squires
  • 17,695
  • 11
  • 67
  • 88
34
votes
6 answers

At what size of data does it become beneficial to move from SQL to NoSQL?

As a relational database programmer (most of the time), I read articles about how relational databases don't scale, and NoSQL solutions such as MongoDB do. As most of the databases I have developed so far have been small to mid scale, I have never…
wobbily_col
  • 1,861
  • 3
  • 16
  • 25
32
votes
4 answers

How do you decide what kind of database to use?

I really dislike the name "NoSQL", because it isn't very descriptive. It tells me what the databases aren't where I'm more interested in what the databases are. I really think that this category really encompasses several categories of database. …
Jason Baker
  • 9,625
  • 8
  • 44
  • 67
28
votes
2 answers

NoSQL within SQL Server

This question is not about the difference between SQL and NoSQL. I am looking for some rationale for something that really does not make sense to me at the moment (maybe because of my lack of understanding or appreciation). We have started a new…
Andy Clark
  • 415
  • 6
  • 8
26
votes
5 answers

When should we use MongoDB?

MongoDB is a NoSQL database which I've found quite easy to use. Recently I had to develop a simple application which needed to collect some data using HTTP requests and store some results after processing the data, and I tried using MongoDB. From…
user1620696
  • 4,817
  • 7
  • 31
  • 46
23
votes
8 answers

How would you design a user database with custom fields

This question is around how should I design a database, it can be relational / nosql databases, depending on what will be the better solution Given a requirement where you'll need to create a system that will involve a database to track "Company"…
noobcser
  • 331
  • 1
  • 2
  • 4
17
votes
3 answers

Document Database versus Relational Database : how to choose?

I'm a SQL guy, but I know there is Not Only SQL databases - document-database mostly. As with most technologies there are pro and cons for each technology. I've read some articles, but they were too theorical. What I would like is two real cases…
Johan Buret
  • 281
  • 1
  • 2
  • 10
17
votes
3 answers

Where to put business logic if using Firebase?

I'm about to start developing a single page web application that is very simplified a multi user documentation system. The front end will probably use Angular2. The project has a short deadline, so I've been looking for "shortcuts", i.e. using…
Magnus
  • 405
  • 3
  • 10
15
votes
2 answers

Why NoSQL over SQL?

Possible Duplicate: When would someone use MongoDB (or similar) over traditional RDMS? How well the SQL and NoSQL go head-to-head. I read somewhere that SQL databases are not well for data that is well structured or has some graph-iness…
c0da
  • 1,526
  • 3
  • 12
  • 20
1
2 3
…
14 15