Jeremy Winters's Blog

  • Feb 18, 2015

    VoltDB for Easy HTTP Ingestion

    About a year ago, a Full360 gaming customer had a requirement to create an analytics data warehouse for in-game events. These events are generated by various mobile and desktop versions of their games, representing significant actions in the game such as wins, losses, level ups, and in-game currency transactions. The final target for the data was a Vertica database running on AWS EC2 instances… to be analyzed and visualized with Tableau.

  • Dec 10, 2014

    Dynamic Data Warehousing of Semi-Structured Data with Snowflake

    Here at Full 360 we consider ourselves “data centric… technology agnostic”. When faced with a data problem we try to identify the software solution that will best handle our client’s needs, as opposed to a “one hammer fits all” approach of using only tools that we know. That being said… over time we have developed preferences for certain products and providers. These preferences have grown from our experience doing BI for 15+ years, and understanding the problems that emerge over the lifetime of the application. Our primary preference for reporting on “big data” is the use of columnar databases. We already have what we consider to be the two strongest columnar database options under our banner of expertise… and have found that most of the other options in the marketplace aren’t worth pursuing because they don’t bring anything new to the table… or are simply columnar options for enterprise RDBMS offerings.

    Earlier in 2014, Snowflake Computing contacted us about a sneak preview of their SaaS columnar data warehouse offering. After seeing the demo I was immediately excited and took them up on their offer for a free account so that I could give it a spin. Now that the product has become publicly available I am free to share my excitement with you!

  • Feb 14, 2013

    Amazon Redshift - Review and First Impressions

    As an AWS Premier partner, and the only partner with expertise in columnar databases in the cloud, Full360 was given earliest preview access to Amazon Redshift, the new cloud-based columnar data warehouse offering which was announced at the Re:Invent conference in November. Here are some of my initial impressions and experiences working with it over the past month.

  • Oct 12, 2012

    User Defined Load Libraries in Vertica 6

    Vertica 6 introduces the concept of UDLs, User Defined Load libraries. These libraries are C++ routines created with the Vertica API allowing you to extend the functionality of the COPY (bulk loading) statement. Traditionally, the COPY statement loads data from text files or character streams. UDLs allow you to substitute an external function call for a stream name or file location, then load the results directly into a table. This sort of functionality is useful when you want to access complex data sources such as…

    • Non-Vertica databases
    • SOAP and RESTful Web Services
    • Hadoop/MapReduce processes
  • Jul 3, 2012

    Real World Vertica Performance at Full360 via Chef

    As a boutique, BI solutions integrator, Full360 sometimes receives requests from medium sized, prospective clients to do a proof of concept of our elasticBI platform, a stack consisting of Jaspersoft BI reporting combined with the Vertica columnar database.  Typically in these cases, the prospect is comparing several BI solutions, looking for the one that will best fit their needs.  The bigger players in the space often have more resources to throw at building a POC… usually part of a presales technical team.