Is there a "rigorous" method for choosing a database?

Posted by Andrew Martin on Server Fault See other posts from Server Fault or by Andrew Martin
Published on 2012-11-14T10:55:24Z Indexed on 2012/11/14 11:05 UTC
Read the original article Hit count: 327

Filed under:

database-performance

|

schema

|

nosql

|

planning

|

rdbms

I'm not experienced with NoSQL, but one person on my team is calling for its use. I believe our data and its usage isn't optimal for a NoSQL implementation.

However, my understanding is based off reading various threads on various websties. I'd like to get some stronger evidence as to who's correct.

My question is therefore, "Is there a technique for estimating the performance and requirements of a certain database, that I could use to confirm or modify my intuitions?".

Is there, for example, a good book for calculating the performance of equivalent MongoDB/MySQL schema?

Is the only really reliable option to build the whole thing and take metrics?

© Server Fault or respective owner

Related posts about database-performance

A Perspective on Database Performance Tuning

as seen on SQL Server Central - Search for 'SQL Server Central'
Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply for any given situation. Julian Stuhler looks at database performance tuning, and why it remains one of the most important topics for any DBA, developer… >>> More
A Perspective on Database Performance Tuning

as seen on Internet.com - Search for 'Internet.com'
Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply for any given situation. Julian Stuhler looks at database performance tuning, and why it remains one of the most important topics for any DBA, developer… >>> More
Will Check Constraints Improve Database Performance?

as seen on SQL Server Performance - Search for 'SQL Server Performance'
[Read Full Article] >>> More
Database Performance Across 3 NetApp FAS2050

as seen on Server Fault - Search for 'Server Fault'
I recently inherited a SQL Server 2005 box that has LUNs mounted on it from three different NetApp FAS2050 filers. The reason there are three is because the first two filers are out of space and our databases continually need more of it. What kind of performance impact (if any) does this setup have… >>> More
Database performance benchmark

as seen on Stack Overflow - Search for 'Stack Overflow'
Any good articles out there comparing Oracle vs SQL Server vs MySql in terms of performance? I'd like to know things like: INSERT performance SELECT performance Scalability under heavy load Based on some real examples in order to gain a better understanding about the different RDBMS. >>> More

Related posts about schema

Active Directory and Apple's Workgroup Manager

as seen on Server Fault - Search for 'Server Fault'
I thought I'd share my experiences here. I work for a small business with only ~20 users. I wanted the ability to use managed client preferences to assign things like the software update server. Basically the ability to manage my Macs easily and in a native way. At first I tried the magic triangle… >>> More
SQL SERVER – How to Compare the Schema of Two Databases with Schema Compare

as seen on SQL Authority - Search for 'SQL Authority'
Earlier I wrote about An Efficiency Tool to Compare and Synchronize SQL Server Databases and it was very much well received. Since the blog post I have received quite a many question that just like data how we can also compare schema and synchronize it. If you think about comparing the schema manually… >>> More
Copy a domain in old schema to new schema with a procedure in postgresql

as seen on Stack Overflow - Search for 'Stack Overflow'
How do we copy a domain in old schema to new schema using a procedure in postgresql? >>> More
Star Schema vs Snowflake Schema performance

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi... I'm begin to developing a scial sharing website so I'm curious about database design Schema... So in Data-Mining Star-Schema is the best one but how about a social sharing website... And as a nature of the SS websites there will be (i hope :)) many users in same time... Which better for performance… >>> More
java.lang.NoClassDefFoundError: org/springframework/transaction/interceptor/TransactionInterceptor

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to integrate spring 3.1.1 with hibernate 4.0. This is my dispatcher-servlet.xml: <?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www… >>> More