Questions tagged [database-design]
For questions about structuring the data within a database. How to lay out tables, whether to use a relational DB or not, etc.
1,326
questions
4
votes
3
answers
331
views
How to query a very long list of properties fast
I have a structure for storing item properties on SQL Server:
ItemId PropertyId Value
1 1 a
1 2 b
2 1 a
2 2 5
Currently there are over 130000 ...
5
votes
2
answers
371
views
What design is best for data transformation?
My company's database makes available data to a lot of external applications. So I need to transform the same data to a lot of dynamic views. I can see that a former database developer had implemented ...
1
vote
2
answers
227
views
Conditions for a traditional friends system vs. open following system
I'm just curious for everyone who is developing social sites out there. When you build a method for connecting users, do you prefer to use a following-style system (follow me, you can see all of my ...
4
votes
4
answers
281
views
Two possible solutions to a problem, DB design
I saw the recent post about the person questioning his boss's solution (I believe my solution is better than my boss, so should I ignore him?) and decided to ask something similar but not as "clashing"...
15
votes
10
answers
5k
views
How do you approach database design? [closed]
I am primarily a web developer and I have a couple of personal projects which I want to kick off.
One thing that is bugging me is database design. I have gone through in school db normalization and ...
16
votes
5
answers
426
views
Should my multi-server RDBMS or my Application handle database Referential Integrity?
Should items like Foreign Keys, Constraints, Default Values, and so on be handled by the database management system (in this case, MS SQL 2005) or the application? I have heard opinions from both ...