SELECT command is used to retrieve data from the database. For improved results, built-in functions can be employed, or operators such as
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, ...