Optimizing Database Efficiency

1
Optimizing Database Efficiency
2
Or, Finding The Happy Medium
3
Original Scenario
System Skeletal Muscle Region Pelvic Structure
Sartorius
Boundaries Contains Surface Anatomy Common
Anomalies Illustrations
Source Branches Motor Sensory
lumbar plexus (ventral primary rami of spinal
nerves L2-L4)
Femoral Nerve
4
Categories of Anatomy Tables
(Annotation, Semantic and Anatomical layers are
present, explicit and implied, crudely)
Vein Tributaries Drains into Region Drained Notes
Bone Structure Description Notes
Topographical Anatomy Structure/Space Description/
Boundaries Significance
Nerve Source Branches Motor Sensory Notes
Joint or ligament Description Notes
Organ/Part of Organ Location/Description Notes
Lymphatics Location Afferents from Efferents
to Regions drained Notes
Muscle Origin Insertion Innervation Artery Notes
Artery Source Branches Suply to Notes
5
Anatomy Table Examples
Bone Structure Description Notes
femoral n. Source lumbar plexus
(ventral primary rami of spinal nerves L2-L4)
Branches anterior femoral
cutaneous
brs., nn. to sartorius m.,
rectus femoris m., vastus
lateralis
m., vastus
intermedius m., vastus
medialis m., pectineus m.
Motor
sartorius, rectus femoris,

vastus lateralis, vastus

intermedius, vastus
medialis,
pectineus
Sensory skin of
anterior thigh

Notes passes under inguinal


ligament lateral to femoral a.



6
Categories of Anatomy Tables
Vein Tributaries Drains into Region Drained Notes
Bone Structure Description Notes
Topographical Anatomy Structure/Space Description/
Boundaries Significance
Nerve Source Branches Motor Sensory Notes
Joint or ligament Description Notes
Organ/Part of Organ Location/Description Notes
Lymphatics Location Afferents from Efferents
to Notes
Muscle Origin Insertion Innervation Artery Notes
Artery Source Branches Supply to Notes
7
Back to First Principles Grays Anatomy
8
You Cant See the Forest for the Semantic
Relations of the Trees
9
Digging Into the Details
10
What To Do
femoral n. Source lumbar plexus
(ventral primary rami of spinal nerves L2-L4)
Branches anterior femoral
cutaneous
brs., nn. to sartorius m.,
rectus femoris m., vastus
lateralis
m., vastus
intermedius m., vastus
medialis m., pectineus m.
Motor
sartorius, rectus femoris,

vastus lateralis, vastus

intermedius, vastus
medialis,
pectineus
Sensory skin of
anterior thigh

Notes passes under inguinal


ligament lateral to femoral a.



Parse the Major Categories Into Feature Tables,
and use the features to link between Systems
11
BoneTable Structure Pronunciation Description
Featuretable Featuretable Feature Description
Featureattachmenttable Featureattachmenttable Musc
le Bone Ligament Tendon Joint Nerve Suture
BoneS table Name Structure Description Notes