| For readers who asked for a detailed
database design |
| The SAITO application software
operates over HEIKI (兵器 = Japanese for 'weapons') |
|
which is a relational database. For civilians, that means that
data is stored on disk
|
|
as tables which are made up of rows which are, in turn, made
up of columns. So a table |
|
to store information about vendors (in this case, companies
that sell DNA sequencing
|
|
services) would likely have a row for each vendor and each row
would contain |
| columns containing the name of the
vendor, the type of the vendor, the website of |
| the vendor and
so on. Typically, software programs or human users send long
strings of |
|
SQL (Structured Query Language) to a database engine (another
program) which |
|
interprets the SQL and returns data. From the innermost walls of Lascaux a
graphic |
 |
| This means: (a) genes can have one or
more synonyms (b) so can syndromes |
| (c) genes can belong to one or more
syndromes (d) syndromes can have one or more |
| genes (e) genes can have one or more
mutations or variations (f) people can have one |
| or more mutations (g) vendors sell
one or more panels (h) panels are lists of one or |
| more genes (i) people get their DNA
analyzed by buying one or more panels |
| |