Kscope19 Logo-No Location.png

View Printable Version

Uses of Row Pattern Matching

Session Number: 8143
Track: Database
Sub-Categorization: DB Dev
Session Type: Tips, Techniques and Tuning
Primary Presenter: Kim Berg Hansen [Senior Developer - Trivadis]
Time: Jun 26, 2019 (02:15 PM - 03:15 PM)
Room: 618, Level 6

Speaker Bio: Kim Berg Hansen is a database developer from Middelfart in Denmark. Originally wanting to work with electronics, he almost coincidentally tried computer programming and discovered where his talent lay; the programs he did worked well—unlike the electronics projects he soldered, which often failed. After that experience he progressed from Commodore Basic on VIC-20 over Modula-2 and C at Odense University to Oracle SQL and PL/SQL, which he has now worked with extensively since 2000. His professional passion is working with data inside the database, utilizing the SQL language to the fullest to achieve the best application experience for the users.

Kim shares his experience and knowledge by blogging, presenting at various Oracle User Group conferences, and being the SQL quizmaster at the Oracle Dev Gym. His motivation is when peers go “now I understand” after his explanations, or when end users “can’t live without” his application coding. He is a certified Oracle OCE in SQL, as well as an Oracle ACE Director. Outside the coding world, Kim is married, loves to cook, and is a card-carrying member of Danish Beer Enthusiasts association.

Technologies or Products Used: Oracle Database

Session Summary for Attendees:  With 12c came the ability to search efficiently for patterns within your rows of data using a syntax similar to searching for character patterns in strings with regular expressions, but instead of searching text, it searches for data patterns.

This is useful for pattern recognition like finding ups and downs in values over time (e.g., stock tickers) or transaction patterns in accounts that may look like fraudulent behavior. But it can also be used for grouping consecutive data, finding gaps, finding or merging overlapping periods, calculating number of children in hierarchical data, and more.

Join me for a discussion of different use cases of row pattern matching.

Be sure to keep your user profile up to date! Click here to update now.