Business logic in the code or in the data base?

Question posted in Computer Software on 11 2009
Rate question difficulty level 0 Votes
Do you think that the data base should do handle with the business logic or it should only perform basic actions like update delete and select ?
 
 
10 Answers
 
Always in the code!
The idea of putting business logic in the database is a contradiction to the concept of loose coupling. the application will be less managable and certainly less modular.
Also:
- it will render object oriented concepts to elimintation.
- it limits the design to start from how to store instead of what to do with it.
- it requires more knowledge from the developer which now going to cost more.
- it will not haste the development or cut the costs.
- it forces your GUI to work directly with the database wihch opens a new series of ALSO:
* more licenses, since you will be using your db as your clients Server.
* multi-servers network will be a problem..
* security is less as your client directly involves the database.
There are even more problems... but I think those suffcient to decide.

11/07/2009
 
 
In my applications, we have 3 projects: Domain, DataBaseManager, Business logic...it's easy understand what each projecto do

11/07/2009
 
 
I think database should handle business logic only if business logic is data manipulation. Otherwise it's purpose of business module.

11/07/2009
 
 
I'm shocked that I found this info so esaliy.

01/13/2012
 
 

01/13/2012
 
 
valtrex ahh propecia 88830 flomax =-PPP

02/02/2012
 
 
 
 
 
 
 
 
 
 
Add an answer*
 
Your name
Email
 

add a question

arrow_blue


Now hiring!
Business Analyst, Product Development IT Relationship Managment Team
Vertex Pharmaceuticals 
Cambridge, MA
Activity Diagrams- In depth understanding of the various software development lifecycles (e.g. Agile, RUP, and ... - Bachelors Degree- In depth understanding of the various software development lifecycles (e.g. Agile, RUP, and...
---------------------------
IT Sourcing Procurement Analyst Software Service Infrastructure
CVS Caremark 
Woonsocket, RI
Strategy, including: Procurement Execution ?Maintain IT procurement process in collaboration with IT stakeholders ... legal risk mitigation strategy are addressed ?Support the development of executive briefings summarizing contract...
---------------------------
IT Project Manager - Information Systems Development
UnitedHealth Group 
Southfield, MI
innovative solutions to meet them * Participate in the development of business strategy * Develop and manages ... of healthcare for millions of people worldwide. It's your chance to be a transformational force in the...
---------------------------
Software Development Analyst/ .NET Developer- Health IT
Northrop Grumman 
Atlanta, GA
Sharp programming skills, eagerness for challenging development opportunities, and the ability to work with a ... of information security concepts and principles, as it pertains to application/service development and...
---------------------------
(IT Applications Analyst Developer Lead
Halliburton 
Houston, TX
Houston, TX DUTIES: Responsible for the development, acquisition, maintenance and support of applications in assigned ... plus 7 years of progressive experience in Systems Development and Application Support, including analysis,...
---------------------------
Mgr Software Development 2-Health IT
Northrop Grumman 
Little Rock, AR
and software developers. Works with members of the development team to ensure that all legacy data is ... years of relevant experience - Experience with IT Project Development Lifecycle - Experience converting data for...
---------------------------
IT Specialist (Applications Development)
Parsons 
Houston, TX
in software complexity. Makes a recommendation to senior IT management and the end user. Uses charts, diagrams and ... guidance to lower-level IT staff assigned to an application development project. * Develops functional specifications to...
---------------------------
Software Development Engineer (IT Security)
Amazon.com 
Seattle, WA
Role Description Amazon.com is looking for expert Software Development Engineers to develop tools supporting the IT ... for you. You will participate in every level of software development from requirements gathering to operational...
View all jobs