Database Reference
In-Depth Information
Figure 3.2
shows how the data in
Listing 3.2
might be stored in a five-node
cluster using a
COMPOUND KEY
.
Figure 3.2
Illustration of how data may be stored using a
COMPOUND KEY
Listing 3.2
Illustration of How Data May Be Stored Using a
COMPOUND KEY
CREATE TABLE animals (
name TEXT,
species TEXT,
subspecies TEXT,
genus TEXT,
family TEXT,
PRIMARY KEY(family, genus)
);
SELECT * FROM animals;
name | family
| genus | species
| sub-
species
......+..........+.......+..................+.................
dog | Canidae | Canis |
C. lupus | C. l.
familiaris
wolf | Canidae | Canis |
C. lupus
|
null
cat | Felidae | Felis |
F. catus
|
null
