This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:indexing:autocomplete:home [2011/01/24 21:20] els |
admin:indexing:autocomplete:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 19: | Line 19: | ||
| Most of us have grown accustomed to AutoComplete in web applications. In many websites, when you start to type something, the web page will automatically present a drop-down box with choices matching the characters you've entered so far. Some sites even present you with the most likely choice first. Internet search engines, like Google and Bing, are examples of sites that do this. | Most of us have grown accustomed to AutoComplete in web applications. In many websites, when you start to type something, the web page will automatically present a drop-down box with choices matching the characters you've entered so far. Some sites even present you with the most likely choice first. Internet search engines, like Google and Bing, are examples of sites that do this. | ||
| - | This capability belongs in databases, too. Omnidex's AutoComplete feature provides this option. AutoComplete uses the Omnidex indexing to suggest possible choices. These choices can be ordered based on their counts as well, which places the most common values highest in the list. | + | This capability belongs in databases too. Omnidex's AutoComplete feature provides this option. AutoComplete uses the Omnidex indexing to suggest possible choices. These choices can be ordered based on their counts as well, which places the most common values highest in the list. |
| AutoComplete works hand-in-hand with ActiveCounts. ActiveCounts is best for low-cardinality data, such as geographic codes or demographic codes. ActiveCounts is more challenging with high-cardinality data, such as telephone numbers and email addresses. These columns are ideal for AutoComplete, and the combination of ActiveCounts and AutoComplete provides a comprehensive experience for the user. No matter which column they are referencing, the database is helping them see their choices. | AutoComplete works hand-in-hand with ActiveCounts. ActiveCounts is best for low-cardinality data, such as geographic codes or demographic codes. ActiveCounts is more challenging with high-cardinality data, such as telephone numbers and email addresses. These columns are ideal for AutoComplete, and the combination of ActiveCounts and AutoComplete provides a comprehensive experience for the user. No matter which column they are referencing, the database is helping them see their choices. | ||
| - | AutoComplete also works hand-in-hand with PowerSearch. AutoComplete can help a user choose a value in the database, and PowerSearch will then expand the search to included synonyms, spelling variations and so forth. AutoComplete allows the user to find what they are looking for without having to know the data in advance. | + | AutoComplete also works hand-in-hand with PowerSearch. AutoComplete can help a user choose a value in the database, and PowerSearch will then expand the search to include synonyms, spelling variations, and so forth. AutoComplete allows the user to find what they are looking for without having to know the data in advance. |
| - | Take a look at an [[admin:indexing:autocomplete:example|example]] of AutoComplete, or even try a quick [[appendix:demo:autocomplete|demo]]. As you continue this section, you will learn how to add AutoComplete into your application. | + | Take a look at an [[admin:indexing:autocomplete:example|example]] of AutoComplete. As you continue this section, you will learn how to add AutoComplete into your application. |
| ===== ===== | ===== ===== | ||