database design - Decoupling using stored procedures at what cost? -


I was taught to reduce the code implementation with database implementation through the use of stored procedures, For example:

decoded DAO methods (C #) 

  User FindByName (string value); User FindByLogin (string value); User FindByEmail (string value); User FindByFoo (string value); User FindByBar (string value); Contrast with  
  no-so-dekopple dao methods   
  Find user (string ) ColumnName, string value);  
 
 This is the result of writing a lot of code (though, it assumes that most of these will be cut and paste), very few stored procedures are written and kept, but also added Code for database implementation 
 
 In this case, where is the line between good and impractical design practice?

The decompressing is not as bad as you anticipate. In your example, you have the possibility of FindByName () and FindByLogin () , and no option is available.

What exactly are you demanding a good fragmentation between your compiled code and the database, do not spread the stored procedures. Ideally It should be coded in such a way that not only will there be no change in your compiled code to change the contents of stored procs, but rather the whole database system think it like this- stored work The signature is like an interface, your compiled code does not care that the type and rules of the input and output remain the same.

Of course this is an ideal scenario and this does not mean that you have to do this, it can be exaggerated for your situation and can be completely engineered. A simple fuzzy FindBy () can be perfect to meet your current and future needs. Your application for database call structure can be as granular as you want it to be. But this does not mean that your FindBy (string columnname, string value) is essentially a good option because it's going to bind you for a particular table or visual structure (even if you actually Calling stored procedure to implement it), which you are trying to avoid being separated from your code / database.

At the end of the day, it comes down to a compromise:

  • Does it meet current requirements
  • Is it necessary
  • Is it worth it
  • Is it worth it
  • This is testable
    • < / Ul>

-

Comments

Post a Comment

Popular posts from this blog

Eclipse CDT variable colors in editor -

I hope this is a good question to ask here. This programming is related, so I thought it would be better than the superuser, so I am using the CDT C ++ Eclipse plugin. I know how the editor changes colors for some things But is there a way to do that all the variables are different colors? For example in KDEValue, it sets the local variables and square variables in different colors and bold square squares. Can I copy it to CDT? Eclips provides some level of color customization for text editor syntax You can see it on the following: There are many elements, including the Window> Preferences> C / C ++> Editor> Syntax color code that can be changed, assembly, Comments, Preprocessor and Doxian Under the code, it is possible to change the color of some variable types, such as global variables, local variable announcements, local variable references, and parameter variables. But I do not think the code is capable of changing the color of each variable declared....
Read more

AJAX doesn't send POST query -

$ (दस्तावेज़) .ready (function () {function ajaxselectrss (rssurlvar) {var ajaxRequest; // वेरिएबल जो अजाक्स को संभव बनाता है! कोशिश करें कि {// ओपेरा 8.0+, फ़ायरफ़ॉक्स, सफारी अजाक्स अनुरोध} = नया एक्सएमएलएचटीपीआरइवेस्ट ();} कैच (ई) {// इंटरनेट एक्सप्लोरर ब्राउज़र्स {ajaxRequest = new ActiveXObject ("Msxml2.XMLHTTP");} पकड़ो (ई) {try {ajaxRequest = new ActiveXObject ("Microsoft.XMLHTTP");} कैच (ई) {// कुछ गलत चेतावनी ("आपका ब्राउज़र तोड़ दिया!"); वापसी झूठी;}}} // एक बनाएं फ़ंक्शन जो सर्वर से भेजे गए डेटा प्राप्त करेंगे ajaxRequest.onreadystatechange = function () {if (ajaxRequest.readyState == 4) {var ajaxDisplay = document.getElementById ('news'); ajaxDisplay.innerHTML = ajaxRequest.responseText;}} / / Var rssurlvar = $ (this) .attr ("title"); var queryString = "rurl =" + rssurlvar; var urltofile = "rssget.php"; ajaxRequest.open ("पोस्ट", urltofile, सच); ajaxRequ Est.setRequestHeader ("सामग्री-प्र...
Read more

wpf - Custom Message Box Advice -

Well, I'm using a custom window box that comes with some custom control boxes that accompany the text The producers who are displayed are called. I have a defined event, which has been subscribed through the original class, it gets burnt when clicking on the button. However, I can not see how to use it effectively, I would like to return one yes, whether yes or not, but obviously my code will continue to execute, so this Below is some example code to clarify the problem that the method has subscibed by clicking on the button. Message box window Public partial class custom message box: window {public representative message messagebox object sender, event events e); Public event messagebox handler messagebox document; Public Customs Box () {Initial group (); } Public Customsbox (String Message) {InitializeComponent (); This.txtdescription.Text = Message; } Public Customsbox (String Message, String Title, String First BTNtext) {Initialization (); This.lbltitle.Content =...
Read more