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

Complete Guide to SQL Pattern Matching - Volume 1

    • 5.0 • 1 Rating

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
    Computers & Internet
    RELEASED
    2017
    October 27
    LANGUAGE
    EN
    English
    LENGTH
    112
    Pages
    PUBLISHER
    Keith Laker
    SELLER
    Gerard Laker
    SIZE
    92.2
    MB
    SQL Queries for Mere Mortals SQL Queries for Mere Mortals
    2018
    SQL Queries for Mere Mortals SQL Queries for Mere Mortals
    2014
    Practical SQL, 2nd Edition Practical SQL, 2nd Edition
    2022
    Oracle SQL By Example Oracle SQL By Example
    2009
    Microsoft SQL Server 2012 T-SQL Fundamentals Microsoft SQL Server 2012 T-SQL Fundamentals
    2012
    The Definitive Guide to DAX The Definitive Guide to DAX
    2015
    Data Warehousing and Big Data #OOW16 Data Warehousing and Big Data #OOW16
    2016
    Review of Data Warehousing and Big Data At #OOW16 Review of Data Warehousing and Big Data At #OOW16
    2016
    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
    Big Data Warehousing Review of Oracle OpenWorld 2017 Big Data Warehousing Review of Oracle OpenWorld 2017
    2017
    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 Big Data Warehousing  #OOW18 Must-See Guide For Big Data Warehousing  #OOW18
    2018
    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
    Freeform SQL Essentials Freeform SQL Essentials
    2013
    Introducing Microsoft SQL Server 2014 Introducing Microsoft SQL Server 2014
    2014
    One Database, Many Instances: How to Have the Best of Both Worlds By Integrating SQL and NoSQL One Database, Many Instances: How to Have the Best of Both Worlds By Integrating SQL and NoSQL
    2011
    Introduction to MySQL Introduction to MySQL
    2014