Chapter 9. Introduction to Information Retrieval

The SQL SELECT command is used to retrieve data from the database. For improved results, built-in functions can be employed, or operators such as LIKE or BETWEEN might be used. This type of search is considered data retrieval since this is essentially a dumb query. By "dumb query" we're referring to SQL's inability to determine what a document is about in order to provide the most relevant documents to the end user. It takes a query term as input and spits back out all documents that contain that term regardless of meaning.

Information Retrieval (IR), on the other hand, uses ranking algorithms to determine how relevant a document is to the search criteria. It provides the ability to manage data, ...

Get Expert Oracle PL/SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.