External interfaces of FusionInsight MPPDB

7

FusionInsight MPPDB provides JDBC and ODBC interfaces.

Other related questions:
What are the interfaces of FusionInsight MPPDB?
FusionInsight MPPDB provides JDBC and ODBC interfaces.

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.

What interfaces does FusionInsight MPPDB comprise?
FusionInsight MPPDB provides JDBC and ODBC interfaces.

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