Exclusive interview of guests at | 2020 PostgreSQL Asia Conference: Zhou Xiang

Time:2020-11-15

The Organizing Committee of PostgreSQL Asia Conference 2020 specially launched alicloud databaseGuest series online interviewIn the second phase, we invited Zhou Xiang, a senior product expert of Alibaba cloud database. He will bring “Alibaba cloud PostgreSQL ecological cloud native database products” in English during 09:40-10:20 of Alibaba cloud database training session on November 17.

Zhou Xiang, senior product expert of Alibaba cloud. Graduated with a master’s degree in 2008, he joined the DB2 for Z / OS R & D team of IBM China R & D center, engaged in the research and development of database engine related to DB2 for Z / OS; started to engage in the research and development of IBM big data product biginsights in 2012. He joined Alibaba at the end of 2013 and is one of the core R & D members of Alibaba cloud’s OLAP analytical database analyticdb and data Lake analytics. Currently, he is the international product manager of Alibaba cloud database team, responsible for the strategy of all database products facing the international market and related work of go to market. So far, we have owned and applied for more than 30 technological invention patents, mainly involving relational database, big data, distributed computing, cloud computing and other fields.

Zhou Xiang, senior product expert of alicloud database

Q1: when did you first contact PostgreSQL? How to embark on the road of product development?
Zhou XiangHello, I’m Zhou Xiang, senior product expert of alicloud database. The first time I came into contact with PostgreSQL was when I was a student. It should be a design topic of telecom system oriented to SOA architecture. During the implementation of the project, open-source database was needed to store basic business data. At that time, I made a comparison and selection between MySQL and PostgreSQL. The reason is relatively simple. It was written by Berkeley and developed. The code is excellent, so I choose it PostgreSQL. During the postgraduate internship, I was interned in the Chinese R & D team of IBM DB2 for Z / OS. After graduation, I joined this department and began to start with some database optimization tools to participate in the product kernel development of DB2.

Q2: how do you solve the difficulties in product planning or product development? What do you feel most proud (interesting)?
Zhou Xiang: when I work for a period of time and have accumulated a certain amount of experience in a field, when I encounter difficulties, I still have to think independently. There are problems with architecture design and code bugs. After independent thinking and analysis, it is also necessary to fully discuss with the project and team members. When it comes to architecture design, it is particularly important to fully discuss it. Gather the wisdom of everyone to avoid some architectural defects and potential holes; when it comes to some difficult code bugs, my experience is that we need to be more independent and in-depth debug root cause.

The most interesting thing for me is that in a very important project four years ago, one week before the business went online, due to new business queries and load online, our database system modules began to frequently core dump. Under great business pressure, I got experts from the group in the field of JVM (our database system is implemented by Java) to analyze and locate the address overlap problem caused by unsafe API operation. But what is the specific reason and which code causes the address overlap? This problem has been tangled for two days. Finally, all the Java related unsafe operation codes are pulled out and analyzed in the system code. It is found that in the Java 6 era, we have developed an open source Java 8 In the beta version, the use of the stream feature code in advance is related to. Different variable lengths lead to address overlap. It was found that this problem was two days before the business was launched. After the modification, they were frightened and tested on the last day before the business was launched, and the problems were found and solved. It’s interesting to think about the stress situation and the feeling after solving the problem.

Q3: how do you think database products will have more vitality in the future?
Zhou XiangDatabase has been an indispensable infrastructure of business system, especially in the cloud era. Database system itself is a very complex technology implementation and product, but its role and positioning is simple and clear. I think that the future of the database in the cloud is to make full use of the cloud’s ability, and make it as easy to use as water and electricity. There is almost no threshold for the use of water and electricity. However, if you only look at the database, in fact, the threshold for getting started and getting started is very high, and more integration and connection with business applications can make the database more widely used. At the same time, efficient collaboration with business and application can also make the promotion and application of database more rapid and smooth.

Q4: what’s your opinion on the ecological development of products? Do you have any plans for building product ecology in the near future?
Zhou XiangDatabase products still adhere to the road of integration, and do well enough for the integration and compatibility of upper business and application software, such as mutual certification of enterprise software such as ERP and CRM, integration and compatibility of database ecological tools, mutual authentication of migration, backup and recovery, ETL, Bi software, etc. Only when these foundations are integrated well, it means more market application space and lower threshold. We will also firmly go down this road.

Alibaba cloud database special session of 2020 PostgreSQL Asia Conference
On November 17, 2020, from morning to evening, eight lecturers from the original factory will share their dry goods and live broadcast in Chinese online PostgresConf.CN & PGConf.Asia Alicloud database special channel of 2020 conference, looking forward to your joining!
Exclusive interview of guests at | 2020 PostgreSQL Asia Conference: Zhou Xiang

About alicloud database
Alibaba cloud intelligent database products division carries all the online data and data services of Alibaba cloud and Alibaba group. It provides a full stack of database products and services from online transaction processing to online analysis and processing, and supports flexible deployment in various environments of public cloud and private cloud, and full coverage of individual developers, small and medium-sized enterprises and global large-scale enterprises. Alibaba cloud database service is the most reliable and efficient choice for both individual and enterprise business requirements. With the advent of the data age, Alibaba cloud database products are redesigned and implemented based on the architecture of cloud computing and data center. It is a global leader in database storage engine, cloud native technology, analysis engine, distributed processing, FPGA / GPU hardware acceleration, intelligent database, intelligent management and control platform, security database and other aspects. It is a comprehensive cloud product and service group Together, we have provided rich database product solutions and industry experience for Alibaba cloud customers and Alibaba Group’s diversified business.

At present, after more than ten years of application practice and technical iteration, Alibaba cloud has the most powerful and rich cloud database product family in China, covering five major sectors: relational database, non relational database, analytical database, database ecological tools and cloud database exclusive cluster, which can meet different database application development needs of users and solve the cloud of enterprise core business The key challenges of the project.

Core products
The core products include: self-developed cloud native relational database polardb, cloud native data warehouse analytical dB and cloud native data Lake analysis DLA, cloud native multi-mode database lindorm, cloud database exclusive cluster MyBase and relational database service RDS, non relational database service NoSQL products HBase, redis, mongodb, graphdb, and database ecological tools DTS / DMS / DBS / Adam Operation and maintenance platform DAS, etc.

Among them, polardb is the first cloud native relational database in China, which adopts the separation of storage and computing and the integrated design of software and hardware to meet the needs of large-scale application scenarios.

PostgreSQL Alibaba cloud database special session – nail communication group
Exclusive interview of guests at | 2020 PostgreSQL Asia Conference: Zhou Xiang

about PostgresConf.CN&PGConf . asia2020 Conference
As the largest and most famous PG series conference in the world, pgconf is running in all regions of the world from New York to Moscow, from Rio de Janeiro to Johannesburg. The largest PG technology event in Asia – PGConf.Asia The conference will be held in China for the first time in November this year. As the host, PG branch of China Open Source Software Alliance hosted the conference, which was broadcast to the world through motianlun community. This conference will gather Chinese PG strength, major PG contributors and application enterprises in Asia to jointly build the largest PG ecological conference in Asia.

current PGConf.Asia The conference will PostgresConf.CN The conference was jointly held in China. PostgresConf.CN The China conference is also a global formal conference listed in the postgresconf conference sequence, and also the largest and highest specification PG ecological conference in China. Since 2017, it has been held for three consecutive sessions. This year’s conference will continue to be based on the domestic PG industry, providing the most clear and unique perspective for the audience.
Exclusive interview of guests at | 2020 PostgreSQL Asia Conference: Zhou Xiang

Special Thanks
Conference sponsor
Exclusive interview of guests at | 2020 PostgreSQL Asia Conference: Zhou Xiang

Partner of live broadcast platform
Exclusive interview of guests at | 2020 PostgreSQL Asia Conference: Zhou Xiang

Entry point:https://www.modb.pro/event/220

For more wonderful content, please pay attention to the following platforms and websites:

Official account of China PostgreSQL branch (technical articles and technical activities):
PostgreSQL branch of Open Source Software Alliance

China PostgreSQL technical Q & a community:
www.pgfans.cn

Official website of China PostgreSQL branch:
www.postgresqlchina.com