What users are saying about

Apache Spark

99 Ratings

Microsoft Access<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>

501 Ratings

Apache Spark

99 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.6 out of 101

Microsoft Access<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>

501 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.3 out of 101

Add comparison

Likelihood to Recommend

Apache Spark

Apache Spark has rich APIs for regular data transformations or for ML workloads or for graph workloads, whereas other systems may not such a wide range of support. Choose it when you need to perform data transformations for big data as offline jobs, whereas use MongoDB-like distributed database systems for more realtime queries.
Nitin Pasumarthy profile photo

Microsoft Access

Microsoft Access is great for integrating with .NET for both stand-alone and web-based solutions. Since it is so widely-used, it is fairly easy to find people in your existing work pool who can use it, and also easier to find new applicants who can hit the ground running with this technology. It is terrific for small businesses or small departments within larger organizations who want to be in control of their own simple projects and prototyping. It is well-suited for environments where security is locked down but employees still need to accomplish simple programming tasks.
No photo available

Pros

  • Machine Learning.
  • Data Analysis
  • WorkFlow process (faster than MapReduce).
  • SQL connector to multiple data sources
Anson Abraham profile photo
  • An Access database can be designed and put to use rather fast, in order to answer an immediate need, even if the design must be done by someone with no previous exposure to Access. It can be modified/improved later on, without much impact on the users.
  • A relatively simple Access database does not require knowledge of any programming language. It can be implemented by using 'macros', which are of a 'point-and-click' type.
  • If a more complex application is required, Access is fully compatible with Visual Basic for Applications language, which is a object-oriented, even-driven programming language, designed by Microsoft specifically for utilization by all modules belonging to the Office suite.
  • Since the commonality of VBA across Office, Access databases can be made to interface with other Office applications, and in particular with Excel.
  • Access is easy to master, cheap, and allows easily the construction of aesthetically pleasing interfaces with the user, while remaining quite powerful. Due to these reasons, it yields itself to be sometimes used for the design of non-database applications, but specialized calculators.
Fred Abraham, P.Eng profile photo

Cons

  • Data visualization.
  • Waiting for Web Development for small apps to be started with Spark as backbone middleware and HDFS as data retrieval file system.
  • Transformations and actions available are limited so must modify API to work for more features.
Kamesh Emani profile photo
  • Long loading times for larger datasets - Depending on the data with which you are working, it can take a while to open and save documents. Additionally, if you are working with multiple datasets that are joined, this is all saved into one file and seems to make the issue worse.
  • Learning curve - Without a relatively strong background in either database management or SQL, it can be difficult to adapt to Access. The layout isn't very intuitive for new users and so it takes time to learn the ins and outs.
  • File size limit - Access has a 2GB file size limit, which, for the large majority of cases is not a problem. For those instances where you are working with multiple large datasets, though, this will be an issue unless you link multiple Access databases.
Joseph R. Sweeney profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Microsoft Access9.0
Based on 15 answers
We're extremely likely to renew this subscription, as it is what drives some very vital information to a public facing website that our entire company has access to and relies on very regularly. We would be lost without this and I would be utterly shocked if we didn't renew it.
No photo available

Usability

No score
No answers yet
No answers on this topic
Microsoft Access7.0
Based on 3 answers
Microsoft Access is easy to use. It is compatible with spreadsheets. It is a very good data management tool. There is scope to save a large amount of data in one place. For using this database, one does not need much training, can be shared among multiple users. This database has to sort and filtering features which seem to be very useful.
No photo available

Reliability and Availability

No score
No answers yet
No answers on this topic
Microsoft Access8.0
Based on 1 answer
I don't think the program has ever failed me. It is one of those programs where there is always a solution if you know where to look.
No photo available

Support

No score
No answers yet
No answers on this topic
Microsoft Access7.5
Based on 2 answers
I intend to elaborate very soon via another update, after checking some of my notes.
Fred Abraham, P.Eng profile photo

Alternatives Considered

I prefer Apache Spark compared to Hadoop, since in my experience Spark has more usability and comes equipped with simple APIs for Scala, Python, Java and Spark SQL, as well as provides feedback in REPL format on the commands. At the same time, Apache Spark seems to have the best performance in the processing of large data that works in memory and, therefore, more processes can be downloaded on Spark than on Hadoop, despite the fact that Hadoop is also a very useful tool.
Carla Borges profile photo
Microsoft Access is a good data management tool. and it excels in that area, which is what we needed the most. It was simple to use and easy to learn. Database management can be done with multiple users in Access. And we can have reports for data summaries, or for any specific purpose.
No photo available

Return on Investment

  • By learning Spark, we can become certified and/or provide proper recommendations or implementations on Spark solutions.
  • With a background in Hadoop distributed processes, it has been easy to understand and diagnose how Spark handles the transfer of data within a cluster. Especially when using YARN as the resource manager and HDFS as the data source.
  • Staying up to date with the latest changes to Spark has become a repetitive task. While most Hadoop distributions only support Spark 1.6 at the moment, Spark 2.0 has introduced some useful features, but those require a re-write of existing applications.
Jordan Moore profile photo
  • The access databases work very well with many of the programs for Windows-based software development. You can also use your tables in products such as Microsoft SQL Server and in others not based on Microsoft such as Oracle and Sybase.
  • Easy to install and use: To create access databases, just install Microsoft Access and this is something that any database administrator can do in just a few minutes, leaving a fully functional relational database management system. Like many other Microsoft applications, Access contains wizards that guide you through every step of the way. The user interface is intuitive, speeding up data recovery.
  • It can be placed online: Although it still has limitations on the number of users with simultaneous connection, when there is a need for remote users, it can give full control and functionality to an access database so that teleworking can become a viable option for database administrators.
Thairy Ollarves profile photo

Pricing Details

Apache Spark

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

Microsoft Access

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