Tagged Questions
This tag can be used by questions on database design, such as normalization vs. denormalization, SQL vs. NoSQL, learning about database design, etc...
0
votes
1answer
81 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 ...
8
votes
8answers
312 views
How should repetitive calendar tasks be stored in the database?
This is for a small personal project for micro-management. Basically, I store tasks in a SQLite3 database that looks like this:
id INTEGER PRIMARY KEY AUTOINCREMENT
label TEXT
deadline ...
-3
votes
0answers
43 views
which datastore is html friendly and scalable? [closed]
I wish to have a datastore which will be mostly user generated. Though I love the design aspects of websites, I am not very skilled/good at it. Which programming language? database/datastore? ...
12
votes
4answers
206 views
Can I use the database structure of an open source project?
I found a database structure for a CMS system and I want to copy it with the EF that this database is done in, is it OK to copy the database structure of open source software which is under GNU v2 ...
3
votes
2answers
71 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.
...
3
votes
1answer
127 views
What are the advantages and disadvantages of storing the number of comments in an integer column vs. calculating it on the fly?
Let's take CodeReview page as an example. If you go here, you will see the list of the questions with their vote numbers and comment numbers
Now, I am wondering if these numbers are calculated on the ...
2
votes
1answer
54 views
Who's responsible for a master / slave switch?
We are introducing a master / slave replication schema in our web application. At certain scenarios we would prefer to explicitly direct reads to a slave and writes to the master, which to me is an ...
1
vote
1answer
173 views
Books that every software system architect/data modeller must read
I hope I'm not confusing the term system architecture with the data model/database.
Is there a book out there that's the standard for describing best practices, design methodologies, and other ...
17
votes
4answers
413 views
Best Practices for Redesigning a Database
I'm aware of some general best practices when designing a database for an application, but what about redesigning?
I'm on a team tasked with re-designing an internal business application, though ...
4
votes
0answers
53 views
Relational database: in-RAM partitioning? Theoretical structure discussion
I'm rewriting an MMORPG server engine using some rather esoteric elements (theoretically good but rarely used in practice), and having a bit of doubt. Some elements of this are “solid” — but the point ...
1
vote
1answer
69 views
What's the best way to design a data and php model for a multi-account system?
I'm doing some high-level sketching of a system that will require users to register, when they do they get an account and can invite others to that account.
To be clear, an account would be similar ...
3
votes
2answers
106 views
two approaches to database modeling - which one to use when
recently I have noticed a new approach to data modeling vs what I have used so far. This seems to be a way to address modeling of an entity that has a very large set of fields and quite often many of ...
0
votes
5answers
261 views
Worst practices in developing database applications [closed]
In constrast to
http://programmers.stackexchange.com/questions/123591/database-design-good-practices
I wanted to ask:
What are the top worst practises you encountered when having to work with other ...
-4
votes
2answers
98 views
Badging System similar to Stack Overflows
I am thinking about a game that has a badging system in it, so I was planning on using something like the Badges on the Stack Exchange sites. The list of available badges is constantly growing, and ...
1
vote
0answers
109 views
Querying key/value store
Dunno if this question is reasonably answerable (and therefore will be closed), but I will take my chances: What are the possible problems (and solutions), one might encounter, when developing query ...
