• Limitations
• Data Modeling
• ER Diagrams
• ER Diagrams - Examples

• Data modeling is a large topic
• We're going to focus on one data modeling technique (Entity-Relationship Diagrams)
• What am I not telling you about?
  • Other data modeling techniques (see Data Modeling on Wikipedia for a more complete list)
  • Application modeling techniques like UML
  • User modeling techniques that attempt to document the user interaction
• This is an introduction
  • enough to get started and to know what you don't know (I hope)
• Ask questions!

A system to automate the tracking and documentation of plasmid construction

• Terminology:
  • fragment: a length of double-stranded DNA
  • plasmid: a circular fragment
  • recipe: a series of manipulations of the DNA to produce a new plasmid with cDNA of interest inserted
• Needs:
  • Data processing -- convert raw data into results
  • Visualization -- a way to visualize the results
  • Data storage -- store the results (and perhaps the raw data)

• Incremental implementation
  • Start coding right away with small parts of system
  • Add complexity as you go along
  • Pros:
    • get something done quickly
    • learn by doing
  • Cons:
    • will probably have to throw out a lot of code
    • early data model will constrain your implementation
    • changes to data model will require significant refactoring
    • over time, will become unmaintainable
  • Only recommended for quick-and-dirty throw-away code

• Detailed design
  • Produce detailed design
    • Data model
    • Class diagrams
    • UML, etc.
  • Code only after design complete
  • Pros:
    • probably get cleaner implementation
    • design documentation will serve to assist in maintenance
    • better able to scope project and estimate resources
  • Cons:
    • very time consuming
    • changes in research may happen too quick to make this practical
    • users may get inpatient
  • Only recommended for very limited, stable projects
  • Data model is key

• Hybrid approach
  • Produce data model design
  • Do incremental implementation
• Pros:
  • changing the data model is hard, probably will have the largest impact on your code
  • data model documentation is a useful document to discuss system with colleagues
  • get benefit of incremental implementation
• Cons:
  • still have to spend some up-front design time
  • will (undoubtedly) need to throw out some code or refactor
• Recommended approach for most projects

• The FIRST Step
• Structured way to understand the data semantics
• Independent of underlying platform
• Way to communicate with team members (including users)
• Excellent (minimal?) documentation
• Example: ER Diagrams

• Entity (Entity Type)
  • A collection of entities that share common properties (a thing)
    • e.g. Fragment, Recipe, Gene

• Attribute
  • Property of an entity that is of interest
    • e.g. Name, File, Sequence

• Relationship
  • An association between entities
    • e.g. Produces

• Degree
  • Number of entities involved in the relationship
    • one-to-many, one-to-one, many-to-many

• Extend the system....
  • Add the ability to extract the experimental details
  • Add more information about the gene: promotors, enhancers, RBS, introns, exons, CDS, etc.
  • Add information about the protein: structure, function, sequence, etc.

One possible design:

Drop "Feature" entity:

Expand structure:

1. The canonical: employee/employer/department system
2. Another database "favorite": sales/parts/inventory
3. More relevant: on-line laboratory information management system (LIMS)
4. Modeling systems:
   • apoptosis signaling pathway
   • ascending pain pathway

• Questions?

• Recommended Reading:
  • Chen, P.S. The entity-relationship model: toward a unified view of data. ACM Trans on Database Syst. pp 9-36 (March 1976)

Put together an ER diagram for a database system for cellular pathways. Include information about the proteins, metabolites, functions, interactions, cellular locations, and evidence codes. Don't attempt to be complete -- focus on the major entities and their relationships.