Feeds

Google inflates BigQuery AaaS

Bigger, faster, more queries

Build a business case: developing custom apps

Google has expanded its BigQuery analytics-as-a-service product via price cuts, new features, and more sophisticated commands.

The upgrades to BigQuery were announced by Google on Tuesday, and see the company let BigQuery output query results of larger than 128MB, along with being able to ask it more sophisticated queries.

Prices have also been cut, with data-storage costs falling from $0.12 per gigabyte per month to $0.08, with further pricing plans coming in the future for "high-volume users," Google developer programs engineer Felipe Hoffa wrote in a blog post.

"These updates make BigQuery a faster, smarter, and even more affordable solution for ad hoc analysis of extremely large datasets," Hoffa wrote.

BigQuery is Google's remote analytics service, and is the external implementation of the Chocolate Factory's proprietary "Dremel" data analysis tool.

Dremel can scan 35 billion rows without an index "in tens of seconds," Google says, because of its use of columnar data storage and a tree architecture for dispatching queries across thousands of machines.

Now, BigQuery has been given the ability to output results larger than 128MB of compressed data, via the -allow_large_results flag which shoves it into a destination table.

It has also gained more analytical tricks via the "window functions" feature, which let you rank results and use distributions and percentiles.

These changes follow Google making the service more attractive to traditional developers in March via an expanded range of SQL commands. BigQuery will now cache results on a per-user basis for up to 24 hours as well, Google said.

To make sure developers don't break the bank on expensive or ineffecient queries, Google rolled out a tool that can validate a query and estimate its cost prior to running, allowing analysts to make changes before they spend their cash.

The features are being rolled out on Tuesday, and the new prices will take effect in July.

Build a business case: developing custom apps

More from The Register

next story
Sysadmin Day 2014: Quick, there's still time to get the beers in
He walked over the broken glass, killed the thugs... and er... reconnected the cables*
Auntie remains MYSTIFIED by that weekend BBC iPlayer and website outage
Still doing 'forensics' on the caching layer – Beeb digi wonk
Microsoft says 'weird things' can happen during Windows Server 2003 migrations
Fix coming for bug that makes Kerberos croak when you run two domain controllers
Cisco says network virtualisation won't pay off everywhere
Another sign of strain in the Borg/VMware relationship?
VVOL update: Are any vendors NOT leaping into bed with VMware?
It's not yet been released but everyone thinks it's the dog's danglies
prev story

Whitepapers

Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Consolidation: The Foundation for IT Business Transformation
In this whitepaper learn how effective consolidation of IT and business resources can enable multiple, meaningful business benefits.
Backing up Big Data
Solving backup challenges and “protect everything from everywhere,” as we move into the era of big data management and the adoption of BYOD.
Boost IT visibility and business value
How building a great service catalog relieves pressure points and demonstrates the value of IT service management.
Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.