September 2005
Intermediate to advanced
496 pages
8h 46m
English
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, ...
Read now
Unlock full access