Text Search in a DBMS

• SQL standard: new data type FullText

• Incorporate keyword search into SQL

• Also support “rank” method

• Typical implementation

  • Separate, loosely-coupled text-search engine
  • Update index asynchronously on inserts
  • No transactional guarantees

Notes: