StubHub's Data Scientists reap benefits of integrated approach….

By -

We have released yet another great video customer video, this time with StubHub.

StubHub provides the world's largest fan-to-fan ticket marketplace. The company was formed in 2000 and now dominates the market by making sure fans have a truly open marketplace where they can buy or sell tickets without restrictions or limitations. For more information about SubHub and its services visit their website: http://www.stubhub.com

StubHub's is now getting real business benefit from moving their data analytics inside their data warehouse. This seems like an obvious way to build your data warehouse but many customers are still pulling data out of their data warehouse and shipping it to specialised processing engines so they can mine their data, run spatial analytics and/or built multi-dimensional cubes. The problem with this approach, as the team at StubHub points out, is that typically when you move the data to these specialised engines you have to work with a subset of the data that is sitting in your data warehouse. When you work with a subset of data you immediately start to impose compromises on your analytical workflows. If you can't work with all your data then you can't be sure that your analytical model is as good as it could be and that could mean losing customers or missing out on additional revenue.

The other problem comes from everyone using their own favourite tool to do their analysis: how do you share your discoveries, how do you develop a high level of corporate-wide analytical skills?

Stubhub-Video

Click on the above image to watch the video

StubHub asked Oracle to help them resolve these two key problems. Their data scientists have now adopted open source R as their standard tool for data mining projects. By adopting Oracle's R Enterprise solution they have been able was to push all their analytical processing that is linked to their data mining workflows back inside their Oracle Data Warehouse. Oracle Advanced Analytics is optimised to provide real-time analytics that delivers insight into key business subjects such as product recommendations, and fraud alerting. Most importantly because the data mining workflows run inside the Oracle Database the data scientists have access to all the data inside their data warehouse and no longer have to rely on extracting small subsets of data, the data remains completely secure and they can benefit from the built-in operational scalability of the Oracle Database.

To watch the video you can click on the image above or click here to go directly to the Oracle MediaNetwork page.

For more information about Oracle's R Enterprise solution use the following link: http://www.oracle.com/us/products/database/options/advanced-analytics/overview/index.html. 

 

Technorati Tags: , , ,

Comments

Post a Comment

Popular posts from this blog

My query just got faster - brief introduction to 12.2 in-memory cursor duration temp tables

By -
Image
Image courtesy of wikipedia This post covers one of the new SQL performance enhancements that we incorporated into Database 12c Release 2 . All of these enhancements are completely automatic, i.e. transparent to the calling app/developer code/query. These features are enabled by default because who doesn’t want their queries running faster with zero code changes? So in this post I am going to focus on the new In-Memory “cursor duration” temporary table  feature. Let’s start by looking at cursor duration temp tables… Above image courtesy of wikimedia.org What is a cursor duration temp table? This is a feature that has been around for quite a long time. Cursor duration temporary tables (CDTs) are used to materialize intermediate results of a query to improve performance or to support complex multi step query execution. The following types of queries commonly use cursor duration temp tables: WITH Clause and parallel recursive WITH Grouping Sets S...
Keep reading

SQL Pattern Matching Deep Dive - Part 1

By -
Image
There has been quite a lot of interest in the new 12c MATCH_RECOGNIZE feature for SQL pattern matching. Therefore, I thought now would be the perfect time to start a series of quick deep dive posts that explain how SQL pattern matching works. Over the coming weeks I will cover the following topics in a series of posts. This is the start of a series of posts based on a presentation that I put together for the recent annual  BIWA conferenc e at Oracle HQ. The Oracle BI, DW and Analytics user community always puts on a great conference and this year was the best yet. You can download any or all of the presentations from this year’s conference by following this link . My pattern matching deep dive presentation started life about a year ago as a post covering some of the new keywords in the explain plan that are linked to pattern matching, see here . It has now expanded to cover a much wider range of topics. Firstly, a huge vote of thanks to my development team (Lei Sheng and Chun-Chie...
Keep reading

SQL Pattern Matching Deep Dive - Part 6, state machines

By -
Image
The obvious way to start this particular post is to pose a couple of simple questions: what is a state machine and why should you care? In general I would say that you don't need to know about or care about state machines. That's the beauty of using SQL for pattern matching. The MATCH_RECOGNIZE clause encapsulates all the deep technical modelling and processing that has to be performed to run pattern matching on a data set. However, there are times when it is useful, probably vital, that you understand what is going on behind the scenes and one of the most obvious situations is when backtracking happens. Therefore, the content covered in this post is a going to be a gently lead-in into my next post where I am going to discuss the concept of “backtracking”  and the dreaded  ORA-30009 error. Let’s start our voyage of discovery…when you attempt to run a SQL statement containing a MATCH_RECOGNIZE clause during the compilation phase we generate a finite state machine ba...
Keep reading