OpenWorld 2103 - My two sessions on SQL analytics

By -
OOW Banner
Good news, I will be presenting two papers at this year's OOW.
The first session is a customer panel: Your Data Is Talking to You: Customers Describe How In-Database Analytics Drives Their Business
Your data is talking to you, but do you have the analytics to listen? The business world today is filled with immense opportunities for translating the messages from our data into insights and actions. In this session, a panel showcases several customers that have taken listening to their data to completely new levels. Come hear how you can better use the database you have today to improve productivity, cut costs, and increase customer satisfaction with in-database analytics.
This will be a great session because you will have the chance to talk to customers who are really pushing the boundaries of SQL analytics. If you are using SQL to drive your DW and BI solutions then come and share your ideas and use cases because this panel will definitely be a two-way communication session. Everyone is going to learn something new and amazing during this session. Here is a link to the entry in the content catalog so you can add this session to your online agenda, click here.
Session number two is a presentation that is linked to the topic above: SQL: The Best Development Language for Big Data
Large-scale data processing is undergoing tremendous transformations: new datasources are more readily available, and businesses are focusing more heavily on analytic solutions. Hadoop and other nonrelational datasources are becoming more common, but working with and analyzing this data is hard. SQL, on the other hand, is the most commonly used language for data analysis. So how can we combine these two? This session discusses Oracle’s analytical SQL capabilities and how complex analytical queries running on large to extremely large data sets are becoming a reality, even on datasources outside the relational world. Learn also how Oracle envisions the future of a unified analytical world.
This should be a lively and interactive session and I will be looking to the audience to really engage with this content as SQL analytics and big data are both hot topics. Here is a link to the entry in the content catalog so you can add this session to your online agenda, click here.
If you are going to be at OpenWorld I would love to meet up with you to talk about SQL analytics, use cases, ideas, enhancement requests etc. Looking forward to seeing you at this year's event - it is going to be a good one!

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 Star Trans
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