Click here to Skip to main content
15,888,401 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
AnswerRe: QUERY FOR ALL vs QUERY FOR EACH Pin
jschell6-Jun-13 10:15
jschell6-Jun-13 10:15 
GeneralRe: QUERY FOR ALL vs QUERY FOR EACH Pin
Paulo S X Soares7-Jun-13 5:22
Paulo S X Soares7-Jun-13 5:22 
GeneralRe: QUERY FOR ALL vs QUERY FOR EACH Pin
jschell10-Jun-13 9:02
jschell10-Jun-13 9:02 
QuestionHelp on designing DB/ Web Service Pin
DavJes4-Jun-13 7:49
DavJes4-Jun-13 7:49 
AnswerRe: Help on designing DB/ Web Service Pin
jschell4-Jun-13 8:54
jschell4-Jun-13 8:54 
AnswerRe: Help on designing DB/ Web Service Pin
Eddy Vluggen4-Jun-13 8:55
professionalEddy Vluggen4-Jun-13 8:55 
GeneralRe: Help on designing DB/ Web Service Pin
DavJes9-Jun-13 7:03
DavJes9-Jun-13 7:03 
GeneralRe: Help on designing DB/ Web Service Pin
Eddy Vluggen10-Jun-13 3:26
professionalEddy Vluggen10-Jun-13 3:26 
DavJes wrote:
Please just guide me to learn how to do DB design and webservice architecture
Can't give more pointers on webservices than the book I mentioned. I've listed some resources on database-normalization, which would be the preferred design IMHO.
  • MSDN[^], explains up to rule #6
  • MSDN[^], tips
  • Wikipedia[^], with examples and explanation. (Links halfway details on every step)
  • SqlMag[^] has a nice introduction on the topic, as well as a link that explains when normalization should be skipped.
Personally, I don't go all the way, just upto BCNF. It's boring and tedious stuff to learn and apply, but I wouldn't recommend it if the advantages don't outweigh the disadvantages; the result will be more confidence in the model used, fewer design-errors, and within a few tables you'll be normalizing your structures without effort.

The reason I recommended Mannings' SOA patterns[^] is because it focuses on the most-used patterns; a pattern is a proven and reusable solution, and that's always a nice thing to have in any architecture. I also recommend it because I read and enjoyed it myself Smile | :)
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

QuestionTransactional MSMQ & firewall Pin
John Padgett27-May-13 22:35
John Padgett27-May-13 22:35 
AnswerRe: Transactional MSMQ & firewall Pin
jschell28-May-13 9:31
jschell28-May-13 9:31 
QuestionSOA and exposing a program from the 80s Pin
darklies17-May-13 19:37
darklies17-May-13 19:37 
AnswerRe: SOA and exposing a program from the 80s Pin
jschell20-May-13 11:09
jschell20-May-13 11:09 
GeneralRe: SOA and exposing a program from the 80s Pin
darklie22-May-13 16:41
darklie22-May-13 16:41 
GeneralRe: SOA and exposing a program from the 80s Pin
jschell24-May-13 12:26
jschell24-May-13 12:26 
QuestionLanguage features required (or useful) for numerical computing Pin
harold aptroot15-May-13 3:49
harold aptroot15-May-13 3:49 
AnswerRe: Language features required (or useful) for numerical computing Pin
jschell15-May-13 8:31
jschell15-May-13 8:31 
GeneralRe: Language features required (or useful) for numerical computing Pin
harold aptroot15-May-13 9:12
harold aptroot15-May-13 9:12 
GeneralRe: Language features required (or useful) for numerical computing Pin
dusty_dex15-May-13 10:02
dusty_dex15-May-13 10:02 
GeneralRe: Language features required (or useful) for numerical computing Pin
harold aptroot15-May-13 21:15
harold aptroot15-May-13 21:15 
GeneralRe: Language features required (or useful) for numerical computing Pin
dusty_dex15-May-13 23:09
dusty_dex15-May-13 23:09 
QuestionBooks on Design & Architecture Pin
Mohammed Hameed12-May-13 23:15
professionalMohammed Hameed12-May-13 23:15 
AnswerRe: Books on Design & Architecture Pin
ospmojamcpds27-May-13 6:51
professionalospmojamcpds27-May-13 6:51 
GeneralRe: Books on Design & Architecture Pin
Mohammed Hameed27-May-13 19:05
professionalMohammed Hameed27-May-13 19:05 
GeneralRe: Books on Design & Architecture Pin
ospmojamcpds28-May-13 20:29
professionalospmojamcpds28-May-13 20:29 
GeneralRe: Books on Design & Architecture Pin
Mohammed Hameed29-May-13 5:02
professionalMohammed Hameed29-May-13 5:02 

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.