[GBASE Event] Voting Begins for the 1st GBase Technical Article Contest — Cast Your Vote for the Grand Prize Winner!
Hello everyone! The first GBase Technical Article Contest, jointly organized by GBase and the Modb community, has come to an end after more than two months. We truly appreciate all the authors’ enthusiastic participation and our readers’ warm support. We received a total of 65 submissions, and 29 articles passed the initial review. For details on the shortlisted entries, please see our earlier post: Heavyweight | Announcing the Shortlisted Articles of the 1st GBase Technical Article Contest
According to the previously announced selection process, our expert judges evaluated the articles based on quality, reads, likes, and other dimensions. From all shortlisted entries, the judges have selected 10 outstanding articles, which have been reposted on the “GBase” WeChat official account. Starting today, we are launching a public vote for these 10 articles. Based on the final vote counts, we will select the first‑prize, second‑prize, and third‑prize winners, who will receive JD Cards worth RMB 3,000, RMB 1,000, and RMB 500 respectively. (Scroll down to the end of this article to vote for your favorite blog posts)
Voting Rules
- Each user may vote only once during the voting period.
- You can vote for one or more articles.
- The voting period runs from April 8 to April 14.
Below are the ten outstanding blog posts selected for this contest. What made them so impressive to the judges? What technical insights do they offer? Let’s take a look!
Featured Articles Showcase
01 – Performance Practice of GBase 8a in Complex Query Scenarios (← Click for full article)
Author: Huang Yonghou
To support sustainable business growth, we plan to introduce an MPP database cluster architecture that can handle massive structured data for complex analytical queries both now and in the future, thereby optimizing resource utilization on our core database platform. The shift toward China-developed databases has been a major tech trend in recent years. From both a technical and a policy perspective, it will significantly influence the future sustainable development of our data platform. By conducting POC validation tests and building technical reserves, we accelerate the adoption of China-developed database platforms. We also hope our experience can serve as a useful reference for peers in the industry.
02 – Two Years After Adopting GBase 8a (← Click for full article)
Author: Cai Zhongmou
This article shares the successful experience of a major bank in Macau that transitioned from a legacy DB2-based data warehouse to the new GBase 8a MPP data warehouse. Over more than two years of production operation, the GBase 8a China-developed database has demonstrated excellent performance, strong compatibility, stability, and minimal operational burden. Users have had a very positive experience. Notably, even complex queries never falter, and usage scenarios have steadily expanded, providing robust support for daily operations and product innovation.
03 – GBase 8s Project O&M Experience Summary (← Click for full article)
Author: Yang Kai
Through this article you can quickly learn the common commands for daily O&M of GBase 8s: database start/stop, data export/import, heterogeneous database migration, daily database optimization, locks, fault handling, JDBC configuration specifications, character set settings, and more. We hope you find it helpful.
Author: Wu Yi
This article briefly describes the steps to install the Docker edition of GBase 8a, explains the process of migrating data from MySQL to GBase 8a, and tests the migrated data through a Node.js connection. Inspired by a discussion on the GBase 8a forum about connecting Node.js to GBase 8a, we tried implementing it in a similar way to MySQL 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 Practice (← Click for full article)
Author: Zhao Zhiguo
Get hands-on and practice through real-world exercises, from installation to execution, with images and step-by-step guidance to get you started with GBase 8a!
06 – GBase 8a SSBM Model Test and Optimization Experiment Report (← Click for full article)
Author: Meng Xiangxin
As heaven maintains its vigor through movement, a gentleman should constantly strive for self-improvement. Only self-reliance keeps us free from control and truly strengthens our nation and country!
GBase is an outstanding representative of China-developed databases. This article is an experiment report on testing and optimizing GBase 8a using the SSBM model during my own GBase learning journey. I hope more people will get to know, learn, and use China-developed databases, and together we can support the advancement and strength of our indigenous database technology!
07 – Troubleshooting Tips for GBase 8a Python Connector (← Click for full article)
Author: Huang Shuchun
Using the GBase 8a Python Connector for ETL development is simple and efficient. I analyzed and summarized the issues I encountered while developing ETL programs and share my analysis and findings in this article for fellow GBase 8a Python Connector developers, hoping it will be helpful to all GBase 8a data developers.
08 – Issues Encountered When Building a Blog System Based on GBase 8a (← Click for full article)
Author: Yan Shaoan
This article details the process of building a WordPress blog with GBase 8a as the database and the problems encountered along the way. It focuses on five key issues, with appropriate extensions, such as comparing the similarities and differences of date/time data types between GBase 8a, MySQL, Oracle, and PostgreSQL. It aims to help you gain a deeper understanding of the GBase 8a database.
09 – GBase 8a Cluster Hands-On Practice (← Click for full article)
Author: Cui Fengyi
Based on a hands-on practice activity for the GBase 8a MPP cluster using exercises designed by GBase instructors, this article records in detail the implementation steps for database installation, data loading, and SQL coding, sharing the thought process behind the solutions in the hope of sparking ideas or providing help.
10 – Common Gcware Troubleshooting Guide for GBase 8a V95 Cluster (← Click for full article)
Author: Yuan Qingqian
This article systematically summarizes the various environmental and anomaly issues encountered with gcware in the GBase 8a V95 cluster at various sites over the past two years, and outlines practical solutions so that on-site personnel can resolve related problems more quickly and efficiently.
How to Vote: On your PC or mobile, follow the “GBASE Database” WeChat official account, type “Vote” in the chat box to receive the voting campaign post, and vote at the bottom of the article.
Note: The 19 shortlisted articles that did not advance to the final voting round will each receive a JD Card worth RMB 50.
All rewards will be distributed between April 15, 2022 and April 22, 2022.
For details, see: Event | Announcement of the 1st GBase Technical Article Contest with Prizes