Data Warehouse Palo

Baidu Palo is an enterprise-class data warehouse platform based on Apache Doris, a modern MPP analytics data warehouse product. Query results can be obtained only in sub-second response time, which can effectively support online real-time data analytics. Palo's distributed architecture is very simple, easy to operate. Besides, Palo can support very large data sets of petabytes or more.
Data Warehouse Palo
  • Product Description
  • Features
  • Advantages
  • Customer Cases

Product Description

Palo helps enterprises to create the PB-level MPP architecture data warehouse service within several minutes and import the massive data from RDS, BOS, and BMR. Thus, Palo can perform the multi-dimensional analytics of big data. Palo is compatible with mainstream BI tools. Data analysts can analyze and display the data visually and gain insights quickly to assist decision-making.

Product Description

Features

Efficient Query
Efficient Query
It has the industry-leading MPP query engine, with column storage, intelligent index,and vector execution functions. It can also provide in-library analytics, window functions, and other advanced analytics functions.
Data Loading
Data Loading
It supports atomic import of batch data.
It supports low latency import of streaming data.
On-line Data Management
On-line Data Management
You can create a materialized view and change the table structure without the suspension of service. It supports flexible and efficient data recovery.
Materialized View
Materialized View
The materialized view is automatically updated with the original table. It can automatically select the most appropriate materialized view to complete the query.

Advantages

  • Ease of use

    Ease of use

    It is compatible with MySQL protocol, supports rich SQL-2003 syntax, supports online table structure changes, and can provide various data import and export methods.

  • Excellent Performance

    Excellent Performance

    It is designed as an MPP query architecture that supports both high concurrency small queries and high throughput ad-hoc queries. It has a high-performance Hybrid-OLAP storage engine.

  • High Availability and Reliability

    High Availability and Reliability

    It can provide multi-copy data storage function, can automatically request routing, automatic data repair

  • Comprehensive Big Data Ecology

    Comprehensive Big Data Ecology

    It supports ODBC access to external data sources, supports ElasticSearch using SQL queries, and supports reading and writing data via Spark.

Customer Cases

  • aiBank

    aiBank

    aiBank is the first independent legal entity to be approved as a direct bank, jointly launched by China Citic Bank and Baidu Inc. The main business of aibank is online business, which is characterized by the great fluctuation of online access, rapid change of service, and operation relying on intelligent means of big data. Therefore, relying on Baidu Data Warehouse Palo, aiBank built a reliable data analytics platform to help Baixin Bank build a data warehouse, data mart, with efficient SQL query capability.

    Turnover Rate APP

    Turnover Rate APP

    Turnover Rate App is the first in China to map mode real-time quantitative main capital attack direction of the stock App. It needs to visually present real-time quantitative analytics and individual stock big data analytics reports for users. Baidu Data Warehouse Palo provides it with multi-dimensional analytics and reports query functions on large data sets. Palo also supports visual analytics applications compatible with JDBC interface, making it more intuitive and convenient to display data analytics results.

    Sichan Airlines

    Sichan Airlines

    Sichuan Airlines is China's largest full-Airbus fleet airline. Up to now, Sichuan Airlines has formed a route network covering more than 80 cities in China, with a total of more than 200 routes. Sichuan Airlines cooperated deeply with Baidu to establish a big data center to solve the problem of chaotic data governance and serious data silencing. During the construction of the project, Baidu Data Warehouse Palo provided the operation analytics platform with efficient and stable real-time report query capability and data analytics capability.