* [[topbar |Table of Contents]] * [[intro:overview:what|Introduction]] * [[install:home|Installation]] * [[install:editions|Product Editions]] * [[install:requirements|System Requirements]] * [[install:platforms|Supported Platforms]] * [[install:guides:home|Installation Guides]] * [[install:licensing:home|Licensing]] * [[install:releases:home|Release Notes]] * [[admin:home|Administration]] * [[admin:admin:home|Administration Basics]] * [[admin:admin:architecture:home|Omnidex Architecture]] * [[admin:admin:applications:home|Building Applications]] * [[admin:basics:home|Omnidex Fundamentals]] * [[admin:basics:environments:home|Omnidex Environments]] * [[admin:basics:sqlengine:home|Omnidex SQL Engine]] * [[admin:basics:updates:home|Omnidex Updates]] * [[admin:basics:network:home|Network Services]] * [[admin:indexing:home|Omnidex Indexing]] * [[admin:indexing:concepts:home|Indexing Concepts]] * [[admin:indexing:indexes:home|Indexing Options]] * [[admin:indexing:creation:home|Index Creation]] * [[admin:indexing:strategies:home|Indexing Strategies]] * [[admin:indexing:activecounts:home|ActiveCounts]] * [[admin:indexing:powersearch:home|PowerSearch]] * [[admin:indexing:autocomplete:home|AutoComplete]] * [[admin:indexing:text:home|Omnidex Text]] * [[admin:features:home|Omnidex Features]] * [[admin:features:snapshots:home|Omnidex Snapshots]] * [[admin:features:grids:home|Omnidex Grids]] * [[admin:features:rollups:home|Rollup Tables]] * [[admin:features:geo:home|Geographic Searches]] * [[admin:features:expressioncols:home|Expression Columns]] * [[admin:features:segments:home|Omnidex Segments]] * [[admin:features:attach:home|Attaching Data]] * [[admin:features:export:home|Exporting Data]] * [[admin:optimization:home|Optimizing Queries]] * [[admin:optimization:plans:home|Query Plans]] * [[admin:optimization:caches:home|Dynamic Caches]] * [[admin:optimization:config:home|Configuring Omnidex]] * [[integration:home|Integration]] * [[integration:rdbms:home|Relational Databases]] * [[integration:rdbms:oracle:home|Oracle]] * [[integration:rdbms:sqlserver:home|SQL Server]] * [[integration:rdbms:mysql:home|MySQL]] * [[integration:rdbms:odbc:home|Generic ODBC]] * [[integration:rawdata:home|Raw Data Files]] * [[integration:rawdata:fixed:home|Fixed-length Files]] * [[integration:rawdata:delimited:home|Delimited Files]] * [[integration:rawdata:ost:home|Standalone Tables]] * [[dev:home|Development]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:overview|Overview]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[dev:connections:home|Connection Strings]] * [[dev:odbc:home|ODBC Interface]] * [[dev:jdbc:home|JDBC Interface]] * [[dev:debugging:home|Logging/Debugging]] * [[programs:home|Programs]] * [[programs:odxsql:home|OdxSQL]] * [[programs:odxnet:home|OdxNet]] * [[appendix:home|Appendix]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[http://www.omnidex.com/download/|Downloads]] * [[support:home|Support]]

**This is an old revision of the document!** ----

A PCRE internal error occured. This might be caused by a faulty plugin

~~NOTOC~~ {{page>:top_add&nofooter&noeditbtn}} ====== Administration: Omnidex Indexing ====== ===== AutoComplete ===== **[[admin:indexing:autocomplete:home|Overview]]** | [[admin:indexing:autocomplete:example|Example]] | [[admin:indexing:autocomplete:sql|SQL]] | [[admin:indexing:autocomplete:optimization|Optimization]] | [[admin:indexing:autocomplete:tips|Tips]] ---- ==== Overview ==== 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. 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 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. ===== ===== **[[admin:indexing:autocomplete:example|Next]]** ====== Additional Resources ====== See also: {{page>:admin:indexing:see_also&nofooter&noeditbtn}} {{page>:bottom_add&nofooter&noeditbtn}}

Back to top
admin/indexing/autocomplete/home.1300832172.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0