This shows you the differences between two versions of the page.
|
admin:features:rollups:create [2011/01/10 22:41] els created |
admin:features:rollups:create [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | ====== Administration: Omnidex Features ====== | ||
| - | |||
| - | ===== Rollup Tables ===== | ||
| - | |||
| - | [[admin:features:rollups:home|Overview]] -> [[admin:features:rollups:design|Design]] -> **[[admin:features:rollups:create|Creation]]** -> [[admin:features:rollups:indexing|Indexing]] -> [[admin:features:rollups:optimization|Optimization]] | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ==== Creating Rollup Tables ==== | ||
| - | A rollup table is quite easy to create. The rollup tables are first created in the Omnidex Environment File, complete with the SQL statement that represents the rollup data. Then the UPDATE ROLLUPS command is issued in ODXSQL to populate the rollup tables. Here is a simple example of creating a rollup that provides counts of people based on geographic regions: | ||
| - | |||
| - | <code> | ||
| - | create table "LIST_GEO" | ||
| - | type ROLLUP | ||
| - | physical "dat\list.geo" | ||
| - | as "select COUNTRY, REGION, STATE, COUNTY, CITY, ZIP, MSA_CSA, PMSA, | ||
| - | count(*) NUM_INDIVIDUALS | ||
| - | from LIST | ||
| - | group by COUNTRY, REGION, STATE, COUNTY, CITY, ZIP, MSA_CSA, PMSA" | ||
| - | </code> | ||
| - | |||
| - | |||
| - | In ODXSQL, ODBC or JDBC, the following command will populate the rollup tables in the Omnidex Environment: | ||
| - | |||
| - | update rollups | ||
| - | |||
| - | ==== ==== | ||
| - | **[[admin:features:rollups:design|Prev]]** | **[[admin:features:rollups:indexing|Next]]** | ||
| - | |||
| - | ====== Additional Resources ====== | ||
| - | |||
| - | {{page>:admin:features:see_also&nofooter&noeditbtn}} | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||