Google makes BigQuery available to all

01.05.2012
BigQuery, a cloud-based service from Google for analyzing very large sets of data, is now publicly available after a period of limited-availability testing, Google on Tuesday.

is an online analytical processing (OLAP) system able to crunch data sets with billions of rows containing terabytes of data and is aimed at businesses and enterprise developers that need to slice and dice "big data" in real time, according to Google.

Users can tap into the Big Query service via several methods, including a Web-based user interface, a REST API (application programming interface) and a command-line tool. Data can be imported into the Google BigQuery servers in CSV format.

Pricing varies according to the amount of data being stored and the volume of queries processed. Details are .

Some early testers of BigQuery have built applications on it, according to Google. For example, a company called Claritics created a tool that lets game developers analyze user-behavior data in real time.

Big Query isn't for OLTP (online transaction processing) tasks, nor suitable for making changes to the data sets stored on it. For companies that need a more traditional relational SQL database for managing small and medium data sets in OLTP scenarios, Google instead recommends its cloud-based database , which supports full SQL syntax and tables.