TrustRadius: an HG Insights company

Azure Blob Storage, with Azure Data Lake Storage vs. Db2

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Azure Blob Storage

    Score8.7 out of 10
    N/AAzure Blob Storage is Microsoft Azure’s object storage service for storing and accessing large volumes of unstructured data. Organizations use it for application content, backups and archives, media, logs, data exports, machine learning datasets, high-performance computing workloads, and data-lake storage. NOTE: Azure Data Lake Storage, also known as Azure Data Lake Storage Gen2, is not a separate service or account type. It is a set of big-data analytics capabilities within Azure Blob Storage…

    $0.01

    per GB/per month

    Db2

    Score8.6 out of 10
    N/ADB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.

    $0

    Pricing
    Azure Blob StorageDb2
    Editions & Modules
    Block Blobs
    $0.0081
    per GB/per month
    Azure Data Lake Storage
    $0.0081
    per GB/per month
    Files
    $0.058
    per GB/per month
    Managed Discs
    $1.54
    per month
    Db2 on Cloud Lite
    $0
    Db2 on Cloud Standard
    $99
    per month
    Db2 Warehouse on Cloud Flex One
    $898
    per month
    Db2 on Cloud Enterprise
    $946
    per month
    Db2 Warehouse on Cloud Flex for AWS
    2,957
    per month
    Db2 Warehouse on Cloud Flex
    $3,451
    per month
    Db2 Warehouse on Cloud Flex Performance
    13,651
    per month
    Db2 Warehouse on Cloud Flex Performance for AWS
    13,651
    per month
    Db2 Standard Edition
    Contact Sales
    Db2 Advanced Edition
    Contact Sales
    Offerings
    Pricing Offerings
    Azure Blob StorageDb2
    Free Trial
    YesYes
    Free/Freemium Version
    NoYes
    Premium Consulting/Integration Services
    NoYes
    Entry-level Setup FeeNo setup feeOptional
    Additional Details——
    More Pricing Information
    Best Alternatives
    Azure Blob StorageDb2
    Small Businesses
    Google Cloud Storage
    Score9.2 out of 10
    Amazon RDS
    Score8.1 out of 10
    Medium-sized Companies
    Everpure FlashBlade
    Score9.9 out of 10
    SingleStore
    Score8.2 out of 10
    Enterprises
    Google Cloud Storage
    Score9.2 out of 10
    SAP IQ
    Score5.4 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Azure Blob StorageDb2
    Likelihood to Recommend
    9.1
    (25 ratings)
    9.1
    (114 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    7.9
    (12 ratings)
    Usability
    8.9
    (4 ratings)
    8.4
    (9 ratings)
    Availability
    -
    (0 ratings)
    9.3
    (64 ratings)
    Performance
    -
    (0 ratings)
    9.1
    (12 ratings)
    Support Rating
    9.0
    (3 ratings)
    8.9
    (6 ratings)
    In-Person Training
    -
    (0 ratings)
    8.2
    (1 ratings)
    Implementation Rating
    -
    (0 ratings)
    5.6
    (3 ratings)
    Configurability
    -
    (0 ratings)
    9.1
    (2 ratings)
    Data Sharing and Collaboration
    -
    (0 ratings)
    8.0
    (1 ratings)
    Data Sources
    -
    (0 ratings)
    9.0
    (1 ratings)
    Ease of integration
    -
    (0 ratings)
    7.8
    (4 ratings)
    Product Scalability
    -
    (0 ratings)
    8.3
    (66 ratings)
    Vendor post-sale
    -
    (0 ratings)
    9.0
    (2 ratings)
    Vendor pre-sale
    -
    (0 ratings)
    9.0
    (2 ratings)
    User Testimonials
    Azure Blob StorageDb2
    Likelihood to Recommend
    Microsoft
    In Azure, it is the storage to use, and in my view, the Blob Storage offers more, or finer-grained configuration options, than S3. So my recommendation would be to check in detail what is offered. As the Blob Storage is more or less a Microsoft exclusive product, the "interoperability" is more limited than, for example, with S3. The S3 is more widely adopted, and if you cannot exclude a migration scenario from one cloud provider to another, additional effort is needed.
    Incentivized
    Read full review
    IBM
    I have primarily used it as the basis for a SIS - but I have migrated more than a few systems from there database systems to DB2 (Filemaker, MySQL, etc.). DB2 does have a better structural approach, as opposed to Filemaker, which allows for more data consistency, but this can also lead to an inflexibility that can sometimes be counterintuitive when attempting to compensate for the flexibility of the work environment as Schools tend to have an all in one approach.
    Incentivized
    Read full review
    Pros
    Microsoft
    • The data lake analytics tool is good and provides loads of computing power to speed up the processing time.
    • It provides unlimited storage for structured, semi-structured or unstructured data.
    • Cloud-based service and we can easily use it for ETL and ELT processes.
    Incentivized
    Read full review
    IBM
    • While we query a large set of data, the results are generally available within a minute or so.
    • Always reliable - I have never experienced an application going down.
    • It is easy to write queries and find tables and columns.
    • We can log in smoothly without any headaches.
    Incentivized
    Read full review
    Cons
    Microsoft
    • study for the certifications also to have them as a reference for work when you have any questions about applying a configuration to the equipment.
    • The Internet interface is simple and easy to use. Capacity is good and it's good that HP continues to innovate with this technology
    Incentivized
    Read full review
    IBM
    • Learning curve for DB resources - Improvements to UI or native command line built-ins can help with increasing efficiencies for DB resources
    • Better resource utilization monitoring and recommendations
    • Continue to adopt support for modern frameworks and languages making it easier for organizations to see making Db2 the easy first choice
    Incentivized
    Read full review
    Likelihood to Renew
    Microsoft
    No answers on this topic
    IBM
    The DB2 database is a solid option for our school. We have been on this journey now for 3-4 years so we are still adapting to what it can do. We will renew our use of DB2 because we don’t see. Major need to change. Also, changing a main database in a school environment is a major project, so we’ll avoid that if possible.
    Incentivized
    Read full review
    Usability
    Microsoft
    Blob storage is fairly simple, with several different options/settings that can be configured. The file explorer has enhanced its usability. Some areas could be improved, such as providing more details or stats on how many times a file has been accessed. It is an obvious choice if you're already using Azure/Entra.
    Incentivized
    Read full review
    IBM
    You have to be well versed in using the technology, not only from a GUI interface but from a command line interface to successfully use this software to its fullest.
    Incentivized
    Read full review
    Reliability and Availability
    Microsoft
    No answers on this topic
    IBM
    I have never had DB2 go down unexpectedly. It just works solidly every day. When I look at the logs, sometimes DB2 has figured out there was a need to build an index. Instead of waiting for me to do it, the database automatically created the index for me. At my current company, we have had zero issues for the past 8 years. We have upgrade the server 3 times and upgraded the OS each time and the only thing we saw was that DB2 got better and faster. It is simply amazing.
    Incentivized
    Read full review
    Performance
    Microsoft
    No answers on this topic
    IBM
    The performances are exceptional if you take care to maintain the database. It is a very powerful tool and at the same time very easy to use. In our installation, we expect a DB machine on the mainframe with access to the database through ODBC connectors directly from branch servers, with fabulous end users experience.
    Incentivized
    Read full review
    Support Rating
    Microsoft
    Microsoft has improved its customer service standpoint over the years. The ability to chat with an issue, get a callback, schedule a call or work with an architecture team(for free) is a huge plus. I can get mentorship and guidance on where to go with my environment without pushy sales tactics. This is very refreshing. Typically support can get me to where I need to be on the first contact, which is also nice.
    Incentivized
    Read full review
    IBM
    Easily the best product support team. :) Whenever we have questions, they have answered those in a timely manner and we like how they go above and beyond to help.
    Incentivized
    Read full review
    In-Person Training
    Microsoft
    No answers on this topic
    IBM
    the material was very clear and all subjects have been handled
    Incentivized
    Read full review
    Implementation Rating
    Microsoft
    No answers on this topic
    IBM
    db2 work well with the application, also the replication tool can keep it up
    Read full review
    Alternatives Considered
    Microsoft
    Azure Premium Blob offers better latency than competitors. It works best with the Azure ecosystem, and competitors lack it. Azure Blob even stands out in storage durability, providing up to 16 nines. It can have various use cases that can suit all the organisation's needs. The Azure Blob solution can also be deployed on-premises.
    Incentivized
    Read full review
    IBM
    DB2 was more scalable and easily configurable than other products we evaluated and short listed in terms of functionality and pricing. IBM also had a good demo on premise and provided us a sandbox experience to test out and play with the product and DB2 at that time came out better than other similar products.
    Incentivized
    Read full review
    Scalability
    Microsoft
    No answers on this topic
    IBM
    By
    using DB2 only to support my IzPCA activities, my knowledge here
    is somewhat limited.

    Anyway,
    from what I was able to understand, DB2 is extremely scallable.

    Maybe the information below could serve as an example of scalability.
    Customer have an huge mainframe environment, 13x z15 CECs, around
    80 LPARs, and maybe more than 50 Sysplexes (I am not totally sure about this
    last figure...)

    Today
    we have 7 IzPCA
    databases, each one in a distinct Syplex.

    Plans
    are underway to have, at the end, an small LPAR, with only one DB2 sub-system,
    and with only one database, then transmit the data from a lot of other LPARs,
    and then process all the data in this only one database.



    The
    IzPCA collect process (read the data received, manipulate it, and insert rows
    in the tables) today is a huge process, demanding many elapsed
    hours, and lots of CPU.

    Almost
    100% of the tables are PBR type, insert jobs run in parallel, but in 4 of the 7
    database, it is a really a huge and long process.



    Combining
    the INSERTs loads from the 7 databases in only one will be impossible.......,,,,



    But,
    IzPCA recently introduced a new feature, called "Continuous
    Collector"
    .
    By
    using that feature, small amounts of data will be transmited to the central
    LPAR at every 5 minutes (or even less), processed immediately,in
    a short period of time, and with small use of CPU,
    instead of one or two transmissions by day, of very large amounts of data and
    the corresponding collect jobs occurring only once or twice a day, with long
    elapsed times, and huge comsumption of CPU



    I
    suspect the total CPU seconds consumed will be more or less the same in
    both cases, but in the new method it will occur in small bursts
    many times a day!!
    Incentivized
    Read full review
    Return on Investment
    Microsoft
    • Data Migration projects from relational sources to Azure Data Lake Storage have given a great ROI, thanks to the less running costs, and High availability
    • Pretty easy to work with in terms of Managing and accessing Data in containerized fashion.
    • Further features like Archival of data which is accessed less frequently can significantly reduce cost
    Incentivized
    Read full review
    IBM
    • Negative: Difficult and manual deployment
    • Negative: Missing assistants from common monitoring metrics
    • Positive: Stability
    • Positive: Performance
    • Positive: Resiliency and high availability (HADR)
    • Positive: Data Replication (Q-Rep)
    • Positive: Interaction with storage subsystems for backups (TSM, SVC)
    • Positive: Gigantic monitoring features in the form of table functions
    Incentivized
    Read full review
    ScreenShots

    Db2 Screenshots

    Screenshot of Db2 - Data sharingScreenshot of Db2 - Machine LearningScreenshot of Db2 - Real time insights