This shows you the differences between two versions of the page.
|
integration:rdbms:servers [2011/03/14 19:38] 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 places on an Omnidex Server and the relational database is placed on a Relational Database Server. This allows Omnidex to utilize the system resources of the Omnidex Server in the manner it needs, while also allowing the relational database to do the same. | ||
| - | |||
| - | {{:integration:rdbms:server_architecture.png|}} | ||
| - | |||
| - | |||
| - | |||
| - | ===== ===== | ||
| - | |||
| - | **[[integration:rdbms:home|Prev]]** | | ||
| - | **[[integration:rdbms:environments|Next]]** | ||
| - | |||
| - | ====== Additional Resources ====== | ||
| - | |||
| - | See also: | ||
| - | |||
| - | {{page>:integration:rdbms:see_also&nofooter&noeditbtn}} | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||