InfoQ Homepage SQL Content on InfoQ
-
Scaling Dropbox
Preslav Le talks about how Dropbox’s infrastructure evolved over the years, how it looks today, as well the challenges and lessons learned on the way.
-
Introduction to Spring Data
Greg Turnquist explains how Spring Data avoids writing data queries by hand and provides the means to avoid SQL lock-in and connect to multiple data stores.
-
But I Need a Database that _Scales_
Aaron Spiegel reviews common scaling techniques for both relational and NoSQL databases, discussing trade-offs of these techniques and their effect on query flexibility, transactions and consistency.
-
Elasticsearch for SQL Users
Shaunak Kashyap looks at several well-understood concepts and SQL queries from the relational paradigm and maps these to their Elasticsearch equivalents.
-
Federated Queries with HAWQ - SQL on Hadoop and Beyond
Christian Tzolov shows different integration approaches between HAWQ and GemFire, showing using Spring XD to ingest GemFire data into HDFS and using Spring Boot to implement a RESTful proxy for HAWQ.
-
Working with Databases & Groovy
Paul King reviews the features in Groovy which make it easy to work with databases - Groovy SQL, datasets -, and working with NoSQL databases such as MongoDB and Neo4J.
-
The New Features in MariaDB 10.0 and in the Upcoming MariaDB 10.1
Michael Widenius walks through the features of MariaDB 10.0 and 10.1, outlining the performance benefits resulting from switching to MariaDB.
-
SQL Strikes Back! Recent Trends in Data Persistence and Analysis
Dean Wampler takes a look at SQL’s resurgence and specific example technologies, including: NewSQL, Hybrid SQL, SQL abstractions on top of file-based data, SQL as a functional programming language.
-
A Distributed Transactional Database on Hadoop
John Leach explains using HBase co-processors to support a full ANSI SQL RDBMS without modifying the core HBase source, showing how Hadoop/HBase can replace traditional RDBMS solutions.
-
SQL on Hadoop - Pros, Cons, the Haves and Have Nots
Ted Dunning discusses the different options for running SQL on Hadoop including pros and cons.
-
A Big Data Arsenal for the 21st Century
In this solutions track talk, sponsored by MongoDB, Matt Asay discusses the differences between some of the NoSQL and SQL databases and when Hadoop makes sense to be used with a NoSQL solution.
-
The Microsoft Cloud OS Data Platform
Anthony Saxby introduces the new capabilities added to SQL Server, SQL Server PDW and HDInsight in the first half of 2014.