Data Layer: Problems

  • Mixture of Storage (flat files, databases)
  • SQL code interspersed with business code
  • SQL calls not portable
    • Time calculations
    • Time formatting
    • Locking
    • Sequences
    • Blobs
    • Keyword conflicts