Likelihood to Recommend First, get the database on Oracle. If you are in an Oracle stack, it would be much better to use the Oracle products. If you are driving a Ferrari, you wouldn’t put a Mercedes engine in it. If you are writing a query, you cannot rely on other brands. Since I'm an architect, when I look for a product, I look for performance. The installation is easy because it comes out-of-the-box and you just start using it. Previous to Oracle Exadata, we were using a normal Oracle RAC service. We were just waiting for this product to come out. I'm currently writing a data warehouse on Exadata. Before this solution, we were aiming for this to be completed by 8 a.m., when our ETLs would finish. With the help of Exadata's special features, this was reduced to 3 a.m. This solution allows us to bring more data within the same time period. It provides us with more subject areas that provide more reports to our users. Our ETL times reduced to 65%, then to 50%. Read full review Actian matrix is not good for small data sets. If you have a limited data pool, or do not plan on having multiple users/clients accessing a data source, stick with a more traditional relational database model - Access for the truly small user base, or a DB2 or Oracle back end if your going to have multiple users, and moderate sized data. Actian is for LARGE data sets (Big Data, in the industry parlance). Millions of rows of data from multiple sources with various down stream systems accessing the database. It is for data analytics of large data groups and intense data mining.
Read full review Pros Customize-able for specific functionality optimized for combination of online transaction or analytical processing. Ability to serve mix workloads with resource management feature enables prioritizing allocation for certain workload. Scale-able on-premise with compatibility for cloud deployment offers flexible solution for organization considering to transition from on-premise solution. Read full review Super fast. Aggregate query such as SUM(), Count() returns result within seconds from a table with more than billion records. Excellent data compression. Easy maintenance. We managed this database without having a full time DBA. Support ANSI SQL and ODBC/JDBC. It's easy to connect to this database from other systems. Read full review Cons Patching can often become quite involved and convoluted. It should be more transparent and straightforward. Storage metrics can be difficult and time consuming to obtain. Basic administrative functions can be hard to repair when discovered. Vendor support can take a while to obtain. Generally several attempts are necessary to reach the right area of vendor expertise. Read full review Some of the bugs were annoying and QA definitely needs improvement Connectivity to Informatica and ETL providers Workload management could be better like when you compare with Teradata Read full review Usability I wish to give higher rating for the speed and efficiency in handling the queries, but only 6 because of consistent bugs we encounter
Read full review Support Rating Faster initial response Trained professionals Very helpful in resolving issues Read full review Implementation Rating Leader failover setup is the toughest and lack of proper documentation is making things tough.
Read full review Alternatives Considered Oracle Exadata Database Machine had the best performance overall hands down. It clearly beat the competition and we were seeing 1000X improvement on
SAP HANA . Oracle Exadata Database Machine beat that without us refactoring our code. To achieve that in HANA, we had to refactor the code somewhat. Now this was for our limited POC of 5 use cases. Given the large number of stored procedures we had in Sybase, we need to capture more production metrics but we are seeing incredible performance.
Gene Baker Vice President, Chief Architect, Development Manager and Software Engineer
Read full review Actian Matrix is our first big data analytics storage platform, and as I was not involved in the POC process to compare it to other products out on the market, unfortunately I cannot say if it is better than other Big Data storage options. I can say that it out performs products such as Oracle or UDB in regards to the volume of data it can easily index and handle.
Read full review Return on Investment Single support from a single vendor with both machine and database from Oracle, which is costing us less. With Exadata, we need less technical manpower and less technical support. A business transaction with the integrated and centralized database helps us focus on other business needs. We don't need to buy additional licenses and Hardware for the next 3 to 5 years. Habeeb Akbar Sr. Product Manager/Consultant for Software Technologies and Infrastructure
Read full review ROI is great, less spending on full time DBA and that money could be use to add additional node. Negative - Not many developers are well aware of this tool, it takes some time to learn. Read full review ScreenShots