Natural Language

Handling Natural Language fields and indexes in PostgreSQL.

• Videos

  • Lecture: 05 FullText 01 Blocks 1080
  • Lecture: 05 FullText 02 Index 1080
  • Lecture: 05 FullText 03 Invert SQL 1080
  • Demonstration: 05 01 Inverted SQL edited
  • Lecture: 05 FullText 04 Invert PG 1080
  • Demonstration: 05 02 String GIN raw
  • Lecture: 05 FullText 05 Natural SQL 1080
  • Demonstration: 05 03 stop stem raw
  • Lecture: 05 FullText 06 Natural PG 1080
  • Demonstration: 05 04 fulltext functions raw
  • Demonstration: 05 05 tsvector gin raw

• Slides

  • 05-FullText.php

• References

  • Sample SQL For Lecture
  • High Contrast / Printable Slides
• Discussions:
  • Natural Language (Login Required)
    
• Tools:
  • Quiz: Natural Language (Login Required)
    
  • Autograder: Inverted Index in SQL (Login Required)
    
  • Autograder: Reverse Index (with stop words) in SQL (Login Required)
    
  • Autograder: String Array GIN Index (Login Required)
    
  • Autograder: GIN ts_vector Index (Login Required)