General FAQs

Product FAQs

  • What is MatrixOne?

MatrixOne is a future-oriented hyperconverged cloud & edge native DBMS that supports transactional, analytical, and streaming workload with a simplified and distributed database engine, across multiple datacenters, clouds, edges and other heterogenous infrastructures. The all-in-one architecture of MatrixOne will significantly simplify database management and maintenance, single database can serve multiple data applications. For information about MatrixOne, you can see MatrixOne Introduction.

  • Where can I apply MatrxOne?

MatrixOne provides users with HTAP services to support hybrid workloads, it can be used to build data warehouse or data platform.

  • Is MatrixOne based on MySQL or some other database?

MatrixOne is a totally redesigned database. It’s compatible with part of MySQL syntax and semantics, and we are working to support more database semantics such as PostgreSQL, Hive, Clickhouse, as we intend to develop MatrixOne as a hyperconverged database.
About the compatibility with MySQL, you can see MySQL-Compatibility.

  • What’s the relationship between MatrixOne and MatrixCube?

MatrixOne is the main database project, including query parser layer, compute layer, and storage layer, it could work as a standalone database system. MatrixCube is a independant library who doesn’t work alone, it’s a distributed system framework. It gives MatrixOne the ability to extend as a distributed database. It also supports to be mounted with other storage engines. For information about MatrixCube, you can see MatrixCube Introduction.

  • Why MatrixOne is so fast?

MatrixOne achieves accelerated queries using patented vectorized execution as well as optimal computation push down strategies through factorization techniques.

  • Which programming language is MatrixOne developed with ?

Currently, the primary programming language used for our codes is Golang.

  • What operating system does MatrixOne support?

MatrixOne supports Linux and MacOS.

  • Which MatrixOne data types are supported?

You can see data tpyes in MatrixOne to learn more about the data types we support.

  • Can I contribute to MatrixOne?

Yes, MatrixOne is an open-source project developed on GitHub. Contribution instructions are published in Contribution Guide. We welcome developers to contribute to the MatrixOne community.

Deployment FAQs

  • Are there any hardware requirements for deploying MatrixOne?

Standalone setting specification: x86 CPU with 4 cores and 32GB memory, with CentOS 7+ Operating System.

Distributed setting specification: 3 servers, each one with x86 CPU with 16 cores and 64GB memory, with CentOS 7+ Operating System.

SQL FAQs

  • Whether functions and other keywords are case sensitive？

No, they are not case sensitive.

  • How do I export data from MatrixOne to a file?

You can use SELECT INTO OUTFILE command to export data from MatrixOne to a csv file (only to the server host, not to the remote client).
For this command, you can see SELECT Reference.