Tagged Questions
0
votes
1answer
22 views
Store Arbitrary values related to mysql record
I have created an app that manages a Data cleansing workflow. Each row imported needs to store an arbitrary number of key value pairs in addition to our standard mysql schema. The key values need to ...
-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 ...
4
votes
3answers
279 views
Designing a fitness / weight lifiting routine database
I'd like to create an app similar to Barbell Pro for Android, for practice / interest / educational purposes really. Or even as another example for database purposes, Fitocracy
The problem is, I ...
3
votes
1answer
310 views
State pattern vs Inheritance
In the following image for the State Pattern from Applying Domain-Driven Design and Patterns: With Examples in C# and .NET
I'm trying to persist the SalesOrder entity into the database. Normally I ...
2
votes
4answers
362 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, ...
1
vote
2answers
138 views
Should a DR & CR entry both be created or a single-entry accounting is fine
A new project has an amount. It is always related to a client.
One client can have many projects. And he may pay in steps for a particular project.
In order to keep track of client payments, I've ...
3
votes
1answer
733 views
Database design/relationship for threading messages
What's the database design or business logic for creating an app for messaging between users?
I am having difficulties with choosing how to approach the relationship between each Conversation of User ...
5
votes
5answers
2k 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)
...
3
votes
3answers
263 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 ...
1
vote
1answer
348 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
121 views
What is a good design for a container, assignment and items
------------- 1 * -------------- * 1 --------
| Container |--------| Assignment |-----------| User |
------------- -------------- --------
^ ...
2
votes
3answers
323 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
110 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 ...
5
votes
4answers
258 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
764 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
305 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
732 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
139 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
2k 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 ...
7
votes
4answers
2k 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
119 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
337 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
356 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
497 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
325 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 ...
