×
Database

How Search Systems with Billions of TBs of Indexes Ensure Real-time Data Quality

In this blog, we'll show you how Youku was able to cope with the traffic spikes during the coronavirus outbreak.

See How Alibaba Cloud Powered Some of China's Best Classrooms in the Cloud

Learn about the technologies that helped Onion Academy's classes stay online under the immense pressure of huge spikes in traffic during the epidemic in China.

Programming Design of IBMSYS

In this article, we'll discuss the development of Intelligent Business Management System (IBMSYS) by analyzing each of its subsystems.

Design of Intelligent Business Management System (IBMSYS)

In this article, we'll take a closer look into IBMSYS and discuss how it can help you establish a more efficient yet simple system for all your needs.

Three Reasons Why Businesses Should Consider Cloud-Native Databases

In this blog, we'll show you how cloud-native databases can help you accelerate your business through its wide range of features.

How PolarDB Produced Scores for 1.2 Million Online Test Takers in 10 Minutes

Alibaba Cloud PolarDB helped Yuanfudao online education platform, with over 1.2 million test takers and producing scores in just 10 mins.

How to Protect Your Enterprise from Increased Security Threats when Facing Coronavirus Lockdowns

Learn how Alibaba Cloud can help to protect your enterprise from increased security threats during these difficult times.

Learn How Alibaba Engineers Accommodated for Face Masks in their Face Recognition Algorithms

Learn how Alibaba engineers accommodated for face masks in their face recognition algorithms in response to coronavirus outbreak.

Reducing the Cost of Enterprise Database IT amid the Coronavirus Outbreak

In this blog, we'll show you how you can save on your database expenses with ApsaraDB RDS for PostgreSQL to cope with the recent COVID-19 outbreak.

Ant Financial Unveils SaaS Version of Its Database Solution Oceanbase

Ant Financial recently launched the Software-as-a-Service (SaaS) version of its database technology product, OceanBase.

Real-Time Conversion in Data Loading - Triggers and Rules

This article explains how PostgreSQL supports triggers and rules to effectively convert string data into the types supported by PostgreSQL in real-time.

How to Optimize Duplicate Data Cleansing in PostgreSQL

This article evaluates different duplicate data cleansing techniques while considering several technical database issues in PostgreSQL.

How to Retrieve and Deduplicate Similar Text in PostgreSQL

This article attempts to answer a series of questions raised in the Alibaba Cloud Community's Q&A section regarding the retrieval and deduplication of similar text in PostgreSQL.

PostgreSQL Data Deduplication Methods

This article describes the different PostgreSQL methods to remove duplicates and suggests how to choose the method that works best for users.

PostgreSQL Data Rotate Method Introduction: Overwrite History Data by Time

This article explains the method to rotate data using partition tables in polling mode while using truncate to clear partitions.

How Does PostgreSQL Implement Batch Update, Deletion, and Insertion?

This article addresses all the frequently asked questions pertaining to batch update, insertion, and deletion in PostgreSQL.

How Does PostgreSQL Implement Upsert to Automatically Separate New Data from Old Data

This article explains the method that PostgreSQL uses to implement upsert for automatically separating new data from old data.

Data Sampling in PostgreSQL

This article gives a quick walkthrough on how to perform data sampling in PostgreSQL using a comprehensive example.

Use of the PostgreSQL Upsert (INSERT ON CONFLICT DO) Function

This article introduces a new function of PostgreSQL 9.5 called Upsert (INSERT ON CONFLICT DO).

Automatic Cleaning and Scheduling of PostgreSQL Rotate Tables - Constraints and Triggers

This article demonstrates how to use constraints and triggers for automatic cleaning and scheduling of PostgreSQL tables.