Relational Database Management System, a widely used type of database management system characterised by its extensive use of joining as a core operational principle.
3
votes
1answer
783 views
How mature is the Firebird database when compared with PostgreSQL and MySQL?
I have used PostgreSQL with small projects and MySQL is running in production environment. No issues with them. I have been hearing of Firebird which is again a solid RDBMS in the open-source area.
...
3
votes
3answers
438 views
MySQL very slow query when changing one WHERE field despite no index/key
This is quite a confusing issue for me. I have a database full of baseball statistics. Running this query:
SELECT * FROM hits
JOIN stadiums ON stadiums.gameName = hits.gameName
JOIN players ON ...
3
votes
1answer
1k views
Amazon SimpleDB or Amazon RDS?
I'm at a deciding point in my project of whether to implement the database using SimpleDB or Amazon RDS. The database needs to be accessed through an iPhone app and as well through a website. Here are ...
6
votes
1answer
173 views
Are relations slower than a big, inefficient table?
I've been asked in my job to violate the first normal form (repeating groups across columns, using empty / null values) several times, "for the sake of computer processing power". In a nutshell, a ...
5
votes
4answers
992 views
Why are so many MPP solutions based on PostgreSQL instead of MySQL?
Astor Data, Greenplum and GridSQL all allow Massive Parallel Processing of SQL queries. They are also all built around PostgreSQL technology. Is this just because of licensing issues or are there ...
20
votes
4answers
2k views
What does “index” mean on RDBMSs? [closed]
I use indexes like most developpers do (mostly on... well ! index), but i'm sure there is a lot of subtle way to optimize a database using index. I'm not sure if it is specific to any implementation ...
41
votes
5answers
7k views
What are the differences between NoSQL and a traditional RDBMS?
What are the differences between NoSQL and a traditional RDBMS?
Over the last few months, NoSQL has been frequently mentioned in the technical news. What are its most significant features relative to ...
5
votes
3answers
195 views
Which databases support parallel processing across multiple servers? [closed]
I need a database engine that can utilize multiple servers for processing a single SQL query in parallel. So far I know that this is possible with the some engines, though none of them are feasible ...
