“G” Memories Renewed: A Year in Review of GBASE Database Tech Insights
Database technology continues to evolve, and “GBASE Tech,” as the technical sharing window of GBASE (General Data Technology), has delivered a wealth of technical insights over the past year. These articles, curated from the GBASE Tech Community, cover multiple dimensions including database feature analysis, migration and adaptation, performance tuning, operations management, and troubleshooting, aiming to help users and partners gain in-depth, hands-on experience with GBase databases.
Now, let’s revisit the exclusive “G” memories that “GBASE Tech” has etched for us in the database world.
Database Migration
Ø Overview of Migration Solutions from Heterogeneous Databases to GBase 8a
Provides an overview of the work involved and key technical points of heterogeneous database migration solutions.
Ø Exploring Several Methods for GBase 8a Database Migration
Introduces conventional methods for full data migration in GBase 8a.
Ø In-Depth Comparison of DB2 and GBase 8s: A New Chapter in Database Migration
Explores the similarities and differences in architecture, variables and parameters, storage limits, etc., and provides specific migration solutions.
Ø Solutions for Migrating from Oracle to GBase 8c
Explains how to ensure data migration without loss or downtime, given the architectural and functional differences between databases.
Database Feature Analysis
Ø Introducing Multi-Shard Concurrent Query in GCDW Cloud-Native Data Warehouse
Introduces the functionality overview and implementation principles of multi-shard concurrent queries in the GCDW cloud-native data warehouse.
Ø Using Transparent Gateway and DBLINK in GBase 8a Cluster
Leveraging DBLINK together with Transparent Gateway services to query remote databases and perform correlated operations between remote and local data.
Ø Hot, Warm, Cold Data Analysis in GBase 8a Based on Audit Logs
Uses audit logs to calculate and analyze data table usage frequency for data cleanup or migration.
Ø Operating System Upgrade Solution for GBase 8a MPP Cluster
Describes precautions and procedures before and after an operating system upgrade.
Ø Tech Sharing | Brief Introduction to RTSync Synchronization Tool
Introduces the installation, deployment, parameter configuration, and usage of the RTSync synchronization tool.
Ø Overview of Network Interaction in GBase 8s SSC Cluster (Part 1)
Introduces the network interaction mechanism of the GBase 8s SSC cluster.
Ø Overview of Network Interaction in GBase 8s SSC Cluster (Part 2)
Analyzes the network throughput performance of the SSC cluster under different business scenarios.
Ø Introduction to the Flashback Function in GBase Database
Introduces the built-in flashback tool onflsbk.sh in the GBase 8s shared-storage database cluster.
Ø GBase 8s Data Compression Strategy
Introduces the data compression features of GBase 8s, including its purpose, methods, commands, and limitations.
Introduces the use of GCI (GBase Client Interface), including environment setup, program compilation, and how to run GCI programs.
Ø Locking and Concurrent Transaction Scheduling in GBase 8s
Explores the transaction processing features of GBase 8s, revealing how it ensures ACID properties and effectively manages concurrent transactions.
Ø Fundamentals and Setup Steps for GBase 8s RHAC Cluster
Introduces the basic principles and setup steps of GBase 8s RHAC (Remote High Availability Cluster).
Ø Rapidly Deploying an SSC Shared-Storage Cluster in GBase 8s High-Availability Architecture
Demonstrates rapid deployment of an SSC shared-storage cluster in a standalone environment.
Ø Analysis and Practice of GBase 8c Transaction State Retention Technology
Introduces the basic concepts and technical implementation of the transaction state retention feature in GBase 8c.
Ø Retrieving Cursor-Type Data with JDBC in GBase 8c
Demonstrates how to retrieve cursor data when accessing GBase 8c databases via JDBC.
Ø Using Trino for Data Migration and Federated Queries Between GBase 8c and Heterogeneous Databases
Shares how Trino, an open-source distributed SQL query engine, enables data migration and federated queries between GBase 8c and heterogeneous databases.
Database Performance Tuning
Ø How to Use GBase 8a Data Loading Functions and Maximize Performance
Explains the loading function module of the GBase 8a cluster in terms of principles and architecture, and provides tuning solutions for loading performance parameters as well as loading and exporting from Kafka data sources.
Ø Performance Testing and Tuning Strategies for GBase 8s
Describes how to conduct performance testing and tuning for GBase 8s databases.
Ø Boosting GBase 8s Performance with GCI Batch Insert
Explores the impact of enabling batch insert on database performance through real-world examples.
Database Operations Management
Ø Emergency Handling for Database Failures: Don't Panic, Here's How (Part 1)
Provides basic troubleshooting ideas for database issues, categorized into hardware failures, operating system failures, and abnormal resource usage.
Ø Emergency Handling for Database Failures: Don't Panic, Here's How (Part 2)
Covers fault types such as database service anomalies, data loss, and other exceptions, and provides basic troubleshooting ideas.
Ø Migrating GBase 8s Database Files to Free Up Space
Describes how to free up storage by migrating chunk files when directory space is exhausted.
These are the “G” memories of “GBASE Tech” for the year. Through deep dives and real-world cases, GBase database products empower database enthusiasts to learn and master them. In the future, we will continue to produce more high-quality technical articles to help the database ecosystem thrive. At the same time, we welcome you to visit the GBASE Tech Community (https://www.gbase.cn/community) to jointly share and accumulate more technical “G” memories of GBase databases.