Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
admin:indexing:powersearch:home [2011/01/23 05:14]
els
admin:indexing:powersearch:home [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 14: Line 17:
 ==== Overview ==== ==== Overview ====
  
-People do not think like databases. ​ Databases are highly ​organized and structured, and they follow ​careful ​rules. ​ People simply ask questions that they want answered, and they don't always follow the rules when they ask their questions. ​ Databases record their data very precisely, and they expect queries to be precise as well.  People do not always ask precise questions.+People do not think like databases. ​ Databases are highly structured, and they follow ​rigid rules. ​ People simply ask questions that they want answered, and they don't always follow the rules when they ask their questions. ​ Databases record their data very precisely, and they expect queries to be precise as well.  People do not always ask precise questions.
  
-Imagine asking a question of an Internet search engine, such as Google or Bing.  You give your best guess at criteria and the search engine interprets ​them for you.  It compensates for spelling errors, plurals and verb tenses. ​ It translates acronyms and honors well-known synonyms. ​ It generally finds what you want, and it can even suggest, "Did you mean ...?"​.  ​+Imagine asking a question of an Internet search engine, such as Google, Yahoo or Bing.  You give your best guess at criteria and the search engine interprets ​it for you.  It compensates for spelling errors, plurals and verb tenses. ​ It translates acronyms and honors well-known synonyms. ​ It generally finds what you want, and it can even suggest, "Did you mean ...?"​.  ​
  
 People appreciate how Internet search engines think more like a person. ​ They don't have to be an expert searching the web, and they don't have to understand the structure and details of a web page.  They just need to know how to ask a question. People appreciate how Internet search engines think more like a person. ​ They don't have to be an expert searching the web, and they don't have to understand the structure and details of a web page.  They just need to know how to ask a question.
  
-This flexibility belongs in databases, too.  PowerSearch provides this flexibility. ​ PowerSearch ​let'​s ​you find your data even if you don't know the correct spelling, transpose numbers, use abbreviations,​ or use nicknames or synonyms. ​ PowerSearch allows your database to think like a person.+This flexibility belongs in databases, too.  PowerSearch provides this flexibility. ​ PowerSearch ​lets you find your data even if you don't know the correct spelling, transpose numbers, use abbreviations,​ or use nicknames or synonyms. ​ PowerSearch allows your database to think like a person.
  
 With PowerSearch,​ each column has a context, and each context demands a different flexibility. ​ For example:  ​ With PowerSearch,​ each column has a context, and each context demands a different flexibility. ​ For example:  ​
Line 26: Line 29:
   * A First Name column needs to allow synonyms for given names, equating Bill to William, Beth to Elizabeth, and so forth.  ​   * A First Name column needs to allow synonyms for given names, equating Bill to William, Beth to Elizabeth, and so forth.  ​
   * A Last Name column needs to allow a phonetic search.  ​   * A Last Name column needs to allow a phonetic search.  ​
-  * An Address column ​need to allow misspellings and postal ​code abbreviations. ​  +  * An Address column ​needs to allow misspellings and postal abbreviations. ​  
-  * A Postal ​Code column needs to allow a geographic radius search for all Postal Codes within a certain distance.  ​+  * A Zip Code column needs to allow a geographic radius search for all zip codes within a certain distance.  ​
   * A Phone Number column needs to allow transpositions,​ and would allow alternative area codes.   * A Phone Number column needs to allow transpositions,​ and would allow alternative area codes.
   * An Email Address column needs to allow alternative spellings, or alternate domain names.   * An Email Address column needs to allow alternative spellings, or alternate domain names.
  
-PowerSearch ​provides these capabilities,​ and also lets you choose the best combinations ​for each column. ​ PowerSearch ​also allows you to create custom synonym lists that are designed specifically for your data. As a database administrator,​ you can design the flexibility that you want in your database. ​ In the end, you can help your users find what they are looking for.+PowerSearch lets you choose the best flexibilities ​for each column. ​ PowerSearch ​even allows you to create custom synonym lists that are designed specifically for your data. As a database administrator,​ you can design the flexibility that you want in your database. ​ In the end, you can help your users find what they are looking for.
  
-Take a look at an [[admin:​indexing:​powersearch:​example|example]] of PowerSearch, or even try a quick [[appendix:​demo:​powersearch|demo]].  As you continue this section, you will learn how to add PowerSearch into your application.+Take a look at an [[admin:​indexing:​powersearch:​example|example]] of PowerSearch. ​ As you continue this section, you will learn how to add PowerSearch into your application.
  
 =====  ===== =====  =====
 
Back to top
admin/indexing/powersearch/home.1295759659.txt.gz · Last modified: 2016/06/28 22:38 (external edit)