Tagged Questions
10
votes
2answers
1k views
How do I map an IS-A relationship into a database?
Consider the following:
entity User
{
autoincrement uid;
string(20) name;
int privilegeLevel;
}
entity DirectLoginUser
{
inherits User;
string(20) username;
string(16) ...
8
votes
2answers
259 views
Decision criteria on when to use a non-dbo schema vs a new Database
I'm mostly an application developer but find myself having to do all the up-front database work for my current project (btw... its MS SQL Server 2008). As a first decision, I'm trying to figure out ...
12
votes
5answers
467 views
Needing A Database Design Book
I am designing a database and it has so many relationships among my tables and i need a book that teaches database design very well.I am looking for a book where table relationships simple and complex ...
152
votes
14answers
34k views
Can MySQL reasonably perform queries on billions of rows?
I am planning on storing scans from a mass spectrometer in a MySQL database and
would like to know whether storing and analyzing this amount of data is remotely
feasible. I know performance varies ...
0
votes
1answer
2k views
Set permissions on all objects for SQL users
I have a procedure that loops through all objects in the database and assigns them proper permissions to that object. I want to know if there is a better way to do this? I use a model database to ...
4
votes
2answers
215 views
Introducing an 'age' category in a patients database
I want to do the following in my DB related to patients:
when patient inserts his birthday it shows his age category as: infants, children, adult, elderly... etc. to help me classify my patients
how ...
6
votes
3answers
455 views
Is there a standard implementation of a Users Database?
I need to implement basic personalized user functionality for my website. Is there a standard structure for databases of this type? Like is it common practice to have all user info and data in a ...
4
votes
2answers
2k views
Database behind a Multilingual User Interface
This question is about an issue somewhat more complicated than the one which has already been addressed in these old questions, all of which are duplicates of one another:
Suggestion for database ...
5
votes
3answers
1k views
SQL Server Primary key / clustered index design decision
Looking for some advice regarding a table / index design decision I've got to make on some tables that I've got to port into SQL server from an existing 4GL based database.
I've got a product history ...
3
votes
2answers
253 views
Help with a multi-language medical database
My project is to design a database for medicines in many countries.
Medicines have various criteria like composition, price, manufacturer.
Database will be multi-language; related to each country.
...
7
votes
5answers
573 views
Database design: Dividing multiple identical tables, good or bad?
I am very new at SQL and databases in general. I only use them for the occasional homework so I haven't even tried to master them.
I have seats at a theater, the seats are divided into 4 main areas ...
1
vote
4answers
113 views
How to model inheritance of two tables mysql
I have some tables where I store data and depending on the type of person (worker,civil) that did a job I want to store it a table 'event', now these guys rescue an animal (thereis a table animal).
...
1
vote
1answer
101 views
Are there situations where queries are formed geometrically?
The topic came up in this other question. We were discussing sign value on a primary key having any significance.
If there are good times to use geometry in building queries the sign value could be ...
0
votes
2answers
208 views
Database design of Ledger Account and Balance sheet generation
I am building an application which has deposit and loan accounts management, for which i have to develop ledger accounts and then generate balance sheet. Being new to database design, i am having a ...
0
votes
1answer
121 views
Trouble in Multi-Language DB
I'm working on a DB design for medicines in many countries with different languages. I created a table for the different languages I want and link it to another table of chemicals. But I find that ...
