Videos tagged with SQL

noSQL isn't new, but it has a new fervor in the web community. There has been a relentless battle of fanatics (similar to the vi vs. emacs wars) arguing which is better. The interesting truth is that almost all large (and successful) web properties use both. This panel will not focus on which is better, but talk instead about how they are different and the specific uses for which they are better.

We will detail several architectures we evaluated or operated to meet our needs: accepting a continuous influx of events, storing tens of billions of points as time-series, and offering rich and low-latency query semantics on them. Expect to hear in particular about: * What we got from Oracle/Postgres over the past decade, and at what cost * Illustrated joys and growing pains of running Cassand...

Google I/O 2010 - BigQuery and Prediction APIs App Engine 101 Amit Agarwal, Max Lin, Gideon Mann, Siddartha Naidu Google relies heavily on data analysis and has developed many tools to understand large datasets. Two of these tools are now available on a limited sign-up basis to developers: (1) BigQuery: interactive analysis of very large data sets and (2) Prediction API: make informed predictio...

Google I/O 2010 - BigQuery and Prediction APIs App Engine 101 Amit Agarwal, Max Lin, Gideon Mann, Siddartha Naidu Google relies heavily on data analysis and has developed many tools to understand large datasets. Two of these tools are now available on a limited sign-up basis to developers: (1) BigQuery: interactive analysis of very large data sets and (2) Prediction API: make informed predictio...

Hosted by Eric David Benari, Organizer of the NYC MySQL GroupDwight is one of the leading engineering minds in the Interactive industry, possessing a particular knack for solving the most complex problems.In 1995, Dwight co-founded DoubleClick and served as its CTO for ten years. Dwight was the architect of the DoubleClick ad serving infrastructure, DART, which serves tens of billions of ads pe...

This is the first of three screencasts where we begin to look at a few new Rails libraries to help you scale your Rails applications. In this first episode we take a look at Bullet, which will help you optimize your SQL queries by giving you growl notifications when you’re not using eager loading properly or should be using a counter cache. Then there’s Rails Indexes which provides ...

SummaryBeth Massi is back to talk about how to generate custom Word documents and Excel spreadsheets with LINQ to SQL and XML Literals in Visual Basic .NET.BioBeth is an Online Content and Community Program Manager on the Visual Studio Community Team responsible for managing and producing content for business application developers and driving community features onto MSDN Developer Centers (htt...

A ruby DSL for building data queries in SQL and other query languages. RQuery is a small DSL inspired by RSpec for building text queries in languages like SQL. It is meant to be concise, easy to read, and expressive about what the query will be asking for. Currently only the ActiveRecord extension is implemented with a Sqlite adapter. Mysql should follow shortly, and then support for Grove + JS...

This tutorial is a screen cast that will show you exactly how to work with Hive. We'll walk through importing data, creating tables, and making queries.

  Hive is a powerful data warehousing application built on top of Hadoop which allows you to use SQL to access your data. This lecture will give an overview of Hive and the query language. This lecture includes a work-along exercise. The next video is a screencast of a user performing this exercise.