This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
overview:omnidex [2009/11/16 20:48] tdo |
overview:omnidex [2012/10/26 14:24] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Omnidex Overview ====== | + | {{page>:top_add&nofooter&noeditbtn}} |
| - | Omnidex is a highly optimized search and analytic engine that delivers dramatically faster queries for business intelligence and e-commerce applications. | + | <html><div align="center"><span style="color:red">DRAFT</span></div></html> |
| - | Omnidex is a supplemental indexing system that can be used to enhance data retrieval from flat files and relational databases such as SQL Server. Oracle, and MySQL as well as any ODBC compliant database via the generic ODBC Database interface. | + | ====== Overview ====== |
| - | Omnidex provides retrieval capabilities beyond traditional retrieval. | + | ===== What is Omnidex? ===== |
| - | * Fast retrievals with complex criteria | + | |
| - | * Text searches – words/values within a column | + | |
| - | * Active Counts/Count Engine – the best/fast count engine | + | |
| - | * Powersearch – fuzzy search | + | |
| + | * Omnidex is a highly-optimized search and analytic engine that delivers dramatically faster queries for business intelligence and online applications using standard SQL interfaces. | ||
| - | Omnidex is a lightweight but powerful indexing system. | + | * Omnidex provides flexible search capabilities that go well beyond a standard database. Omnidex indexes your textual data using search engine-like features, and uses fuzzy searches so that you don't worry about exact search terms or misspellings. |
| - | ===== How Omnidex works ===== | + | * Omnidex supports your relational database by adding speed and flexibility without altering the underlying database. Omnidex can enhance your query performance without jeopardizing your investment in the relational system. |
| - | Omnidex works by specifying indexes on database columns or fields in files using the OdxAdmin Windows based program and storing the specification in an XML Catalog. The indexes can then be synchronized with the underlying data using the OdxAdmin program. | + | * Omnidex indexes flat file data without costly imports into a relational database. Omnidex provides a complete SQL engine for your raw data files and transaction logs, all using standard ODBC and JDBC interfaces. |
| - | Applications can then utilize the Omnidex indexes for very fast and flexible retrieval using either an [[development:interfaces:odbc:intro|ODBC]], [[development:interfaces:jdbc:intro|JDBC]], or a stored procedural interface. | + | ===== Where is Omnidex used? ===== |
| - | ===== Omnidex Modules ===== | + | |
| - | | OdxAdmin | Windows base tool for specifying and maintaining Omnidex indexes. | | + | Omnidex is used in a wide variety of applications. Essentially, Omnidex is used when you need high performance and increased flexibility. Some of the more common Omnidex applications include: |
| - | | [[programs:odxsql:intro|OdxSQL]] | Console based Omnidex SQL testing and scripting tool. | | + | |
| - | | OdxNet | Allows Omnidex access across a network to facilitate a multi-tiered server environment, partioning across servers, and control of Omnidex environments from the Windows OdxAdmin tool. | | + | |
| - | | ODBC Driver | A standards compliance ODBC driver. | | + | |
| - | | JDBC Driver | A standards compliance JDBC driver. | | + | |
| - | | Stored Procedural Interface | A collection of routines to inteface Omnidex to stored procedures. | | + | |
| - | | DBINSTAL | Console base utility for specifying and maintaining Omnidex indexes. Typically OdxAdmin is used instead but DBINSTAL can be used for scripting as well as supporting Omnidex Environment Catalog environments. | | + | |
| - | | Active Counts | Provides counts of attributes within previous selections. | | + | |
| - | | PowerSearch | Provides additional retrieval options such as synonym lists, phone number transpositions, phonetics on last name to the Omnidex selection routines. | | + | |
| - | | OmniSearch.NET | ASP.NET xml driven web pages using Active Counts and PowerSearch Web controls. | | + | |
| + | * [[overview:lists|Database marketing and customer lists]] | ||
| + | * [[overview:analytics|Business analytics and data warehouses]] | ||
| + | * [[overview:onlinedb|Online, searchable database applications]] | ||
| + | * [[overview:flatfiles|Transaction logs and other flatfile databases]] | ||
| + | * [[overview:largedb|Billion-record databases]] | ||
| + | * [[overview:text|Knowledgebases and text databases]] | ||
| - | ===== Nine Steps to a Successful Omnidex Installation ===== | ||
| - | ^ Steps ^ Operation ^ | + | ===== How is Omnidex implemented? ===== |
| - | |1) OS Installation & Setup | View the Windows, Linux or Unix specific installation/setup information | | + | |
| - | |2) Settings and Verification | View RegTest, Environment Settings | | + | |
| - | |3) Index Design | View Design | | + | |
| - | |4) Create Environment | View OaComp, OaDecomp, OaHelper | | + | |
| - | | 5) Index Installation | View OdxAdmin or DBINSTAL and VIEWGEN and SNOWGEN if setting up Star Schema Data Warehouses | | + | |
| - | | 6) Index Maintenance | View OdxAdmin or DBINSTAL | | + | |
| - | | 7) Test the Installation | View OdxSQL, DsEdit, OdxQuery | | + | |
| - | | 8) Application Development | View ODBC, JDBC, Stored Procedures | | + | |
| - | | 9) Debugging | View Debugging and Explain Plans | | + | |
| + | There are three basic steps to implementing Omnidex into your applications: | ||
| + | |||
| + | - Tell Omnidex where to find your data. | ||
| + | - Add Omnidex indexing to your data. | ||
| + | - Connect to Omnidex and perform queries. | ||
| + | |||
| + | Omnidex applications are easy to prototype. Omnidex will walk you through all of these steps using the Omnidex Administrator. Once you have created your Omnidex-enhanced database, you can run queries and see the performance for yourself. | ||
| + | |||
| + | As with all things, it is valuable to understand Omnidex more deeply before building a production application. Omnidex has many powerful features. Learning about these features will help you decide where you want to enhance your application. | ||
| + | |||
| + | ===== How long has Omnidex been around? ===== | ||
| + | |||
| + | Omnidex was introduced in 1981 during an era when companies were just beginning to use computers for their day-to-day operations. During the 1980's, Omnidex provided indexing to the early database users in the Hewlett-Packard marketplace. During the 1990's, Omnidex expanded to support databases across Windows, UNIX and VMS operating systems. Today, Omnidex uses standard interfaces to automatically optimize SQL queries across the major databases and operating systems. Over nearly three decades, Omnidex has been used by over 4,000 customers in countries around the world. | ||
| + | |||
| + | ===== How can I find out more information? ===== | ||
| + | |||
| + | If you are looking for technical advice on how to develop and deploy an Omnidex application, you can read more of this documentation, or you can speak to one of our [[appendix:contactus#technical|technical staff]]. | ||
| + | |||
| + | If you are looking for more information about purchasing Omnidex, you can speak to one of our [[appendix:contactus#sales|sales staff]]. . | ||
| + | |||
| + | Either way, we look forward to assisting you! | ||
| + | ====== Video Resources ====== | ||
| - | ===== For Existing Customers ===== | + | [[link1|Overview of Omnidex]] |
| - | This section outlines the differences between version 5.x and previous Omnidex versions. | + | [[link2|Building an Omnidex Application]] |
| + | [[http://docs.disc.com/dokuwiki/video/Active_Counts.swf|Active Counts]] | ||
| - | ====== Quick Links ====== | + | {{page>:bottom_add&nofooter&noeditbtn}} |
| - | {{page>:quicklinks&nofooter&noeditbtn}} | + | |