Relational Databases Features

Read what people say are the most valuable features of the solutions they use.
Renan Medeiros says in a Tibero review
Administrador de Banco de Dados with 501-1,000 employees
* Threaded architecture, AI/O, HA, and DR. * Oracle standard SQL support. View full review »
reviewer866730 says in a Tibero review
Technical Consultant at a tech services company with 11-50 employees
Tibero uses Hyper-Threading architecture, which is incredibly fast. Active cluster and active storage are also a few of those features which makes Tibero stand out from rest of its competitors. View full review »
Abdel Moneim Emad says in an IBM Db2 review
Enterprise Solutions Architect at Intercom Enterprises
A) The command set is almost the same in Windows and AIX operating systems, which greatly minimize the administration efforts to manage DB2 in both environments. Needless to say that working with the banking sector (which is my default playground) I need the ability to deal with many operating systems. B) The ability to understand and interpret PL/SQL queries, with ease switching from Oracle to DB2. C) Stability, scalability and security with high performance. View full review »
Muhammad Nurazhan Moin says in a MySQL review
Senior Web Manager at a university with 501-1,000 employees
* Open-source * Multi-platform * Lightweight * Simple to set up, configure and tune * Support for enterprise-grade features like clustering, master-slave replication, even Sharding (to some extent) which is an advanced feature View full review »
reviewer125703 says in a SQL Server review
Management Trainee for Training at a tech services company with 11-50 employees
* Net integration is best for me * Better optimizer * Ease of use (admin tools) View full review »
Andrés Gómez Casanova says in an IBM Db2 review
DB2 DBA at a financial services firm with 10,001+ employees
* PureScale * Blu acceleration * XML and JSON datatypes * Autonomous computing (storage, memory, and maintenance) * HADR * NoSQL (RDF and MongoDB). View full review »
ITArchitectMgr298 says in a SAP Adaptive Server Enterprise review
Project and IT Architecture Manager at a security firm with 1,001-5,000 employees
* OLTP features * Robustness * Reliability View full review »
Xavier Garcia says in an IBM Informix review
Administrador de Hardware y Base de Datos at a retailer with 1,001-5,000 employees
* High performance on OTLP environment, but depends on application design. * Data compression for enterprise version with data deduplication. * Provides solutions for making data highly available, with data replication configuration (HDR, RS, and SD) and ER (Enterprise Replication) for different scenarios. * The Informix Flexible Grid eliminates the administrative complexity of ER. Flexible Grid provides the ability to automatically create database objects, such as tables, indexes, and stored procedures on all nodes within the grid as a single operation. Link: http://waiug.org/wp-content/uploads/2015/11/2015-Nov-waiug-ER-Grid.pdf View full review »
reviewer280197 says in a SQL Server review
BI Solution Architect at a tech services company with 501-1,000 employees
The database engine within SQL Server 2014 is one of the most valuable components of the platform to me. The engine provides a solid and efficient database backend for any relational database requirement, performance is strong and there are options such as table, index partitioning and columnstore indexes that enhance the scalability of the platform. In addition to the database engine, I would also highlight the built-in integration services platform (SSIS) for ETL purposes as well as the Reporting and Analysis Services functionality (SSRS and SSAS respectively). One of the key features that I would use regularly to support the delivery of a Data Warehouse solution would be the Master Data Services (MDS). This is an extendable Master Data Management platform that works very well out-of-the- box. View full review »
it_user290733 says in a SQL Server review
IT Consultant & IT Project Manager Assistant with 10,001+ employees
The SSIS, SSRS, and DB are the most valuable features because they help in everything. View full review »
Albeez says in a SQL Server review
IT Director at a construction company with 501-1,000 employees
Apart from the standard SQL database-related features, the 2012 version enables the AlwaysOn functionality which enables two or more SQL Servers that can be clustered, with heartbeat across geographic locations along with high availability failover and 99.9999% uptime. View full review »
operatio515592 says in an Oracle Database review
Operations Engineering Manager at a consultancy with 10,001+ employees
* Security and Scalability * I have used Oracle technologies for last two decades apart from other similar vendors like MS SQL Server, IBM DB2, etc. * Power of Oracle combined with robust Unix platforms like Linux or AIX makes it powerful and secure as compared to MS SQL on Windows * IBM DB2 needs indepth technical expertise and lot of workarounds or automation to build a strong solution, MS SQL is on Windows and that makes it not the best choice View full review »
Hermann Jimenez Franco says in an IBM Informix review
DBA Informix at a outsourcing company
* I have been administering Informix for 10 years, and it's a highly reliable product, robust, processes high volumes of information, etc. * Its high availability characteristic is very stable and easy to configure and administer compared to Oracle to be performed higher than lower costs. * I really think it's a robust database tool and an excellent support. View full review »
ctsanders says in a MySQL review
Partner at a tech services company with 51-200 employees
* Its ease of use * It's secure. * It's fast. * It has high-end processing. * It can distribute across clouds. * It has the ability to run on any operating system. View full review »
Aju Mathai says in a SQL Server review
Database Architect at Huron Consulting
* Performance-wise, it is an excellent tool. * It is a Microsoft product, so there's a lot of support. * It's not a new tool; it has been around for a while. * It is one of the top five relational databases in the market. * It is very user-friendly. * There are a lot of resources available for it. View full review »
Martin Klier says in an Oracle Database In-Memory review
Senior Database Consultant at Performing Databases
In recent versions, Oracle implemented storing the In-Memory column store contents in the database, to resurrect the IMCS quicker and in a repeatable way. View full review »
reviewer1030020 says in a SQL Server review
Programmer Analyst at a tech services company with 10,001+ employees
* Creating and executing SQL queries, transactions, ACID properties * Creating and implementing stored procedures. View full review »
Lei Liu says in a SQL Server review
DBA,data architectuire at a tech services company
table partition options, that is very useful to separate unnecessary cost. For legacy data, we can do partition swith out and store into flat files or old tables. When it necessary, we can switch in back. View full review »
Menoj-Roekalea says in a SQL Server review
User
* SSMS * SSIS * Reporting services * FCI clustering * AlwaysOn * Basic availability groups. View full review »
Royden Akerley says in a SQL Server review
Enterprise Programmes Architect with 10,001+ employees
Traditional DB toolkit closely integrated into Microsoft Office. This makes it truly easy to deploy in a light non-business critical environment. View full review »
Daniel Du Toit says in a SQL Server review
Systems Analyst Developer with 1-10 employees
It is widely used and we never have problems with it. It can handle a PC, and it can also handle huge data. It is fast and efficient. It is something unique that tracks reporting of records, personnel, finances and more. It also integrates well with everything, not just Microsoft tools. View full review »
Osama Mustafa says in an Oracle Database review
Cloud Expert | DevOps | Oracle Consultant at a tech services company
* The most valuable feature for me is the pluggable database because it provides database consolidation and the solution for utilizing your resource. On the other hand, I find security products that are provided by Oracle very strong and not in comparison with any database vendor. * The encryption, database reduction, audit vault, database firewall: All of these products provide an extra layer of security when they are implemented in the right way. * Let's also mention real application cluster, and disaster recovery solution. View full review »
JReviewer312 says in an IBM Db2 review
CTO at Jutel
Some of the most valuable features are the scaling from a small very cheap installation to a very large enterprise installation. In addition, the backups and assistance are good. View full review »
Manzeel Uprety says in a MySQL review
Co-Founder at a non-tech company with 1-10 employees
I have found the following features valuable: * NetFlow of the whole system * Information flow and scaling * Communication between multiple collaborators and stakeholders * Its user-friendly features. View full review »
Reviewer342 says in an Oracle Database review
Lead Database Developer at a tech services company with 201-500 employees
* I really appreciate the performance of Oracle. * When using AWR records you can really see where a problem is. * You can get advice about which queries are the heaviest for the database. * You also can see advice for indexes. If an index isn't used, then you can remove it to improve performance. This is a really good feature. * The JDBC connection is also quite good. * The object types are really good, the types of tables you can use in PL/SQL are also really helpful. View full review »

Sign Up with Email