This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
admin:basics:overview:sqlengine [2012/01/24 21:20] doc created |
admin:basics:overview:sqlengine [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| ===== Introduction to Omnidex Fundamentals ===== | ===== Introduction to Omnidex Fundamentals ===== | ||
| - | **[[admin:basics:home | Environments ]]** | | + | [[admin:basics:home | Environments ]] | |
| - | [[admin:basics:overview:sqlengine | SQL Engine]] | | + | **[[admin:basics:overview:sqlengine | SQL Engine]]** | |
| [[admin:basics:overview:updates | Updates]] | | [[admin:basics:overview:updates | Updates]] | | ||
| [[admin:basics:overview:network | Network Services]] | [[admin:basics:overview:network | Network Services]] | ||
| ---- | ---- | ||
| \\ | \\ | ||
| - | |||
| - | The Omnidex indexing technology is built upon four building blocks that provide the foundation of the product. It is valuable to understand these building blocks before learning how to index your data and tune your application. | ||
| - | |||
| - | === Omnidex Environments === | ||
| - | |||
| - | An Omnidex Environment is a term that describes all the aspects an Omnidex database. This includes: | ||
| - | |||
| - | * The Omnidex Environment File, an XML file containing selective metadata about the database and the Omnidex indexing. | ||
| - | * The database, consisting of a relational database, a series of raw datafiles, a series of delimited files, or all three. | ||
| - | * The Omnidex indexes and support files for the database. | ||
| - | |||
| - | Typically, an Omnidex Environment is a directory with subdirectories that contain all of these elements. This is often the most convenient approach since whole directories are easy to move and back up. In many cases, however, the database and indexes are large enough that they must span multiple disk drives or even machines. In that case, the Omnidex Environment refers to the entire collection, even though it is disbursed. | ||
| - | |||
| - | [[admin:basics:environments:home | More >]] | ||
| - | |||
| - | ===== ===== | ||
| - | ---- | ||
| - | **[[admin:basics:overview:sqlengine | Next]] ** | ||
| === Omnidex SQL Engine === | === Omnidex SQL Engine === | ||
| Line 40: | Line 22: | ||
| [[admin:basics:sqlengine:home | More >]] | [[admin:basics:sqlengine:home | More >]] | ||
| - | === Omnidex Updates === | + | ===== ===== |
| - | + | ---- | |
| - | Omnidex allows databases to be updated either in batch or online. The large majority of companies choose to update their databases in batch, and this is in keeping with the design of Omnidex and the nature of large databases. Databases with lots of data and lots of indexes are inherently difficult to update online. Relational databases that have just a few indexes per table are often updated online; however, this in itself can cause performance problems. Omnidex databases with hundreds of indexes are best updated in batch. | + | \\ |
| - | + | **[[admin:basics:home | Prev]] | [[admin:basics:overview:updates | Next]] ** | |
| - | Omnidex provides high-speed, batch approaches to updating indexes that are must faster than relational databases, processing at rates of 1 billion index entries an hour. | + | |
| - | + | ||
| - | [[admin:basics:updates:home | More >]] | + | |
| - | + | ||
| - | === Network Services === | + | |
| - | + | ||
| - | Omnidex Network Services provide the core communication interface between the components of Omnidex. Based upon the TCP/IP standard, Omnidex Network Services provides the communication services for Omnidex's ODBC and JDBC drivers, as well as the internal communication used in Omnidex Grids. | + | |
| - | + | ||
| - | Omnidex Network Services normally runs as a service in Microsoft Windows, or as a background daemon on Linux. The main process will listen for network requests and spawn additional processes to service each request. It is common to see many Omnidex processes running on an Omnidex server, each one handling a request from a user. Note that Omnidex favors a separate process for each request to help improve control and stability of the application. | + | |
| - | [[admin:basics:network:home | More >]] | ||
| ====== Additional Resources ====== | ====== Additional Resources ====== | ||