BZAN 6356 Lecture 2.3: Fuzzy Search and Comparisons in PostgreSQL

preview_player
Показать описание
0:00 - Introduction
0:47 - Importing the data
8:05 - LIKE Operator
12:11 - Regular expressions
15:48 - Levenshtein distance
19:50 - Trigrams
24:27 - Lexemes
26:10 - Metaphones
29:44 - Multidimensional Cubes

#SQL #NoSQL #NRDBMS #RDBMS #nonrelational #Database #postgresql #Education
  1. Professor Mark Grimes
Рекомендации по теме
BZAN 6356 Lecture 0:39:20

BZAN 6356 Lecture 2.3: Fuzzy Search and Comparisons in PostgreSQL

Lecture 2 - 1:52:13

Lecture 2 - BZAN 6356 Fall 2024

BZAN 6356 Lecture 0:20:14

BZAN 6356 Lecture 2.2: Advanced Relational Database Topics

BZAN 6356 Lecture 0:03:58

BZAN 6356 Lecture 2.0: Relational Databases Revisited

BZAN 6356 Lecture 0:37:10

BZAN 6356 Lecture 2.1: A Brief Overview of Relational Databases

Lecture 5 - 1:35:02

Lecture 5 - BZAN 6356 Fall 2023

6.1 - The 0:12:48

6.1 - The Relational Data Model

PostgreSQL пример полнотекстового 0:01:29

PostgreSQL пример полнотекстового поиска

Databases: sql server 0:01:51

Databases: sql server full text search - fuzzy searching? (2 Solutions!!)

Using Fuzzy Lookup 0:07:54

Using Fuzzy Lookup and Grouping in SSIS

SQL : Fuzzy 0:01:10

SQL : Fuzzy search in SQL

PostgreSQL Full Text 0:14:12

PostgreSQL Full Text Search Tutorial

Ultimate Guide to 0:42:23

Ultimate Guide to Fuzzy Search Algorithms

Fuzzy Match walkthrough 0:02:16

Fuzzy Match walkthrough

IT - PSQL 0:21:17

IT - PSQL COMMANDS -2

PostgreSQL for Beginners 0:28:46

PostgreSQL for Beginners - Topic 6 - Part 1 - Objects (Tables, Indexes etc.,) Management

SQL : Similarity 0:01:14

SQL : Similarity function in Postgres with pg_trgm

Scaling Postgres Episode 0:19:25

Scaling Postgres Episode 154 Connection Queues | Connection Pool Size | Simple Audits | Fuzzy Match

PostgreSQL Optimizer Methodology 1:05:10

PostgreSQL Optimizer Methodology (Robert Haas)

Databases: How to 0:03:23

Databases: How to Pivot in PostgreSQL? (2 Solutions!!)

PostgreSQL GIN pg_trgm 0:01:49

PostgreSQL GIN pg_trgm default operator class

How to install 0:02:20

How to install fuzzystrmatch.sql pg_trgm.sql on postgresql on mac os x? (5 Solutions!!)

SQL : Postgresql 0:01:14

SQL : Postgresql regular expression matching function: regexp_matches

2. How to 0:13:48

2. How to add content and metaphone equivalent to our database

Комментарии
Автор

I am SO glad to have found this course, and I learned so much from it! I have been using PostgreSQL for more than 10 years, but never used anything past the basic comparison operators and simple regex strings. But now I am needing to do more advanced comparisons on name fields (e.g. nicknames and misspelled names) and this course was EXACTLY what I needed!

msheaver
Автор

Excellent video!! Especially interesting on the levenshtein distance and trigrams for implementing full text search with fuzzy string capability for a web application.

Good stuff.

jorgedardon
Автор

Professor you are awesome and so underrated in YouTube. Wish the very best. You teaching skill is so amazing. I learned a lot in very short time in compared watching some other channels tutorial.

naimurhasanrwd