Heroku gussies up Postgres with database roll-back and proactive alerts

  SUMMARY:New Heroku Postgres database service features should free up DBAs to do more meaningful work, said product lead Craig Kerstiens. Heroku’s new Postgres 2.0 database service brings perks — including proactive database monitoring and alerts, and a rollback feature that is more forgiving if there’s a database snafu. The new “unlimited undo” feature, roughly analogous to Apple’s ...

Facebook open sources its SQL-on-Hadoop engine, and the web rejoices

  SUMMARY:Facebook has open sourced Presto, a SQL engine it says is on average 10 times faster than Hive for running queries across large data sets stored in Hadoop and elsewhere. Facebook has open sourced Presto, the interactive SQL-on-Hadoop engine the company first discussed in June. Presto is Facebook’s take on Cloudera’s Impala or Google’s Dremel, and ...

Facebook tells how it makes its MySQL cluster ‘almost run itself’

Facebook has one of the largest, if not the largest, MySQL installations in the world, and has created a tool to keep that system online with as little human intervention as possible. It’s called MySQL Pool Scanner and, Facebook’s Shlomo Priymak wrote in a post on Monday describing it, it’s designed to automate ”nearly everything a conventional MySQL ...

How to Get Started in Data Science

A lot of people ask me: how do I become a data scientist? I think the short answer is: as with any technical role, it isn’t necessarily easy or quick, but if you’re smart, committed and willing to invest in learning and experimentation, then of course you can do it. In a previous post, I described my ...

Oracle, the leader in relational databases, is playing catchup everywhere else

  photo: Getty Images SUMMARY:Oracle leads the league in relational databases but it’s far from clear that the company can replicate its success in non-relational and in-memory categories. That’s why Larry Ellison’s no-show matters. You’ve got to hand it to Larry Ellison. The Oracle CEO has his priorities and so when it came down to a ...

What to know when choosing database as a service

This report underwitten by: Clustrix In the past couple of years, we’ve seen more innovation in the SQL database management system (DBMS) category than in the 30-plus years since commercial products became available. The past decade’s web 2.0 sites have mostly driven this innovation, which looks to bridge some of the gap between NoSQL DBMS ...

The hot new technology in Big Data is decades old: SQL

The decades-old database technology is staging a comeback. A slide from a presentation at Hadoop Summit describes HortonWorks’ Stinger initiative, an effort to make SQL work better with Hadoop through Apache Hive. Jason Levitt Despite the growth of “NoSQL” databases over the past few years, SQL is going nowhere isn’t going anywhere. In fact, it seems Structured ...

Evolving Hadoop ecosystem presents new ways to program big data apps

The Hadoop ecosystem is a body in motion. Just a few years ago, you might quickly but fairly describe Hadoop as “HDFS, MapReduce and some glue” — referring to the Hadoop Distributed File System, its associated software programming model and an emerging collection of APIs and utilities, which together were becoming synonymous with big data systems. What ...

Why use a database instead of just saving your data to disk?

For smaller projects, is a database worth it? Stack Exchange This Q&A is part of a weekly series of posts highlighting common questions encountered by technophiles and answered by users at Stack Exchange, a free, community-powered network of 100+ Q&A sites. Dokkat appears to think that databases are overused. “Instead of a database, I just serialize my data ...

Teradata gets into the in-memory biz to take on SAP’s HANA

  photo: Shutterstock / Hellen Sergeyeva SUMMARY:Teradata is trying to steal some thunder in the in-memory analytics space with a new technology called Intelligent Memory that places hot data in RAM while dispersing the rest across solid-state drives and disk. Data analytics veteran Teradata will not let the new era of data-analysis architectures pass it by ...