InfoQ Homepage SQL Content on InfoQ
-
Core.logic and SQL Killed my ORM
Craig Brozefsky presents the tradeoffs involved with moving to a purely SQL relational model, instead of using an ORM, along with some of the tools built to facilitate this.
/presentations/Core-logic-SQL-ORM/en/mediumimage/Brobig.jpg)
-
Integrating SQL & NoSQL & NewSQL & Realtime Data Intelligence for the Financial Industry
Charles Cai, Ashwani Roy discuss a robust, cost effective, hypothetical solution to address extreme challenges in financial institutions, from decision making support to pricing and risk management.
/presentations/finance-sql-nosql-newsql/en/mediumimage/DOibig.jpg)
-
Scaling Pinterest
Yashwanth Nelapati and Marty Weiner share lessons learned growing Pinterest: sharding MySQL, caching, server management, all on Amazon EC2.
/presentations/Pinterest/en/mediumimage/Martybig.jpg)
-
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.
/presentations/MySQL-NoSQL-Data-Modeling/en/mediumimage/Andersonbig.jpg)
-
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.
/presentations/Percona-MySQL-Cloud-1/en/smallimage/Koa.JPG)
-
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.
/presentations/NoSQL-History/en/smallimage/Eric.JPG)
-
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.
/presentations/Index-SQL/en/smallimage/Zar.JPG)
-
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.
/presentations/NewSQL-VoltDB/en/smallimage/Mike.JPG)
-
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.
/presentations/SQL-NoSQL-Grid-Cache/en/smallimage/John.JPG)
-
Banking Case Study: Scaling with Low Latency using NewSQL
Jags Ramnarayan and Jim Bedenbaugh present the case of a bank who adopted SQLFire, covering the business requirements, the scalability issues, patterns used and the chosen solution.
/presentations/Banking-Case-Study-Scaling-with-Low-Latency-using-NewSQL/en/smallimage/vm.jpg)
-
How to get the most out of Spring and Google App Engine
Chris Ramsdale shows how to build Spring apps on Google App Engine, covering performance Google SQL Service and other advanced topics.
/presentations/get-the-most-out-of-Spring-and-Google-App-Engine/en/smallimage/Chris.JPG)
-
Using MongoDB on Mono
Justin Dearing introduces MongoDB, and shows how to interact with Mono via the official 10gen driver. Techniques for handling business logic in application code, such as LINQ are discussed.
/presentations/using-MongoDB-on-Mono/en/smallimage/Dearing.jpg)