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

Complete Guide to SQL Pattern Matching - Volume 1

Description de l’éditeur

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
    Informatique et Internet
    SORTIE
    2017
    27 octobre
    LANGUE
    EN
    Anglais
    LONGUEUR
    112
    Pages
    ÉDITIONS
    Keith Laker
    TAILLE
    92,2
    Mo

    Plus de livres par Keith Laker

    Review of Data Warehousing and Big Data At #OOW16 Review of Data Warehousing and Big Data At #OOW16
    2016
    Data Warehousing and Big Data #OOW16 Data Warehousing and Big Data #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 Must See Guide for Oracle OpenWorld 2017 Big Data Warehousing Must See Guide for Oracle OpenWorld 2017
    2017
    Big Data Warehousing Review of Oracle OpenWorld 2017 Big Data Warehousing Review of Oracle OpenWorld 2017
    2017
    Must-See Guide For Big Data Warehousing  #OOW18 Must-See Guide For Big Data Warehousing  #OOW18
    2018

    D’autres ont aussi acheté

    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
    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
    Introducing Microsoft SQL Server 2014 Introducing Microsoft SQL Server 2014
    2014
    Introduction to MySQL Introduction to MySQL
    2014