Google's BigQuery brings big data to the cloud

Google revealed more about its data analysis service at the New York GigaOm data conference

While most of the talk around big data assumes such systems will be deployed in-house, Google is building a service that will allow for analyzing large amounts of data in the cloud.

The service, called BigQuery, would help organizations analyze their data without the need for building infrastructure, explained Google product manager Ju-Kay Kwek, speaking at the GigaOm Structure Data conference being held this week in New York.

With BigQuery, "you can build applications and share data all as a service," Kwek said. Google now offers the service in a limited preview mode for a handful of customers. Kwek did not say when the service would be fully available.

Google executives saw a natural opportunity to offer a query service because they already had developed some of the needed tools for internal use. "Indexing the Web is a big data problem to begin with," Kwek said. The company also does a lot of analysis of how people use its services such as Gmail. Operational data can provide glimpses into what features are or are not working.

Google's key to successful analysis is to keep all the data it generates. "The fine-grain data is key," Kwek said. In many cases, Google engineers do not know which questions to ask beforehand when it comes to querying its data. The key is to ask lots of questions. "The more questions you can quickly ask, the smarter those questions get," he said.

The trial users are testing the service in various ways. Customers will upload a set of data and then stream updates to the data set as they become available. They then can use Google's algorithms and query language to parse the data sets. Online ad providers use the service to collect a range of data about what actions users are doing and collect metrics to see how successful their ads are doing. Another customer, a hotel, uses the data to manage revenue data, mashing up information from different financial systems to make fiscal projections.

The cloud model for big data offers a number of benefits, Kwek said. Most notably, it eliminates the need for an organization to provision and set up a data warehouse.

"We take care of all the plumbing," Kwek said.

Security and data back-up are included in service. As a result, using a service could "reduce the time to insight," Kwek said.

One user is We Are Cloud, a company based in Montpellier, France, that offers business intelligence capabilities as a cloud service. The service, called Bime, is marketed at small and medium-sized businesses that may not have the staff to maintain an in-house business intelligence system. The service's dashboard can draw information from multiple sources, such as in-house relational databases. Customers "want tools to become self-aware," said Rachel Delacour, CEO and co-founder of We Are Cloud.

The company became a beta user, allowing it to offer BigQuery to its customers. One customer, an unnamed telecommunications company located in the Middle East, uploaded 15 terabytes of customer data that it could then analyze using Bime. Delacour said she could not reveal how much Google charges to host the data, but says the rate has been quite reasonable.

"It makes sense in a dynamic environment. It gives you near [real-time] response on top of very large data sets," Delacour said of BigQuery, in an interview following her presentation.

Joab Jackson covers enterprise software and general technology breaking news for The IDG News Service. Follow Joab on Twitter at @Joab_Jackson. Joab's e-mail address is Joab_Jackson@idg.com

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.
Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Joab Jackson

IDG News Service
Show Comments

Essentials

Brother MFC-L3745CDW Colour Laser Multifunction

Learn more >

Mobile

Exec

Budget

Back To Business Guide

Click for more ›

Brand Post

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Tom Pope

Dynabook Portégé X30L-G

Ultimately this laptop has achieved everything I would hope for in a laptop for work, while fitting that into a form factor and weight that is remarkable.

Tom Sellers

MSI P65

This smart laptop was enjoyable to use and great to work on – creating content was super simple.

Lolita Wang

MSI GT76

It really doesn’t get more “gaming laptop” than this.

Jack Jeffries

MSI GS75

As the Maserati or BMW of laptops, it would fit perfectly in the hands of a professional needing firepower under the hood, sophistication and class on the surface, and gaming prowess (sports mode if you will) in between.

Taylor Carr

MSI PS63

The MSI PS63 is an amazing laptop and I would definitely consider buying one in the future.

Christopher Low

Brother RJ-4230B

This small mobile printer is exactly what I need for invoicing and other jobs such as sending fellow tradesman details or step-by-step instructions that I can easily print off from my phone or the Web.

Featured Content

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?