Differences

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

--- admin:indexing:powersearch:home [2011/01/22 23:38]
els
+++ admin:indexing:powersearch:home [2016/06/28 22:38] (current)
@@ Line 1: / Line 1: @@
+~~NOTOC~~
 {{page>:top_add&nofooter&noeditbtn}}
@@ Line 9: / Line 11: @@
 [[admin:indexing:powersearch:sql|SQL]] |
 [[admin:indexing:powersearch:optimization|Optimization]] |
+[[admin:indexing:powersearch:custom|Customization]] |
 [[admin:indexing:powersearch:tips|Tips]]
 ----
+==== Overview ====
-People do not think like databases.  Databases are highly organized and structured, and then follow careful rules.  People simply ask the questions they want answered, and they don't follow the rules when they ask their questions.  Databases record data very precisely, and they expect queries to be precise as well.  People do not 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.
-People love asking questions of Internet search engines, such as Google or Bing.  They love it because they can just ask for what they want.  The search engine will interpret it and do the best job it can of finding what the user wants.  It will ask, "Did you mean ...?".  It will compensate for spelling errors, plurals and verb tenses.  It will even try to translate some acronyms and synonyms for first names.
+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 love Internet search engines because the search engine thinks more like a person, rather than the person having to think like the web page.  This flexibility belongs in databases, too.  PowerSearch provides that flexibility.  PowerSearch let's you search a database and find what you are looking for, even if you don't know the correct spelling, transpose numbers, use abbreviations, or even use nicknames or synonyms.  PowerSearch allows your database to think like a person.
+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.
-With PowerSearch, each column has a context, and it allows you to use the rules that are appropriate to that context.
+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.
-  * A First Name column would use a synonym list of first names, equating Bill to William, and so forth.
+With PowerSearch, each column has a context, and each context demands a different flexibility.  For example:
-  * A Last Name column would use a phonetic search.
-  * An Address column would allow misspellings and postal code abbreviations.
-  * A Postal Code column would allow a search for all Postal Codes within a certain geographic radius.
-  * A Phone Number column would allow transpositions, and would allow alternative area codes.
-  * An email address would allow alternative spellings, or alternate domain names.
-PowerSearch provides these capabilities, and also allows you to create your own.  As a database administrator, you know your data.  You know the context of each column.  You know how to add flexibility to each search.  PowerSearch can be customized to meet the needs of your database.
+  * 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.
-In the end, users want to find their data.  They may not know how the database is set up, or even how to ask for it.  PowerSearch closes that gap and finds what they are looking for.
+  * An Address column needs to allow misspellings and postal abbreviations.
+  * A Zip Code column needs to allow a geographic radius search for all zip codes within a certain distance.
-Take a look at an example of PowerSearch, or even try a quick demo.  As you continue this section, you will learn how to put PowerSearch into your application.
+  * 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.
-==== Overview ====
+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.  As you continue this section, you will learn how to add PowerSearch into your application.
 =====  =====

Back to top

admin/indexing/powersearch/home.1295739501.txt.gz · Last modified: 2016/06/28 22:38 (external edit)

Sitemap Recent Changes