Sign in to see all reviews and comparisons. It's Free!
By clicking Sign In with Social Media, you agree to let PAT RESEARCH store, use and/or disclose your Social Media profile and email address in accordance with the PAT RESEARCH Privacy Policy and agree to the Terms of Use.
IBM DB2 Warehouse is a software-defined data warehouse for private and virtual clouds that support Docker container technology. It is client managed and optimized for fast and flexible deployment with automated scaling to meet agile analytic workloads.
Category
Database as a Service SQL Data Model
Features
• Performance optimization feature (IBM DB2 Query Patroller software) • Deep data compression • Integrated development environment [IDE]) workbench: Provides a stand-alone environment, based on Eclipse • MDC tables, which block data based on dimensional combinations, can help improve query performance and reduce data maintenance overhead • SQL warehousing (SQW) design tool with a graphical interface for data warehouse transformation design • Table partitioning improves query processing, simplifies administration
License
Proprietary
Pricing
Subscription
Free Trial
Available
Users Size
Small (<50 employees), Medium (50 to 1000 Enterprise (>1001 employees)
Company
IBM Db2 Warehouse
What is best?
• Performance optimization feature (IBM DB2 Query Patroller software) • Deep data compression • Integrated development environment [IDE]) workbench: Provides a stand-alone environment, based on Eclipse • MDC tables, which block data based on dimensional combinations, can help improve query performance and reduce data maintenance overhead
What are the benefits?
• Scalability: Support very large databases, common in the data warehousing environment, as well as complex workloads and increased parallelism for administration tasks • Mining: View, export, update and delete models in the mining database • Immediate access to relevant data: Enable users to gain self service access to all relevant data sources • Flexible scaling and simplified deployment: Save on licensing costs as users pay for what they use on a monthly basis
PAT Rating™
Editor Rating
Aggregated User Rating
Rate Here
Ease of use
7.6
7.0
Features & Functionality
7.6
8.5
Advanced Features
7.6
8.6
Integration
7.6
9.0
Performance
7.6
8.0
Customer Support
7.6
9.0
Implementation
8.0
Renew & Recommend
6.4
Bottom Line
IBM Db2 Warehouse (formerly IBM dashDB Local) is a client-managed, private cloud data warehouse for Docker container supported infrastructures.
7.6
Editor Rating
8.1
Aggregated User Rating
4 ratings
You have rated this
IBM DB2 Warehouse is a software-defined data warehouse for private and virtual clouds that support Docker container technology. It is client managed and optimized for fast and flexible deployment with automated scaling to meet agile analytic workloads. Fusing IBM Db2 BLU and Netezza technologies, DB2 Warehouse offers cloud elasticity combined with the simplicity of a software appliance. It is supported on variety of platforms such as Intel x86, Power and Linux on z. DB2 Warehouse can also be deployed on IBM Cloud Private platform, IBM Bluemix, or any virtual private cloud such as AWS, Microsoft Azure and more. Deploy a pre-configured data warehouse in minutes on Docker container supported infrastructure of choice, with elastic scaling and ease of updates / upgrades to continually meet service levels. With just a few clicks, unstructured data sources are automatically transformed into a structured format for analysis – Twitter data, Open Data, geospatial data… A common SQL analytics engine across public and private cloud, compatible with on-premises data warehouses, enables workloads to be moved to the right location with ease. DB2 Warehouse provides support for exchanging data mining models with workbench providers such as SPSS or SAS, as well as the capability to interchange OLAP models with leading business intelligence (BI) vendors such as Microstrategy, Cognos and Business Objects. Additional features include operational warehouse metadata management and embedded analytical application capabilities. The DB2 Warehouse platform creates an environment in which database administrators (DBAs), data architects, BI designers and BI deployment specialists can collaborate in a cohesive and integrated manner on a warehouse project.
By clicking Sign In with Social Media, you agree to let PAT RESEARCH store, use and/or disclose your Social Media profile and email address in accordance with the PAT RESEARCH Privacy Policy and agree to the Terms of Use.