Course Outline

Database Logic analysis and problems

  • Where to find logic
  • How to distinguish logic which should be migrated out of database and the logic which can stay
  • Scalability issues
  • Creating unit tests

Migration strategies analysis - pros and cons

  • Flexibility vs speed
  • Speed vs scalability
  • Procedural Language to Service
  • PL to PL
  • Removing intermediate derived data (cash) and replacing with life logic
  • OLTP vs Warehouse

Design of new logic adapter service

  • Using traditional programming
  • Using Rule Engines or other Logic Engines
  • Unit Testing
  • Performance and scalability issues

Changing Client Site

  • ORM (Object-relations mapping) frameworks
  • Using web-service output instead of a query or stored procedure
  • Performance testing
  • Profiling (finding bottlenecks and performing optimisation)

Requirements

Good understanding of SQL, database structure and fair understanding of procedural language (e.g. PL/SQL, SQL PL, etc...)

  7 Hours
 

Testimonials (3)

Related Courses

Related Categories