InfoQ Homepage Database Design Content on InfoQ
-
MySQL Usage of Web Applications with 1 User and 100 Million
Peter Boros discusses a MySQL architecture useful for the majority of projects, backup, online schema changes, reliability and scalability issues, and basics of sharding.
-
In-Memory Message & Trade Repositories
John Davies walks through a reference implementation of a in-memory database meant to combine dozens of different legacy databases developed by banks over time.
-
Scaling Pinterest
Yashwanth Nelapati and Marty Weiner share lessons learned growing Pinterest: sharding MySQL, caching, server management, all on Amazon EC2.
-
A Relational Database System in which Joins Cost Zero
Ori Herrnstadt introduces the Akiban database which solves the problem of joins and combines the best of relational and document databases.
-
Building a Cloud Ecosystem Architecture
Chris Haddad discusses cloud computing, PaaS, multi-tenancy, cloud ecosystems, cloud aware APIs from the perspective and the benefits it can provide to the business.
-
Executing Queries on a Sharded Database
Neha Narula provides advice on choosing a data store for a web applications and executing distributed queries.
-
Deconstructing the Database
Rich Hickey deconstructs the monolithic database into separate services, transactions, storage, query, combining them with a data model based on atomic facts to provide new capabilities and tradeoffs.
-
Understanding Indexing Without Needing to Understand Data Structures
Zardosht Kasheff suggest using 3 rules for indexing SQL databases: Retrieve less data, Avoid point queries, and Avoid sorting.
-
Writing Datomic in Clojure
Rich Hickey introduces Datomic, including architectural and implementation details.
-
The Database as a Value
Rich Hickey discusses the complexity introduced by a database into a system, and a way to deal with it by using Datomic. He also discusses immutability, epochal time, and persistent data structures.
-
Securing OAuth2-Enabled, Multi-Tenant Applications with Spring Security
Robert Winch explains how to secure a multi-tenant application with Spring Security and how to enable OAuth 2.
-
The Design of Datomic
Rich Hickey discusses the design decisions made for Datomic, a database for JVM languages: what problems they were trying to solve with it, the solutions chosen, and their implementations.