RSS A lot has been written by people about the benefits and disadvantages of relational databases and NoSQL.
A very well thought out and fact based article can be found on Quora with the title, “Why does Quora use MySQL as the data store instead of NoSQLs such as Cassandra, MongoDB, CouchDB etc?”
There are [...]
A commonly adopted strategy to address the lack of scalability in relational databases is to “shard” the data.
Sharding is a horizontal partitioning strategy where data in fact tables is divided up into non-overlapping subsets, and these subsets are each stored on a different database. At its core, sharding is a natural reaction to the fact that relational database performance degrades as data volumes increase. If your database behaves worse with more data, give it less data. [...]
Currently available solutions [sic] to database scalability problems can be grouped broadly into four types:
Scale Up Solutions Scale Out Solutions Non-Relational Solutions Accelerators Scale-Up Solutions
Scale-Up solutions are based on simple logic, get bigger hardware. Or, as Arthur Bloch puts it,
“Don’t force it … Get a bigger hammer.”
- Arthur Bloch, the author [...]
In the context of databases we often use terms like scalability, and speak of “scale-up” and “scale-out”. These terms are often misunderstood. In the previous post, we focused on the terms “Scale-Up” and “Scale-Out”, and in this post will talk about scalability. In the next post, we describe some common solutions to scalability problems.
There are a large class of database operations where the performance degrades rapidly as data volumes increase. For example, the worst case time to join two tables degrades exponentially as the size of the tables increases. [...]
This is the first of three posts that address the issue of Scalability in databases. In this post, we focus on the terms “Scale-Up” and “Scale-Out”, and the next post will discuss scalability itself, and the final post will describe some current solutions to scalability challenges.
In the context of databases we often use terms [...]
We continue to accumulate data at an enormous rate. It is generally accepted that the amount of data that is accumulated each year is growing according to Moore’s Law.
The amount of all digital data created last year, if put on DVDs and stacked, would reach all the way to the moon and back.
The [...]
Watch Video
Learn how to Flex Your Database with ParElastic.
Download White Paper:
Flexibility: The Future of Database Technology
