×
Database

Getting up Your Real-Time Key-Value Store with RedixDB

In this article, you will be learning how you can set up RedixDB on an Alibaba Cloud ECS instance as well as learn about some of the basic commands and features of RedixDB.

Data Encryption for Database Backup with Data Backup Service

In this post, we will explore the importance of data encryption for backups, and introduce the services that Alibaba Cloud provides that allow us to do so.

Streaming Statistics in PostgreSQL with INSERT ON CONFLICT

In this blog, we'll show you how you can use the PostgreSQL INSERT ON CONFLICT syntax and the RULE and TRIGGER functions to implement real-time data statistics.

PostgreSQL Swinging Door Trending (SDT) Algorithm for Stream Computing Applications

This article uses Swinging Door Trending (SDT) as an example to provide a design suggestion and demo for this type of stream computing in PostgreSQL.

PipelineDB Sharding Cluster for Distributed Stream Computing

In this article, we'll introduce the PipelineDB cluster architecture and discuss how it maintains high availability for read/write operations amid shard failures.

Probabilistic Data Structures and Algorithms in PipelineDB

This article walks you through five different probabilistic data types as well as the related data structures and algorithms in Pipeline and looks these them in detail.

Conducting a Pivotal Analysis of Multiple Streams for Both Human and Robot Service Channels

This article looks at the pivotal analysis of multiple streams-with both human and robot service channels-and shows how you can conduct this kind of pivotal analysis.

In-Depth Comparison between MaxCompute and MPP Query Engines

In this blog, Senior Technical Expert Yuan Haisheng explained the differences and similarities between MaxCompute and Massively Parallel Processing (MPP) query engines.

How MaxCompute Helped YCLOSET Build Smart O&M Tools

In this blog, Cheng Yiding, CTO of YCLOSET, describes the data architecture of YCLOSET and explained the steps needed to build smart O&M tools based on MaxCompute.

Create a Real-Time Data Exchange Platform with BottledWater-pg and Confluent

In this article, we will look at how you can use BottledWater-pg and Confluent to create a real-time data exchange platform.

Streaming, Lambda, and Triggered Modes Compared: At Look at How You Can Process Data in Real Time

This article looks at the advantages and disadvantages of using stream computing, Lambda, and synchronous real-time (or triggered) data analysis.

Row-level Security Solutions for MSSQL

In this tutorial, you will learn how to implement data access control solutions using the new Row Level Security feature introduced by SQL Server 2016.

Mask Privacy Data Columns in MSSQL

In this tutorial, you will learn how to use the dynamic data masking feature of SQL Server 2016 to mask privacy data.

Enable SSL Encryption for an MSSQL Network Transport Layer

In this tutorial, you will learn how to enable SSL encryption for the network transport layer of your SQL Server.

Enable Always Encrypted for Your MSSQL Databases

In this tutorial, you will learn how to enable Always Encrypted to ensure that the data stored in your SQL databases on the cloud is continually encrypted.

Database Backup Encryption in MSSQL

In this tutorial, you have learned how to use certificates to implement database backup encryption in SQL Server 2014 and later.

Using the Built-In and Custom Ranking Algorithms of PostgreSQL for Full-Text Searches

In this article, we will explore how you can refine ranking algorithms for PostgreSQL through using tsvector or a multi-dimensional array.

The RUM index and Full-Text Search Using PostgreSQL

The recent update of PostgreSQL 9.6 has made many enhancements in full-text search and has also brought us RUM plug-in support.

Using PostgreSQL to Create an Efficient Search Engine

This article goes over how you can use PostgreSQL to create an efficient search engine for full-text searches and other query types including fuzzy and similarity queries.