InfoQ Homepage SQL Content on InfoQ
-
Presto-as-a-Service: Interactive SQL Queries on AWS
Presto, a technology from Facebook enabling interactive SQL queries on petabytes of data, has now taken a first step into mainstream adoption. Big Data startup Qubole has launched its Presto-as-a-Service alpha with integration to Amazon Web Services.
-
Open Source SQL-in-Hadoop Solutions: Where Are We?
With Facebook recently releasing Presto as open source, the already crowded SQL-in-Hadoop market just became a tad more intricate. A number of open source tools are competing for the attention of developers: Hortonworks Stinger initiative around Hive, Apache Drill, Apache Tajo, Cloudera’s Impala, Salesforce’s Phoenix (for HBase) and now Facebook’s Presto.
-
Cascading 2.5 Supports Hadoop 2
New version of Cascading released this week incorporates Hadoop 2 support and includes Cascading Lingual - an open source project that provides a comprehensive ANSI SQL interface for accessing Hadoop-based data
-
Presto: Facebook’s Distributed SQL Query Engine
Facebook has open-sourced Presto, their distributed SQL query engine. Presto uses a pipelined architecture rather than the Map/Reduce design found elsewhere. In production since early this year, Facebook has since “deployed in multiple geographical regions and [they] have successfully scaled a single cluster to 1,000 nodes”.
-
SQL Makes a Comeback through NewSQL
New database developments indicate a return to SQL, but not by running the traditional relational stores on bigger and better hardware, not even on sharded architectures, but through NewSQL solutions.
-
NuoDB Blackbirds 2.0 Gets Geo-distributed Capability
NuoDB has announced version 2.0 of their NewSQL database, now a globally distributed database that can run in the cloud or on premises with real-time replication.
-
Entity Framework 6 RC Adds SQL Logging, Testability Improvements and New IntelliSense Documentation
Microsoft has released release candidate version of Entity Framework 6 with support for interception, SQL logging, testability improvements. It also includes substantial changes to API, IntelliSense documentation.
-
Google Extends Their Services with Cloud SQL
Google is making MySQL available in the cloud as a fully managed service, including a JSON API for programmatic management.
-
NuoDB 1.1 Targets .NET Developers
NuoDB 1.1 includes a ADO.NET driver, LINQ and EF providers, support for Windows 64-bit and Azure, performance improvements.
-
Greenplum Pivotal HD Combines the Strengths of SQL and Hadoop
EMC Greenplum has announced Pivotal HD, a new Hadoop distribution including a fully compliant SQL MPP database running on HDFS and being “hundreds of times faster than Hive”.
-
Phoenix: Running SQL Queries on Apache HBase [Updated]
Salesforce.com has open sourced Phoenix, a Java layer enabling developers to run SQL queries on Apache HBase. Update: An interview on Phoenix with James Taylor, Lead Developer at Salesforce.com, has been appended.
-
Hekaton: In-Memory Transaction Processing Integrated with SQL Server
During the PASS Summit 2012, a technical conference for SQL Server professionals, Microsoft announced Hekaton, an in-memory row-based data management system targeted at transaction processing (TP) workloads. Besides the advertised increase in TP speeds of up to 10x for old applications and up to 50x for new optimized ones, Microsoft touts Hekaton as being fully integrated into SQL Server.
-
News from O’Reilly Strata Conference + Hadoop World 2012: Azure HDInsight, Cloudera Impala, MapR M7
Several new Hadoop-based frameworks where announced during this year O’Reilly Strata Conference + Hadoop World 2012 in New York last week.
-
FluentData: A New, Lightweight ORM with a Fluent API
FluentData is a new introduction to the micro-ORM family that aims to be more straightforward to use than full ORMs like NHibernate and Entity Framework. It uses a fluent API and supports SQL Server, SQL Azure, Oracle, and MySQL.
-
Hybrid SQL-NoSQL Databases Are Gaining Ground
Hybrid SQL-NoSQL database solutions combine the advantage of being compatible with many SQL applications and providing the scalability of NoSQL ones. Xeround offers such a solution as a service in the cloud, including a free edition. Other solutions: Database.com with ODBC/JDBC drivers, NuoDB, Clustrix, and VoltDB.