Tagged Questions
7
votes
1answer
184 views
When should you use a document vs relational vs graph database? [closed]
For the purposes of discussion let's consider a FourSquare scenario.
Scenario
Entities:
Users
Places
Relationships:
Checkins: users <-> places, many to many
Friends: users <-> users, ...
8
votes
5answers
499 views
Is it the job of programmers to design the database?
I've been a programmer for the past six years. Throughout my career, I have worked on many web applications.
Most of the time, when a database was needed, it was given to us (the programmers) or we ...
1
vote
4answers
141 views
Web application - database design/infrastructure
I have just begun development of a web application (that will be deployed using Google app engine), without going into the specifics, the web app will allow users to deploy a small website of their ...
1
vote
4answers
139 views
At least one database view per database table-Is this good or bad design and why?
We are building a Windows Mobile based application to interface with a customer's existing web application. We are reading and writing data to the customer's SQL server 2008 database.
The customer ...
1
vote
3answers
99 views
Structuring database for multi-object “activity” and “following” functionalities
I am working on a web application which operate with different types of objects such as user, profiles, pages etc. All objects have unique object_id.
When objects interact it may produce "activity", ...
5
votes
6answers
283 views
Database Table Prefixes
We're having a few discussions at work around the naming of our database tables. We're working on a large application with approx 100 database tables (ok, so it isn't that large), most of which can be ...
0
votes
4answers
112 views
Best approach for a database of long strings
I need to store questions and answers in a database. The questions will be one to two sentences, but the answers will be long, at least a paragraph, likely more.
The only way I know about to do this ...
2
votes
2answers
109 views
What's the best way to modularize a User schema so it's generic
I have a database design question. Basically I want to be able to create a schema for a User model, then use this User model in other models that extend User but I want to design it in such a way that ...
0
votes
2answers
102 views
Using a column to store the company or a separate database?
I am writing an system for the company to put their promotion material on the site, which is like some kinds of CMS. So, I need a database that store their data, but I am considering how to store ...
2
votes
3answers
132 views
Standard semantic name for 3rd table in 3NF
For 3 tables that are in 3NF, a many-to-many relationship, is there a standard name or term to describe the 3rd table, the one that associates the other tables? Basically, I'm looking for a semantic ...
12
votes
4answers
228 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
1answer
91 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 ...
-4
votes
2answers
121 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 ...
2
votes
1answer
198 views
Querying key/value store
I don't know whether 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 ...
7
votes
5answers
340 views
Is there any reason to use VARCHAR sizes rounded to a 128/256/4096 byte offset?
In database schema's, I often notice VARCHAR sizes are rounded to the byte offsets 128/256 or 4096. I've done it before as well, and the idea behind it was probably something with efficiency.
...
