3.6.05. Design in context

  • Query design needs context
    • Hardware information
    • Competition information (other Application Servers)
      • MySQL, Apache, Tomcat, SVN
    • Data information
      • Likely number of rows, lifetime of information, interval distribution within domains
    • Database design information
    • Database implementation information
      • Transaction granularity
    • Use information
      • Balance between read (SELECT) and write (INSERT, UPDATE, DELETE) ops