Schedule - PostgreSQL Development Conference 2024

Back

Implementing Row Pattern Recognition

Date: 2024-05-29
Time: 16:00–16:50
Room: Canfor(1600)
Level: Intermediate

Row pattern recognition (RPR) has been defined since SQL:2016. RPR is a powerful feature to analyze complex data, especially series of data. With RPR you can find specific trends in a sequence of rows by defining search conditions and regular expressions. Currently we are working on implementing RPR in PostgreSQL's Window clause: https://www.postgresql.org/message-id/20230625.210509.1276733411677577841.t-ishii%40sranhm.sra.co.jp

This talk includes following topics:

  • What is RPR?
  • How is RPR useful?
  • How to implement RPR in PostgreSQL?
  • Future plans
  • Demonstrations

Talk recorded at https://youtu.be/mPcmqi-6cGU.

Slides

The following slides have been made available for this session:

Speaker

Tatsuo Ishii