Database vendors have been advocating data partitioning techniques for managing large volumes of data over the past several years. Oracle has pioneered this trend with Oracle Database 8 and improved ...

Partitioning can provide a number of benefits to a sharding system, including faster query execution. Let’s see how it works. In a previous post, I described a sharding system to scale throughput and ...

Horizontal partitioning separates rows by key fields; for example, all Arizona records are maintained in one index and New Mexico records in another, etc., or account numbers from 00001 to 49999 in ...

I get this request a lot: We have a single, huge database and want to keep part of the data on-premises and part of the data in the cloud. Is that possible? Of course. Enough time and money can solve ...