Tagged Questions
4
votes
2answers
201 views
Which is a better design pattern for a database wrapper: Save as you go or Save when you're done?
I know this is probably a bad way to ask this question. I was unable to find another question that addressed this.
The full question is this: We're producing a wrapper for a database and have two ...
1
vote
2answers
92 views
Main class passes dbConn obj to all its services, I need to change the dbConn for one of its services. - suggestion for design pattern
There is this main class
and there are several services ( which uses db connection to retrieve data )
These services are initialized in the main class
db properties are obtained from the property ...
3
votes
2answers
231 views
“Don't cross the streams” Database access objects independant of the Data tier in an N-Tier architecture?
I'm adding functionality to our website which performs long-running processes asynchronously using MSMQ. Doing this ansynch, however means we need to notify users when their requests are completed. ...
8
votes
3answers
672 views
How to store prices that have effective dates?
I have a list of products. Each of them is offered by N providers.
Each providers quotes us a price for a specific date. That price is effective until that provider decides to set a new price. In ...
7
votes
3answers
1k views
What is the difference between all-static-methods and applying a singleton pattern?
I am making a database to store information about the users of my website (I am using stuts2 and hence Java EE technology). For the database I'll be making a DBManager. Should I apply singleton ...
8
votes
3answers
233 views
Best way to model a singleton in a relational database
When designing relational database schema for web applications, I often find a case where I end up creating a table just to contain one row, and only one row. It feels like that is the wrong way to ...