Relational databases report from it central station 2018 01 27 thumbnail
Find out what your peers are saying about Oracle, Teradata, Microsoft and others in Relational Databases.
253,818 professionals have used our research since 2012.
Relational databases report from it central station 2018 01 27 thumbnail
Find out what your peers are saying about Oracle, Teradata, Microsoft and others in Relational Databases.
253,818 professionals have used our research since 2012.
Chart Key
Average Rating
Average rating based on reviews
Views
Number of total page views
Comparisons
Number of times compared to another product
Reviews
Total number of reviews on IT Central Station
Followers
Number of followers on IT Central Station
The total ranking of a product, represented by the bar length, is based on a weighted aggregate score. For Views, Comparisons, Reviews, and Followers the score is calculated as follows: The product with the highest count in each area gets the highest available score of 17.5 points. Every other product gets assigned points based on its total in proportion to the #1 product in that area. For example, if a product has 80% of the number of reviews compared to the product with the most reviews then the product's score for reviews would be 17.5% (weighting factor) * 80% = 14. For Average Rating, the maximum score is 30 points awarded linearly based on our rating scale of 1-10. If a product has fewer than ten reviews, the point contribution for Average Rating is reduced (one-third reduction in points for products with 5-9 reviews; two-thirds reduction for products with fewer than five reviews). Reviews that are more than 24 months old, as well as those written by resellers, are completely excluded from the ranking algorithm.
Most Views
From IT Central Station visitors
Most Reviews
Within the last 24 months
Most Followed
By IT Central Station users
Most Compared
From IT Central Station visitors

What is Relational Databases?

The purpose of Relational Database Management (RDBMS) is to maintain various digital software system databases. Querying and maintaining aspects of the database is achieved by using SQL, (Structured Query Language) which is universally accepted by almost all relational database systems. An RDMBS manages, builds and deploys applications located onsite or in the cloud. The digital space has a lot of competition and finding the best RDBMS requires IT experts to source the most comprehensive technology.

According to IT Central Station IT professionals, operational performance, (OLTP, DWH - ETL) security, support for developer APIs, and MDX support are among the most important RDMBS features. Scalability and modeling must be easy to use, and responsive vendor support is especially desirable. Data capacity, integration, and speed are integral to the needs of IT and DevOps.

Because IT managers have multiple needs within RDMBS, criteria for choosing a vendor requires the strictest data integrity and offer project specifications such as, “[a] distributed SQL database that has a flexible deployment model allowing the [team] 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.”

IT Central Station IT and Devops managers are clear about how RDMBSs and their many features can function in an enterprise environment to be best leveraged in DevOps. There is a need for parallel distribution and parallel computing when evaluating performance.

One topic that is frequently discussed is, “transactional atomicity.” With all the moving parts in Relational Databases, the granular can become the springboard for success. These include loading and unloading data, meeting performance and recovery time objectives and adherence to standards.

IT Central Station developers have specific standards and would choose RDMBS based on whether the “DB comes with a mature BI stack.” RDMBS has many variables. IT Central Station users chose Relational Databases based on a number of criteria. IT Central Station’s offerings are complete and wide-ranging for the needs of IT and DevOps teams looking for agile excellence.


Relational Databases Reviews

Read reviews of Relational Databases that are trending in the IT Central Station community:
Your trust is our top concern, so companies can't alter or remove reviews.
Microsoft 400x400
Microsoft
159a9a7a 02f4 41c3 90af e5fb6360368c avatar
Real User
Applications Business Intelligence Analyst at a aerospace/defense firm with 10,001+ employees
Jul 16 2017

What is most valuable?

There are many, but I would have to say the two most important for me have been SQL Server Profiler -- to run traces and the ability to kill sessions in the enterprise manager tool. This command-based functionality lets you search and sort... more»

How has it helped my organization?

In an effort to forego a data warehouse purchase, one company I worked with used a second SQL Server instance loaded to separate hardware as a reporting environment avoiding the need to hire additional employees to support a data warehouse.... more»

What needs improvement?

Multiple operating systems support should improve. The ongoing and newly marketed support for Linux and Unix environments running SQL Server is a big win for Microsoft, in my opinion. Previous hold back related to open source environments... more»
Anonymous avatar x80
Real User
Sr. Database Consultant at IGT

What is most valuable?

The most valuable feature is how evolved the solution is right now. It's been around for a while, and I think it's been servicing a lot of different use cases. I think it's really stabilized, evolved, and you can actually put it to use in... more»

How has it helped my organization?

It has definitely improved the way my organization functions. It's our database management tool. We have a lot of sensitive information. Different business verticals have a lot of sensitive information that they want to reliably preserve... more»

What needs improvement?

I’d like to see them include a certain amount of intuitiveness in the optimization of the queries, and the algorithms for that could be better. There's still room for improvement in those areas. One of the things that is also mentioned about... more»
Relational databases report from it central station 2018 01 27 thumbnail
Find out what your peers are saying about Oracle, Teradata, Microsoft and others in Relational Databases.
253,818 professionals have used our research since 2012.
A3efc6db 422f 420e 8d54 b4aa3364379c avatar
Real User
Strategic Solutions Architect at OnX Enterprise Solutions

What is most valuable?

I'm going to be discussing Database In-Memory and Multitenant in Oracle 12c. The multitenant features offer some really excellent flexibility, especially for an organization that's looking to consolidate their databases from smaller servers,... more»

How has it helped my organization?

Multitenant is going to get much better in the next release, but that doesn't mean you can't adopt it right now. The major advantage of multitenant, as I see it, is to be able to share memory on a larger server with larger amounts of CPU and... more»

What needs improvement?

The In-Memory database features are probably going to double in capacity and in power in the upcoming release; also, with pluggable and container databases. They're going to become much more flexible. Most of this is already public knowledge.... more»
D084d54f 11c0 4ad5 a0f2 ab5e8d9ce7b7 avatar
Real User
Senior Product Manager at a software R&D company with 501-1,000 employees

What is most valuable?

If you remember the old Saturday Night Live skit by the baseball player, Oracle's been very, very good to me. I chose to work with databases and specifically Oracle right out of college, the 80s. It was a right career decision. It took me... more»

How has it helped my organization?

Right now, one of the things I've been using a lot of is the In-Memory column store, which is a new Oracle 12c feature and it's gotten a lot of press. It's a great feature. If you remember a few years ago, Vertica and some other column... more»

What needs improvement?

I know that a lot of people like Oracle Enterprise Manager and it's capable and it's great, but for a lot of tasks it's overkill. They came out with this new tool in 12, the OEM Express. I would like to see that tool persist. Oracle does on... more»
C3fd016e 297d 4427 95e6 102ea107f78c avatar
Consultant
Senior Oracle Consultant at a retailer with 1,001-5,000 employees
Apr 04 2017

What is most valuable?

Ours is a DW environment, ETL extracts data from SAP and loads into the reporting database. The DBA objective was optimal performance for both nightly batch and reporting. We used the below features which significantly helped improve he... more»

How has it helped my organization?

This data is of our BI reporting. This reporting is open for all the warehouse managers to know all their financial status.The period end . We have very tight schedules. Every report has to complete in milli seconds seconds. The SLA are very... more»

What needs improvement?

For some reason, the stats optimizer doesn't work well. We actually disabled some of these features, such as the optimizer adaptive features. On the fly, the optimizer actually changes the explained plan, and that feature is really not... more»
3785b8d2 d4d4 4c2b b034 9943f4414369 avatar
Real User
Senior Principal Engineer/Architect, Oracle ACE Director at a tech vendor with 1,001-5,000 employees

What is most valuable?

So what happened is that today IT is facing a lot of challenges, because the data has grown so fast. They have to find a way to manage the cost, the performance, and the capacity. So that's why we have this strategy called information management: a strategy to manage this data within a reasonable cost. Oracle 12C introduced these two new features, called ADO,... more»

What needs improvement?

So this is a very good tool, but I would like to add some more features. One thing I would think about is that, the database lets me write some new rules. Right now, the data moving is mainly based on how much this tier one storage is full. Like, if 80 percent of full? Then it starts moving the data. What I really want is, based on how much the data has been... more»
Anonymous avatar x80
Real User
Security Analyst at a insurance company with 1,001-5,000 employees
Jul 26 2017

What is most valuable?

Ease of use and robust automated security administration and reporting are features any mainframe shop needs and should have. The cost of investing in such products will usually offset the expense associated with the DB2 environment and the... more»

How has it helped my organization?

When new DB2 resources are introduced into the environment, the Vanguard Administrator product allows us to quickly build the required RACF security rules and access lists. There are features in the Administrator product that automate the... more»

What needs improvement?

It is worth noting that the RACF security product is used to safeguard the DB2 environment on the mainframe. This allows us to maintain all security rules for resources on the mainframe using the RACF security product. Some shops I have... more»
Jt hjyjg 400x400
Oracle
Gaston nusimovich li?1414340879
Real User
Software Architect at a tech consulting company with 51-200 employees
Dec 19 2017

What is most valuable?

We design web solutions for customers with PHP. MySQL offers a simple, no frills, but effective DBMS solution with a very low hardware footprint. Since it has no licensing fees, it offers great TCO for our customers.

How has it helped my organization?

We do software development for our customers on both Windows and Linux. Since these tools are available for both Windows and Linux, we can leverage the knowledge of these tools for development on both platforms.

What needs improvement?

Only one of the engines, InnoDB, supports ACID transaction control. The best performance engine, MyISAM, has no transactional control support. It would make a lot of sense to include one engine that offers both very good overall performance... more»
81979b04 c1c6 4f51 ae24 4e4cc1730535 avatar?1448747451
Consultant
Principal Consultant at a software R&D company with 501-1,000 employees

What is most valuable?

Cloudera Hadoop provides the scalable data architecture organizations need to manage increasing data volumes, though not the intuitive GUI for business users. Oracle Big Data Discovery (BDD) provides business users the ability to explore and... more»

How has it helped my organization?

Using Oracle Endeca Information Discovery has enabled our clients to search and explore unstructured data so they can answer unexpected questions as soon as they come up. This has been a game changer since it dramatically reduces the delay... more»

What needs improvement?

Oracle Big Data Discovery allows business users to interact with data in Hadoop and to transform it into a different format on the Hadoop cluster. This proprietary format can sit within the Hadoop cluster, but is not fault tolerant and query... more»
0857219f 293a 49e1 85f5 e9a9e8ae1a29 avatar
Real User
Lead Database Administrator (DBA) at a energy/utilities company with 1,001-5,000 employees

What is most valuable?

Oracle is the premier relational database platform for enterprise environments. Any organization that purchases enterprise applications will likely have Oracle in place since so many applications require or prefer it. The most valuable features of Oracle database from my perspective are: * Read consistency (all queries see a read consistent view of the database... more»

What needs improvement?

Oracle Database is a big, complex technology stack with many options, features, management packs, etc. The base product (Oracle Database Enterprise Edition) is generally rock solid. Some of the oldest, most mature options are also quite reliable (example: Partitioning option). However, most of the other optional products create additional issues. Almost every... more»
C865069e d5ad 4459 8ed3 a6cd824bce2b avatar
Real User
President at Oraclewizard.com Inc

What is most valuable?

I'm going to be discussing the enhancements to the PL/SQL language in what I'm going to call the bad old days, what we did was we put all of our application code and all of our application objects into one schema. What happened when you would... more»

How has it helped my organization?

The biggest benefit is you're closing holes to SQL injection bugs. If I have a program, say program unit A has a PL/SQL injection bug, and you haven't implemented this, if I can inject into A, I can get to the sensitive information. But now... more»

What needs improvement?

In the next release, I'd like to see the ability to shred ghost data. I'd like to see the ability to when you run a data pump export of encrypted data and you did not specify encrypted in the command line, the data will be saved unencrypted... more»
Anonymous avatar x80
Real User
Technology Lead at a tech services company with 1,001-5,000 employees
Aug 31 2017

What is most valuable?

The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution. It's two things: * Highest performance on query. This is very notable. Let's say, yesterday I was doing some of the... more»

How has it helped my organization?

Instead of having a PNO process at the end of the day, which was running forever (six hours) I moved the process into SAP IQ. Now, I am giving real time, or near real time, PNO. The portal runs for four minutes, rather than running for six... more»

What needs improvement?

Yes. The room for improvement would be the marketing of the product, because this product is much better than advertised. One of my colleagues was working with Adobe, where the Product Management team was using Hadoop. Hadoop was doing a... more»
Microsoft 400x400
Microsoft
Gaston nusimovich li?1414340879
Real User
Software Architect at a tech consulting company with 51-200 employees
Aug 15 2017

What is most valuable?

* SQL Server Integration Services tools * Data Quality Services tools * Master Data Services tools * SQL Server Reporting Services tools * Data Partitioning (Horizontal Partitioning) tools * ColumnStore Indices * In-Memory OLTP tables

How has it helped my organization?

We design and implement DW solutions with SS 2016 Dev Ed tools. This solution has given us high levels of productivity, which has allowed us to use an Agile approach to the design and implementation of DW solutions for our customers, and this... more»

What needs improvement?

We do not have much to complain about SS 2016 Dev Ed in itself, we do have some complaints regarding licensing for SQL Server 2016 Enterprise Ed. In an emerging market like Argentina, it is very steep for our customers to pay U$S 28,000 or... more»
51e16a05 fc91 4eba a912 bcf40c5e8f0f avatar
Real User
Managing Director at CarajanDB

What is most valuable?

The cloning features are outstanding. It’s easy to clone an existing database in the same CDB into another CDB running on-premise or even to a CDB running in a private or public cloud. This opens new doors database consolidation with an easy... more»

How has it helped my organization?

I’ve created tons of scripts for my customers to deploy databases, set up RAC instances, and Data Guard configurations. To verify such a script takes weeks and is very error-prone. Now, I’m able to set up a database once and just add... more»

What needs improvement?

The main area for improvement is regarding backup and recovery. Today, it’s difficult to set a pluggable database to a former point in time because flashback pluggable database doesn’t exist. Another important feature will be to support... more»
Anonymous avatar x80
Real User
Oracle DBA at Roketsan Missiles Inc.

What is most valuable?

Oracle Database has had a multiple-concurrent-user control system from the very beginning. Most enterprise database solutions have recently become aware of this. Oracle's approach was the true approach to isolate users. Databases have some... more»

How has it helped my organization?

We have the opportunity to easily open service requests and get answers from the professional Oracle teams. We have the advanced customer support team in Turkey. If there is a problem, it is easily and elegantly solved. It adds value; we... more»

What needs improvement?

We have not been using the new release yet, we are running on 11g. We haven’t had much opportunity to deeply examine 12c yet. See my comments in the initial setup section.
C865069e d5ad 4459 8ed3 a6cd824bce2b avatar
Real User
President at Oraclewizard.com Inc

What is most valuable?

The most valuable feature is the TDE advanced security as there are several options of different encryption algorithms. It's also easy to implement Tablespace Encryption.

How has it helped my organization?

We're able to go through and encrypt our database much faster using Tablespace Encryption versus using column encryption which requires you to identify each atomic piece of information to be encrypted. This ease-of-implementation gives us... more»

What needs improvement?

I've heard rumors of an upcoming ability to get rid of ghost data. Here's an example: if I have a column in a database, say social security number, and a policy comes up and says encrypt social security number, and if there's an index on that... more»
506c17de 43af 4eae 9720 be9143378550 avatar
Real User
Co Founder & Executive Director at SatyaMoksh Inc.

What is most valuable?

The most valuable features for us are the cloud-like traits of ODB, grid computing with version 11g onward, live database, and Data Guard.

How has it helped my organization?

We're a non-profit with branches all over the world -- Africa, India, and the US -- so we need a database solution that can be centralized. We have an entire datacenter in India, but our users need access to it from our other locations. The... more»

What needs improvement?

Honestly, it's not really in the cloud as such, but the definition of "cloud" changes daily. It's more on VMs, but the VM's are so powerful that we can access the database from anywhere without investments in machines or other hardware. We've... more»
Ea3341a5 d34a 4b33 b5de d5bb455b1b7f avatar
Real User
Senior Developer at a tech services company with 501-1,000 employees

What is most valuable?

The powerful SQL language for working with, analyzing and manipulating lots of data. The concurrency and consistency model that allows many simultaneous users with little or no locking. The extensibility using PL/SQL and Java to extend legacy... more»

How has it helped my organization?

Rewriting legacy procedural modules to SQL with analytic functions has on several occasions turned multi-hour jobs into few-minute jobs. High concurrency enables sales persons in shops to service customers swiftly with no waiting even on peak... more»

What needs improvement?

There's not much - new features come along in every version helping to keep up with technological advances. There are some small technical issues such as support forwindowing clause in LISTAGG function and a few similar small issues in SQL.... more»
Jt hjyjg 400x400
Oracle
09578bbb f459 4a07 88ad c5f105def011 avatar
Real User
ERP System Analyst at a tech services company with 501-1,000 employees
Jan 03 2018

What do you think of MySQL?

We could write books about MySQL and every book could have a different focus: setup, optimization, backup, etc. So, this review will be about sharing some of the experiences that I have had. So, MySQL is probably the most used RDBMS for web applications. The server is really easy to install, literally a straightforward installation. It is very fast and stable and at the same time not resource hungry compared to some other RDBMS products. For smaller projects, you will not even need to do any "after install" tweaks or configurations, just install and you are ready to go. Nevertheless, for some more demanding projects, you will need to investigate and optimize your setup to fit the requirements. What is the best configuration for a MySQL server? There is no single best...
Ignite%20technologies logo
Ignite Technologies
Anonymous avatar x80
Real User
Senior System Architect - Resiliency Engineering at a comms service provider with 10,001+ employees
Dec 05 2017

What is most valuable?

A valuable feature was the use of a columnar database for large, ever-growing, big datasets. It also have very amazing smart grid query feature for very fast aggregate queries across millions of rows

How has it helped my organization?

When working properly, the ability to continually insert large datasets, millions of records per minute, while simultaneously querying the same data tables, was very impressive. But it almost never was able to run continually without errors.

What needs improvement?

This version of Infobright has zero support for distributed scalability. The internal smart grid employed for each table has a major flaw in that the data size cannot be expunged until 2GB of data is reached at the column-level. This is a... more»
Relational databases report from it central station 2018 01 27 thumbnail
Find out what your peers are saying about Oracle, Teradata, Microsoft and others in Relational Databases.
253,818 professionals have used our research since 2012.

Relational Databases Articles

A5223938 eed9 42af 9f16 9a9bd1568f21 avatar
Content and Community Manager
IT Central Station
Jan 05 2018
What are operations engineers, BI developers, solution architects, and other IT professionals saying about relational databases? IT Central Station users have compared the key players in the relational database industry: Oracle Database, MySQL, SQL Server, Teradata, and SAP IQ. What can... more»
Ioannis syrigos avatar 1434074141?1434074139
2,193

3
IT Consultant, Business Owner, Lecturer
Dr Ioannis Syrigos is a Computer and Electrical Engineer, an Entrepreneur, co-owner and Managing Director of Stella Novus LTD, an IT consulting company running several individual online projects (Ancient-Origins.net, Members.Ancient-Origins.net, Evolving-Science.com, EnglishWithJo.com and... more>>
3d4f9fa6 cf59 4860 ab16 149a577fbcba avatar
262
Experience in design, development and deployment of applications build on Client/Server Systems, Data warehousing ,Big Data,Business Intelligence applications. Extensive experience Knowledge on MPP database including Netezza Twinfin/Striper Appliance,Teradata and AsterData. Good experience... more>>
Ac828e79 9183 4a39 82be 3200bebea1ed avatar
761
Owner - Consultant
Oracle DBA with more than 15 years of experience in technical leadership, computer technologies and critical missions. Expertise in Oracle Database Management and setup, high availability, critical recovery scenarios, server and application tuning. Proven advanced diagnostic abilities.... more>>
15d11e1e 7dfd 4bea 94c5 697f8104a33b avatar?1439407192
16
TOP 5
IT Consultant & IT Project Manager Assistant
Berardi Florin Via Prati Secchi 22, 21027 Ispra (VA) Italia (+39) 366 – 977 85 86 florin.berardi@outlook.com Italian 24 Marzo 1986 Male BRR FRN 86 C 24 F917 G Unmarried Windows/Distributed/Enterprise Application Developer Amministrazione e Gestione di Database  Analista... more>>
042d32a9 ebd7 4fa8 8d4b f08737222bcd avatar?1437580748
24
TOP 5
Professional Services Senior Consultant
• Más de 24 años de experiencia en Consultoría, de los cuales los últimos 14 años he trabajado en Teradata Iberia SLU. • Profundo conocimiento en bases de datos y Teradata Data Warehouse, en particular en implantaciones Teradata para Industrias de Telecomunicaciones, Retail y... more>>
Add pombal
1,108
TOP 5
Technical computer science engineer. Nowadays DW and BI consultant with 5 years experience in Data Warehousing and Business Intelligence. Good knowledge in processes of a BI/DW project. Specialties:Designing, developing and maintaining data marts. Design and build ETL processes, OLAP... more>>
1fa40977 cae8 4758 96ba 7aa393fa53d1 avatar
372
Team Leader of I&O Team in Bridge Consulting (Florence, Italy). Main activities: project management, coordination/planning, installation/problem solving. Trainer of new colleagues. Everyday involved with big customers such as Gucci, Unicoop Firenze, Ferragamo and so on. Oracle CAB: 2014... more>>
Charles aydin li?1427841182
4
TOP 5
Data Scientist / Consultant
Technically astute, self motivated, highly organized, process&detail focused, results driven and hands-on Physics Ph.D. with excellent research, critical thinking, problem solving, cross-functional team support, and oral & written communication skills. Definitive strengths include the... more>>
13acc869 2103 4909 97a6 043d2b2872d0 avatar
430
Technology Leader Oracle / Senior Consultant
Oracle Certified Master (OCM 12c) and Oracle ACE Director Senior DBA, Oracle Expert, Data Architect, Performance specialist Architecture, DataModeling, Conception, Tuning, Exploitation, Training
Picture 1103 1358283403
3,841
TOP 20POPULAR
 Passionately believe that Information Technology provides the best opportunity to improve the competitive advantage be it from reduced operating costs, improved communications, better and consistent information, reliable and accurate source of data or improving research and fostering growth in... more>>
Reviewed Oracle Database: Beware: Need to monitor disk space
Cedric parish pmp li?1414337558
1,811
TOP 20POPULAR
Senior IT Consultant/Program Mgmt
Information systems professional with a 15+ year background in project management, systems analysis, programming, e-Business, and Internet sales/marketing within the healthcare, manufacturing, insurance, financial services and research industries. Proven abilities in organizing management... more>>
Reviewed SQL Server: Performance Monitoring
Davide moraschi li?1414329707
3,511
TOP 20POPULAR
Senior business Intelligence consultant
Freelance MicroStrategy Professional. Author of the book: "Business Intelligence with MicroStrategy" I've been doing Business Intelligence projects with MicroStrategy and SQL Server/Oracle for the last 10 years now. I have experience in several sectors including Healthcare, Agriculture and... more>>
Picture 2285 1370344574
27,942
TOP REVIEWERPOPULAR
First in Theoretical Physics with 2 years post-grad study of quantum mechanics and general relativity. Founded Butler Group - Europe's largest indigenous IT analyst firm until acquisition by Datamonitor in 2005. Founder of Butler Analytics - dedicated to analysis of analytics technologies and... more>>
Add leonidgvirtz
764
Database Expert
My name is Leonid Gvirtz, I'm freelance consultant in database-related areas. I work with various database-related technologies since 1995. I have a vast amount of experience in the design of databases and database-oriented applications, implementation, troubleshooting, performance & tuning,... more>>

Sign Up with Email