Self Study - Neuroinformatics
To standardize and streamline the process of data collection and to produce more timely results.
This was a passion project. Though I was forewarned of its complexity I was determined to complete it. The project taught me about neuroscience and database architecture. Most importantly, it required me to think outside the scope of our class curriculum to determine innovative solutions. The sure scale and variety of data formats forced me to seek alternative solutions to organize the collection process and efficiently compose the data in an organizational schema. I found a solution in designing a hybrid database model, one that reduces the complexity by having “attribute” entities consisting of “attribute” classes; a nest like structure. The model is similar to a fan pattern and in my design reduced the complexity of the schema.
A fulfillment for two classes, my project of choice was to investigate a hypothetical design for a research-based system revolving around the neuron connections of the brain. An abstract statement is provided below.
Lessons Learned
Relational modeling and logical design
SQL- implementing, populating, and querying databases
Organizational and managerial decisions in database development
Rationalizing Scale
Three main problems prevailed in the processing of data:
Lack of an anatomically organized collection process within industry to place data in an organizational schema
Need for a sizable network volume to handle heavy data load (10.5TB)
Configuring both schema and network in human readable form
Techniques
Hybrid rational, entity-attribute-value (EAV) database model
Benefits
"Attribute" titled entities consisting of "attribute" classes to reduce complexity
Comparable to "fan" pattern
Interoperability, adaptability, and scalability
Drawbacks:
Lack of integrity constraints and null values
Extensive upfront work
Use Case 1: Data Analysis
Relevant Models