This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
admin:admin:applications:prototype [2011/02/11 20:29] deb |
admin:admin:applications:prototype [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 7: | Line 7: | ||
===== Building Omnidex Applications ===== | ===== Building Omnidex Applications ===== | ||
- | [[admin:admin:applications:design|Design]] -> **[[admin:admin:applications:prototype|Prototype]]** -> [[admin:admin:applications:development|Development]] -> [[admin:admin:applications:testing|Testing]] -> [[admin:admin:applications:staging|Staging]] -> [[admin:admin:applications:production|Production]] -> [[admin:admin:applications:optimization|Optimization]] | + | [[admin:admin:applications:design|Design]] | **[[admin:admin:applications:prototype|Prototype]]** | [[admin:admin:applications:development|Development]] | [[admin:admin:applications:testing|Testing]] | [[admin:admin:applications:staging|Staging]] | [[admin:admin:applications:production|Production]] | [[admin:admin:applications:optimization|Optimization]] |
---- | ---- | ||
Line 27: | Line 27: | ||
Administrators usually create a small test database, often using an Omnidex Snapshot. This test database is useful for optimizing queries and predicting performance. Since Omnidex Snapshots reside in flat files, they are highly portable and can be moved to development servers. They do not require licenses for the relational database software, nor do they need the support of database administrators. This allows Omnidex prototyping to occur quickly and easily, without affecting the main data server. | Administrators usually create a small test database, often using an Omnidex Snapshot. This test database is useful for optimizing queries and predicting performance. Since Omnidex Snapshots reside in flat files, they are highly portable and can be moved to development servers. They do not require licenses for the relational database software, nor do they need the support of database administrators. This allows Omnidex prototyping to occur quickly and easily, without affecting the main data server. | ||
- | Omnidex Snapshots can be built on a subset of the database. At this stage of analyzing queries, the database does not need more than a few thousand rows. A smaller database allows quick changes to the indexing structure as queries are tuned, avoiding the complications of indexing the main database. Omnidex Snapshots can be built using the Omnidex Administrator. For more information on Omnidex Snapshots, refer to the article on [[admin:snapshots:home|Omnidex Snapshots]]. | + | Omnidex Snapshots can be built on a subset of the database. At this stage of analyzing queries, the database does not need more than a few thousand rows. A smaller database allows quick changes to the indexing structure as queries are tuned, avoiding the complications of indexing the main database. Omnidex Snapshots can be built using the Omnidex Administrator. For more information on Omnidex Snapshots, refer to the article on [[admin:features:snapshots:home|Omnidex Snapshots]]. |
The production database can be indexed directly as long as the development and testing process does not interfere with regular operations. If the database contains over 20 million rows, it is a candidate for an Omnidex Grid; therefore, a smaller database would be appropriate for prototyping. | The production database can be indexed directly as long as the development and testing process does not interfere with regular operations. If the database contains over 20 million rows, it is a candidate for an Omnidex Grid; therefore, a smaller database would be appropriate for prototyping. | ||
Line 37: | Line 37: | ||
Omnidex Environments are created interactively using the Omnidex Administrator, or are created with SQL statements such as CREATE ENVIRONMENT, CREATE DATABASE, CREATE TABLE and CREATE INDEX. Both of these approaches will create an XML file that contains all of the meta-data describing an Omnidex-enhanced database. | Omnidex Environments are created interactively using the Omnidex Administrator, or are created with SQL statements such as CREATE ENVIRONMENT, CREATE DATABASE, CREATE TABLE and CREATE INDEX. Both of these approaches will create an XML file that contains all of the meta-data describing an Omnidex-enhanced database. | ||
- | The [[admin:environments:home|Omnidex Environments]] section of the documentation discusses how to create and connect to Omnidex Environments. | + | The [[admin:basics:environments:home|Omnidex Environments]] section of the documentation discusses how to create and connect to Omnidex Environments. |
=== 3. Creating Omnidex Indexes === | === 3. Creating Omnidex Indexes === | ||
Line 47: | Line 47: | ||
Omnidex indexes can be built interactively using the Omnidex Administrator, or can be built using the UPDATE INDEXES statement. | Omnidex indexes can be built interactively using the Omnidex Administrator, or can be built using the UPDATE INDEXES statement. | ||
- | The [[admin:indexing:create|Creating Omnidex Indexes]] section of the documentation discusses how to create and build Omnidex indexes. | + | The documentation on [[admin:indexing:creation:home|Index Creation]] discusses how to create and build Omnidex indexes. |
=== 4. Optimizing Queries === | === 4. Optimizing Queries === |