Community

Blog Events Webinars Tutorials Forum
  1. Blog
  2. Events
  3. Webinars
  4. Tutorials
  5. Forum
Create Account
×
Community Blog Starter Guide | Build a Heat Map Tile App with Alibaba Cloud ECS and PostgreSQL in One Click

Starter Guide | Build a Heat Map Tile App with Alibaba Cloud ECS and PostgreSQL in One Click

This tutorial describes how to build interactive heat map to realize geo visualization and real-time analytics by Ganos on ApsaraDB RDS for PostgreSQL.

This article focuses on one-click deployment through the Alibaba Cloud console. If you need to use scripting for automated deployment, you can refer to this article that uses Terraform.

Overview

A Heat Map Tile is a data visualization tool that represents the spatial distribution of data by overlaying colored tiles on a map. Each tile's color intensity reflects the magnitude or concentration of a particular metric within that area. Heat Map Tiles are often used to visualize geographic data, making it easier to identify patterns, trends, and outliers at a glance.

Billing Instructions

The expenses on Hmt mainly involve：

  1. Selected vCPU and memory specifications
  2. System disk type and capacity
  3. Public network bandwidth
  4. ApsaraDB RDS for PostgreSQL specifications and storage space

Deployment Architecture

1

Parameter Description

Parameter Group Parameter item Illustrate
Service Instance Service Instance Name The name can be up to 64 characters in length, and can contain digits, letters, hyphens (-), and underscores (_). The name must start with a letter.
Region The region where the service instance is deployed.
Instance Charge Type Charge type for the service instance.
ECS instance configuration Instance Type ECS instance type
Instance Password Server login password, Length 8-30, must contain three(Capital letters, lowercase letters, numbers, ()`~!@#$%^&*_-+={}[]:;'<>,.?/ Special symbol in)
network configuration Availability Zone The availability zone where the ECS instance is located
VPC ID VPC where resources are located
VSwitch ID The availability zone of the VSwitch
PostGreSQL configuration Instance specifications The specifications of PostGreSQL instances that can be used in the availability zone
DatabaseName Database Name(default hmt)
AccountName Account Name(default hmt_user)
EngineVersion Engine Version

Permissions Required

Deploying this service instance requires accessing and creating some Alibaba Cloud resources. Therefore, your account needs to include permissions for the following resources.

Note: You only need to add this permission when your account is a RAM account.

Permission policy name Remarks
AliyunECSFullAccess Permission to manage cloud server service (ECS)
AliyunVPCFullAccess Permission to manage private network (VPC)
AliyunROSFullAccess Permission to manage Resource Orchestration Service (ROS)
AliyunComputeNestUserFullAccess Manage user-side permissions for the ComputeNest service (ComputeNest)
AliyunPostGreSQLFullAccess Manage permissions for cloud database services (PostgreSQL)

Deployment Steps

1.  Visit Deployment Link and fill in the deployment parameters as prompted: Deployment link

2

2.  After filling in the deployment link parameters, you can see the corresponding inquiry details. After confirming the parameters, click Next step: Confirm the order.

3

3.  After confirming the completion of the order, agree to the service agreement and click Create Now to enter the deployment phase.

4

4.  Wait for deployment to complete before entering service instance management.

5.  Find Hmt links in the console and copy them to the browser to access them.

5
6

PostgreSQL Database Data Visualization Tutorials ApsaraDB RDS for PostgreSQL Ganos Heat Map Heat Map Tile App
0 1 0
Share on

Read previous post:

Starter Guide | Build BI Dashboard By PostgreSQL, Cube and React in One Click

Read next post:

Starter Guide | Build a RAG Service on Compute Nest with LLM on PAI-EAS and AnalyticDB for PostgreSQL in One Click

ApsaraDB

443 posts | 93 followers

You may also like

Comments

ApsaraDB

443 posts | 93 followers

Related Products

More Posts by ApsaraDB

See All