Feeds

Google's BigQuery gets data slurping capability

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

3 Big data security analytics techniques

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. ®

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
AMD's 'Seattle' 64-bit ARM server chips now sampling, set to launch in late 2014
But they won't appear in SeaMicro Fabric Compute Systems anytime soon
Brit boffins use TARDIS to re-route data flows through time and space
'Traffic Assignment and Retiming Dynamics with Inherent Stability' algo can save ISPs big bucks
prev story

Whitepapers

Mainstay ROI - Does application security pay?
In this whitepaper learn how you and your enterprise might benefit from better software security.
Combat fraud and increase customer satisfaction
Based on their experience using HP ArcSight Enterprise Security Manager for IT security operations, Finansbank moved to HP ArcSight ESM for fraud management.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Top three mobile application threats
Learn about three of the top mobile application security threats facing businesses today and recommendations on how to mitigate the 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.