Sign in to see all reviews and comparisons. It's Free!
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.
Database as a Service SQL Data Model
• 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
Small (<50 employees), Medium (50 to 1000 employees), Enterprise (>1001 employees)
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
Aggregated User Rating
Ease of use
Features & Functionality
Renew & Recommend
IBM Db2 Warehouse (formerly IBM dashDB Local) is a client-managed, private cloud data warehouse for Docker container supported infrastructures.
Aggregated User Rating
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.
PAT RESEARCH is a B2B discovery platform which provides Best Practices, Buying Guides, Reviews, Ratings, Comparison, Research, Commentary, and Analysis for Enterprise Software and Services. We provide Best Practices, PAT Index™ enabled product reviews and user review comparisons to help IT decision makers such as CEO’s, CIO’s, Directors, and Executives to identify technologies, software, service and strategies.