What Drags Down Throughput in GBase 8a Bulk Loading — and Where to Look First
When loading large volumes into a gbase database cluster, stability matters far more than a single peak throughput number. The same 500 GB data set ta…
Programming
⚑ Report a ProblemLatest Programming news from Tech News
All topics
AI
agents
ai
api
architecture
automation
aws
beginners
career
claude
database
devchallenge
devops
javascript
learning
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
rust
security
showdev
tutorial
typescript
webdev
GBase 8a Security Hardening: Permissions, Password Policies, SSL Encryption, and Audit Logs
This guide provides a complete security hardening checklist for a gbase database cluster, covering user privileges, password policies, SSL encryption,…
GBase 8c Distributed Cluster Operations: Troubleshooting Common Failures with Hands‑On Fixes
Node crashes, connection storms, shard anomalies, and resource overloads are the most frequent disruptions in a gbase database cluster. This guide dis…
GBase 8a Data Migration: Standardizing Export, Load, and Verification
When moving data between GBase 8a clusters, stability trumps speed. Failures often stem not from the commands themselves but from inconsistent formatt…
GBase 8c Object Dependency Checks Before Schema Changes
The real challenge in a gbase database schema change isn't writing the DDL — it's uncovering every object that depends on the table before you hit “ex…
GBase 8c DDL Change Risks: Object Dependencies and Troubleshooting
DDL changes in a gbase database often fail not because of syntax errors, but because of hidden object dependencies, long-running transactions, lock ch…
How NULL Values Skew Comparisons, Aggregations, and Deduplication in GBase 8a
NULL in a gbase database doesn't behave like an ordinary value, nor is it simply a blank. It affects comparisons, deduplication, aggregations, and con…
Debugging Slow SQL in GBase 8a: How Execution Plans, Distribution Keys, and Parallelism Go Off the Rails Together
A slow query in a gbase database MPP cluster is rarely just a matter of sloppy SQL. More often, it's the combined effect of data distribution, executi…
GBase 8a Backup and Restore Guide: Full and Incremental Backups with gbackup
GBase 8a stores massive analytical datasets across many nodes. If hardware fails, someone drops a table, or an upgrade goes wrong, a solid backup stra…
When GBase 8a Execution Plans Go Wrong: Mastering Statistics Management
A simple SQL suddenly triggers a full table scan, or a JOIN order looks completely off. Most of the time, the culprit is stale statistics misleading t…
How to Audit Only Critical Operations Like DROP TABLE in GBase 8a
GBase 8a’s audit log can capture virtually every SQL operation. To keep logs lean and focused on security, you can configure a policy that records onl…
Why a Failed Rebalance Returns to STARTING Instead of CANCELED in GBase 8a
When a rebalance operation fails on a table that is in RUNNING state, GBase 8a moves the table back to STARTING — not to CANCELED . This behavior reve…
Inner vs Outer Joins: The Two Fundamental Join Types in SQL
SQL joins fall into two fundamental categories — inner joins and outer joins — while LEFT , RIGHT , and FULL joins are subclasses of the outer join. T…
Interval Partitioning in GBase 8s: Automatic Extension and Lifecycle Management
Interval partitioning automatically creates new partitions when data exceeds the defined range, eliminating the need to manually add partitions. GBase…
Optimizing GBase 8s JDBC with IFX_AUTOFREE
The JDBC driver for GBase 8s provides IFX_AUTOFREE , a parameter that cuts an extra network round trip when closing statements. If your application ex…
GBase 8a QUALIFY Clause: Filtering Window Functions the Smart Way
When you use window functions in SQL, you can't filter their results directly in a WHERE or HAVING clause — that's a well‑known limitation across many…
Expanding a GBase 8a Cluster: Adding a GNode in Practice
As data grows, you'll likely need to add nodes to your existing GBase 8a MPP cluster without downtime. This hands‑on guide walks through the full proc…
GBase 8s: How DELIMIDENT Controls Case Sensitivity
By default, identifiers in GBase 8s are case‑insensitive: uppercase letters are silently treated as lowercase. Setting the environment variable DELIMI…
End-to-End: Hadoop Deployment and Data Loading into GBase 8a
This post walks through setting up a distributed Hadoop cluster from scratch and loading data from HDFS into GBase 8a, GBASE's China-domestically deve…
GBase 8c High Availability with VIP: A Step-by-Step Verification Guide
This walkthrough demonstrates how to deploy a GBase 8c primary‑standby cluster with a virtual IP (VIP) and verify automatic failover. GBase 8c is a Ch…