For questions about structuring the data within a database. How to lay out tables, whether to use a relational DB or not, etc.

learn more… | top users | synonyms

15
votes
6answers
757 views

What do DBAs do? [closed]

Yes, I know they administrate databases. I asked this question because I'd like to get a further insight into the kind of day-to-day duties a DBA might perform, and the real-world business problems ...
4
votes
2answers
24k views

Entity-relationship model diagrams in Visio

I would love to create some database diagrams like this one with Visio but I can't find any templates at all for that kind of notation. The example I linked to was apparently made in Photoshop, which ...
12
votes
9answers
11k views

Should I use multiple column primary keys or add a new column?

My current database design makes use of a multiple column primary key to use existing data (that would be unique anyway) instead of creating an additional column assigning each entry an arbitrary key. ...
3
votes
3answers
248 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
2answers
340 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
2answers
201 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
4answers
223 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 ...
13
votes
10answers
3k 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 ...
15
votes
5answers
342 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 ...