What users are saying about
3 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.8 out of 100
149 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9 out of 100

Likelihood to Recommend

Actian Matrix (discontinued)

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.
Anonymous | TrustRadius Reviewer

Google BigQuery

One of the most important aspects while working with data warehousing solutions and analytics is the ability to handle large datasets. Google BigQuery is the best in business for that particular aspect. It is ridiculously fast while handling large data sets. Another aspect where it is well suited is the ability to integrate it with data visualization tools like Data Studio. It is fast, easy to use, and very reliable. The only aspect where I feel it is less appropriate where you have to pay more of inefficient scripts and that can hamper the growth of the company a bit.
Rounak Verma | TrustRadius Reviewer

Feature Rating Comparison

Database-as-a-Service

Actian Matrix (discontinued)
Google BigQuery
9.4
Automatic software patching
Actian Matrix (discontinued)
Google BigQuery
9.4
Database scalability
Actian Matrix (discontinued)
Google BigQuery
9.7
Automated backups
Actian Matrix (discontinued)
Google BigQuery
9.6
Database security provisions
Actian Matrix (discontinued)
Google BigQuery
9.5
Monitoring and metrics
Actian Matrix (discontinued)
Google BigQuery
8.4
Automatic host deployment
Actian Matrix (discontinued)
Google BigQuery
9.5

Pros

Actian Matrix (discontinued)

  • 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.
Dipankar Pradhan | TrustRadius Reviewer

Google BigQuery

  • BigQuery is ridiculously fast and has the ability to query absurdly large data sets to return results immediately.
  • BigQuery allows for storage of a massive amount of data for relatively low prices.
  • Easy to learn. BiqQuery uses SQL-like queries and is easy to transfer your existing skills to use.
Tristan Dobbs | TrustRadius Reviewer

Cons

Actian Matrix (discontinued)

  • 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
Anonymous | TrustRadius Reviewer

Google BigQuery

  • One issue with Google Cloud Storage is its price. For one to have that premium Google Cloud Storage, for the purpose of massive storage, he/she must have adequate cash. Otherwise, Google Cloud Storage is a safe and perfect online storage platform.
  • The only thing that can come to mind that would be annoying with this software was that sometimes when trying to share files on the Cloud with coworkers, it would just not share at all, or there would be a massive delay in when I shared them and when they received them. Other than that though, everything is perfect with this.
Sam Lepak | TrustRadius Reviewer

Usability

Actian Matrix (discontinued)

Actian Matrix (discontinued) 6.0
Based on 1 answer
I wish to give higher rating for the speed and efficiency in handling the queries, but only 6 because of consistent bugs we encounter
Anonymous | TrustRadius Reviewer

Google BigQuery

Google BigQuery 9.0
Based on 1 answer
BigQuery is a little bit difficult to learn at first. The tools are all there but it takes a few hours of practice and trial and error to be comfortable processing a large dataset. It can handle quite a bit and the cloud storage makes those experimental practice hours much easier to do in your spare time. The software is capable of doing a lot, it's just a matter of being patient and learning the ways of BigQuery.
Anonymous | TrustRadius Reviewer

Support Rating

Actian Matrix (discontinued)

Actian Matrix (discontinued) 8.0
Based on 2 answers
  • Faster initial response
  • Trained professionals
  • Very helpful in resolving issues
Anonymous | TrustRadius Reviewer

Google BigQuery

Google BigQuery 8.2
Based on 16 answers
I rated the overall support for Google BigQuery as a mediocre five because it has limited support from Google. Instead, it is heavily dependent on an organization's IT resources such as SQL analysts and Data Architects to run big data reports or maintain data quality. Additionally, if errors occur during a run of complex SQL queries or when sending data to Google BigQuery from other sources, Google provides basic email support which needs to be complemented with internal data warehouse support to fix the root cause of the database errors. Finally, due to constraints on the amount of data an analyst can query or pay the additional cost when exceeding the limit, basic Google support is not sufficient to meet data needs without interruption.
Anonymous | TrustRadius Reviewer

Implementation Rating

Actian Matrix (discontinued)

Actian Matrix (discontinued) 6.0
Based on 2 answers
Leader failover setup is the toughest and lack of proper documentation is making things tough.
Anonymous | TrustRadius Reviewer

Google BigQuery

No score
No answers yet
No answers on this topic

Alternatives Considered

Actian Matrix (discontinued)

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.
Anonymous | TrustRadius Reviewer

Google BigQuery

Spinning up, provisioning, maintaining and debugging a Hadoop solution can be non-trivial, painful. I'm talking about both GCE based or HDInsight clusters. It requires expertise (+ employee hire, costs). With BigQuery if someone has a good SQL knowledge (and maybe a little programming), can already start to test and develop. All of the infrastructure and platform services are taken care of. Google BigQuery is a magnitudes simpler to use than Hadoop, but you have to evaluate the costs. BigQuery billing is dependent on your data size and how much data your query touches.
Csaba Toth | TrustRadius Reviewer

Return on Investment

Actian Matrix (discontinued)

  • 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.
Dipankar Pradhan | TrustRadius Reviewer

Google BigQuery

  • Google BigQuery has had enormous impact in terms of ROI to our business, as it has allowed us to ease our dependence on our physical servers, which we pay for monthly from another hosting service. We have been able to run multiple enterprise scale data processing applications with almost no investment
  • Since our business is highly client focused, Google Cloud Platform, and BigQuery specifically, has allowed us to get very granular in how our usage should be attributed to different projects, clients, and teams.
  • Plain and simple, I believe the meager investments that we have made in Google BigQuery have paid themselves back hundreds of times over.
Alex Andrews | TrustRadius Reviewer

Pricing Details

Actian Matrix (discontinued)

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Actian Matrix (discontinued) Editions & Modules

Additional Pricing Details

Google BigQuery

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Google BigQuery Editions & Modules

Edition
Queries (On-Demand)$51
Queries (Hourly Flex Slots)$42
Queries (Monthly Flat Rate)$20002
Queries (Annual Flat Rate)$1,7002
  1. per TB
  2. per 100 slots
Additional Pricing Details

Rating Summary

Likelihood to Recommend

Actian Matrix (discontinued)
8.8
Google BigQuery
9.2

Likelihood to Renew

Actian Matrix (discontinued)
6.0
Google BigQuery

Usability

Actian Matrix (discontinued)
6.0
Google BigQuery
9.0

Support Rating

Actian Matrix (discontinued)
8.0
Google BigQuery
8.2

Implementation Rating

Actian Matrix (discontinued)
6.0
Google BigQuery

Add comparison