Description:
Discussing advances in database technology.
|
|
|
A good database monitoring program?
|
| |
Hi, First of all I can be said new at database stuff. I want to know how to test MySQL and PostgresSQL. I had googled some and I am thinking of using a monitoring tool. Any monitoring tool with graph reports like jmeter? For comparision operation I will need a dummy database with thousands of records. Is there any tool that generates data for specified... more »
|
|
|
Why is database integrity so impopular ?
 
|
| |
Hello, When time comes to build transactional databases (as opposed to data wharehouses), I belong to the school that STRONGLY believe in normalizing data with high integrity mechanisms. I know all the performance cons but IMHO, pros largely overwhelme. It amazes me, though, how many systems rely on the application to... more »
|
|
|
Simple database design question
|
| |
Hi all, I have 2 tables, "sims" (as in mobile phone sim cards) and "phones" (as in mobile phones). I can add any number of sim cards to the "sims" table and any number of mobile phones to the "phones" table. Simple enough. Rule 1: A sim card can either be in a phone, or not in a phone. It cannot be in more than one phone.... more »
|
|
|
Non-text database theory
|
| |
Hi all. This might be off topic for this group; if so please direct me to a more appropriate group. I have 20 years of programming experience (hobby / personal scale) and am getting my feet wet with databases for the first time. The project at hand needs a database to handle large amounts of data. The data are... more »
|
|
|
Replication in databases
|
| |
Hello, I have a fundamental doubt regarding replication in databases. If the isolation level is set to Serializable, why cant we just ship the transaction statements from the master to the backup and replay those transactions. Why do we adopt complicated solutions like log shipping and all such kind of things for replicating databases.... more »
|
|
|
primary key as subtype discriminator
|
| |
Hello, I have something like: TABLE A a PK TABLE B b PK TABLE AB (many-to-many table) a, b PK TABLE AB-1 (AB subtype) a, b PK TABLE AB-2 (AB subtype) a, b PK Can I use the attribute "a" (part of PK) as subtype discriminator? Thanks, philip
|
|
|
