110 likes | 228 Views
Optimizing Database Efficiency. Or, Finding The Happy Medium. Action Origin Insertion Innervation Arterial Venous Bounded by. Original Scenario. System: Skeletal Muscle Region: Pelvic Structure: Sartorius. Boundaries Contains Surface Anatomy Common Anomalies Illustrations.
E N D
Action Origin Insertion Innervation Arterial Venous Bounded by 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
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
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.
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
You Can’t See the Forest for the Semantic Relations of the Trees
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
BoneTable Structure Pronunciation Description Featuretable Featuretable Feature Description Featureattachmenttable Featureattachmenttable Muscle Bone Ligament Tendon Joint Nerve Suture Bone”S” table Name Structure Description Notes