Share on LinkedInTweet about this on TwitterShare on Google+Share on FacebookShare on Reddit
Auto Trader logo Thoughworks

Putting Google BigQuery to the test

ThoughtWorks wanted to road test Google BigQuery so we worked with a UK big data client, Auto Trader, the top UK site for buying and selling cars online. We gave three people five days and the top-of-mind questions for Auto Trader’s dealers. With five years’ historical data, over 750 million rows of data, they set to work.

We asked: Can Google’s new BigQuery service give customers Big Data analytic power without the need for expensive software or new infrastructure?

The tests showed consistent query performance in the 7-10 second range. We used the REST APIs with Java, JavaScript and Google Charts to create a web front-end with interactive visuals of query results.

The verdict: BigQuery performed well, and could benefit organizations with Big Data and smaller budgets — especially those without a data warehouse, or whose data warehouse has restricted use.

Download the complete case study for the details of how we tested, and more findings.

View the full case study (PDF)

75% Reduction in Testing Time, and a 95% Reduction in Testing Effort

Testing was growing unwieldy for AutoTrader.co.uk, the UK’s #1 automotive website, with multiple tools, lack of automation, and increasing test maintenance. Twist removed the biggest pain-point, by drastically reducing the overhead of test maintenance. With Twist, the team could add real value, and tested new functionality at a rapid pace

View the full case study (PDF)

Original Source: Thoughtworks.com

Share on LinkedInTweet about this on TwitterShare on Google+Share on FacebookShare on Reddit

Blog Publisher / Head of Data Science Search

Founder & Head of Data Science Search at Starbridge Partners, LLC.