150 likes | 216 Views
Design and Development of a Discrete Simulation for Optic Nerve Development . By: Brent Hefty Greg Tevis Project Advisor: Samuel F. Hunter, M.D., Ph.D. Overall Purpose.
E N D
Design and Development of a Discrete Simulation for Optic Nerve Development By: Brent Hefty Greg Tevis Project Advisor: Samuel F. Hunter, M.D., Ph.D.
Overall Purpose • To design and implement a simulation for central nervous system generation and repair as a function of micro-environmental interactions.
Data Structure Development • Main Tables • Axon Table • Oligodendrocyte Table • Myelin Table • Astrocyte Table • Astrocyte Process Table
Axon Table • Important aspects • position • time
Oligodendrocyte Table • Important aspects: • sheath number • time
Myelin Table • Important aspects • time • references back to other table
Myelination Process Representation • Myelination Process Components • Myelinating Oligodendrocyte • Process attached to axon • Maximum of 10 - 20 turns at .07 um per turn. • Hypertophication after mylination
Astrocyte Table • Important aspects • time • position (due to size)
Astrocyte Process Table • Important aspects • branching • branching ID
Design of Table in SQL • Use SQL Server Enterprise Manager • Select New Table option • Fill in fields according to model: • Column Name • Datatype • Length • Precision • Scale • Allow Nulls • Default Value • Identity • Identity Seed • Identity Increment
Change of Table Values • Initial Table • Record Table • Updated Table
SQL Can publish to web Cannot import HTML tables Cannot hyperlink datatype Automatic backups Transaction log backup Automatic recovery Max. database size: 1,048,516 terabytes Very Large Database (VLD) support No built-in reporting Access Can publish to web Can import HTML tables Can hyperlink datatype No auotmatic backups No transaction log backup No automatic recovery Max. database size: 1.2 GB No Very Large Database (VLD) support Built-in reporting SQL vs. Access
Past Work: SQL is installed Tables are constructed Initial growth parameters and algorithms Future Work: Fill table field values Begin work on algorithm implementation Project Status