Complete Guide to SQL Pattern Matching - Volume 1 Complete Guide to SQL Pattern Matching - Volume 1

Complete Guide to SQL Pattern Matching - Volume 1

Publisher Description

The first volume of this two-book series provides a gentle introduction to the new MATCH_RECGONIZE clause. In Chapter 2 I review some of the customer use cases that we collected during the functional specification phase when we were designing and building this feature. They are excellent examples of the types of business problems linked to pattern matching.


The deep dive sections of this two-book series (Chapters 4 and 5 in this volume and the whole of Volume 2) are based on a presentation that I put together for one of the annual BIWA conferences at Oracle HQ which then led to a long running series of blog posts.


The presentation started life about a year earlier as a blog post covering some of the new keywords linked to pattern matching that appear in the explain plan. The original BIWA presentation and the blog posts have now expanded to cover a much wider range of deep dive topics.


These two eBooks brings all this content together in one place. I expect both Volume 1 and 2 will be extremely useful for both SQL developers and DBAs who are new to SQL pattern matching.

  • GENRE
    Computing & Internet
    RELEASED
    2017
    27 October
    LANGUAGE
    EN
    English
    LENGTH
    112
    Pages
    PUBLISHER
    Keith Laker
    SIZE
    92.2
    MB

    More Books by Keith Laker

    Big Data Warehousing Must See Guide for Oracle OpenWorld 2017 Big Data Warehousing Must See Guide for Oracle OpenWorld 2017
    2017
    Must-See Guide For Autonomous Database #OOW19 Must-See Guide For Autonomous Database #OOW19
    2019
    The Complete Review Of Data Warehousing and Big Data From OpenWorld 2018 The Complete Review Of Data Warehousing and Big Data From OpenWorld 2018
    2018
    Review of Data Warehousing and Big Data At #OOW16 Review of Data Warehousing and Big Data At #OOW16
    2016
    Hightlights From Autonomous OpenWorld  #OOW19 Hightlights From Autonomous OpenWorld  #OOW19
    2019
    Day-by-Day Guide for Big Data Warehousing  #OOW18 Day-by-Day Guide for Big Data Warehousing  #OOW18
    2018

    Customers Also Bought

    SQL Procedures, Triggers, and Functions on IBM DB2 for i SQL Procedures, Triggers, and Functions on IBM DB2 for i
    2016
    DBA's Guide to NoSQL DBA's Guide to NoSQL
    2014
    Introduction to MySQL Introduction to MySQL
    2014
    SQL SQL
    2012
    1000 SQL Interview Questions and Answers 1000 SQL Interview Questions and Answers
    2020
    DBA Monster Manual DBA Monster Manual
    2012