Archives: 2020 | Liang Tan's Blog

Never really desperate, only the lost of the soul.

Liang Tan

2020

2020- 11 - 02: 349. Intersection of Two ArraysProblem link. Method 1: HashTableUsing two HashSet. put one array numbers

2020-11-01 algorithm

Java Python Data Structure Algorithm Design

1.Introduction.Reservoir Sampling is an online algorithm designed for picking up small amount of sample with uniform pro

2020-05-14 Liang Tan

Python Big Data sampling algorithm

A frequently retrieving task is to find the nearest candidate to the target candidate based on speific feature. 1. Naive

2020-05-14 Liang Tan

PostGIS PostgreSQL R-tree SQL Data Structure and algorithm

1. Introduction:This post will go through some basic concepts and examples. All the experiments are running on the Ubant

2020-03-17 Liang Tan

SQL, PostgreSQL, Time-series Database, spatial databases, data storage

1. Problem Description:You are given serveral tables as follows: Table: Movies +---------------+---------+ | Column N

2020-03-10 Liang Tan

SQL