Tagged Questions
3
votes
1answer
147 views
Application Design with a Shared Database
I have a generic design question that relates to enterprise applications but I think that software developers from other types of projects may have experience with this as well.
The scenario is ...
0
votes
3answers
114 views
Search on multiple values
I have a database having around 15 tables.Currently I am working on a report generation page, which is having 16 criteria.The values are distributed among multiple tables.User can select any number of ...
2
votes
3answers
155 views
Using a database for each module in a system [duplicate]
I was reading this question:
I was trying to standardize and modularize some functions (Email
Management Module, CMS Module & etc) by implementing a 3-tier
architecture concept where each ...
0
votes
2answers
311 views
Designing a Web Application with Two Different Backend Databases [closed]
I'm working on a pretty standard LAMP based web application. The server itself has a standard MySQL database and the application is written in PHP. The kicker is, we also use SQL Server databases ...
4
votes
1answer
208 views
Methodologies for Managing Users and Access?
This is something I'm having a hard time getting my head around. I think I might be making it more complicated than it is.
What I'm trying to do is develop a method to store users in a database with ...
2
votes
2answers
485 views
Design pattern for access to tree-like database in Java?
I'm developing a Roleplaying character viewer/manager programme for a locap LARP system. The Characters have access to skills that are layed out in a tree-like structure. There are a lot of skills, ...
4
votes
2answers
510 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
153 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
335 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. ...
13
votes
3answers
1k 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
3k 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
284 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 ...
