Data Warehouse Service

Data Warehouse Service (DWS) is a real-time, simple, secure, and reliable enterprise-class converged data warehouse service. With the help of Express, DWS can extend its querying and analysis to data lakes.

Starting from ¥2.007/DataNode/Hour

Learn more
Product Advantages
  • Secure and Reliable

    Integrates with DBSS to better protect user privacy and data security with network isolation and security group rule setting options. Adopts HA design and transparent data encryption to ensure high data and system reliability.

  • Easy to Use

    A unified console helps you easily manage data warehouses and focus on data and service. DWS is compatible with Oracle, PostgreSQL, and Teradata so you have the freedom to choose. Simple-to-use database migration tool allows you to smoothly move heterogeneous databases over with complete confidence.

  • Efficient

    Real-time data import to databases, T+0 agile service analysis and decision-making, and correlation analysis on at-scale data within seconds. Provides enterprise-class capabilities such as OLAP analysis, statistics analysis, and self-service analysis.

  • Various Import Modes

    Batch-import of data from OBS and MRS adds speed and efficiency. Working with DIS, CS, and DLI, DWS helps you quickly and conveniently import stream data. The service also uses third-party ETL and CDM for data migration and supports real-time data writing using JDBC and Copy interfaces.

Application Scenarios
  • Data Warehouse Migration

  • Converged Big Data Analysis

  • ETL + BI Analysis

  • Real-Time Data Analysis

Data Warehouse Migration

Data Warehouse Migration

The data warehouse is an important data analysis system for enterprises. As the service volume grows, performance of self-built data warehouses cannot meet the actual service requirements due to their poor scalability and high costs. As an enterprise-class data warehouse on the cloud, DWS features high performance, low cost, and easy scalability, satisfying requirements in the big data era.

Advantages

Seamless Migration

DWS provides various migration tools to ensure seamless migration of popular data analysis systems such as TeraData, Oracle, MySQL, SQL Server, PostgreSQL, Greenplum, and Impala.

Compatibilities with Traditional Data Warehouses

DWS supports the SQL 2003 standard and stored procedures. It is compatible with some Oracle syntax and data structures, and can be seamlessly interconnected with common BI tools, smoothing service migration efforts.

High Security and Reliability

DWS supports data encryption and connects to the Database Security Service (DBSS) to ensure data security on the cloud. In addition, DWS supports automatic full and incremental backup of data, improving data reliability.

Related Services

dis

cdm

dlf

drs

Converged Big Data Analysis

Converged Big Data Analysis

Data has become the most important asset. Enterprises must be able to integrate their data resources and analysis platforms with high precision to mine the full value of their data. In predictive analysis use cases, massive volumes of data must be processed. Huawei DWS delivers the needed processing power to handle these intense compute scenarios.

Advantages

Unified Analysis Entry

The DWS SQL serves as the unified entry of upper-layer applications, so that application developers can access all data using the SQL.

Real-Time Interactive Analysis

Analysis personnel can obtain immediately-actionable information from the big data platform in real time using broad analysis requests.

Auto Scaling

Adding nodes allows you to easily expand into PB-range capacity while enhancing query and analysis performance of the system.

ETL + BI Analysis

Enhanced ETL + Real-Time BI Analysis

The data warehouse is the pillar of the BI system for collecting, storing, and analyzing massive volumes of data. It powers business decision analysis for the IoT, finance, education, mobile Internet, and O2O industries.

Advantages

Data Migration

Ability to import data in batches in real time from multiple data sources.

High Performance

Cost-effective PB-level data storage and response to correlation analysis of trillions of data records within seconds.

Real-Time

Real-time consolidation of service data to produce actionable insights in operational decision-making.

Related Services

cdm

dlf

drs

Real-Time Data Analysis

Real-Time Data Analysis

In the mobile Internet and IoT domains, huge volumes of data must be processed and analyzed in real time to extract the full data from data. The quick data import and query capabilities of DWS accelerate data analysis capabilities to enable real-time ingestion, processing, and value generation.

Advantages

Real-Time Import of Stream Data

Data from IoT and Internet applications can be written into DWS in real time after being processed by the stream computing and AI services.

Real-Time Monitoring and Prediction

Device monitoring, control, optimization, supply, self-diagnosis, and self-healing based on data analysis and prediction.

Converged AI Analysis

Correlation analysis can be conducted on results of image and text data analysis by AI services and other service data on DWS.

Functions

  • High Reliability

    Provides various functions to improve the reliability of data warehouse clusters.

  • PB-Level High-Performance

    Provides high-performance data warehouses dedicated for enterprises.

High Reliability

  • Built-in redundancy at the instance and data-level avoids potential single points of failure (SPOFs), adding robustness to the service mix.

  • Provides two data replicas and supports manual data backup to OBS.

  • Automatically isolates faulty nodes, uses the replica to recover data, and supports node replacement.

  • Automatic incremental backup ensures data reliability at zero cost.

PB-Level High-Performance

  • Uses a MPP-based computing framework, and supports row and column-based data storage and vectorized executors, as well as SQL 03 analysis functions.


  • Adopts in-memory computing, MPP and SMP technologies, and LLVM, improving performance by as much as 10 times.

  • Optimizes the communication between large-scale clusters based on telecommunication technologies, improving data transmission efficiency between compute nodes.

  • Cost-based optimizer generates an optimal execution plan based on cluster scale and data volume for supercharged efficiency.

  • Openness and Compatibility

    Supports comprehensive SQL capabilities and smooth application migration.

  • Monitoring and Audit

    Controls service usage and status.

Openness and Compatibility

  • Supports SQL 92 and SQL 2003 standards, complete transaction processing capabilities, and stored procedures.

  • One-click schema migration tool and support for SQL code conversion for heterogeneous databases like Oracle and MySQL.

  • Compatible with the PostgreSQL ecosystem and supports interconnection authentication with mainstream database ETL and BI tools provided by third-party vendors.

  • Compatible with Oracle, PostgreSQL, and Teradata.

Monitoring and Audit

  • Integrates with CTS to allow you to audit all operations performed on the DWS management console and API invocation.

  • Integrates with Cloud Eye to allow you to monitor compute nodes and databases in the cluster.

  • Records all SQL operations, involving connection attempts, queries, and database changes.

Usage Guides

Create an Account and Experience HUAWEI CLOUD for Free

Register Now