Analyzing our Big Data Lite movie app clickstream data
By KLaker on Apr 17, 2014
Since last year's OpenWorld I have posted quite a few articles on our new 12c pattern matching feature:
- OLL Live webcast - Using SQL for Pattern Matching in Oracle Database
- OOW content for Pattern Matching….
- SQL analytical mash-ups deliver real-time WOW! for big data
- OTN Virtual Developer Day content now available on-demand
- Sessionization with 12c SQL pattern matching is super fast
- Oracle Technology Network's FREE Virtual Database Developer Day in EMEA
To date most of my online demos and tutorials have used a very simple data set consisting of a single table with 60 rows of fictitious trade data. Over the last few months I have been searching around for a slightly bigger and more challenging data set to use. Fortunately, our BIg Data PMs (led by Marty Gubar) have put together a very rich big data schema as part of their recently launched Big Data Virtual Machine that you can download fro our OTN web page, see here: http://www.oracle.com/technetwork/database/bigdata-appliance/oracle-bigdatalite-2104726.html.
The data set is based around an online customer movie application. Here is a little background…
Oracle MoviePlex Demo Application
Oracle MoviePlex is a fictitious on-line movie streaming company. Customers log into Oracle MoviePlex where they are presented with a targeted list of movies based on their past viewing behavior. Because of this personalized experience and reliable and fast performance, customers spend a lot of money with the company and it has become extremely profitable.