Business Logic: Database or Application Layer

by

Maintainability of your code is always a big concern when determining where business logic should go.

Integrated debugging tools and more powerful IDEs generally make maintaining middle tier code easier than the same code in a stored procedure. Unless there is a real reason otherwise, you should start with business logic in your middle tier/application and not in stored procedures.

However when you come to reporting and data mining/searching, stored procedures can often a better choice. This is thanks to the power of the databases aggregation/filtering capabilities and the fact you are keeping processing very close the the source of the data. But this may not be what most consider classic business logic anyway.

More Related Contents:

  1. Can we update primary key values of a table?
  2. Oracle (ORA-02270) : no matching unique or primary key for this column-list error
  3. How to display table data more clearly in oracle sqlplus
  4. Liquibase lock – reasons?
  5. How SID is different from Service name in Oracle tnsnames.ora
  6. Are foreign keys really necessary in a database design?
  7. Is it possible to generate django models from the database?
  8. What is a View in Oracle?
  9. What is the difference between Non-Repeatable Read and Phantom Read?
  10. Convert String ISO-8601 date to oracle’s timestamp datatype
  11. What is the default Precision and Scale for a Number in Oracle?
  12. Oracle: How do I convert hex to decimal in Oracle SQL?
  13. How to perform compound queries with logical OR in Cloud Firestore?
  14. Database development mistakes made by application developers [closed]
  15. What is NoSQL, how does it work, and what benefits does it provide? [closed]
  16. First name, middle name, last name. Why not Full Name?
  17. SQLite UPSERT / UPDATE OR INSERT
  18. Elastic search, multiple indexes vs one index and types for different data sets?
  19. In terms of databases, is “Normalize for correctness, denormalize for performance” a right mantra?
  20. Full-text search in NoSQL databases [closed]
  21. Import SQL dump into PostgreSQL database
  22. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  23. Multivalued Fields a Good Idea?
  24. Are Cloud Firestore queries still case sensitive?
  25. How should you build your database from source control?
  26. Strange behavior in PowerShell function returning DataSet/DataTable
  27. Oracle DB: How can I write query ignoring case?
  28. SQL DataType – How to store a year?
  29. Maximum number of rows in a sqlite table
  30. Any example of a necessary nullable foreign key?

Leave a Comment