This tag can be used by questions on database design, such as normalization vs. denormalization, SQL vs. NoSQL, learning about database design, etc...
2
votes
3answers
135 views
Database architecture decisions
I do not know too many things about databases, so a lot of questions concerning architecture came up lately. Two of these things are:
If I have a table with a lot of entries(millions probably), how ...
9
votes
0answers
217 views
Database design: how to handle the “archive” problem? [migrated]
I'm pretty sure a lot of applications, critical applications, banks and so on do this on a daily basis.
The idea behind all that is:
all the rows must have a history
all links must stay coherent
it ...
8
votes
5answers
489 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 ...
0
votes
2answers
163 views
How to correctly design NoSql database schema? [closed]
I would like to learn something more about NoSQL databases, so I've chosen to create a new project from scratch to handle football results. In my traditional relational database, I have tournaments, ...
3
votes
1answer
68 views
What relationship would this be and how to implement
I have a pet project where I am making a Grade Book Application to better teach several different topics in DB, OOP and Planning. Im running into some issues with the database planning of things. For ...
11
votes
3answers
232 views
When accessing/manipulating complex data, is it better to store it in many small pieces or one large chunk?
I am building a web app that manipulates fairly complex data: guitar tabs.
As a reference, guitar tabs look like this:
...
1
vote
4answers
115 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
126 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
86 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
2answers
155 views
How to separate sensitive data in database(MySql)
I need to design a database that will contains information about personal disease of users.
What can be the approach in order to implement the columns of the DB's tables: encrypt the information, ...
5
votes
6answers
274 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 ...
-2
votes
1answer
70 views
Adding a forum to an existing site
I've got a site with ~500 registered members, 300 of which are what you'd call "active". Site data is kept in a MySQL dbase.
I'd like to add a myBB forum to the site, but this question applies to any ...
2
votes
5answers
224 views
Do any database “styles” use discrete files for their tables?
I've been talking to some people at work who believe some versions of a database store their data in discrete tables. That is to say you might open up a folder and see one file for each table in the ...
2
votes
3answers
90 views
Designing a large database with multiple sources
I have been tasked with redesigning, or at worst optimising the structure of a database for a data warehouse.
Currently, the database has 4 other source databases (which is due to expand to X ...
0
votes
3answers
65 views
Optimal Database design regarding functionality of letting user share posts by other users
I want to implement functionality which let user share posts by other users similar to what Facebook and Google+ share button and twitter retweet.
There are 2 choices:
1) I create duplicate copy of ...
