Bigdata
Now Reading
IBM Db2 Warehouse
0
Review

IBM Db2 Warehouse

Overview
Synopsis

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 employees), 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
Features & Functionality
7.6
8.6
Advanced Features
7.6
8.9
Integration
7.6
8.3
Performance
7.6
Customer Support
7.6
Implementation
Renew & Recommend
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.6
Aggregated User Rating
1 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.

Filter reviews
User Ratings





User Company size



User role





User industry





Ease of use
Features & Functionality
Advanced Features
Integration
Performance
Customer Support
Implementation
Renew & Recommend

What's your reaction?
Love It
0%
Very Good
0%
INTERESTED
0%
COOL
0%
NOT BAD
0%
WHAT !
0%
HATE IT
0%