Feeds

Google's BigQuery gets data slurping capability

'Streaming' feature lets it suck rows rather than nosh batches

Secure remote control for conventional and virtual desktops

Instead of having to upload stuff into the Google cloud and then feed it through to BigQuery, cloud wranglers can now stream data directly into the Chocolate Factory's analytics-as-a-service tech.

Google announced the "streaming data" update to BigQuery on Wednesday and it means admins can pour data into the service and start analysing it quickly, rather than waiting to upload it into the Google cloud storage layer in bulk.

Doing this speeds access to data and real-time insertions, Google says, but risks "possible data duplication" and "possible connection drops."

Appropriate applications for the service include ones that are constantly generating data that needs need quick-turnaround analysis, such as dashboards.

"The new data is available for querying instantaneously. This feature is great for time sensitive use cases like log analysis and alerts generation," Felipe Hoffa, a Google developer programs engineer, said.

However, limits apply for streaming: the system can ingest 100 rows per second, per table, though Google will permit "occasional bursts of up to 1,000 rows per second." The maximum row size is 100KB and the maximum data size per streaming insert is 1MB.

The upgrade follows Google introducing SQL-like commands such as JOIN into the technology in March, and cutting the price of data storage costs from $0.12 per gigabyte to $0.08 in June.

Streaming data will be free until January 1, 2014, at which point it will cost 1 cent per 10,000 rows inserted, Google wrote. ®

Secure remote control for conventional and virtual desktops

More from The Register

next story
BOFH: WHERE did this 'fax-enabled' printer UPGRADE come from?
Don't worry about that cable, it's part of the config
Azure TITSUP caused by INFINITE LOOP
Fat fingered geo-block kept Aussies in the dark
You think the CLOUD's insecure? It's BETTER than UK.GOV's DATA CENTRES
We don't even know where some of them ARE – Maude
Want to STUFF Facebook with blatant ADVERTISING? Fine! But you must PAY
Pony up or push off, Zuck tells social marketeers
The cloud that goes puff: Seagate Central home NAS woes
4TB of home storage is great, until you wake up to a dead device
Yahoo! blames! MONSTER! email! OUTAGE! on! CUT! CABLE! bungle!
Weekend woe for BT as telco struggles to restore service
prev story

Whitepapers

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.
Getting started with customer-focused identity management
Learn why identity is a fundamental requirement to digital growth, and how without it there is no way to identify and engage customers in a meaningful way.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
The next step in data security
With recent increased privacy concerns and computers becoming more powerful, the chance of hackers being able to crack smaller-sized RSA keys increases.
Storage capacity and performance optimization at Mizuno USA
Mizuno USA turn to Tegile storage technology to solve both their SAN and backup issues.