×
Database

Setting up the Stage for Enterprise-Grade Deployment on Alibaba Cloud

This article shows you how you can set up an enterprise grade deployment for managing thousands of users while maintaining a centralized governance on the cloud.

Real-time SQL Server Migration to Alibaba Cloud ApsaraDB RDS for SQL Server

In this tutorial, we'll show you how to migrate an on-premises Microsoft SQL Server to Alibaba Cloud ApsaraDB for SQL Server with minimal downtime.

BDS Supports Cassandra for Quick Data Migration

This article describes how BDS supports Cassandra to perform database migration.

PostgreSQL: ST_Value Function Usage Examples to Optimize Raster Data in a Database

In this article, we'll discuss optimizing raster data in PostgreSQL databases using the ST_Value function and describe various optimization methods.

Special for Indonesia: The Top 10 New Products from Alibaba Cloud

Here are the top 10 new products that we introduced to Indonesian region in 2020.

PostgreSQL Opens the Door to Space and Time

This article discusses spatiotemporal data and its wide usage in multiple domains, such as indoor positioning, pilotless driving, and scientific research.

PostgreSQL 3D City Applications

In this article, the author explains various features in PostgreSQL that help implement 3D city applications.

What's New in Alibaba Cloud Database?

Find out the latest updates and innovations in Alibaba Cloud Database, and learn how they can help you drive the cloud digital transformation of your business.

PostgreSQL Real-time Position Tracking + Trace Analysis System Practices: Processing 100 Billion Traces/Day with a Single Server

In this article, the author discusses PostgreSQL-based real-time position tracking and trace analysis in respect of express delivery companies.

PostgreSQL-enabled Electronic Fences: Application Scenarios and Performance

In this article, the author discusses electronic fence technology based on PostgreSQL and describes its applications in various common business scenarios.

PostgreSQL Best Practices: Overcoming Ride-Hailing Conflicts Arising in a Trip Dispatch System

In this article, the author discusses optimizing the PostgreSQL database to overcome ride-hailing conflicts in crowded areas during peak hours.

Use Geometry Split to Optimize PostgreSQL Performance in GiST Index-based Polygon Search

In this article, the author discusses geometry split in PostgreSQL and describes how to use it to optimize performance in GiST index-based polygon search with example code.

Optimize Spatial Searches in PostgreSQL Using ST_Contains and ST_Within

This article discusses optimizing spatial search performance in PostgreSQL using ST_Contains and ST_Within to address the I/O amplification problem and CPU usage.

Spatial Search: Geometry and GiST Combination Outperforms Geohash and B-tree

In this article, we explore spatial search performance and describe when to use Geohash, geometry, and geography data types along with indexes such as GiST and B-tree.

Use BRIN to Discover Target Customers from Massive E-Commerce Advertising Data in Milliseconds

This article discusses discovering target customers using BRIN from massive e-commerce advertising data using PostgreSQL and AnalyticDB.

Importing Data from Google Earth to PostgreSQL

This article discusses how to utilize PostgreSQL to import crucial data and geometry segments from Google Earth and convert KML files into ESRI format files.

Comparison Between PostgreSQL 10 and Greenplum in Spatiotemporal Object Selection and Data Pivoting

In this article, the author discusses spatiotemporal object selection and data pivoting and extensively compares PostgreSQL 10 and Greenplum in this respect with example code.

PostgreSQL: Real-time User Positioning and Selection Based on Massive Amounts of Data

In this article, the author discusses real-time user positioning and selection using PostgreSQL. The author also discusses various design methods and optimization for performance improvements.

Database Design and Implementation of a Ride Hailing Dispatch System

This article discusses the database design of an order dispatch system for ride hailing apps by using DiDi as an example.

How to Install and Configure the Windows Server Failover Clustering on an ECS Instance

In this tutorial, we will show you how to prepare your remote cloud and deploy Windows Server Failover Clustering (WSFC) on an Alibaba Cloud Elastic Compute Service (ECS) Instance.