Tagged Questions
14
votes
5answers
269 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 ...
13
votes
4answers
709 views
Front end first or Back end first. Of the two which is a Good system design pratice?
I have a client right now requiring me to develop a school enrollment system. Now this is the first time im having this kind of challenge. Most of the past software that i created are not that ...
9
votes
6answers
816 views
what exactly do database programmers do?
Please take no offense, this is a genuine doubt I have.
Every time I read about Oracle programmers etc, I get this doubt. I am unable to understand what exactly they do. From my understanding, ...
4
votes
2answers
211 views
Should I use a relational datamodel or Cassandra with ColumnFamily based indexes?
Currently we are working on some storage problems for log data from various servers and communication message logs (HTTP(S), XMPP). There will be many write operations and for read operations we will ...
4
votes
11answers
676 views
Over normalization in database
Currently I am working on creating a new database schema as part of a major new product. Our previous customer address records (in a previous product) look something like this in our current schema ...
3
votes
1answer
236 views
Database Application Design Best Practices
Once upon a time it was common practice for both the business logic and database logic to be written in the same language (eg PL/SQL, Transact SQL, etc), more recently the practice is to separate the ...
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 ...
2
votes
3answers
179 views
What advantages do we have when creating a separate mapping table for two relational tables
In various open source CMS, I have noticed that there is a separate table for mapping two relational tables. Like for categories and products, there is a separate product_category_mapping table. This ...
2
votes
3answers
196 views
How to design a database wherein multiple tags(string) are to be associated with an id?
I have to design a database wherein I have to associate an audio_id with multiple tags(words). I am considering following approaches to select one from these:
1) To have multiple fields for multiple ...
2
votes
2answers
109 views
Database Documentation
What are some of your personal preferences, techniques, and tools for documenting databases and database objects?
