2014-12-09 11:35:00 UTC

When evaluating Relational Databases, what aspect do you think is the most important to look for?


Let the community know what you think. Share your opinions now!
Guest
6060 Answers
author avatar
Consultant

Backup and replication options.

2015-01-16 19:35:01 UTC
author avatar
TOP 5LEADERBOARDReal User

At the first based on my experience we need to calculate software or customer requirements and after that choose the best option. Today all databases have the same options with little difference like Data types, HA, Performance, Security, Backup/Recovery, etc.
for example if you want to design a software with just 5 to 20 users, is that reasonable to use Oracle database service ?
however, from a programmer's point of view evaluating Relational Databases are rated by features like Datatypes, Functions, Index types and etc, DBA's (Database Administrators) vision is different. So my list is
- TCO (Total cost of ownership)
- High Availability Solutions.
- Backup / Restore solutions.
- Performance
- Data Capacity and Security.
- Memory Management.
- Caching
- Inmemory Database, Tablespace, Table.
- 3rd Party software

2019-12-10 06:19:38 UTC
author avatar
TOP 5Real User

My priorities:
1. Backup and recovery
2. Data security
3. Price
4. Performance

2019-12-06 01:47:12 UTC
author avatar
TOP 20Real User

An Oracle logo.

2019-05-21 13:53:58 UTC
author avatar
User

Top in my list
- Performance
- Security

2018-09-24 08:04:50 UTC
author avatar
User

A single reason is not enough, we can rank the following reasons:

- Operational Performance (OLTP, DWH - ETL)
- Relate to hardware such as disk (storage), memory, cpu and how well they can use them
- Data Capacity
- Data Security
- Application Support
- Vendor Support

2017-02-14 19:13:48 UTC
author avatar
TOP 5Real User

The most important is "Solid backup and recovery solution." Imho.

2019-12-06 01:45:33 UTC
author avatar
Vendor

- Capability
- HA
- Security
- Performance

2019-10-10 20:38:25 UTC
author avatar
Vendor

Performance, Security, Quiet Easy to Implement the database Solution, Excellent database tools for managing the Database Environment for example Microsoft SQL Server Management Studio.

2017-12-08 03:07:11 UTC
author avatar
Consultant

Performance, Security, Vendor Support and Price

2017-10-21 21:58:41 UTC
author avatar
Vendor

Definitely Performance, Data mining, easy use.

2017-09-13 15:14:00 UTC
author avatar
Vendor

We should evaluate mainly performance of the database as well as pricing of the database.

- If you want to host application which has small amount of data and does not have secure content in it you can go for open source databases.
- vice versa, if your data has secure or critical contents in it then we should consider security features of database as well.
- one more important feature we need to consider now a days is parallel distribution/parallel computing feature e.g. Postgresql / greenplum has this feature.

2016-01-24 11:10:06 UTC
author avatar
TOP 5Consultant

Modeling features (from physical to business), sql optimization / mdx support, easy of use

2016-01-11 09:58:37 UTC
author avatar
TOP 5Consultant

mainly the performance. For RDBMS you would not be having any performance issue. But when it comes for data loading, RDBMS would not be a good take. This of an MPP where the data is spread accross segments

2016-01-06 10:43:25 UTC
author avatar
Consultant

Scalability and performance, both in relation to volume of data and concurrent queries.

2015-12-15 15:39:54 UTC
author avatar
Vendor

scalability and platforms DBMS runs on

2015-11-19 18:37:56 UTC
author avatar
TOP 20Consultant

Uniform Syntex
Ease of use
Examples of complex statements or auto creation of queries

2015-11-18 13:32:51 UTC
author avatar
Consultant

If it covers all of the project needs/specifications.
The price.

2015-10-15 12:08:57 UTC
author avatar
TOP 5LEADERBOARDReal User

Vendor support, product track record, scalability, clustering options and security.

2015-10-08 04:02:32 UTC
author avatar
Consultant

First Knowledge of the platform, performance, backup/restore...

2015-10-07 20:13:07 UTC
author avatar
Consultant

Easy integration, fast ,scalability to needs and support for all developer APIs

2015-10-04 07:18:50 UTC
author avatar
Consultant

only one reason as of today, that is transactional atmoicity, don't see any other; you open source them with light versions and see the miracles; graph databases are evolving and once there cn be a better fit not just for social as they are today;

2015-09-22 14:13:26 UTC
author avatar
TOP 20User

Performance, ease of use, scalability and support for all developer APIs.

2015-09-18 21:48:25 UTC
author avatar
TOP 20Consultant

There's no "most important" criteria when choosing a tool, and a RDBMS is just a tool. If you're running Twitter, then the key factor is performance. If you're running a small medical clinic software, then you need data integrity above the others.

2015-09-18 19:25:20 UTC
author avatar
Vendor

The most important criteria for our customers at NuoDB is that our distributed SQL database has a flexible deployment model that allows them to run the database on a single server machine, across machines in a data center or public cloud, and even on a global basis (across multiple data centers) without having to architect a new solution for each use case.

2015-08-30 08:15:16 UTC
author avatar
Vendor

Scalability, performance and Business Intelligence capability from ETL to warehousing and analytics. Also how well the database solution can be leveraged in an enterprise development organization. There are many more options these days but not from a mature development to deployment and maintenance standpoint.

2015-08-12 20:32:33 UTC
author avatar
Vendor

Reliability, scalability, security, performance, ease of management.

2015-08-12 18:00:38 UTC
author avatar
TOP 20Real User

The RDBMS that are known for its Scalability, Availability and its OLTP performance. However am exploring its Analytical functional capabilities. I have been using Sybase IQ EDW. its serves the purpose now. However moving towards building an Enterprise Data Warehouse –Data Lake, researching about MSSQL DW 2014

2015-08-08 21:01:42 UTC
author avatar
Consultant

Vendor support.

2015-08-05 20:16:34 UTC
author avatar
Consultant

performance, scalability & security

2015-08-03 15:40:51 UTC
author avatar
Vendor

Can't answer this blindly. Depends on why I'm researching a relational db technology and what the requirements are.

2015-07-28 18:45:39 UTC
author avatar
TOP 20Real User

Performance &

2015-07-23 09:17:33 UTC
author avatar
Consultant

Ability to retrieve as and when required in any format to give valuable insights to business.

2015-06-19 13:38:11 UTC
author avatar
Consultant

Easy for support and use. Set of high availability features.

2015-06-17 21:33:02 UTC
author avatar
Consultant

operational efficiency and simplicity of use and understanding ( set of features ) has a high value in any case.

2015-06-17 18:15:48 UTC
author avatar
Vendor

performance, security, and it allows OO_RDBMS

2015-06-11 03:19:22 UTC
author avatar
Vendor

Wide adoption, Performance, Scalability, Replication, Failover.

2015-06-06 17:49:48 UTC
author avatar
Consultant

1. Performance 2. Ease of using analytic functions 3. Industry hold

2015-06-01 08:01:31 UTC
author avatar
Real User

Performance and security

2015-05-28 16:04:01 UTC
author avatar
Vendor

Performance.

2015-05-11 17:39:07 UTC
author avatar
Consultant

Existing organisational capabilities. e.g; introducing Oracle to a team already skilled in MSSQL would likely be a mistake. Beyond that, I haven't 'researched' RDBMSs for some time. The choice is usually clear for me. MSSQL, MySQL or Postgres.

2015-05-11 01:04:48 UTC
author avatar
Vendor

Performance

2015-04-30 06:26:16 UTC
author avatar
Vendor

Scalability and performance.

2015-04-07 16:42:56 UTC
author avatar
Vendor

Do we actually need any of the 'relational' part or can we leverage an object db or something even more lightweight?

2015-04-03 11:17:44 UTC
author avatar
Vendor

Perfomance

2015-03-21 13:36:55 UTC
author avatar
Consultant

Organised, Relationship establishment between objects, Atomic, Security.

2015-03-13 09:55:24 UTC
author avatar
Consultant

Performance, period. Needs to provide a variety of ways to move and process data quickly leveraging disk, processors, RAM, and IO.

2015-03-10 15:31:40 UTC
author avatar
Vendor

Meets Availability requirement, performance and recovery time objective.
Ease of use is also important as well as utilities to load and unload data.

2015-03-01 11:02:15 UTC
author avatar
Vendor

Compatibility. If the database engine doesn't work well with the software you want to use it with, the rest of the features just don't matter. After that, performance and scalability.

2015-02-28 17:56:07 UTC
author avatar
Vendor

Ease of use, scalability, and portability.

2015-02-27 20:19:57 UTC
author avatar
TOP 20Consultant

Performance and more performance. Go hand in hand with the best technologies Disk.

2015-02-09 17:05:38 UTC
author avatar
Vendor

Performance

2015-02-08 05:41:01 UTC
author avatar
Consultant

The data bases footprint in the current market. For example I am reviewing things. MS Access has been a relational database I thought had a footprint and a future. The stuff I read online about the 2013 upgrade and Office 365 have me thinking maybe my ideas need to shift to something else.

2015-01-28 03:49:48 UTC
author avatar
Vendor

Scalability, reliability, performance, ease of management and adherence to standards.

2015-01-27 16:50:22 UTC
author avatar
Vendor

Replication, failover and performance.

2015-01-19 22:19:32 UTC
author avatar
Vendor

Reaction to system failure

2015-01-16 14:24:38 UTC
author avatar
Vendor

The most important criterion is whether the DB comes with a mature BI stack.

2015-01-15 16:24:15 UTC
author avatar
Consultant

The metadata and the less "case when" script.

2015-01-12 15:19:35 UTC
author avatar
Vendor

Concurrency control, analytic functions and indexing options

2014-12-24 05:08:17 UTC
author avatar
Consultant

Ease of use as for uniformed command line and syntax, JOIN performance and features to be able to create sub join / sub view. Community support and widespread use. Availability on documents and technical know - how.

2014-12-23 06:17:44 UTC
Find out what your peers are saying about Microsoft, Oracle, Teradata and others in Relational Databases. Updated: December 2019.
390,232 professionals have used our research since 2012.