error handling techniques designed into database fields?

Question

What are some the postive reasons to have error handling techniques designed into database fields? What are some of the negative aspects that could result from this?

Answer 1

in theory you cannot have error handling designed into database fields but you can have error handling design as part of your software operations to trap error conditions and gracefully recover with out confusing the end user.



for example: in a 3 tier application you have the Data Access Layer(DAL), Business Layer (BAL) and The application Layer(APP).





APP Calls on BAL, BAL Call on DAL....

DAL reads data but some nut in the computer room switchs off your database server, so the DAL layer tell the BAL layer "My server is gone", then the BAL layer says to APP lay "We are current offline please retry in 2 minutes"....





grab a copy of the free visual studio express in a language of your choice, then visit www.asp.net and look for the starter kits and download the jobsite starter kit. that has perfect example of the various layers to which you can break down your code into layers to handle the application or interface layer, the business logic or your processing rules and the data access layer which controls the overall access to your datasource.



have fun.

Answer 2

Well, my guess is that these techniques will make the database run with less errors, and might be able to handle some of the errors that it handles on its own. On the other hand, you're putting more code and more commands into the database, and you're making it do more work, so there is a possibility for the database itself to encounter new errors. The more complicated you make something, the more likely and the more possible it is to run into problems.



Hope I helped! (Since I have no idea what an "error handling technique" is. I have done some basic programming, though.)



Nice pic, btw.

Answer 3

certain. without the autumn, there is no free will. what's the point of turning out to be a universe the position each man or woman is certain to both love or hate you without skill to make your recommendations up on for themselves? All you get in that scheme are angels and demons, that are boring, and which God already had besides.