HUAWEI TECHNOLOGIES CO., LTD.

Copyright © Huawei Technologies Co., Ltd. 2013. All rights reserved.

General Disclaimer

The information in this document may contain predictive statements including, without limitation, statements regarding the future financial and operating results, future product portfolio, new technology, etc. There are a number of factors that could cause actual results and developments to differ materially from those expressed or implied in the predictive statements. Therefore, such information is provided for reference purpose only and constitutes neither an offer nor an acceptance. Huawei may change the information at any time without notice.

HUAWEI TECHNOLOGIES CO., LTD.

Huawei Industrial Base

Bantian Longgang

Shenzhen 518129, P.R. China

Tel: +86-755-28780808

Version No.: M3-035255-20130202-C-2.0

www.huawei.com

Dorado High-Performance Database Solution

Database nowadays benefits many fields in enterprise

operations, covering enterprise resource planning, customer

relationship management, end-to-end manufacturing process

from procurement, production, to distribution, and enterprise

management issues including finance, human resources, and

decision-making. To survive in fierce market competitions,

enterprises must provide high-quality and efficient services to win

customers. And such services must be supported by mature and

high-performance IT systems, among which database plays a key

role in affecting application performance.

Nowadays, customers pose more and more demanding

requirements on waiting time and result availability of online

transaction processing (OLTP) and online analytical processing

(OLAP) applications. Therefore, enterprise IT systems must rise to

the challenges on transaction response time, number of active

users, queries time, and system reliability. The overall system

performance and response time of database applications must

be optimized.

Challenge 1: system response failure in peak hours, limiting

service development

The system cannot support the huge number of users that will •

keep increasing with the service development.

Note: "Database Capacity" is the total capacity of multiple databases. The capacity ratio of OLTP applications to OLAP applications is 1:7, that is, if the

total capacity is 2 TB, 250 GB is for OLTP applications and 1750 GB is for OLAP applications.

The number of transactions that need to be processed during •

peak hours is soaring, adding the waiting time and causing

customers' complaints.

Challenge 2: exploding service data growth, hampering fast

decision-making

Data analysis time is long, delaying accounting and decision-making•

Fast data growth prevents reports being generated within the •

specified period, hindering service development.

Challenge 3: increasing pressure on efficiency improvement, •

challenging IT personnel's adaptability to changes

Parallel computing and virtualization intensify applications, add •

system pressure, and aggravate performance bottlenecks.

IT personnel are spending a lot of time and energy in reducing •

traditional methods such as full table scan, index optimization,

tablespace optimization, and cache hit ratio improvement.

The attempts to add database license , improve server •

performance, and add SSDs/HDDs cannot efficiently resolve

the database performance issues caused by long latency.

Under fierce competition and tight budget, IT personnel must •

keep searching for better solutions to cope with the issues

risen with rapid data growth.

Background/Challenge

Recommended configuration

High-Speed Configuration Base Edition Standard Edition Enterprise Edition Flagship Edition

Database Capacity 2 TB 3.5 – 8 TB 6 – 12 TB 12 – 18 TB

Wait Time for One Transaction Down to 1/10 Down to 1/10 Down to 1/10 Down to 1/10

Number of Concurrent Users 20,000 40,000 65,000 90,000

Analysis Time for 1 TB Data 22 min 16 min 13 min 10 min

OLAP Analysis Bandwidth 2.6 GB/s 4.3 GB/s 5.7 GB/s 7.6 GB/s

Recommended ConfigurationDorado2100 G2 25x100GB SLC

Dorado2100 G2 50x100GB/200GB SLC

Dorado5100 72x200GB SLC

Dorado5100 96x200GB SLC

Space (U) 2 U 4 U 10 U 12 U

Server2 servers (CPU: 2x8 core @2.2GHz or above; Memory: 96 GB each)

4 servers (CPU: 2x8 core @2.2GHz or above; Memory: 96 GB each)

6 servers (CPU: 2x8 core @2.2GHz or above; Memory: 96 GB each)

6 servers (CPU: 2x8 core @2.2GHz or above; Memory: 96 GB each)

Database Version Oracle 10g, 11g; SQL server 2005, 2008, 2012; DB2 LUW 9/10

Operating System Windows Server 2005/2008/2012, Linux (SUSE/RHEL/Oracle Linux), HP-UX, AIX

High-Density Configuration Base Edition Standard Edition Enterprise Edition Flagship Edition

Database Capacity 4 TB 7 – 16 TB 12 – 24 TB 24 – 38 TB

Wait Time for One Transaction Down to 1/10 Down to 1/10 Down to 1/10 Down to 1/10

Number of Concurrent Users 5,500 11,000 18,000 22,000

Analysis Time for 1 TB Data 56 min 44 min 33 min 18 min

OLAP Analysis Bandwidth 2.6 GB/s 4.3 GB/s 5.7 GB/s 7.6 GB/s

Recommended ConfigurationDorado2100 G2 25x200GB eMLC

Dorado2100 G2 50x200GB/400GB eMLC

Dorado5100 72*200GB/400GB eMLC/Dorado2100 G2 75*200GB/400GB eMLC

Dorado5100 72*200GB/400GB eMLC/Dorado2100 G2 75*200GB/400GB eMLC

Space (U) 2 U 4 U 10 U/6U 12 U/8U

Server2 servers(CPU: 2*8 core @2.2GHz or above; Memory: 96GB each)

4 servers(CPU: 2*8 core @2.2GHz or above; Memory: 96GB each)

6 servers(CPU: 2*8 core @2.2GHz or above; Memory: 96GB each)

6 servers(CPU: 2*8 core @2.2GHz or above; Memory: 96GB each)

Database Version Oracle 10g, 11g; SQL server 2005, 2008, 2012; DB2 LUW 9/10

Operating System Windows Server 2005/2008/2012, Linux (SUSE/RHEL/Oracle Linux), HP-UX, AIX

Optimized data productivity to bring a rapid service development

The queries time for OLAP applications is reduced by 72% and •

the efficiency is grown 4-fold.

The transaction response time for OLTP applications is reduced •

by 88%.

The number of supported active users is increased by 24-fold.•

Reduced hardware/software license requirements and a simplified •

architecture lower the maintenance and management complexity.

Four-level reliability protection mechanisms to safeguard key

applications

Application level: applicable to all database clusters such as •

Oracle RAC, SQL Server MSCS, and DB2 Cluster.

Solution level: supports multipathing software and data •

protection technologies such as snapshot and replication in

mainstream operating systems.

HUAWEI database solution is developed based on the high-performance solid-state storage Dorado, and collaborates with mainstream

databases such as Oracle, SQL Server, DB2, Sybase, and My SQL. The migration of data from legacy databases to Dorado does not

require any changes in network elements or applications. Then the system performance is improved by 24 times.

This solution helps users deploy high-performance and high-reliability databases and operating systems in a fast manner, and

complete more applications in a specified time than before. Therefore, enterprises' return on investment (ROI) is maximized, and their

competitiveness is greatly enhanced.

System level: dual-controller full-redundancy architecture, free •

of single points of failure, hot-swap components, and online

component replacement and system upgrade.

Disk level: intelligent wear leveling, bad sector management, •

error checking and correcting (ECC), and 7.5-year ensured

service life.

Simple architecture and deployment to achieve service ease-

of-use and –maintenance

The solution deployment requires no system modification or •

application migration, and its impact is as slight as an offline

preventive maintenance.

The central deployment of data warehouse, OLTP and OLAP •

applications reduces the maintenance complexity.

The performance commissioning process is simplified and the •

storage system deployment can be completed within one click.

Solution Overview

HUAWEI Database Solution

Solution Highlights

Dorado High-Performance Database Solution

Greatly improves the efficiency of various types of database.

Provides an open architecture to support physical machines, virtual machines, and midrange computers.

Employs a standard SAN architecture for ease-of-use and ease-of-access.

Dorado5100

Dorado2100 G2