This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:indexing:powersearch:example [2011/01/23 00:38] els |
admin:indexing:powersearch:example [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ~~NOTOC~~ | ||
| + | |||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| Line 9: | Line 11: | ||
| [[admin:indexing:powersearch:sql|SQL]] | | [[admin:indexing:powersearch:sql|SQL]] | | ||
| [[admin:indexing:powersearch:optimization|Optimization]] | | [[admin:indexing:powersearch:optimization|Optimization]] | | ||
| + | [[admin:indexing:powersearch:custom|Customization]] | | ||
| [[admin:indexing:powersearch:tips|Tips]] | [[admin:indexing:powersearch:tips|Tips]] | ||
| Line 15: | Line 18: | ||
| ==== Example ==== | ==== Example ==== | ||
| - | In this example of PowerSearch, a user is trying to find a person in the database. They were introduced to them as Bill Meyers, but they didn't know the exact spelling of the name. They knew he lived on Fifth Avenue in New York, but they were sure of the zip code. They thought they knew the phone number, but the area code was wrong and the numbers were transposed. They misspelled the email address, but nonetheless, they found who they were looking for. | + | |
| + | In this example of PowerSearch, a user is trying to find a person in the database. They searched the database with many incorrect pieces of information, but still found who they were looking for. | ||
| + | |||
| + | The user was looking for a Bill Meyers who lived on Fifth Avenue in NY, NY. They provided zip codes, phone numbers, and an email address. All of those were incorrect pieces of information, but they were still enough to find the record. | ||
| {{:admin:indexing:powersearch:powersearch_001.png?770x421|}} | {{:admin:indexing:powersearch:powersearch_001.png?770x421|}} | ||
| - | In this example, each column required a different flexibility as described below: | + | \\ |
| + | ---- | ||
| + | \\ | ||
| - | == First Name == | + | ==== How PowerSearch Helped ==== |
| - | When searching a database containing first names, you never know whether the formal given name is stored, or one of common variations. PowerSearch will automatically search for common synonyms for first names. | ||
| - | ^ Given Name ^ Synonyms ^ | + | This is a classic example of how difficult it can be to find what you are looking for in a database. The user entered all of the information he knew, and without PowerSearch, he would not have found what he was looking for. Here are the tools that PowerSearch used to locate the record: |
| - | | William | Bill, Billy, Will, Williams, Willie, Willis, Wilson | | + | |
| - | | James | Jim, Jimmy, Jimmie, Jay, Jaime, Jacob | | + | |
| - | | Elizabeth | Beth, Betty, Eliza, Elsa, Lisa, Liz, Liza | | + | |
| - | | Ann | Ana, Anita, Anna, Anne, Annette, Annie, Annmarie | | + | |
| + | ^ Column ^ User Input ^ Actual Data ^ PowerSearch Technique ^ | ||
| + | | First Name | Bill | William | Synonym list of given names | | ||
| + | | Last Name | Meyers | Myers | Phonetic search | | ||
| + | | Address | 825 Fifth Avenue | 825 5th Ave | Synonym list of postal abbreviations | | ||
| + | | City | NY | New York | Synonyn list of city abbreviations | | ||
| + | | Zip Code | 10022 | 10021 | Geographic search for nearby zip codes | | ||
| + | | Area Code | 917 | 212 | Synonym list of shared area codes | | ||
| + | | Phone Number | 755-4686 | 775-4866 | Transposition and incorrect digits | | ||
| + | | E-mail Address | wmeyers@med.cornell.edu | wmyers@med.cornell.edu | Misspelling search | | ||
| - | == Last Name == | ||
| + | PowerSearch has a wide variety of tools that can be combined to help find data. Custom synonym lists and misspelling searches are most commonly used, but there are many other tools to choose from. PowerSearch also lets you develop your own synonym lists that are appropriate for your database. | ||
| ===== ===== | ===== ===== | ||