Tagged Questions
2
votes
4answers
150 views
How to genericize foreign key references in table?
I am trying to design a table to store references to multiple tables as a "target" of the item in each row.
An example should clarify what I am trying to do:
Imagine you have 4 tables (images, ...
3
votes
3answers
164 views
Design pattern to dynamically create patterns found in a list of links
Can anyone help me think of a way to dynamically generate the patterns section of a tool I am creating? I'm not sure how to store and generate these "patterns" dynamically.
What the program does is ...
0
votes
0answers
11 views
Design pattern to dynamically create patterns found in a list of links [duplicate]
Can anyone help me think of a way to dynamically generate the patterns section of a tool I am creating? I'm not sure how to store and generate these "patters" dynamically.
What the program does is ...
1
vote
1answer
125 views
Multi-user Configuration Settings design
I am designing a flexible and extensible way to store configuration settings for users.
Database Table Design:
╔═════════════════════════════╗
║ ConfigurationItemDefinition ║
...
0
votes
1answer
91 views
What is a good design for a container, assignment and items
------------- 1 * -------------- * 1 --------
| Container |--------| Assignment |-----------| User |
------------- -------------- --------
^ ...
2
votes
3answers
166 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 ...
6
votes
1answer
72 views
Ledger or log design for a point-based system?
Right now creating a new service that will integrate into our company's existing platform. The service will be responsible for tracking "points" that a user can generate over time through certain ...
6
votes
4answers
215 views
Where ORMs blur the lines between code and data, how do you decide what logic should be a stored procedure, and what should be coded?
Take the following pseudocode:
CreateInvoiceAndCalculate(ItemsAndQuantities, DispatchAddress, User);
And say CreateInvoice does the following:
Create a new entry in an Invoices table belonging to ...
0
votes
1answer
430 views
Design Pattern for Complex Data Modeling
I'm developing a program that has a SQL database as a backing store. As a very broad description, the program itself allows a user to generate records in any number of user-defined tables and make ...
0
votes
2answers
276 views
Does there exist a design-pattern for this problem?
I have a big database of data which we can consider today's system. The data has a web front-end which allows my users to update the data. Let's call this "original solution"
When new users come in ...
1
vote
1answer
361 views
Modular Database Structures
I have been examining the code base we use in work and I am worried about the size the packages have grown to. The actual code is modular, procedures have been broken down into small functional (and ...
0
votes
1answer
110 views
Parameterized Django models
In principle, a single Django application can be reused in two or more projects, providing functionality relevent to both. That implies that the same database structure (tables and relations) will be ...
2
votes
2answers
972 views
Booking system (Handle working hours, Get available time slots) [closed]
I'm currently working on a time booking system for a friends hair salon. The plan is to try to keep it as simple as possible.
The user view (where the owner see the booked appointments) is more or ...
4
votes
5answers
963 views
Two database fields for date and time - should they be merged?
In the following question, field and table names have been changed to protect their identities.
If I have two database columns:
MONKEY_DATE DATETIME NULL (with data e.g. 2012-05-14 00:00:00.000)
...
5
votes
4answers
642 views
Design Patterns / Strategies For Custom Fields & Data Types
Are there any common strategies or design patterns for designing applications that have either the ability to add custom fields to data objects, or for creating your own custom definition of objects. ...
2
votes
2answers
110 views
Pattern for group of entities with one required primary member
Given a parent entity with a collection of child entities where there must be exactly one primary child of the group?
To make the question more concrete, I've seen a number of ways that this pattern ...
11
votes
2answers
328 views
What are the advantages of separating 'result' from 'status'
Let's say you have some automated processes that generally go through the following states;
scheduled - initiated - validating - executing - completed
On top of that these processes can prematurely ...
2
votes
2answers
289 views
Factory design pattern - getting the types from a table
I've implemented a generic factory as described here
I need to register elements to the factory hard-code like this:
Factory.Register(1, typeof(MyClass));
this factory will have to be correlated ...
3
votes
2answers
284 views
Is there a design pattern for modelling job execution flow?
In my application I have a set of jobs to execute:
Each job goes through the states "not started", "started", "completed", "failed" etc.
Each job has a set of pre-conditions and post-conditions.
...
5
votes
3answers
304 views
What design would you propose to log reporting data so that the capture of, say, an additional form field can implemented easier?
Why is there an emphasis to log reporting information through an application to a separate database?
I have seen designs where a logging manager is available to every business layer class whether it ...
