Click here to Skip to main content
15,887,676 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
GeneralRe: Abstract factory Pin
Shameel17-May-11 4:21
professionalShameel17-May-11 4:21 
GeneralRe: Abstract factory Pin
Phil00520-May-11 22:09
Phil00520-May-11 22:09 
QuestionUML state diagrams Pin
Phil00510-May-11 7:39
Phil00510-May-11 7:39 
AnswerRe: UML state diagrams Pin
Gerben Jongerius10-May-11 21:19
Gerben Jongerius10-May-11 21:19 
GeneralRe: UML state diagrams Pin
Phil00515-May-11 1:22
Phil00515-May-11 1:22 
AnswerRe: UML state diagrams Pin
Keld Ølykke24-May-11 3:16
Keld Ølykke24-May-11 3:16 
GeneralRe: UML state diagrams Pin
Phil00527-May-11 1:04
Phil00527-May-11 1:04 
QuestionStored Procedures Pin
Leslie Sanford9-May-11 17:38
Leslie Sanford9-May-11 17:38 
I was wondering what the best practises are for stored procedures. Basically, I'm still struggling with a kind of code explosion that occurs when writing code that's related to the database. In the end, what I need to do is move data into and out of the database while sometimes performing transformations and doing error checking along the way. I've found over and over again that it takes a lot of code to do this.

I'm curious if stored procedures are a good way to abstract out of code such things as queries, inserts, updates, etc., and move them into the database itself.

In a way, this relates to a thread I created here a few months ago about database code. I'm trying to get a handle on how to deal with complexity. I'm finding that database programming is largely procedureal in nature, so I'm not finding my experience with Object Oriented programming and patterns to be of much use.
AnswerRe: Stored Procedures Pin
Gerben Jongerius10-May-11 21:27
Gerben Jongerius10-May-11 21:27 
AnswerRe: Stored Procedures Pin
jschell24-May-11 8:43
jschell24-May-11 8:43 
QuestionThinking about the Future Pin
John D. Sanders6-May-11 8:53
John D. Sanders6-May-11 8:53 
AnswerRe: Thinking about the Future Pin
Pete O'Hanlon6-May-11 9:26
mvePete O'Hanlon6-May-11 9:26 
GeneralRe: Thinking about the Future Pin
Sandeep Mewara6-May-11 17:41
mveSandeep Mewara6-May-11 17:41 
GeneralRe: Thinking about the Future Pin
Pete O'Hanlon6-May-11 22:39
mvePete O'Hanlon6-May-11 22:39 
GeneralRe: Thinking about the Future Pin
Paul Michalik14-May-11 22:56
Paul Michalik14-May-11 22:56 
GeneralRe: Thinking about the Future Pin
Pete O'Hanlon17-May-11 1:23
mvePete O'Hanlon17-May-11 1:23 
AnswerRe: Thinking about the Future Pin
RobCroll6-May-11 16:51
RobCroll6-May-11 16:51 
AnswerRe: Thinking about the Future Pin
Shameel9-May-11 2:33
professionalShameel9-May-11 2:33 
AnswerRe: Thinking about the Future Pin
weberrich31-May-11 5:55
weberrich31-May-11 5:55 
GeneralRe: Thinking about the Future Pin
John D. Sanders31-May-11 7:06
John D. Sanders31-May-11 7:06 
QuestionAbout Three -Tier and N-tier Architecture? Pin
maruthimaru29-Apr-11 22:58
maruthimaru29-Apr-11 22:58 
AnswerRe: About Three -Tier and N-tier Architecture? Pin
DaveAuld29-Apr-11 23:08
professionalDaveAuld29-Apr-11 23:08 
AnswerRe: About Three -Tier and N-tier Architecture? Pin
Sandeep Mewara30-Apr-11 0:22
mveSandeep Mewara30-Apr-11 0:22 
AnswerRe: About Three -Tier and N-tier Architecture? Pin
Legor5-May-11 3:35
Legor5-May-11 3:35 
QuestionMVC Implementation Question Pin
Roger Wright25-Apr-11 18:13
professionalRoger Wright25-Apr-11 18:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.