IBM DB2 10.5 with BLU Acceleration IMD14435USEN

青菜

536

12页

6次

2020-04-22

免费下载

IBM Software

Data Sheet

IBM DB2 10.5 with

BLU Acceleration

Multi-workload database software for the big data era

Highlights

• Dramatically faster reporting

and analytics

• Upgrade to in-memory speed and

simplicity on existing infrastructure

• New level of data compression: clients

have reported compression rates of

10 times in IBM® DB2® with BLU

Acceleration versus uncompressed

tables.

• Online rolling upgrades designed for

no planned downtime

• In DB2 10.5, IBM DB2 pureScale® HADR

is designed to achieve failover in seconds;

HADR helps disaster recovery of

pureScale clusters over distances of

thousands of kilometers.

• DB2 pureScale provides transparent

scalability beyond 100 nodes.

• Business-grade NoSQL and IBM Mobile

Database for greater application ﬂexibility

In this era of big data, business and IT leaders across all industries are

looking for ways to easily and cost-effectively unlock the value of

enterprise data that resides in both transactional processing and data

warehouse systems. They are trying to quickly implement new solutions

to gain additional insight from this data to improve outcomes across

all areas of the business, while simultaneously optimizing resource

utilization and reducing costs.

IBM DB2 for Linux, UNIX and Windows is a multi-workload database

management solution built for these challenges. Providing new,

innovative capabilities to meet demanding data processing requirements,

DB2 is designed to help ensure that your data systems are fast, always

available, scalable and exible—while also supporting a wide variety of

new mobile, social and analytical applications.

DB2 10.5 includes several capabilities to help organizations tackle the

challenges presented by big data:

• Analytics at the speed of thought, including new BLU Acceleration

• Always-available transactions

• Future-proof versatility

• Unprecedented affordability

• Streamlined packaging

Data Sheet

IBM Software

Analytics at the speed of thought

The effectiveness and speed of data analytics are often hindered

by infrastructures that are unable to keep pace with the rate of

data growth and change. DB2 with BLU Acceleration offers a

huge step forward in analytic workload processing by

combining proven in-memory and columnar data store

capabilities with advanced compression and hardware

exploitation techniques. The result: reliably faster analytic

query processing for a variety of online analytical workloads—

without the limitations of in-memory-only systems.

Developed by the IBM Research and Development Labs,

DB2 with BLU Acceleration represents a new generation of

data management. Innovations include:

• Dynamicin-memorycolumnarprocessing with dynamic

movement of unused data to storage

• ActionableCompression to preserve order so that the data

can be used without decompression

• Parallelvectorprocessing for delivering multi-core and

Single Instruction Multiple Data (SIMD)

• Dataskipping to bypass unnecessary processing of

irrelevant data

BLU Acceleration adds an extra storage engine and integrated

runtime directly into the core DB2 system to support the storage

and analysis of column-organized tables. This processing runs

parallel to traditional row-based table processing, enabling DB2

to process both row-based and column-based tables in the same

system (see Figure 1). The potential results include signicantly

improved performance, massive storage savings and ease of

implementation and management for both transactional and

analytic data workloads.

IBM DB2 with BLU Acceleration

Runtime

Classic DB2 buffer pool

CPUs with SIMD

BLU runtime

Classic

DB2 runtime

Classic DMS

(for non-BLU tables)

BLU DMS

(for BLU tables)

Classic, row-structured table

Storage

Compressed, encoded columnar

C1 C2 C3 C4 C5 C6 C7 C8 C1 C2 C3 C4 C5 C6 C7 C8

Figure : DB2 can now process both row-based and column-based tables

in the same system, resulting in signiﬁcantly improved performance.

of 12

免费下载

db2 架构设计

关注

评论