This shows you the differences between two versions of the page.
|
integration:rdbms:servers [2011/03/14 19:43] els |
integration:rdbms:servers [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ~~NOTOC~~ | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | |||
| - | ====== Integration: Relational Databases ====== | ||
| - | |||
| - | [[integration:rdbms:home|Overview]] | | ||
| - | **[[integration:rdbms:servers|Servers]]** | | ||
| - | [[integration:rdbms:environments|Environments]] | | ||
| - | [[integration:rdbms:queries|Queries]] | | ||
| - | [[integration:rdbms:updates|Updates]] | | ||
| - | [[integration:rdbms:creation|Generating Data Files]] | | ||
| - | [[integration:rdbms:implementation|Implementation Guides]] | ||
| - | |||
| - | |||
| - | ---- | ||
| - | ==== 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. | ||
| - | |||
| - | 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. | ||
| - | |||
| - | {{: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 SAN's provide great flexibility and excellent performance, though it is important to insure sufficient cache in the SAN as well as sufficient number of paths to the servers. | ||
| - | |||
| - | ===== ===== | ||
| - | |||
| - | **[[integration:rdbms:home|Prev]]** | | ||
| - | **[[integration:rdbms:environments|Next]]** | ||
| - | |||
| - | ====== Additional Resources ====== | ||
| - | |||
| - | See also: | ||
| - | |||
| - | {{page>:integration:rdbms:see_also&nofooter&noeditbtn}} | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||