We performed a comparison between Oracle Database, SAP IQ, and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."All of the features offered by Oracle, more than meet the expectations."
"As a database, the solution has been number one from the beginning."
"The dashboard may be the best solution for intelligent data management, as well as business intelligence."
"It is user-friendly. Its performance and security are also very good. There are 300 million records for our one-year data, and we can easily query this data. You can use Oracle Database as a source for easily integrating with different databases and applications. It supports Java platforms and other applications very well. It works with SAP products better than Microsoft SQL Server."
"The scalability is very good, and it is stable."
"Significant assistance in tuning both the migration process and the production database was provided by Oracle Consulting Services, which provided excellent and very professional advice."
"The product's initial setup phase was very easy."
"It does what I want it to do. It has got a lot of features. Anytime I need a feature, I am able to find it in Oracle Database. It has never happened that I found a feature in any other database, but I was not able to find it in Oracle."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"The primary benefit of SAP IQ is its ability to limit the expansion of the costly SAP HANA database, which has limited storage capacity. This necessitates a form of data management that involves moving data from SAP HANA to SAP NLS, which is essentially archiving. This allows us to retain access to the data via a link whenever it is required."
"Columnar storage allows high compression, high load rates and high query performance."
"Unbeatable speed and compression with a colummn-structured relational database."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"I have found the solution to be scalable."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"The extensibility and efficiency provided by their C++ SDK."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"I like the projection feature, which increases query performance."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"Speed and resiliency are probably the best parts of this product."
"There are actually a lot more features for the Oracle Databases. It is almost impossible for a single person to know and give all the features."
"More integration, in my opinion, would be beneficial."
"It would be nice if creating indexes and other small, repetitive tasks could be automated."
"When you try to tell customers that you can critically patch their system, they always complain about the cost."
"The tool's price gap is a major concern. It makes it hard for others to afford it and use it effectively. More people could benefit from its features if the pricing could be made more reasonable. Many companies choose cheaper options because of this affordability issue."
"Oracle Database could improve by making migration less difficult and having better integration. For example, having the ability to communicate, using native features, to different databases. Mostly connectivity to different databases, such as open-source databases or any other database."
"Oracle is a costly product, and it requires a lot of resources."
"I'm in Indonesia. From what I know, Ali Cloud has already built a center in Indonesia, and Google also has a data center in Indonesia. I have heard that Amazon will also build a data center in Indonesia, and the same will be with Azure if they deal with the Indonesian government. I'm quite appreciative of what Amazon has done by deciding to have a local data center. I expect Oracle to do the same, but Oracle doesn't seem to have plans to build a data center in Indonesia. This is something that needs to be improved. Oracle should follow all the other cloud providers who see a potential market in Indonesia. It would be better for Oracle to be equal to other cloud providers and have a data center in Indonesia so they can compete. Having a local data center means that they can avoid performance issues, the latency of the network, and all the things that are related to the network for internet-based solutions. Customers in Indonesia expect a local data center."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"Concurrency and functional error messaging."
"I think the universe should be part of the Sybase IQ tool set."
"Multiplex is very problematic. There are consistency problems in the metadata, meaning it is possible to lose metadata consistency. You should make sure you have healthy backups."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"Documentation has become much better, but can always use some improvement."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"The geospatial functionality could be designed better."