Feeds

Google makes BigQuery easier to question

SQL commands let devs probe BigQuery AaaS

3 Big data security analytics techniques

Google has updated its BigQuery cloud analytic service to make it attractive to people familiar with SQL.

The new features for the analytics-as-a-service (AaaS) – Big JOIN, Big Group Aggregations, and support for the TIMESTAMP data type – were released by Google on Thursday.

They are designed to cut the steps developers need to take in analysing large amounts of data, and make the technology easier to deal with.

"In response to developer feedback, we're launching new features that enable analysts and developers to run fast SQL-like join and aggregate queries on datasets without the need for batch-based processing," Michael Manoochehri a developer programs engineer for the Google cloud platform, wrote.

Google, like many other tech pioneers, has spent the past half-decade bingeing on NoSQL systems, but like any reformed glutton has realized that this may not have been wise.

The BigQuery update can be considered another way the Chocolate Factory is paying penance for its binge, alongside its move back to SQL-like systems on its internal platform with the introduction of Spanner and F1.

Previously, BigQuery made developers run analytics atop a single (very large) table. But as many people keep their data in all sorts of different tables this made porting stuff into BigQuery painful.

Google has now done away with this, and the analytics service lets developers use standard JOIN functions to link multiple tables of data together.

"Big JOIN simplifies data analysis that would otherwise require a data transformation step, by allowing users to specify JOIN operations using SQL," Manoochehri wrote.

Google has also launched Big Group Aggregations, which lets you put a larger number of distinct values into a result set. In a further bout of SQL-slathering, timestamp data can now be imported as well, he wrote.

Google launched BigQuery in a beta in 2011, and the AaaS became available for general prodding in May 2012. It can support queries across hundreds of terabytes, but so far Google has not provided developers with a feasible way to actually get that much data into its cloud.

The updates all go to make BigQuery more attractive to developers – a key consideration for Google as it tries to generate enthusiasm for its cloud platform while fighting rivals Amazon and Microsoft on price on multiple fronts. ®

SANS - Survey on application security programs

More from The Register

next story
This time it's 'Personal': new Office 365 sub covers just two devices
Redmond also brings Office into Google's back yard
Kingston DataTraveler MicroDuo: Turn your phone into a 72GB beast
USB-usiness in the front, micro-USB party in the back
Dropbox defends fantastically badly timed Condoleezza Rice appointment
'Nothing is going to change with Dr. Rice's appointment,' file sharer promises
BOFH: Oh DO tell us what you think. *CLICK*
$%%&amp Oh dear, we've been cut *CLICK* Well hello *CLICK* You're breaking up...
Just what could be inside Dropbox's new 'Home For Life'?
Biz apps, messaging, photos, email, more storage – sorry, did you think there would be cake?
IT bods: How long does it take YOU to train up on new tech?
I'll leave my arrays to do the hard work, if you don't mind
Amazon reveals its Google-killing 'R3' server instances
A mega-memory instance that never forgets
Cisco reps flog Whiptail's Invicta arrays against EMC and Pure
Storage reseller report reveals who's selling what
prev story

Whitepapers

Designing a defence for mobile apps
In this whitepaper learn the various considerations for defending mobile applications; from the mobile application architecture itself to the myriad testing technologies needed to properly assess mobile applications risk.
3 Big data security analytics techniques
Applying these Big Data security analytics techniques can help you make your business safer by detecting attacks early, before significant damage is done.
Five 3D headsets to be won!
We were so impressed by the Durovis Dive headset we’ve asked the company to give some away to Reg readers.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Securing web applications made simple and scalable
In this whitepaper learn how automated security testing can provide a simple and scalable way to protect your web applications.