#yessql

[datanewoil]

U-SQL: A new language for Big Data.

[datanewoil]

This idea is not ‘new’ – one can say that federated systems is an old topic. But in fact, in a very heterogeneous environment where businesses (groups) are investing in different solutions, such as Hadoop, relational DW, document-oriented stores (e.g. MongoDB) & legacy OLTP systems – each optimized for different kinds of applications -, such federated capabilities become important. The ability of querying all of your company’s data, independent of where it resides, what format it is stored in, in a performing way is crucial in today’s data-centric world with massive, increasing data volume.

Artin Avanes, Solution Architect at Microsoft - 2015

[datanewoil]

Vendors such as Cloudera, Databricks Inc. (the commercial entity behind Spark), Hortonworks, and MapR, along with IBM Corp. and Teradata, have invested significantly in shoring up Hadoop's ANSI SQL bona fides. Cloudera via its investments in Impala, an interactive SQL-like query engine for Hadoop; Hortonworks via its work with Hive (a SQL interpreter for Hadoop) and Tez (a replacement for Hadoop's MapReduce engine that supports interactive processing); MapR via its work with Drill, the open source implementation of Google Inc.'s Dremel distributed query technology; Databricks and IBM via their investments in Spark (which has its own SQL variant, Spark SQL); and Teradata via its investment in Presto, a SQL query engine for Hadoop. If the data warehouse as an institution is dying, data warehouse architecture -- as a conceptual framework -- is alive and well.

Stephen Swoyer, november 2015 

[datanewoil]

At the present time the continuous availability of data is very important. The downtime of a few seconds can generate a huge loss in business and a company's reputation.

This article cleary ignores the existence of modern SQL databases like HP Vertica, but it has great images and explains NoSQL very well.

 The  continuous availability of data section was my favorite.

At the present time the continuous availability of data is very important. The downtime of a few seconds can generate a huge loss in business and a company's reputation. The best solution to avoid this is to use a distributed approach. NoSQL also works on a distributed approach. In a distributed approach we remove dependency from a single machine and spread it out on several machines. If one or more database servers or "nodes" go down then the other nodes in the system are able to continue with operations without data loss. NoSQL databases work on a distributed approach so a NoSQL database is able to provide continuous availability whether in single locations, across data centers and in the cloud.

[datanewoil]

Our database is different than others. We’re not a pure relational database,” he said. “We’ve always been a bit more designed for high-performance applications. If you follow the database market, the majority of the market in the last year has been about SQL. We have SQL as well, but our technology has been designed to use and take advantage of the non-SQL way to handle the data, so that’s made a difference for us."

Evaldo H. de Oliveira, director of business development at FairCom - August 2015

[thoughtbot]

See you at PostgreSQL West

The PostgreSQL West conference will take place in San Jose, California this upcoming September 27 through the 30th.

There are a few interesting talks for the Ruby crowd. Peter van Hardenberg has a talk titled "PostgreSQL and Ruby: Libraries and their Gaps," Jeremy Evans will talk about the excellent Sequel library, Will Leinweber's talk is about "Exposing the power of PostgreSQL to Ruby", and Ryan Smith will talk about his work on Queue Classic, the PostgreSQL powered queueing library for ruby. I will also be speaking about bacon Redis, as well as giving a full day workshop on Ruby on Rails development with PostgreSQL on September 27th. At $349.00, it's a bargain!

Additionally, there are a bunch of interesting talks about PostgreSQL and its ecosystem, including topics like replication and management tools like repmgr and Tungsten, Bucardo and so much more.

Hope to see you there!