O'Reilly logo

Expert Oracle PL/SQL by Michael McLaughlin, Ron Hardman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required