TrustRadius: an HG Insights company

Microsoft R Open / Revolution R Enterprise vs. PrestoDB (or Presto)

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Microsoft R Open / Revolution R Enterprise

    Score8.9 out of 10
    N/AMicrosoft R Open and Revolution R Enterprise are big data R distribution for servers, Hadoop clusters, and data warehouses. Microsoft acquired original developer Revolution Analytics in 2016. Microsoft R is available in two editions: Microsoft R Open (formerly Revolution R Open) and Revolution R Enterprise.N/A

    PrestoDB (or Presto)

    Score10 out of 10
    N/APresto is an open source SQL query engine designed to run queries on data stored in Hadoop or in traditional databases. Teradata supported development of Presto followed the acquisition of Hadapt and Revelytix.N/A
    Pricing
    Microsoft R Open / Revolution R EnterprisePrestoDB (or Presto)
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Microsoft R Open / Revolution R EnterprisePrestoDB (or Presto)
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Features
    Microsoft R Open / Revolution R EnterprisePrestoDB (or Presto)
    Platform Connectivity
    Comparison of Platform Connectivity features of Microsoft R Open / Revolution R Enterprise and PrestoDB (or Presto)
    Feature
    Microsoft R Open / Revolution R Enterprise
    5.3
    3 Ratings
    45% below category average
    PrestoDB (or Presto)
    -
    Ratings
    Connect to Multiple Data Sources6.13 Ratings00 Ratings
    Extend Existing Data Sources6.03 Ratings00 Ratings
    Automatic Data Format Detection6.03 Ratings00 Ratings
    MDM Integration3.01 Ratings00 Ratings
    Data Exploration
    Comparison of Data Exploration features of Microsoft R Open / Revolution R Enterprise and PrestoDB (or Presto)
    Feature
    Microsoft R Open / Revolution R Enterprise
    7.0
    3 Ratings
    19% below category average
    PrestoDB (or Presto)
    -
    Ratings
    Visualization7.03 Ratings00 Ratings
    Interactive Data Analysis7.03 Ratings00 Ratings
    Data Preparation
    Comparison of Data Preparation features of Microsoft R Open / Revolution R Enterprise and PrestoDB (or Presto)
    Feature
    Microsoft R Open / Revolution R Enterprise
    4.8
    3 Ratings
    52% below category average
    PrestoDB (or Presto)
    -
    Ratings
    Interactive Data Cleaning and Enrichment5.13 Ratings00 Ratings
    Data Transformations5.03 Ratings00 Ratings
    Data Encryption3.01 Ratings00 Ratings
    Built-in Processors6.03 Ratings00 Ratings
    Platform Data Modeling
    Comparison of Platform Data Modeling features of Microsoft R Open / Revolution R Enterprise and PrestoDB (or Presto)
    Feature
    Microsoft R Open / Revolution R Enterprise
    6.0
    3 Ratings
    34% below category average
    PrestoDB (or Presto)
    -
    Ratings
    Multiple Model Development Languages and Tools5.03 Ratings00 Ratings
    Automated Machine Learning5.02 Ratings00 Ratings
    Single platform for multiple model development8.03 Ratings00 Ratings
    Self-Service Model Delivery6.03 Ratings00 Ratings
    Model Deployment
    Comparison of Model Deployment features of Microsoft R Open / Revolution R Enterprise and PrestoDB (or Presto)
    Feature
    Microsoft R Open / Revolution R Enterprise
    6.5
    2 Ratings
    27% below category average
    PrestoDB (or Presto)
    -
    Ratings
    Flexible Model Publishing Options6.02 Ratings00 Ratings
    Security, Governance, and Cost Controls6.92 Ratings00 Ratings
    Best Alternatives
    Microsoft R Open / Revolution R EnterprisePrestoDB (or Presto)
    Small Businesses
    RapidMiner
    Score8.9 out of 10
    Amazon RDS
    Score8.1 out of 10
    Medium-sized Companies
    Anaconda
    Score8.8 out of 10
    SingleStore
    Score8.2 out of 10
    Enterprises
    IBM Watson Studio
    Score10 out of 10
    SAP IQ
    Score5.4 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Microsoft R Open / Revolution R EnterprisePrestoDB (or Presto)
    Likelihood to Recommend
    6.0
    (5 ratings)
    7.8
    (2 ratings)
    Likelihood to Renew
    7.0
    (1 ratings)
    -
    (0 ratings)
    Usability
    7.0
    (1 ratings)
    -
    (0 ratings)
    Support Rating
    8.0
    (2 ratings)
    -
    (0 ratings)
    User Testimonials
    Microsoft R Open / Revolution R EnterprisePrestoDB (or Presto)
    Likelihood to Recommend
    Microsoft
    If you are a MS shop specifically, or have more generic data requirement needs from Microsoft sourced data this will work well. If you have a lot of disparate data across a number of unique platforms/cloud systems/3rd party hosted data warehouses then this product will have issues or a lack of documentation on the net. Performance-wise this product is equal to other R platforms out there.
    Incentivized
    Read full review
    Open Source
    Presto is for interactive simple queries, where Hive is for reliable processing. If you have a fact-dim join, presto is great..however for fact-fact joins presto is not the solution.. Presto is a great replacement for proprietary technology like Vertica
    Incentivized
    Read full review
    Pros
    Microsoft
    • It allows distributed algorithm runs on Hadoop HDFS cluster
    • It allows using different file formats such as SAS7BAT files or complex files in tab or comma delimited making data munging easier
    • It provides scalable solutions by allowing users to re-use R scripts and distributing the computing over nodes through RHadoop
    Read full review
    Open Source
    • Linking, embedding links and adding images is easy enough.
    • Once you have become familiar with the interface, Presto becomes very quick & easy to use (but, you have to practice & repeat to know what you are doing - it is not as intuitive as one would hope).
    • Organizing & design is fairly simple with click & drag parameters.
    Incentivized
    Read full review
    Cons
    Microsoft
    • Very steep learning curve... for such a quick and useful tool the learning curve is unacceptable.
    • Very dangerous in the wrong hands. Because most add-ons are pre-written, you have to trust the community that malicious script is not used.
    Incentivized
    Read full review
    Open Source
    • Presto was not designed for large fact fact joins. This is by design as presto does not leverage disk and used memory for processing which in turn makes it fast.. However, this is a tradeoff..in an ideal world, people would like to use one system for all their use cases, and presto should get exhaustive by solving this problem.
    • Resource allocation is not similar to YARN and presto has a priority queue based query resource allocation..so a query that takes long takes longer...this might be alleviated by giving some more control back to the user to define priority/override.
    • UDF Support is not available in presto. You will have to write your own functions..while this is good for performance, it comes at a huge overhead of building exclusively for presto and not being interoperable with other systems like Hive, SparkSQL etc.
    Incentivized
    Read full review
    Likelihood to Renew
    Microsoft
    In general, Revolution Analytics brings a lot of value to the organization. The renewal decision would be based on return on investment in terms of quantified actionable insights that are getting generated against the cost of the product. Additionally, market brand of the tool and reputation risk in terms of possible acquisition and its impact to overall organizational analytic strategy would be considered as well.
    Read full review
    Open Source
    No answers on this topic
    Usability
    Microsoft
    It is good, easy to use, improvements are being made to the product and more info being shared in the community. It just needs some more time to become more integrated to other platforms and tools/data out there.
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Support Rating
    Microsoft
    Generally support comes through the forums and user generated channels which are helpful, easy to access, quickly turned around and provided by knowledgeable users. However the support channels are not employees and the channels are often used as a way to learn quick difficult elements of R. Better design, users interface and tutorial options would alleviate the need for this sort of interaction.
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Alternatives Considered
    Microsoft
    The two are different products for different purposes. But for someone who has little or no experience in R programming, Power BI would be better for starting with. Having said that, Microsoft R is built on R, thus allowing for customization of complex calculations not typically available otherwise.
    Incentivized
    Read full review
    Open Source
    Presto is good for a templated design appeal. You cannot be too creative via this interface - but, the layout and options make the finalized visual product appealing to customers. The other design products I use are for different purposes and not really comparable to Presto.
    Incentivized
    Read full review
    Return on Investment
    Microsoft
    • Helped save company money versus buying other stat software
    Incentivized
    Read full review
    Open Source
    • Presto has helped scale Uber's interactive data needs. We have migrated a lot out of proprietary tech like Vertica.
    • Presto has helped build data driven applications on its stack than maintain a separate online/offline stack.
    • Presto has helped us build data exploration tools by leveraging it's power of interactive and is immensely valuable for data scientists.
    Incentivized
    Read full review
    ScreenShots