The concept of database sharding has gained popularity over the past several years due to the enormous growth in transaction volume and size of business-application databases. This is particularly ...

With the proliferation of private markets databases, chances are that your firm and fund have a profile or two whether you’ve built them yourself or not. This article can help you understand the value ...

Most applications need some form of persistence—a way to store the data outside the application for safekeeping. The most basic way is to write data to the file system, but that can quickly become a ...

Surrogate means a stand-in, a substitute. Surrogate keys take the place of a natural key as the primary key within a database table. Ideally, surrogate keys stand in the shadows and are used in ...

In the era of big data, good old RDBMS is no longer the right tool for many database jobs. Here's a quick guide to choosing among NoSQL alternatives I’ve been in Chicago for the last few weeks setting ...