Topic outline

• Creating InterSystems IRIS® SQL Search Indices for Searching Text Fields

  Creating InterSystems IRIS® SQL Search Indices for Searching Text Fields

  Explore different types of InterSystems IRIS® SQL Search indices — and see how to use SQL to search text properties in the basic and semantic indices — in this video series.

  An IRIS SQL Search index can be added to any text property in a persistent class. InterSystems IRIS® SQL Search takes advantage of the InterSystems IRIS® Text Analytics semantic engine in a strict SQL context. This enhances text searches for regular tables.

  Note:

  iFind in Caché has similar functionality to SQL Search in InterSystems IRIS® data platform.

  The first video presents an introduction and overview to iFind Indices. Looking for an exercise instead? See Searching Unstructured Text Data.
  
• Introduction to iFind

  Introduction to iFind

  This video introduces you to the three types of iFind indices: Basic, Semantic, and Analytic. You will also see the process to create, build, and use the iFind index including the proper WHERE clause syntax.

  
  

  The next video discusses the iFind Basic index in detail.
• iFind Basic Index

  iFind Basic Index

  The iFind Basic index allows SQL searching of text fields for:

  1. Words.
     
  2. Phrases.
     
  3. Wildcard.
     
  4. Regular expressions.

  
  

  The next video discusses the iFind Semantic index in detail.
• iFind Semantic Index

  iFind Semantic Index

  The iFind Semantic index provides all the functionality of the iFind Basic index and adds the ability to perform SQL searching on iKnow entities in the text property.
• Summary

  Summary

  In this course you learned how to create an iFind index on a text property of a Caché persistent class. You also saw how to use the index in an SQL WHERE clause.

  
  

  Share Your Feedback!
• What's Next?

  What's Next?

  • Try analyzing text with InterSystems IRIS® Text Analytics (exercise, 20m).
  • Try searching unstructured text data with SQL Search (exercise, 15m).