Effective Database Searching

1. Effective Database Searching Created by Elizabeth Farrell, Florida State University College of LawLicensed under a Creative Commons BY-NC-SA 3.0 License.

2. Effective Database Searching • Search Methods: • Terms & Connectors (Boolean) searching • Natural Language searching • How to decide which method to use. • How to design an effective search.

3. Natural Language • “Plain English” style search, similar to a google search • Enter in keywords, phrases, sentences or questions • Limited number of results (100-250) • Results ranked by relevancy • Not an excuse for sloppy/lazy searches!

4. Terms & Connectors • Also known as “Boolean” searching • Uses connectors like OR, AND, NOT between search terms • Can specify: • mandatory terms • alternate terms • terms to exclude • terms in specific parts of the document • terms appearing X times • terms within a certain proximity of other terms

5. 2 Ways to Think About Terms & Connectors • Algebra • Remember functions like this? (a + b) x (c – d) (dog OR cat OR animal) AND (bite OR attack) • Venn Diagrams intent AND slander OR libel OR defame

6. Which to Choose • Natural Language • Unfamiliar with the issue’s key terms & vocabulary • You don’t need an exhaustive list of sources • Need a starting point for research • Terms & Connectors • Familiar with the issue’s key terms & vocabulary • You want to check all potentially relevant results • Essential for pre-emption checks!

7. Super Searchers Prefer Terms & Connectors • High level of search precision • High confidence in search results • Lots of control over search input

8. ResponseWare Login ResponseWare Web Address: http://www.rwpoll.com/ Session ID: XXXX

9. After this class, I will be a pro at terms & connectors searching. • True • False

10. Designing an Effective Search – Step by Step • Step 1: Gather Enough Information • Step 2: Frame and Articulate the Issue • Step 3: Determine Key Search Terms • Step 4: Add Alternate Terms • Step 5: Determine Relationships between Terms • Step 6: Use Fields/Segments to Add Precision • Step 7: Use Advanced Boolean Features

11. Step 1: Gather Enough Information • What are you trying to find? • Jurisdiction • Types of materials • Is a database search the best option?

12. Step 1: Gather Enough Information Scenario: Your client is opening a restaurant and asks for your firm’s assistance in making sure he complies with all the necessary laws. What possible areas of law might this include?

13. Step 2: Frame and Articulate the Issue Consider… • The information as if you were briefing a case • Searching the opposite side of the issue • Imagining how the ideal document might discuss the issue

14. Step 2: Frame and Articulate the Issue Scenario: In the spring, while at a book signing event in Minneapolis, Newt Gingrich was unsuspectingly “glitter bombed” by an individual who attended the event. The NY Times and the ABA Journal have recently run stories stating that Mr. Gingrich believe this type of protest is illegal and the Prosecutor in Minneapolis is feeling the pressure to look into charging the protestor. You’ve been tasked with researching the whether charges can be brought.

15. Step 3: Determine Key Search Terms A well-framed issue will usually make the key search terms easy to see. Example: • Can glitter bombing be a “touch” for a battery claim? • Was there a reliance on a misrepresentation of the facts?

16. Step 3: Determine Key Search Terms • Good search terms… • Carry meaning • Are essential to the issue • Be cautious of… • Superfluous or incidental terms • Alternate phrasing

17. Is name-calling alone sufficient to create a hostile work environment under the Americans with Disabilities Act? • name-calling • alone • sufficient • create • Hostile work environment • Americans with Disabilities Act

18. Can a Florida homeowner’s association restrict its members from installing satellite dishes or HAM radio antennas on their home or on their property? • Florida • Homeowner’s association • restrict • member • install • Satellite dish • HAM radio antenna • home • property

19. Step 4: Add Alternate Terms • Synonyms are critical to good searches damag! or destroy! or total! w/10 car or automobile or vehicle • Antonyms can also be helpful admit! or admiss! or inadmiss! or relevan! or irrelevan! w/5 evidence

20. Is it ethical for a Florida attorney to outsource some paralegal duties to an overseas provider? • ethical • Florida • attorney • outsource • paralegal • duties • overseas • provider

21. Designing an Effective Search – Step by Step • Step 1: Gather Enough Information • Step 2: Frame and Articulate the Issue • Step 3: Determine Key Search Terms • Step 4: Add Alternate Terms • Step 5: Determine Relationships between Terms • Step 6: Use Fields/Segments to Add Precision • Step 7: Use Advanced Boolean Features

22. Step 5: Determine Relationships between Terms The purpose of connectors is to show the desired relationships between terms. • Examples: • fraud AND insurance • tax! w/3 income • damages w/25 negligen! • res judicata

23. Issue: school prayerSelect the best search: • “school prayer” • school AND pray! • school W/5 pray! • school OR pray!

24. Issue: Good Samaritan DefenseSelect the best search: • “good samaritan” W/S defense • good AND samaritan AND defense • “good samaritan defense” • good OR samaritan AND defense

25. Issue: Evidence obtained from a sniffer dogSelect the best search: • evidence AND sniff! OR smell OR scent w/20 dog OR canine • evidence w/20 sniff! OR smell OR scent AND dog OR canine • evidence w/20 sniffer dog • evidence AND dog OR canine

26. Scenario: You represent a family with a baby daughter, Jane, in a malpractice suit. During her birth, Jane contracted an infection. Jane exhibited symptoms of infection, but the attending physicians failed to diagnose and treat the infection. A routine course of antibiotics would have cured the infection, but instead the infection worsened and left Jane with severely diminished eyesight.

27. Step 6: Use Fields/Segments to Add Precision Online documents are divided up into searchable segments (or fields). Users can specify where within a document a term should appear. judges(o'connor) and court(eighth circuit) and drugs or narcotics

28. Find opinions authored by Chief Judge Linda Ann Wells of the Third DCA • judge wells AND third DCA • ju(wells) AND ci(third district) • ju(wells) & pr(third)

29. Step 7: Use Advanced Boolean Features Specify… • Singular/plural word forms • Upper/lowercase characters • Number of times a word/phrase appears • Terms to exclude

30. Questions?