Get some sun and learn about Pattern Matching at BIWA

By -

BIWA medium

This is your chance to get some winter sun and learn about the new 12c SQL pattern matching! I have just received confirmation from BIWA Summit team that my presentation and hands-on lab on SQL pattern matching have been accepted for the 2014 conference (Jan 14-16 2014 at the Oracle Conference Center, Oracle HQ, Redwood Shores). If you are not familiar with BIWA then here is an overview:

The Oracle Business Intelligence, Warehousing and Analytics Special Interest Group (BIWA SIG) is the leading worldwide association of persons interested in the successful deployment of Oracle Database-centric business intelligence, data warehousing, analytical products, EPM/Essbase and Big Data related features and options. BIWA now has almost 2000 members worldwide. BIWA is a not-for-profit entity affiliated with the Independent Oracle Users Group (IOUG).

BIWA runs all sorts of activities:

  • Webcasts - BIWA holds monthly webcasts presenting BI and DW experts speaking on BI, Data Warehousing and Analytics topics.
  • Conferences - Participates in major Oracle conferences including Oracle Open World and Collaborate. BIWA manages the BI/DW track at Oracle Open World's User Group day.
  • Summit - BIWA's annual Summit enables members to learn from and network with hundreds of other BI, Warehousing and Analytics specialists, a uniquely valuable environment that cannot be duplicated by less-focused conferences. Our coming conference will be the Get Analytical With BIWA Training Days conference-within-a-conference at COLLABORATE 10 IOUG Forum, April 18-22, 2010 in Las Vegas, Nevada. See the BIWA2010 tab above for details.
  • Our second summit, at Oracle World HQ in California in December, 2008, provided over 60 technical sessions, 10 hands-on workshops and 4 keynotes. Over 300 people participated. BIWA's first summit, in 2007, also drew over 300 participants and offered over 40 technical sessions, plus hands-on workshops and keynotes.

If you are a data scientist, data warehouse developer, analyst, data miner, BI reports developer etc then this is definitely the group for you. There is more information about BIWA on their website: http://www.oraclebiwa.org

Back to my sessions…in my presentation I will explore some interesting use cases and provide details of some performance metrics from our own internal tests and from work with customers. The hands-on lab shows how pattern matching using native SQL improves application and development productivity and query efficiency for row sequence analysis. The lab is divided into five sections:

  • Part 1 - Introduction to SQL Pattern Matching
  • Part 2 - Searching for more complex patterns
  • Part 3 - Understanding how SQL Pattern Matching works
  • Part 4 - How to use built-in measures
  • Part 5 - Advanced Topics

This is a great opportunity to get some hands-on experience with the new MATCH_RECOGNIZE clause and the developers who worked on this feature will be available in the room to answer your questions. If you are interested in learning more about our pattern matching feature then make sure you attend this conference.  I am already digging out the sunscreen and looking forward to a week away from the freezing cold British winter and enjoying some warm days of clear blue skies and sun.

At this point you should be saying "Wow, how do I sign up for this conference?" and that is a great question. The details of the 2104 conference, including how to register, are here: http://www.biwasummit.com/ . Hope to see you in San Francisco.

 

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

Oracle OpenWorld - Highlights from Day 2

By -
Image
Data Warehouse and Big Data - Highlights from Oracle OpenWorld Day 2 Welcome to this online review of day two of Oracle OpenWorld 2012. Our aim is to keep you up to date on all the press reports, blog posts, analyst reports and related activities from this year's conference. Oracle: Big Business Has Big Data Woes (New York Times Interview) Business, the way you’re working will kill you. Storage costs, social media awareness, software application migration — they are all big problems. And, not surprisingly, Oracle is trying to address them. Last week I sat down with Mark V. Hurd, Oracle’s co-president, for a talk about Oracle’s strategy. Most of his conversation had to do with the problems facing big companies as they adapt to a world of mobile devices, cloud computing and
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