InfoQ Homepage Relational Databases Content on InfoQ
-
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.
-
MySQL to NoSQL: Data Modeling Challenges in Supporting Scalability
Kenneth M. Anderson shares some of the data modeling issues encountered while transitioning from a relational database to NoSQL.
-
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.
-
How Percona Helps MySQL Succeed in the Cloud
Koa McCullough presents best practices for running Percona Server and MySQL in the cloud, cloud backups using EBS, Xtrabackup and S3, using Percona Toolkit to simplify operations, and XtraDB Cluster.
-
Postgres Demystified
Craig Kerstiens presents the history of Postgres, the basics of developing with Postgres, notes on its performance, and tips on querying it.
-
NoSQL: Past, Present, Future
Eric Brewer takes a look at NoSQL’s history and considers what should be done so the current NoSQL solutions to evolve in order to address the full range of the application needs.
-
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.
-
Not Your Father’s Transaction Processing
Michael Stonebraker compares how RDBMS, NoSQL and NewSQL support today’s big data transaction processing needs. He also introduces VoltDB, an in-memory NewSQL database.
-
The Impedance Mismatch is Our Fault
Stuart Dabbs Halloway explains what the impedance mismatch is and what can be done to solve it in the context of RDBMS, OOP, and NoSQL.
-
Caching, NoSQL & Grids - What the Banks Can Teach Us
John Davies shares insight into SQL, NoSQL, grid, virtualization and caching technologies from his personal experience using them in financial institutions.
-
Choose the "Right" Database and NewSQL: NoSQL Under Attack
Talk #1: Stefan Edlich suggests choosing a NoSQL DB after answering about 70 questions in 6 categories, and building a prototype. Talk #2: Edlich presents NewSQL solutions counteracting NoSQL.