This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
integration:rdbms:servers [2011/03/14 19:40] els |
integration:rdbms:servers [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 10: | Line 10: | ||
| [[integration:rdbms:queries|Queries]] | | [[integration:rdbms:queries|Queries]] | | ||
| [[integration:rdbms:updates|Updates]] | | [[integration:rdbms:updates|Updates]] | | ||
| - | [[integration:rdbms:creation|Generating Data Files]] | | + | [[integration:rdbms:integration|Integration Guides]] |
| - | [[integration:rdbms:implementation|Implementation Guides]] | + | |
| Line 17: | Line 16: | ||
| ==== Servers ==== | ==== Servers ==== | ||
| - | Omnidex benefits from being on a separate server from the relational database, although there is no requirement to do so. Relational databases usually adopt a strategy that consumes most of the resources on a server. It is not uncommon for a relational database to consume nearly all of the memory and CPU while processing large quantities of data using multiple threads. While this maximizes the performance of the relational database, it does not preserve many resources for other processes such as Omnidex. | + | Omnidex benefits from being on a separate server from the relational database whenever possible. Relational databases tend to use strategies that consume most of the resources on a server. It is not uncommon for a relational database to consume nearly all of the memory and CPU while processing large quantities of data using multiple threads. While this maximizes the performance of the relational database, it does not preserve many resources for other processes such as Omnidex. |
| - | Typically, Omnidex is placed on an Omnidex Server and the relational database is placed on a Relational Database Server. This each to utilize the system resources as they need without interference from the other. If all queries are to be satisfied by Omnidex, then the application simply switches the connections from the relational database to either Omnidex's ODBC or JDBC driver. Alternatively, the application can concurrently maintain connections directly to the relational database server. | + | Typically, Omnidex is placed on an Omnidex Server and the relational database is placed on a Relational Database Server. This allows each to utilize system resources as they need without interference from the other. |
| - | {{:integration:rdbms:rdbms_server_architecture.png|}} | + | Applications can be written to direct all query traffic to Omnidex, or the application can split the traffic between Omnidex and the relational database. Applications that direct all query traffic to Omnidex simply switch the connections from the relational database to Omnidex. Applications that will split the traffic maintain concurrent connections to Omnidex and the relational database. |
| + | {{:integration:rdbms:rdbms_server_architecture.png|}} | ||
| + | Most companies rely on a Storage Area Network (SAN) for accessing their data. Omnidex indexes will usually reside on the SAN as well, though this is not a requirement. High-quality SANs provide great flexibility and excellent performance, though it is important to insure sufficient cache in the SAN as well as a sufficient number of paths to the servers. | ||
| ===== ===== | ===== ===== | ||