This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
admin:features:grids:creation [2012/04/04 15:55] doc |
admin:features:grids:creation [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 66: | Line 66: | ||
Here is an example of a CREATE ENVIRONMENT statement for an Omnidex Grid. | Here is an example of a CREATE ENVIRONMENT statement for an Omnidex Grid. | ||
- | <code sql> | + | <code> |
create environment "list_env" | create environment "list_env" | ||
maxthreads 4 | maxthreads 4 | ||
Line 95: | Line 95: | ||
Here is an example of a CREATE DATABASE statement for an Omnidex Grid. | Here is an example of a CREATE DATABASE statement for an Omnidex Grid. | ||
- | <code sql> | + | <code> |
create database "list" | create database "list" | ||
node NODE01 | node NODE01 | ||
Line 129: | Line 129: | ||
Here is an example of a CREATE TABLE statements for an Omnidex Grid. | Here is an example of a CREATE TABLE statements for an Omnidex Grid. | ||
- | <code sql> | + | <code> |
create table "HOUSEHOLDS" | create table "HOUSEHOLDS" | ||
node NODE01 | node NODE01 | ||
Line 159: | Line 159: | ||
As discussed in the [[admin:features:grids:partitions#how_are_referential_constraints_handled_such_as_primary_and_foreign_keys| partition scheme]], it is necessary to partition tables so that referential integrity is maintained. Typically, the parent is partitioned using criteria, as shown for HOUSEHOLDS above, and the child is partitioned along the foreign key. The PARTITION BY clause for a child shows the join criteria, as shown below: | As discussed in the [[admin:features:grids:partitions#how_are_referential_constraints_handled_such_as_primary_and_foreign_keys| partition scheme]], it is necessary to partition tables so that referential integrity is maintained. Typically, the parent is partitioned using criteria, as shown for HOUSEHOLDS above, and the child is partitioned along the foreign key. The PARTITION BY clause for a child shows the join criteria, as shown below: | ||
- | <code sql> | + | <code> |
create table "INDIVIDUALS" | create table "INDIVIDUALS" | ||
node NODE01 | node NODE01 |