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

Complete Guide to SQL Pattern Matching - Volume 1

Beschreibung des Verlags

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
    Computer und Internet
    ERSCHIENEN
    2017
    27. Oktober
    SPRACHE
    EN
    Englisch
    UMFANG
    112
    Seiten
    VERLAG
    Keith Laker
    GRÖSSE
    92.2
     MB
    Review of Data Warehousing and Big Data At #OOW16 Review of Data Warehousing and Big Data At #OOW16
    2016
    Big Data Warehousing Review of Oracle OpenWorld 2017 Big Data Warehousing Review of Oracle OpenWorld 2017
    2017
    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
    Must-See Guide For Big Data Warehousing  #OOW18 Must-See Guide For Big Data Warehousing  #OOW18
    2018
    Big Data Warehousing Must See Guide for Oracle OpenWorld 2017 Big Data Warehousing Must See Guide for Oracle OpenWorld 2017
    2017
    Data Warehousing and Big Data #OOW16 Data Warehousing and Big Data #OOW16
    2016
    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
    Introduction to MySQL Introduction to MySQL
    2014
    SQL Queries: 200+ Queries to Challenge you. SQL Queries: 200+ Queries to Challenge you.
    2018