ALL COVERED TOPICS

NoSQL Benchmarks NoSQL use cases NoSQL Videos NoSQL Hybrid Solutions NoSQL Presentations Big Data Hadoop MapReduce Pig Hive Flume Oozie Sqoop HDFS ZooKeeper Cascading Cascalog BigTable Cassandra HBase Hypertable Couchbase CouchDB MongoDB OrientDB RavenDB Jackrabbit Terrastore Amazon DynamoDB Redis Riak Project Voldemort Tokyo Cabinet Kyoto Cabinet memcached Amazon SimpleDB Datomic MemcacheDB M/DB GT.M Amazon Dynamo Dynomite Mnesia Yahoo! PNUTS/Sherpa Neo4j InfoGrid Sones GraphDB InfiniteGraph AllegroGraph MarkLogic Clustrix CouchDB Case Studies MongoDB Case Studies NoSQL at Adobe NoSQL at Facebook NoSQL at Twitter

NAVIGATE MAIN CATEGORIES

Close

Google BigQuery: Running SQL-like Queries Against Very Large Datasets

Announced at GigaOm Structure Data event, Google launches a new BigData service named BigQuery:

BigQuery enables businesses and developers to gain real-time business insights from massive amounts of data without any upfront hardware or software investments.

A quick bullet point list of BigQuery features and limitations:

  • BigQuery is ideal for running queries over vast amounts of data—up to billions of rows—with great speed.
  • BigQuery is good for analyzing vast quantities of data quickly, but not for modifying it. In data analysis terms, BigQuery is an OLAP (online analytical processing) system.
  • You can import data into BigQuery as CSV data, where it is stored in the cloud in a relatively small number of tables with no explicit relationship to each other.
  • BigQuery isn’t a database system:
    • It doesn’t support table indexes or other database management features.
    • BigQuery supports a specialized subset of SQL; it doesn’t support update or delete requests.
    • BigQuery supports joins only when one side of the join is much smaller than the other.
  • BigQuery can be used by any client able to send REST commands over the Internet.

After the break you can watch the 15 minutes video recorded at the GigaOm event.

More links:

Original title and link: Google BigQuery: Running SQL-like Queries Against Very Large Datasets (NoSQL database©myNoSQL)