What users are saying about

Apache Spark vs Db2 Big SQL

Apache Spark
127 Ratings
Db2 Big SQL
4 Ratings

Apache Spark

127 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.7 out of 100

Based on 127 reviews and ratings

Db2 Big SQL

4 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100

Based on 4 reviews and ratings

Likelihood to Recommend

Apache Spark

The software appears to run more efficiently than other big data tools, such as Hadoop. Given that, Apache Spark is well-suited for querying and trying to make sense of very, very large data sets. The software offers many advanced machine learning and econometrics tools, although these tools are used only partially because very large data sets require too much time when the data sets get too large. The software is not well-suited for projects that are not big data in size. The graphics and analytical output are subpar compared to other tools.

Read full review

Thomas Young | TrustRadius Reviewer
Thomas Young
View all 20 answers on this topic

Db2 Big SQL

My recommendation obviously would depend on the application. But I think given the right requirements, IBM DB2 Big SQL is definitely a contender for a database platform. Especially when disparate data and multiple data stores are involved. I like the fact I can use the product to federate my data and make it look like it's all in one place. The engine is high performance and if you desire to use Hadoop, this could be your platform.

Read full review

Gene Baker | TrustRadius Reviewer
Gene Baker
View all 2 answers on this topic

Pros

Apache Spark

  • Rich APIs for data transformation making for very each to transform and prepare data in a distributed environment without worrying about memory issues
  • Faster in execution times compare to Hadoop and PIG Latin
  • Easy SQL interface to the same data set for people who are comfortable to explore data in a declarative manner
  • Interoperability between SQL and Scala / Python style of munging data

Read full review

Nitin Pasumarthy | TrustRadius Reviewer
Nitin Pasumarthy
View all 20 answers on this topic

Db2 Big SQL

  • data storage
  • data manipulation
  • data definitions
  • data reliability

Read full review

John Spies | TrustRadius Reviewer
John Spies
View all 2 answers on this topic

Cons

Apache Spark

  • Memory management. Very weak on that.
  • PySpark not as robust as scala with spark.
  • spark master HA is needed. Not as HA as it should be.
  • Locality should not be a necessity, but does help improvement. But would prefer no locality

Read full review

Anson Abraham | TrustRadius Reviewer
Anson Abraham
View all 20 answers on this topic

Db2 Big SQL

  • Cloud readiness.
  • Ease of implementation.

Read full review

Gene Baker | TrustRadius Reviewer
Gene Baker
View all 2 answers on this topic

Usability

Apache Spark

Apache Spark 8.7
Based on 3 answers
Apache integrates with multiple big data frameworks. It does not exert too much load on the disks. Moreover, it is easy to program and use. It reduces the headache of using different applications separately through its high-level APIs. Big data processing has never been as easy as it is with Apache Spark.

Read full review

Partha Protim Pegu | TrustRadius Reviewer
Partha Protim Pegu
View all 3 answers on this topic

Db2 Big SQL

Db2 Big SQL 8.0
Based on 1 answer
IBM DB2 is a solid service but hasn't seen much innovation over the past decade. It gets the job done and supports our IT operations across digital so it is fair.

Read full review

John Spies | TrustRadius Reviewer
John Spies
View all 1 answers on this topic

Support Rating

Apache Spark

Apache Spark 8.2
Based on 6 answers
1. It integrates very well with scala or python.2. It's very easy to understand SQL interoperability.3. Apache is way faster than the other competitive technologies.4. The support from the Apache community is very huge for Spark.5. Execution times are faster as compared to others.6. There are a large number of forums available for Apache Spark.7. The code availability for Apache Spark is simpler and easy to gain access to.8. Many organizations use Apache Spark, so many solutions are available for existing applications.

Read full review

Yogesh Mhasde | TrustRadius Reviewer
Yogesh Mhasde
View all 6 answers on this topic

Db2 Big SQL

Db2 Big SQL 8.7
Based on 2 answers
IBM did a good job of supporting us during our evaluation and proof of concept. They were able to provide all necessary guidance, answer questions, help us architect it, etc. We were pleased with the support provided by the vendor. I will caveat and say this support was all before the sale, however, we have a ton of IBM products and they provide the same high level of support for all of them. I didn't see this being any different. I give IBM support two thumbs up!

Read full review

Gene Baker | TrustRadius Reviewer
Gene Baker
View all 2 answers on this topic

Alternatives Considered

Apache Spark

Spark in comparison to similar technologies ends up being a one stop shop. You can achieve so much with this one framework instead of having to stitch and weave multiple technologies from the Hadoop stack, all while getting incredibility performance, minimal boilerplate, and getting the ability to write your application in the language of your choosing.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 20 answers on this topic

Db2 Big SQL

MS SQL Server was ruled out given we didn't feel we could collapse environments. We thought of MS-SQL as more of a one for one replacement for Sybase ASE, i.e., server for server. SAP HANA was evaluated and given a big thumbs up but was rejected because the SQL would have to be rewritten at the time (now they have an accelerator so you don't have to). Also, there was a very low adoption rate within the enterprise. IBM DB2 Big SQL was not selected even though technically it achieved high scores, because we could not find readily available talent and low adoption rate within the enterprise (basically no adoption at the time). We ended up selecting Exadata because of the high adoption rate within the enterprise even though technically HANA and Big SQL were superior in our evaluations.

Read full review

Gene Baker | TrustRadius Reviewer
Gene Baker
View all 2 answers on this topic

Return on Investment

Apache Spark

  • It has had a very positive impact, as it helps reduce the data processing time and thus helps us achieve our goals much faster.
  • Being easy to use, it allows us to adapt to the tool much faster than with others, which in turn allows us to access various data sources such as Hadoop, Apache Mesos, Kubernetes, independently or in the cloud. This makes it very useful.
  • It was very easy for me to use Apache Spark and learn it since I come from a background of Java and SQL, and it shares those basic principles and uses a very similar logic.

Read full review

Carla Borges | TrustRadius Reviewer
Carla Borges
View all 20 answers on this topic

Db2 Big SQL

  • better data visibility
  • solid reliability for mission critical data

Read full review

John Spies | TrustRadius Reviewer
John Spies
View all 2 answers on this topic

Pricing Details

Apache Spark

General

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

Db2 Big SQL

General

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

Add comparison