Deeply participated in opengauss Developer Day 2022, cloud and enmo showed their style in a number of activities

On the main forum ,CCF Chen Yueguo, Secretary General of the Database Committee, delivered a speech ,openGauss Changjiang Dayong, director of the community council, made a speech entitled 《 Create the future Enjoy extraordinary , Build an open source database root community 》 Keynote speech of , It's all about openGauss Since the second anniversary of open source, we have achieved fruitful results in all aspects . And then , Jiang Dayong and Hu zhengce, Secretary General of the community council, jointly witnessed the collective release of seven database manufacturers based on openGauss 3.0 Commercial distribution of . Cloud and enmo's database products MogDB v3.0 In this year 6 month 15 The inaugural meeting of “ Huawei partners and developers conference ” Officially released on . today ,MogDB v3.0 Become the focus of the game again , Not only does it integrate openGauss 3.0 All characteristics , It integrates many innovative features of cloud and enmo , Continue to help users achieve a secure and easy-to-use enterprise data environment .

7 month 15 On the afternoon of Sunday , Yun and enmo held “ Database kernel SQL Engine Sub Forum ”. Nearly 100 database technology experts from all walks of life 、 developer 、 Industry customers 、 Ecological partners get together , On how to build open source SQL engine , Master database root technology to share and discuss .

Zhang Wanchuan, head of Yunhe enmo database core R & D team, delivered a speech as the producer of this forum . First of all, he welcomed and thanked all the guests for taking the time to attend this event , And then SQL The theme of engine expresses its own views . Zhang Wanchuan emphasized SQL Engine is one of the core modules of database , Its ability will greatly affect the efficiency of the database . however , Domestic database in SQL The ability of the engine is relatively lacking , We need to learn from traditional commercial databases , And continue to use new technology for innovation .

Huawei Gauss Laboratory SQL Engine technologist 、openGauss Maintainer、Apache Doris PMC Chen Hao brings 《openGauss SQL The evolution direction of the engine 》 Speech . He introduced AP and TP In two scenarios openGauss SQL Evolution of engine . stay AP scenario ,openGauss SQL The key technology of engine , Including multiple nodes / Multithreaded parallel execution 、 Vectorization execution engine and compilation execution . stay TP scenario , The lightweight optimizer and lightweight actuator are SQL Engine a key . that , future SQL What is the engine like ？ Chen Hao said , The next generation SQL The engine will also have the ability to handle TP as well as AP Class query and mixed load capability .

Cloud and enmo database kernel R & D Engineer Hou Zongtian shared MogDB 3.0 One of the latest features of - Dynamic zone clipping . stay 《 Divide and rule ,MogDB Dynamic partition clipping for partition optimization 》 In his speech , Hou Zongtian pointed out that partition pruning is a commonly used performance optimization method in partition tables , Before scanning the partition table, according to the constraints containing the partition key , Extract the partition to be scanned , To avoid scanning all partitions , Reduce IO request . Generally, partition constraints are constants or definite expressions , The optimizer can cut out unnecessary partitions in the query planning stage , This clipping method is called static partition clipping . But in many scenarios , In the query planning stage , Partition constraints are not constants or definite expressions , It usually contains internal or external parameters , Need to be in SQL Tailoring during execution , It is often called dynamic clipping .MogDB 3.0 Realize dynamic partition clipping , It greatly improves the query performance of partitioned tables in specific scenarios .

As a representative of academia , Vice president of School of computer science, Nankai University 、 Vice president of the school of Cyberspace Security 、 Liu Zheli, Secretary General of the big data security and privacy computing special committee of the Chinese information society It brings you 《 Research progress of practical Reservation Order encryption 》 The share of . Although Professor Liu failed to come to Beijing because of the epidemic , But he Explain to you through online video Keep the basic concept of sequential encryption , And further share two schemes of frequency hiding sequence preserving encryption design and sequence revealing encryption design . The full dry goods were applauded by the audience .

Wangchunling, the kernel R & D Engineer of Yunhe enmo database, brought a paper entitled 《MogDB Design and implementation of autonomous asynchronous transaction submission in 》 The share of .TP The scenario has a high demand for the performance of high concurrency transaction processing . However MogDB During the transaction submission process, you need to synchronously wait for the log to drop , During this period worker The thread is idle , It cannot be used to deal with other affairs . although MogDB There is “synchronous_commit=off” The implementation of the , However, this implementation cannot guarantee the integrity of data after the database crashes in the middle .MogDB The implementation of autonomous asynchronous transaction submission can realize the real transaction asynchronous submission , On the premise of ensuring the reliability of the database, make full use of CPU, Improve transaction processing capabilities in high concurrency scenarios .

Yang Hao, R & D Engineer of Yunhe enmo database kernel, introduced operator sampling in detail . The titled 《 temperament ,MogDB SQL Operator sampling of operational observation 》 In his speech , Yang Hao pointed out , At present openGauss In the sampling framework of , Missing sampling for execution operator , This leads to the fact that if a statement is found to be executed for a long time and cannot be ended , Staff cannot observe the execution of each operator of the statement in real time in the sampling view .MogDB The database is in the existing openGauss Sampling for execution operators is added on the basis of the sampling framework of , In order to dynamically observe the sampling of each operator during the execution of such slow statements , And use this to analyze the performance .

An important part of the sub Forum , Is the co-founder and co-founder of Yunhe enmo CTO Yang Tingkun officially released 「openGauss Enterprise level technical services 」. The service relies on the cloud and enmo remote service support platform （My Enmo Support, MES）, Designed to reduce the use of enterprise users openGauss Worries of database . Yang Tingkun announced on the spot ： From now on , Cloud and enmo free For enterprise users openGauss Professional technical services .

At the ecological tools sub forum and multimodal sub forum held at the same time that afternoon , Li Cong, general manager of Yunhe enmo's strategic customer architecture department, and Luo Haixiong, a senior technical expert of database, also brought wonderful speeches .

stay 《 Full life cycle heterogeneous database application migration management 》 Sharing , Li Cong from a technical point of view , This paper analyzes the migration and replacement between heterogeneous databases in object 、 Data and SQL Compatible adaptation and the challenges of peripheral tool adaptation . He aims at the specific work scenarios involved in the migration work , The solutions of cloud and enmo are introduced in detail .

Luo Haixiong is 《MogDB Column storage case sharing 》 In the speech , It is pointed out that the application characteristic of a customer system is that there are tens of thousands of parameters in a single entity / attribute , And you need to often read a large number of specific parameter values for calculation , The traditional row storage database can't meet the demand . Column storage is applicable to a large number of the same or similar 、 Adjacent data , Massive data query and aggregation , Data batch loading and other scenarios , It can effectively deal with the challenges encountered in customer business .

At the end of the SIG In the group version planning meeting , Yun and enmo sent 10 More than representatives attended SQL Engine、StorageEngine、Plugin、Infra、CloudNative、OPS and ReleaseManagement Group discussion , by openGauss Plan for the next version , Build a competitive root community .

During the event , The audience listened carefully to the wonderful sharing of the speakers , Yes openGauss The technological achievements and future evolution of have shown great concern and interest . Yunhe enmo booth set up on site , It shows in an all-round way MogDB Innovations and best practices , Become an important window for guests to understand this enterprise database .

openGauss Developer Day 2022 Although the curtain has come to an end , However, the cooperation between cloud and enmo and the community will continue and become closer . Create database root technology , Help enterprise users replace and migrate domestic databases , We have been trying to ！

Slide left and right to see more