2014-12-09T11:35:00Z

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
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-10T06:19:38Z
author avatar
Top 5Real User

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

2019-12-06T01:47:12Z
author avatar
Real User

An Oracle logo.

2019-05-21T13:53:58Z
author avatar
User

Top in my list
- Performance
- Security

2018-09-24T08:04:50Z
author avatar
Top 5Real User

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

2019-12-06T01:45:33Z
author avatar
Vendor

- Capability
- HA
- Security
- Performance

2019-10-10T20:38:25Z
author avatar
Consultant

Backup and replication options.

2015-01-16T19:35:01Z
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-14T19:13:48Z
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-08T03:07:11Z
author avatar
Consultant

Performance, Security, Vendor Support and Price

2017-10-21T21:58:41Z
author avatar
Vendor

Definitely Performance, Data mining, easy use.

2017-09-13T15:14:00Z
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-24T11:10:06Z
author avatar
Consultant

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

2016-01-11T09:58:37Z
author avatar
Top 10Consultant

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-06T10:43:25Z
author avatar
Consultant

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

2015-12-15T15:39:54Z
author avatar
Vendor

scalability and platforms DBMS runs on

2015-11-19T18:37:56Z
author avatar
Consultant

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

2015-11-18T13:32:51Z
author avatar
Consultant

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

2015-10-15T12:08:57Z
author avatar
Top 20Real User

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

2015-10-08T04:02:32Z
author avatar
Consultant

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

2015-10-07T20:13:07Z
author avatar
Consultant

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

2015-10-04T07:18:50Z
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-22T14:13:26Z
author avatar
User

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

2015-09-18T21:48:25Z
author avatar
Consultant

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-18T19:25:20Z
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-30T08:15:16Z
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-12T20:32:33Z
author avatar
Vendor

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

2015-08-12T18:00:38Z
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-08T21:01:42Z
author avatar
Consultant

Vendor support.

2015-08-05T20:16:34Z
author avatar
Consultant

performance, scalability & security

2015-08-03T15:40:51Z
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-28T18:45:39Z
author avatar
Consultant

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

2015-06-19T13:38:11Z
author avatar
Consultant

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

2015-06-17T21:33:02Z
author avatar
Consultant

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

2015-06-17T18:15:48Z
author avatar
Vendor

performance, security, and it allows OO_RDBMS

2015-06-11T03:19:22Z
author avatar
Vendor

Wide adoption, Performance, Scalability, Replication, Failover.

2015-06-06T17:49:48Z
author avatar
Consultant

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

2015-06-01T08:01:31Z
author avatar
Real User

Performance and security

2015-05-28T16:04:01Z
author avatar
Vendor

Performance.

2015-05-11T17:39:07Z
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-11T01:04:48Z
author avatar
Vendor

Performance

2015-04-30T06:26:16Z
author avatar
Vendor

Scalability and performance.

2015-04-07T16:42:56Z
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-03T11:17:44Z
author avatar
Vendor

Perfomance

2015-03-21T13:36:55Z
author avatar
Consultant

Organised, Relationship establishment between objects, Atomic, Security.

2015-03-13T09:55:24Z
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-10T15:31:40Z
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-01T11:02:15Z
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-28T17:56:07Z
author avatar
Vendor

Ease of use, scalability, and portability.

2015-02-27T20:19:57Z
author avatar
Consultant

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

2015-02-09T17:05:38Z
author avatar
Vendor

Performance

2015-02-08T05:41:01Z
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-28T03:49:48Z
author avatar
Vendor

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

2015-01-27T16:50:22Z
author avatar
Vendor

Replication, failover and performance.

2015-01-19T22:19:32Z
author avatar
Vendor

Reaction to system failure

2015-01-16T14:24:38Z
author avatar
Vendor

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

2015-01-15T16:24:15Z
author avatar
Consultant

The metadata and the less "case when" script.

2015-01-12T15:19:35Z
author avatar
Vendor

Concurrency control, analytic functions and indexing options

2014-12-24T05:08:17Z
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-23T06:17:44Z
Find out what your peers are saying about Microsoft, Oracle, IBM and others in Relational Databases. Updated: July 2020.
431,024 professionals have used our research since 2012.