300 likes | 456 Views
Database Searching. Search Statements. Library tutorial by J. Forte September 30, 2014. Each database, including an Internet search engine, has a blank line with the cursor blinking. It wants you to type something in that line. What we type in is called the Search Statement. SEARCH
E N D
Database Searching Search Statements Library tutorial by J. Forte September 30, 2014
Each database, including an Internet search engine, has a blank line with the cursor blinking. It wants you to type something in that line.
What we type in is called the Search Statement. SEARCH STATEMENT
Search Statements contain • The Keywords we learned about in the other tutorial and… • Boolean operators
AND BOOLEAN operators are the words and the computer uses these in different ways. NOT OR NOTE: You do not have to capitalize Boolean operators or type them in a different color.
Example of a search statement College students AND alcohol When you use an AND in the search statement, the computer will look for those articles, etc. that are about college students and alcohol togetherin the same article. If alcohol and college students are nottogetherin the same source, the computer will reject it.
This graph shows how the computer pulls up only those items with Exercise AND Aged together in the same article.
NOT Let’s say we want some articles about exercise but not about exercise used as therapy. Here is where we use the NOTBoolean operator.
Another example of NOT The search string cats not dogs will retrieve only results with cats but not those with dogs. Only cats is included. Dogs and the overlapping center are excluded. N O T cats dogs
OR Remember back in the Keywords tutorial where we said you need to think of synonyms for your keywords just in case you don’t get the search results you wanted. This is where you use the OR to add those synonyms to your search statement. Alcohol, alcohol abuse, alcoholism, binge drinking drinking University students college students
OR Alcohol, alcohol abuse, alcoholism, binge drinking drinking Search Statement College students AND (drinking OR alcohol abuse)
OR College students AND drinking may not give complete results because many articles may be about that subject but express drinking in other terms.
OR That’s why we use a synonym for drinking, such as alcohol abuse. College students AND (drinking OR alcohol abuse) Notice how the OR part of the statement is nested in parentheses. Remember, the computer performs the operations in parentheses first and then does the rest.
College students AND (drinking OR alcohol abuse) The computer finds all of the articles with drinking or alcohol abuse, and then it checks to see if those articles are about college students.
OR Of course the OR does not always have to be nested. It can be part of a simple search statement to get more results: cars OR automobiles
Examples of search statements How does globalization affect employment in the United States? Globalization AND (employment OR jobs) AND United States What are the effects of globalization on income distribution in developing countries? Globalization AND income AND developing countries
More examples of search statements Find some materials on the risks of using cell phones while driving your car Cell phones AND (risks OR safety) AND driving Cell phones AND (cars OR automobiles) Cell phones AND (cars NOT trucks)
Which statement will get the best information from a database search? “Discuss capital punishment as a deterrent to crime.” Capital punishment or crime Deterrent and crime Capital punishment and crime Click the box of the appropriate answer
Which statement will get the best information from a database search? “Discuss capital punishment as a deterrent to crime.” Capital punishment or crime Deterrent and crime Capital punishment and crime Yes, all of the articles retrieved will be on capital punishment AND crime together.
Which statement will get the best information from a database search? “Discuss capital punishment as a deterrent to crime.” Capital punishment or crime Deterrent and crime Capital punishment and crime No, the correct answer is the third one. The first one will retrieve a lot of articles on both topics, but they will not necessarily be related to each other. The second one, or course, does not mention capital punishment at all.
Which statement will get the best information from a database search? “Describe the effects of a thinning ozone layer on the environment.” Environment and ozone layer Effects and environment Effects and thinning Click the box of the appropriate answer
Which statement will get the best information from a database search? “Describe the effects of a thinning ozone layer on the environment.” Environment and ozone layer Effects and environment Effects and thinning Yes, the first one will retrieve all of the articles with environment and ozone layer together. The other two do not mention ozone layer.
Which statement will get the best information from a database search? “Describe the effects of a thinning ozone layer on the environment.” Environment and ozone layer Effects and environment Effects and thinning No, the first one will retrieve all of the articles with environment and ozone layer together. The other two do not mention ozone layer.
Which would retrieve the largest number of records on cars? Cars NOT automobiles Cars OR automobiles Cars AND automobiles Click the box of the appropriate answer
Which would retrieve the largest number of records on cars? Cars NOT automobiles Cars OR automobiles Cars AND automobiles Yes, you use OR to retrieve items that contain the keyword and its synonyms.
Which would retrieve the largest number of records on cars? Cars NOT automobiles Cars OR automobiles Cars AND automobiles No. Use OR to retrieve items that contain the keyword with its synonyms so that you get the most records.
Change around your keywords and search statements. Make sure you are using the right database. You will not find much on French literature in a scientific database. No search results? Did you ask a librarian for help??? Please do.
Don’t stop now!!! You know how to use keywords to form a search statement and you learned about Boolean operators and how create search statements for the library’s databases. NEXT A guaranteed way to get more accurate results from an Internet search!!!
Next tutorial… SEARCH STATEMENTS FOR THE INTERNET