Using stored procedures or ORM

Question posted in Computer Software on 07 2010
Rate question difficulty level 0 Votes
Do you think it's better to use stored procedures over ORM/hibernate or the opposite ?
Please specify why would you rather one over the other ?
 
 
3 Answers
 
Sorry but what is ORM/hibernate ? Object-Relational-Model?

07/18/2010
 
 
ORM - Object-relational mapping (ORM, O/RM, and O/R mapping) in computer software is a programming technique for converting data between incompatible type systems in object-oriented programming languages. This creates, in effect, a "virtual object database" that can be used from within the programming language. There are both free and commercial packages (for example hibernate) available that perform object-relational mapping, although some programmers opt to create their own ORM tools.

credits : http://en.wikipedia.org/wiki/Object-relational_mapping

07/18/2010
 
 
I've had the change to work with both , and there's no simple answer.
Part of designing your system is trying to answer this question.

Basically, if your database is rather simple and does not contain a lot of entities and relations, you might consider going with the old fashion stored procedures and queries.

If not, as part of the ERD design , you should consider at some point a solution involving an ORM.

07/19/2010
 
 
Add an answer*
 
Your name
Email
 
Company: SolarEdge
Location: Israel
database db sql

add a question

arrow_blue


Now hiring!
IT & Engineering Professionals w/ Poly
SRA International 
Herndon, VA
Business focuses on providing high-end information technology solutions and support to clients within the ... Architects ? Configuration Management Specialists ? Software Engineers ? Software Developers ? Geospatial...
---------------------------
IT Application Analyst
Saint Barnabas Health Care System 
Oceanport, NJ
projects. Participate in and provide leadership for development and support of automation initiatives. Research ... skills. Experience in w orking with and developing hospital information systems. Patient Accounting and/or registration...
---------------------------
Lead IT Developer-H/R Payroll, Staffing, and Learning
Home Depot 
Atlanta, GA
to anticipate hardware and software design needs. The Lead Developer must have the ability to view packages and ... AND SCOPE - * Typically reports to Manager, Information Technology * No associates report to this role on a...
---------------------------
IT Mgr Software Engineering
Apollo Group 
Phoenix, AZ
supervision and the software development guidelines and technology standards defined by Apollo Corporate IT, this ... Experience supervising and/or leading other professional level IT staff is required...
---------------------------
Senior Software Developer - Info Technology Job
Mercer 
Deerfield, IL
Senior Software Developer - Info Technology-DEE000C5 Description Mercer is the global leader for trusted Human Resources ... information, please visit us at: www.mmc.com/diversity. Job Information Technology/Software Development Primary Location...
---------------------------
Software Development Manager 2 - Health IT
Northrop Grumman 
Providence, RI
Northrop Grumman is seeking an experienced Software Development Manager to join our team of qualified, diverse ... years of relevant experience - Experience with IT Project Development Lifecycle - Strong Medicaid/Medicare business...
---------------------------
IT Mgr Software Development
Apollo Group 
Phoenix, AZ
supervision and the software development guidelines and technology standards defined by Apollo Corporate IT, this ... design, development, coding, testing and debugging of new software or significant enhancements to existing software.
---------------------------
Software Development Analyst 2 - Health IT
Northrop Grumman 
Providence, RI
Northrop Grumman Information Systems Sector is seeking a Software Development Analyst 2 to join our team of qualified, ... development life cycle (SDLC) in support of application software from design, development, testing, documentation...
View all jobs