Application scenarios of FusionInsight MPPDB

24

FusionInsight MPPDB is oriented to industrial big data applications and applicable to the following scenarios:
1. CDR query: MPPDB can process PB-level data in security, telecommunication, financial, and Internet of things (IoT) industries. Its memory analysis technology enables you to query massive volumes of data while data is being written to the database.
2. Data warehouse: MPPDB can efficiently process hundreds of TB-level data and tens of billions of rows relating to multi-table joining queries. It is applicable to Operational Data Store (ODS), Enterprise Data Warehouse (EDW), and Data Mart (DM) scenarios.
3. Hybrid load: MPPDB is capable of analyzing query statistics of massive volumes of data and processing transactions. It provides the hybrid row-based and column-based storage technology, so it is applicable to a hybrid load scenario consisting of online transaction processing (OLTP) and online analytical processing (OLAP).
4. Big data analysis: MPPDB can analyze PB-level structured data. Its distributed parallel database clusters can provide the analysis function for PB-level structured big data.

Other related questions:
FusionInsight application scenarios
Satisfying demands in the O&M and application development fields for data-intensive industries, such as finance and telecom industries, Huawei FusionInsight provides a reliable, secure, and easy-to-use O&M system and full data modeling middleware. With FusionInsight, enterprises can process data and mine values from massive volumes of data in an accurate and faster manner.

What are the application scenarios of FusionInsight?
Satisfying demands in the O&M and application development fields for data-intensive industries, such as finance and telecom industries, Huawei FusionInsight provides a reliable, secure, and easy-to-use O&M system and full data modeling middleware. With FusionInsight, enterprises can process data and mine values from massive volumes of data in an accurate and faster manner.

Functions of FusionInsight MPPDB
FusionInsight MPPDB provides the following functions: 1. Standard SQL support Supports SQL92 and SQL2003 standards, GBK and UTF-8 character sets, standard SQL functions, OLAP analysis functions, and stored procedure. 2. Database storage management Supports tablespace and online capacity expansion. 3. Component management and high availability (HA) of data nodes Supports atomicity, consistency, isolation, and durability (ACID) features of database transactions, recovery from single node failures, and load balancing. 4. APIs Supports standard JDBC 4.0 and ODBC 3.5. 5. Security management Supports SSL security network connections, user rights management, password management, and security auditing, ensuring security of databases at management, application, system, and network layers.

Development of FusionInsight MPPDB
FusionInsight MPPDB is implemented based on the open source Postgre-XC component and adopts the massively parallel processing (MPP) architecture (also called Shared Nothing structure). It divides database instances into two roles, namely, Coordinator and DataNode. Coordinator is responsible for providing external application interfaces, optimizing and distributing execution plans, and summarizing execution results. DataNode reads data from and writes data to database tables. Multiple database instances can run on each x86 storage node concurrently, forming a distributed database cluster.

Definition of FusionInsight MPPDB
FusionInsight MPPDB is an enterprise-class relational database for large-scale parallel processing. It adopts the massively parallel processing (MPP) architecture, supports column-based storage, and provides processing capabilities of PB-level (two to the fiftieth power) data.

If you have more questions, you can seek help from following ways:
To iKnow To Live Chat
Scroll to top