【GBASE Event】The 1st “GBase Technical Essay Contest” Voting Begins – Cast Your Vote for the Grand Prize Article
Hello everyone! After more than two months, the first “GBase Technical Essay Contest” jointly organized by GBASE and the Modb.pro community has come to a close. Thank you to all authors for your enthusiastic participation, and thank you to our readers for your warm support. We received a total of 65 submissions for this contest, of which 29 articles passed the preliminary review. For details on the shortlisted articles, please see the previous post:《Big News | Announcement of Shortlisted Articles for the First “GBase Technical Essay Contest”》
According to the previously announced selection process, the judging experts selected the best articles based on factors such as article quality, page views, and likes. From all the shortlisted articles, 10 outstanding articles have been selected and reposted to the “GBASE” official account. Starting today, voting will be opened for these 10 outstanding articles. We will award the first prize, second prize, and third prize based on the final vote counts, with rewards of 3000 yuan, 1000 yuan, and 500 yuan JD Card, respectively. (Scroll down to the end of the article to participate in the voting for outstanding blog posts)
Voting Rules
- During the event, each user has only one voting opportunity.
- Users can select one to multiple articles to vote for.
- Voting period: April 8 - April 14.
Below are the ten outstanding blog posts selected for this essay contest. What kind of magic made the judges so impressed? And what well-regarded technical insights do they offer? Let's take a quick look!
Appreciation of Selected Articles
01-Performance Practice of GBase 8a in Complex Query Scenarios (←Click for Full Appreciation)
Author: Huang Yonghou
In order to build sustainable business development, we plan to introduce an MPP database cluster architecture to handle existing and future massive structured data for complex analytical queries, thereby optimizing the resource utilization of the core database platform. The domestic substitution of databases has been a technology hotspot in recent years. Whether from a technical or industry policy perspective, it will have a significant impact on the sustainable future development of our own data platform. By conducting POC prototype verification tests and accumulating technical reserves, we aim to accelerate the domestic replacement of the database platform; we also hope that our work can provide some reference for peers.
02-Written on the Occasion of Two Years After Introducing GBase 8a (←Click for Full Appreciation)
Author: Cai Zhongmou
This article shares the successful experience of a mainstream bank in Macau, transitioning from years of using a traditional DB2 data warehouse to introducing the new GBase 8a MPP data warehouse. Over more than two years of production operations, the domestic GBase 8a database has demonstrated excellent qualities such as powerful performance, good compatibility, stable operation, and low maintenance pressure. The user experience is very good, especially when dealing with complex queries without performance degradation. Its usage scenarios have gradually expanded, providing strong support for daily operations and product innovation.
03-GBase 8s Project O&M Experience Summary (←Click for Full Appreciation)
Author: Yang Kai
Through this article, you can quickly understand the commonly used commands for daily operation and maintenance of GBase 8s: database start/stop, database export/import, database heterogeneous migration, daily database optimization, locks, fault handling, JDBC configuration specifications, how to set character sets, etc. We hope it will be helpful to you.
Author: Wu Yi
A brief description of the steps to install the Docker version of GBase 8a, an introduction to the process of migrating data from MySQL to GBase 8a, and then testing the migrated data by connecting to GBase 8a using Node.js. Drawing on discussions in the GBase 8a forum about connecting to GBase 8a with Node.js, we attempted to implement it using the MySQL approach and found that GBase 8a is compatible with MySQL in JS development, making it easier for JS developers to use and develop with GBase 8a.
05-GBase 8a V95 Cluster Hands-on Drill (←Click for Full Appreciation)
Author: Zhao Zhiguo
Learn by doing with a hands-on drill. From installation to execution, with pictures and truth, step by step guiding you into GBase 8a!
06-GBase 8a SSBM Model Test and Optimization Experiment Report (←Click for Full Appreciation)
Author: Meng Xiangxin
As Heaven’s movement is ever vigorous, so must a gentleman ceaselessly strive along. Self-reliance leads to independence, and only then can the nation and the country truly become strong!
GBase is an excellent representative of domestically developed databases. This article is the author's experiment report on testing and optimizing GBase 8a using the SSBM model during the learning process of GBase. We hope more people will understand, learn, and use domestic databases. Let us jointly contribute to the development and strength of domestic database technology!
07-GBase 8a Python Connector Troubleshooting (←Click for Full Appreciation)
Author: Huang Shuchun
Developing ETL with GBase 8a Python Connector is simple and efficient. I have analyzed and summarized the problems encountered in developing ETL programs. Through this article, I will share the analysis process and results with developers of GBase 8a Python Connector, hoping it will be helpful to all GBase 8a data developers.
Author: Yan Shaoan
This article mainly describes the detailed process and issues encountered while building a WordPress blog using GBase 8a as the database, focusing on five specific problems with detailed explanations and appropriate extensions, such as comparing the similarities and differences of time data types among GBase 8a, MySQL, Oracle, and PostgreSQL. We hope it will be beneficial for deepening your understanding of the GBase 8a database.
09-GBase 8a Cluster Hands-on Drill (←Click for Full Appreciation)
Author: Cui Fengyi
Based on the contents of participating in this GBase 8a MPP cluster hands-on drill activity, according to the practical tasks assigned by the instructor from GBASE, this article records in detail the implementation steps for database installation, data loading, and SQL coding, shares the solution ideas, and hopes to bring inspiration or help to everyone.
10-GBase 8a V95 Cluster gcware Common Troubleshooting Manual (←Click for Full Appreciation)
Author: Yuan Qingqian
This article systematically summarizes various environmental and abnormal issues encountered by various sites in using GBase 8a V95 cluster gcware over the past two years, and sorts out practical solutions, enabling field personnel to resolve related issues more quickly and efficiently.
Voting Method: Follow the “GBASE Database” official account on PC or mobile, enter “Vote” in the chat box to receive the voting event post, and participate in the voting at the bottom of the article.
Note: The remaining 19 shortlisted articles that did not make it to the selected round will also receive a 50 yuan JD Card reward.
All rewards will be issued during: April 15, 2022 - April 22, 2022
For details, see: Event | Announcement of the First “GBase Technical Articles” Award Contest