Home Database Mysql Tutorial IBM DB2 10中的增强提供了高性能、低成本和意外之喜

IBM DB2 10中的增强提供了高性能、低成本和意外之喜

Jun 07, 2016 pm 05:54 PM
db2 ibm low cost high performance

通过显著加速的查询和增强的数据压缩大幅削减存储成本,可在一个小时之内创建的时间感知表,这一切在最新版本的 IBM DB2 中都已成为可能。上述改进连同其他众多改进,使 IBM DB2 10 和 InfoSphere Warehouse 10 成为一种更强大、更经济、更可靠的事务处理和

通过显著加速的查询和增强的数据压缩大幅削减存储成本,可在一个小时之内创建的时间感知表,这一切在最新版本的 IBM DB2 中都已成为可能。上述改进连同其他众多改进,使 IBM DB2 10 和 InfoSphere Warehouse 10 成为一种更强大、更经济、更可靠的事务处理和数据仓库环境,新版本的早期用户可以证实这一点。

优化促进了更快速的查询响应

全新的内部优化提供了超高速查询性能,这直接转化成为了成本节约,加强了履行业务承诺的能力。IBM 针对常用的查询、连接和聚合类型做出了无数的内部优化。IBM 工程师也优化了索引访问,加快了数据检索。缓冲区使用优化改进了 75% 至 85%,显著提升了整体性能,减少了所需的 CPU 周期。

除了上述优化之外,全新的行和列访问控制特性也提供了增强的安全性,同时极大地减少了通过自定义方法分离数据的需求,进一步提高了性能。凭借最新版本中内置的增强,DB2 开箱即用地交付了显著超越旧版本的优异性能改进。

“使用基于 Intel® Xeon® E7 处理器的 IBM System x3850 中的 DB2 10 时,查询处理性能比上一版本提高了十倍,这使我们倍感振奋,”Intel 数据中心和互联系统组的软件战略总经理 Pauline Nist 这样说。“客户现在可在基于 Intel Xeon 处理器的上运行 IBM DB2 10,从而以更低的每查询成本显著提升性能。”

自适应压缩有助于您驾驭数据

压缩存储是 DB2 10 的另一特点。全新的自适应压缩特性能帮助 IT 部门驾驭发展迅猛的数据存储需求,从而节约资金。数据中往往包含重复的信息,例如相同的城市、日期或部门 ID。IT 部门不必再反复存储相同的值,压缩功能允许 IT 部门在单独一个位置(即词典)存储这些值,并使用更短的符号来引用这些值。

IBM DB2 过去一直对整个使用表级压缩词典,这通常能实现更高的压缩率。然而,维护庞大的数据词典要求管理员付出大量时间,并带来了相关成本。在 DB2 10 中,IBM 不仅应用了表级压缩,还会执行页面级压缩,通过它们实现明显超越旧版本的压缩改进。除此之外,页面级词典具有自适应的本质,因此页面级方法消除了耗时的更新和维护问题。

更好的压缩意味着数据占据的空间比以往更少,因此有助于减少存储需求。Coca-Cola Bottling Company 通过公司的 SAP 应用程序测试了 DB2 10 beta 版,管理员对结果深感满意。这家公司从最初的 Oracle Database 迁移到 DB2,实现了 40% 的存储节约,后续升级到 DB2 9.7 又为其带来了 17% 的节约。“现在,通过 DB2 10 的自适应压缩特性,我们又实现了 20% 的节约,使数据库的平均压缩节约达到了 77%,这是非常可观的存储节约,”Coca-Cola 的 SAP 基层总监/DBA Andrew Juarez 这样说。

新特性允许对任意时间点进行查询

全新的 Time Travel Query 功能犹如 DB2 客户的时间机器,其独一无二的特性使 IBM 从竞争对手中脱颖而出。DB2 用户现在可以定义数据有效的时间段,或者穿越时间,处理数据的历史版本。“我们对于新增的 Time Travel Query 特性非常满意,它使我们能在未来的项目中节约大量时间,”中国 LanceInfo 商业智能部门的 Jingjie Li 说。

许多组织都需要管理业务的时间维度。例如,预约系统必须确保不会出现两位客户在相重叠的时间段内预订了相同的旅馆房间或飞机座位的情况。同样,银行需要保证在任意时间点,对于一笔贷款来说,仅有一种利率是有效的。

DB2 10 使企业能满足这些要求,它提供了全面的功能,支持插入、修改和查询过去、现在和未来的有效日期,这些日期都是作为业务时间段进行管理的。该平台也提供了可选的时间约束,这有助于防止旅馆预约出现重叠这类问题。

组织过去始终通过实现自主开发、手动编码的解决方案满足时间数据管理需求。但时间感知的处理逻辑往往极为复杂,手动编码的应用程序开发成本高昂,性能也常常低于预期。随着 DB2 10 的出现,组织可以将自主开发方法抛于脑后。

与自主开发实现相比,利用简单的 SQL 语句执行复杂的时间数据转换能极大地减少编码要求。印度 Tata Consultancy Services 的 Ajith Nayak 认为:“DB2 10 的 Time Travel Query 特性显著简化了应用程序代码,帮助我们在航空相关应用程序的领域节约了至少 25% 至 30% 的工作量。”

DB2 中的 NoSQL 能够集两者之长处

DB2 内的 NoSQL 技术允许组织快捷轻松地部署新应用程序。在探索 NoSQL 的过程中,企业往往会陷入一种两难的境地。开放源码的 NoSQL 数据管理系统能够提供迅速实施应用程序更改的敏捷性。但 IBM DB2 等关系数据存储提供了许多组织都希望保留的重要优势。

利用 IBM DB2 10,组织即可同时利用关系数据技术和 NoSQL 技术的优势。组织既能受益于 NoSQL 的便捷数据库设计和快速开发,也能保留 DB2 的性能、安全性、可靠性和恢复功能,同时还完全符合原子性、一致性、隔离性和持久性 (ACID)。

IBM DB2 10 使用户能够采用一种全新的编程模型,将图形存储范例与数据三元组结合使用。IBM 为 DB2 添加了这项额外的功能,解决了所有必要的优化,确保为 DB2 用户提供流畅体验。IBM 正在开发其他类型的 NoSQL 数据存储,计划将来与 DB2 配合使用,但图形存储技术已经率先发布,它也是最灵活、最有用的一种 NoSQL 方法。

IBM 自己的 Rational 软件组是最先采纳全新图形存储功能的组织之一。实际上,在 IBM Rational 团队评估 DB2 图形存储,并将其与领先的开放源码 NoSQL 解决方案相对比时,他们发现 DB2 的性能比这些解决方案要高 3.5 倍。

新版本有助于解决当今的数据难题

DB2 10 版本还提供了众多其他优势。其中包括多温度带数据管理,允许组织将其数据的不同部分存放在不同的存储层中。举例来说,组织可以将访问较为频繁的数据存放在使用速度更快的存储设备的热存储中,将访问频率较低的数据存放在存储设备速度较慢的冷存储中。最终,性能将得到提高,满足服务水平协议的能力也将得以加强,而组织能够延长其存储的使用寿命,因此成本也得到了削减。

除此之外,全新的 Continuous Ingest 特性允许组织持续、高速地将数据传入数据仓库(即便正在对数据仓库运行查询),从而实现实时数据仓库和运营分析。

凭借这些优势,DB2 在实现未来数据管理的领域中继续保持领先地位。正如 IBM 业务合作伙伴 LIS.TEC GmbH 经理 Ivo Grodtke 所说:“IBM DB2 10 版本解决了当今许多最重要的数据仓库难题。”

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

C++ High-Performance Programming Tips: Optimizing Code for Large-Scale Data Processing C++ High-Performance Programming Tips: Optimizing Code for Large-Scale Data Processing Nov 27, 2023 am 08:29 AM

C++ is a high-performance programming language that provides developers with flexibility and scalability. Especially in large-scale data processing scenarios, the efficiency and fast computing speed of C++ are very important. This article will introduce some techniques for optimizing C++ code to cope with large-scale data processing needs. Using STL containers instead of traditional arrays In C++ programming, arrays are one of the commonly used data structures. However, in large-scale data processing, using STL containers, such as vector, deque, list, set, etc., can be more

How to use Swoole to implement a high-performance HTTP reverse proxy server How to use Swoole to implement a high-performance HTTP reverse proxy server Nov 07, 2023 am 08:18 AM

How to use Swoole to implement a high-performance HTTP reverse proxy server Swoole is a high-performance, asynchronous, and concurrent network communication framework based on the PHP language. It provides a series of network functions and can be used to implement HTTP servers, WebSocket servers, etc. In this article, we will introduce how to use Swoole to implement a high-performance HTTP reverse proxy server and provide specific code examples. Environment configuration First, we need to install the Swoole extension on the server

PHP and WebSocket: Building high-performance, real-time applications PHP and WebSocket: Building high-performance, real-time applications Dec 17, 2023 pm 12:58 PM

PHP and WebSocket: Building high-performance real-time applications As the Internet develops and user needs increase, real-time applications are becoming more and more common. The traditional HTTP protocol has some limitations when processing real-time data, such as the need for frequent polling or long polling to obtain the latest data. To solve this problem, WebSocket came into being. WebSocket is an advanced communication protocol that provides two-way communication capabilities, allowing real-time sending and receiving between the browser and the server.

Use Go language to develop and implement high-performance speech recognition applications Use Go language to develop and implement high-performance speech recognition applications Nov 20, 2023 am 08:11 AM

With the continuous development of science and technology, speech recognition technology has also made great progress and application. Speech recognition applications are widely used in voice assistants, smart speakers, virtual reality and other fields, providing people with a more convenient and intelligent way of interaction. How to implement high-performance speech recognition applications has become a question worth exploring. In recent years, Go language, as a high-performance programming language, has attracted much attention in the development of speech recognition applications. The Go language has the characteristics of high concurrency, concise writing, and fast execution speed. It is very suitable for building high-performance

Embrace AI and lay off 8,000 people! Century-old giant IBM's 'Guangzhou Expansion Plan” has begun Embrace AI and lay off 8,000 people! Century-old giant IBM's 'Guangzhou Expansion Plan” has begun Mar 18, 2024 am 09:40 AM

IBM suddenly announced a new round of layoffs! IBM's chief communications officer announced the news at the latest seven-minute staff meeting. This time it will mainly focus on the marketing and communications departments. Although IBM did not issue a formal statement on the scale of layoffs, as recently as January this year, they announced that they would lay off 3,400 people. The company's CEO Arvind Krishna said earlier that the company will replace 8,000 jobs with artificial intelligence in the next five years. This whole sudden operation directly confused the employees...Have these 8,000 people started laying off employees long ago△Source: One Acre and Three Minutes According to statistics from relevant websites, about 204 technology companies have laid off employees so far this year Nearly 50,000 people. Including Google parent company Alphabet, Amazon

Use Go language to develop high-performance face recognition applications Use Go language to develop high-performance face recognition applications Nov 20, 2023 am 09:48 AM

Use Go language to develop high-performance face recognition applications Abstract: Face recognition technology is a very popular application field in today's Internet era. This article introduces the steps and processes for developing high-performance face recognition applications using Go language. By using the concurrency, high performance, and ease-of-use features of the Go language, developers can more easily build high-performance face recognition applications. Introduction: In today's information society, face recognition technology is widely used in security monitoring, face payment, face unlocking and other fields. With the rapid development of the Internet

How to use the FastAPI framework to build high-performance data APIs How to use the FastAPI framework to build high-performance data APIs Sep 27, 2023 pm 01:49 PM

How to use the FastAPI framework to build high-performance data API Introduction: In today's Internet era, building high-performance data API is the key to achieving fast response and scalability. The FastAPI framework is a high-performance web framework in Python that helps developers quickly build high-quality APIs. This article will guide readers to understand the basic concepts of the FastAPI framework and provide sample code to help readers quickly build high-performance data APIs. 1. Introduction to FastAPI framework FastA

Technical practice of Docker and Spring Boot: quickly build high-performance application services Technical practice of Docker and Spring Boot: quickly build high-performance application services Oct 21, 2023 am 08:18 AM

Technical practice of Docker and SpringBoot: quickly build high-performance application services Introduction: In today's information age, the development and deployment of Internet applications have become increasingly important. With the rapid development of cloud computing and virtualization technology, Docker, as a lightweight container technology, has received widespread attention and application. SpringBoot has also been widely recognized as a framework for rapid development and deployment of Java applications. This article will explore how to combine Docker and SpringB

See all articles