https://www.omnidex.com/docs/v50/ 2026-09-24T16:10:31+0000 https://www.omnidex.com/docs/v50/ https://www.omnidex.com/docs/v50/lib/tpl/simple/images/favicon.ico text/html 2012-10-26T14:26:43+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v50/doku.php?id=admin:applications:design&rev=1351261603&do=diff Building Omnidex Applications Design -> Prototype -> Development -> Testing -> Staging -> Production -> Optimization ---------- Design As with most applications, this is the most important step of the entire application applications. During the design step, key decisions are made about how to approach Omnidex queries and updates in the application. These decisions can lead to high-performing applications, and they can also lead to poor performance. It is worth spending the needed time on … text/html 2012-10-26T14:26:43+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v50/doku.php?id=admin:applications:development&rev=1351261603&do=diff Building Omnidex Applications Design -> Prototype -> Development -> Testing -> Staging -> Production -> Optimization ---------- Development Development of Omnidex applications is remarkable straightforward. Most business access Omnidex databases using a standard ODBC or JDBC interface, and integration of Omnidex can be as simple as changing the connection string to point to Omnidex. Omnidex uses ANSI SQL as its base language, but also has a number of extensions to support features like fuz… text/html 2012-10-26T14:26:43+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v50/doku.php?id=admin:applications:home&rev=1351261603&do=diff Building Omnidex Applications Omnidex applications tend to have a lifecycle. While they share some similarities with normal applications, they also have some unique steps that focus on the Omnidex indexes. The typical Omnidex application has seven stages in its lifecycle: text/html 2012-10-26T14:26:44+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v50/doku.php?id=admin:applications:optimization&rev=1351261604&do=diff Building Omnidex Applications Design -> Prototype -> Development -> Testing -> Staging -> Production -> Optimization ---------- Optimization Omnidex applications are constantly evolving and the queries that are submitted to an application can change over time. The Omnidex indexing strategy must evolve with the application to insure that performance is maintained. This requires reviewing new queries and monitoring slow queries. It is also important to monitor index usage statistics to elim… text/html 2012-10-26T14:26:44+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v50/doku.php?id=admin:applications:production&rev=1351261604&do=diff Building Omnidex Applications Design -> Prototype -> Development -> Testing -> Staging -> Production -> Optimization ---------- Production Like any production application, Omnidex applications should be monitored to insure the best performance and flexibility. Monitoring an Omnidex application is very similar to monitoring any production application. Overall performance is monitored by checking on the available system resources for the servers. Load balancing and connection pools are comm… text/html 2012-10-26T14:26:44+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v50/doku.php?id=admin:applications:prototype&rev=1351261604&do=diff Building Omnidex Applications Design -> Prototype -> Development -> Testing -> Staging -> Production -> Optimization ---------- Prototype Administrators often create a prototype before starting development. Usually, administrators create a smaller test database, and then create Omnidex indexes and run sample queries. Omnidex indexes can also be created on the production database if this is preferable. Prototypes enable businesses to gauge the performance they will see and insure that they… text/html 2012-10-26T14:26:44+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v50/doku.php?id=admin:applications:staging&rev=1351261604&do=diff Building Omnidex Applications Design -> Prototype -> Development -> Testing -> Staging -> Production -> Optimization ---------- Staging Most Omnidex applications involve building indexes on large databases. Some of these applications also involve regular updates or replacements of the data. This data may consist of transaction logs that are produced internally, aggregated monthly or quarterly sales data, or raw data files from list providers or credit agencies. In all of these scenarios, … text/html 2012-10-26T14:26:44+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v50/doku.php?id=admin:applications:testing&rev=1351261604&do=diff Building Omnidex Applications Design -> Prototype -> Development -> Testing -> Staging -> Production -> Optimization ---------- Testing It is important to test Omnidex application, just as it is important to test any application. Testing will help validate the indexing strategy and insure performance. Testing will also insure that there are no mistakes with either the application or SQL language interfaces.