Tagged Questions
3
votes
1answer
157 views
implementing dynamic query handler on historical data
EDIT : Refined question to focus on the core issue
Context:
I have historical data about property (house) sales collected from various sources in a centralized/cloud data source (assume info ...
5
votes
1answer
420 views
To Repository Or Not To Repository
When I first learnt about Domain Driven Design, I was also introduced to the repository and unit of work patterns that once seemed to be top notch for the cool kids that threw SQL queries like ...
-1
votes
1answer
106 views
Should We Use Surrogate Primary Keys for Every Table? [duplicate]
We are developing a data model for a marketing database that will import transaction, customer, inventory, etc. files and the directive is ONE process that works for every client. We have been told ...
0
votes
0answers
79 views
Design of a custom query result array with lazy loading
I have a database that generates a query result array, each position of the array being a hash like object.
Since each array item must be mapped into a well defined class, I decided to implement an ...
1
vote
1answer
304 views
Creating a online database creator
I've been thinking of creating an online database creator (think DabbleDB, Zoho Creator, Intuit Quickbase, etc.).
I've been thinking of a couple solutions:
Have 4 database tables: Tables, Rows, ...
13
votes
5answers
6k 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 ...
1
vote
2answers
190 views
Pattern / methodology for representing large database records as objects
A bit of background information: We have an old database application written in Access that lets users monitor their workload, and the code is... 'procedural' might be too kind. The vast majority of ...
0
votes
1answer
146 views
Geographically Distributed (Data & App) Architecture
Is there any design patterns (or best practices) for implementing a geographically distributed system (mostly a database)?
Description: There is a network of warehouses and a central office. Now I ...
3
votes
2answers
2k views
Design pattern for logging changes in parent/child objects saved to database
I’ve got a 2 database tables in parent/child relationship as one-many.
I’ve got three classes representing the data in these two tables:
Parent Class
{
Public int ID {get; set;}
.. other ...
2
votes
3answers
514 views
Automatically observing changes in database tables
currently I'm working on a project with the following setting:
There is a proprietary application which performs transactions on a Microsoft Access database (which is actually stored as an .mdb ...
0
votes
3answers
143 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 ...
4
votes
1answer
313 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 ...
2
votes
3answers
325 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
550 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 ...
13
votes
3answers
2k 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 ...
4
votes
1answer
892 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
912 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
712 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
180 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
437 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
431 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 ...
