Skip to content

Instantly share code, notes, and snippets.

View euiyulsong's full-sized avatar
🌴
On vacation

EuiYul Song euiyulsong

🌴
On vacation
View GitHub Profile
@euiyulsong
euiyulsong / rank_metrics.py
Created November 29, 2023 08:09 — forked from bwhite/rank_metrics.py
Ranking Metrics
"""Information Retrieval metrics
Useful Resources:
http://www.cs.utexas.edu/~mooney/ir-course/slides/Evaluation.ppt
http://www.nii.ac.jp/TechReports/05-014E.pdf
http://www.stanford.edu/class/cs276/handouts/EvaluationNew-handout-6-per.pdf
http://hal.archives-ouvertes.fr/docs/00/72/67/60/PDF/07-busa-fekete.pdf
Learning to Rank for Information Retrieval (Tie-Yan Liu)
"""
import numpy as np
import java.io.File; // Import the File class
import java.io.FileInputStream;
import java.io.FileNotFoundException; // Import this class to handle errors
import java.time.format.DateTimeFormatter;
import java.util.Date;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.*;
@euiyulsong
euiyulsong / popular_products.java
Created February 8, 2020 08:39
popular_products.java
public boolean equalsWhenOneCharRemoved(String x, String y) {
int x_len = x.length();
int y_len = y.length();
// return false, if length difference between two words is not 1
if (Math.max(x_len, y_len) - 1 != Math.min(x_len, y_len)) {
return false;
}
EuiYul Song
4236 11th Ave NE, Apt 304, Seattle, WA 98105
[email protected]
(206)407-6517
linkedin.com/in/euiyul-song
github.com/euiyulsong
EDUCATION
University of Washington, Seattle WA -Jun 2018 (Expected)
Major: Bachelor of Science in Informatics: Data Science

1. Describe the four different types of table growth patterns and maintenance concerns associated with each.

  • Continuous growth
    • High volume of INSERT activity
    • Few DELETES
    • Value of data wanes with age
      • Because newest rows are "hottest", good performance occurs if indexing strategy avoids older rows
      • Clustered index on sequential value (PK or timestamp)
    • A query that touches most rows before filter
  • Performance will degrade over time