Transcript No Slide Title

Optimizing Database Efficiency
Or, Finding The Happy Medium
Original Scenario
System: Skeletal Muscle
Region: Pelvic
Structure: Sartorius
Action
Origin
Insertion
Innervation
Arterial
Venous
Bounded by
Boundaries
Contains
Surface Anatomy
Common Anomalies
Illustrations
Femoral Nerve
Source
Branches
Motor
Sensory
lumbar plexus
(ventral primary rami
of spinal nerves L2-L4)
Categories of Anatomy Tables
(Annotation, Semantic and Anatomical layers are present, explicit and implied, crudely)
Bone
Structure:
Description
Notes
Nerve
Source
Branches
Motor
Sensory
Notes
Artery
Source
Branches
Suply to
Notes
Vein
Tributaries
Drains into
Region Drained
Notes
Organ/Part of Organ
Location/Description
Notes
Muscle
Origin
Insertion
Innervation
Artery
Notes
Topographical Anatomy
Structure/Space
Description/Boundaries
Significance
Joint or ligament
Description
Notes
Lymphatics
Location
Afferents from
Efferents to
Regions drained
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
Bone
Structure
Description
Notes
Nerve
Source
Branches
Motor
Sensory
Notes
Artery
Source
Branches
Supply to
Notes
Vein
Tributaries
Drains into
Region Drained
Notes
Organ/Part of Organ
Location/Description
Notes
Muscle
Origin
Insertion
Innervation
Artery
Notes
Topographical Anatomy
Structure/Space
Description/Boundaries
Significance
Joint or ligament
Description
Notes
Lymphatics
Location
Afferents from
Efferents to
Notes
Back to First Principles: Gray’s Anatomy
BoneFeatureTableID
50011 ilium
500111
5001111
Ala
Ext ernal Surf ace
Post erior gluteal line
Ant erior glut eal line
Inf erior gluteal line
You Can’t See the Forest for the Semantic Relations of the Trees
5001112
50011121
50011122
50011123
50011124
Internal Surf ace
arcuate line
iliac f ossa
iliac tuberosity
preauricular sulcus
5001113
50011131
50011132
50011133
50011134
Crest
ant erior iliac spine
posterior iliac spine
ext ernal lip
internal lip
5001114
50011141
Ant erior border
iliopubic eminence
5001115
Post erior border
50012 Ischium
5001112
Body
ext ernal surf ace
ant erior border
posterior obturator tubercle
ischial spine
ext ernal surf ace
gemellus superior
internal surf ace
coccygeus
lev at or ani
pelvic f ascia
point ed extremity
sacrospinous ligament
great er sciatic notch
internal surf ace
superior ramus
ext ernal surf ace
in f ront of a prominent margin
quadratus f emoris
ant erior to origin of quadratus f emoris
some f ibers of origin of the obt urat or externus
lower part of external surf ace
origin of part of adduct or magnus
internal surf ace
sharp ridge
f alcif orm prolongat ion of t he sacrot uberous ligament
ant erior to sharp ridge
origin of transv ersus perinei
origin of ischiocavernosus
posterior surf ace
f orms a large sweling, the tuberosit y of the ischium
lower t riangular port ion
out er portion of the lt p
adduct or magnus
inner portion of lt p
sacrotuberous ligament
upper t riangular portion
upper and out er area of the upt
semimem branosus
lower and inner area of t he upt
long head of t he biceps f emoris
semitendinosus
inf erior ramus
out er surf ace
obt urat or externus
some f ibers of the adduct or magnus
inner surf ace
medial border
out er ridge
deep lay er of superf icial perineal f ascia
inner ridge
inf erior f ascia of the urogenital diaphragm
two ridges join
in f ront of the point of junct ion
transv ersus perinei
if f ront of in f ront of the point of junction
crus penis v el clitoridis
ischiocavernosus
lateral border
f orms part f o the medial border of the obturat or f oramen
Pubis
body
internal surf ace
point of origin of the obt urat or int ernus
superior ramus
medial (f latt ened) portion
ant erior surf ace
upper and medial angle, immediat ely below t he crest
adduct or longus
lower down
obt urat or externus
adduct or brev is
upper part of the gracilis
posterior surf ace
lev at or ani
obt urat or int ernus
attachm ent ot t he puboprost atic ligaments
a f ew m uscular f ibers porlonged f rom t he bladder
upper border present s
the prominent pubic t ubercle (pubic spine)
inf erior crus of the subcut aneous (external) inguinal ring
inguinal ligam ent
well-def ined ridge
f orming part of the pectineal line
portion of the inguinal f alx (conjoined tendon of the obliquus internus and t ransv ersus
the relf elcted inguinal ligament
medial to the pubic tubercle
crest
inguinal f alx
rectus abdominus
pyramidalis
angle (point of junction of the crest wit h the medial border)
superior crus of t he subcutaneous ring
medial border
cartilage
bet ween the medial border and t he f ibrocartillaginous lamina
lateral border
obt urat or crest
f orms part of the circumf erence of t he obturator f oramen and af f ords at tachment of theobt urat or membrane
lateral portion
superior surf ace
continuation of the pectineal line
in f ront of the pect ineal line
cov ered by the pectineus
iliopect ineal eminence (point of junction of the ilium and pubis)
inf erior surf ace
oblique groov e
passage of obturat or v essels and nerv es
medially , the obturat or crest
f roms part of the circumf erence of t he obturator f oramen
giv es at tachment f or t he obturator mem brane
posterior surf ace
origin f or some f ibers of the obturator internus
inf erior ramus
Digging Into the Details
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
Bone”S” table
Name Structure Description Notes
BoneTable
Structure Pronunciation Description Featuretable
Featuretable
Feature Description Featureattachmenttable
Featureattachmenttable
Muscle Bone Ligament Tendon Joint Nerve Suture