OLAP database query optimizer and performance

created: 2024-02-23 | updated: 2024-06-29

OLAP database query optimizer and performance


OLAP workloads

Online analytical processing, or OLAP, is an approach to answer multi-dimensional analytical queries swiftly in computing.

https://en.wikipedia.org/wiki/Online_analytical_processing


OLAP VS. OLTP: THE DIFFERENCES

OLAP is used for complex data analysis, while OLTP is used for real-time processing of online transactions at scale.

https://www.snowflake.com/guides/olap-vs-oltp/


Luft: OLAP database for Airbridge

https://engineering.ab180.co/stories/introducing-luft


Airbridge dashboard demo

Let’s take a look at what you’d do if you implemented.

Newsfeed 2023

created: 2023-01-05 | updated: 2023-12-23

December 2023

The Big Cloud Exit FAQ by @dhh

This isn’t some archaic knowledge that’s been lost to the ages. We might not know exactly how the pyramids were built, but we do still know how to connect a Linux machine to the internet.

I think many of us are forgetting this.

“buy the baseline, rent the spike”

100% agree.

Constant Propagation in Compiler Design

In simpler words, we can say that if some value is assigned a known constant, than we can simply replace the that value by constant.

Career

created: 2023-01-29 | updated: 2023-06-24

Reflections on Career Advancement: Understanding the Power of Relationships and Reputation

  1. Anyone can become a Director by working hard enough. To become a Sr. Director, someone needs to push you. To become a VP, several people need to pull for you.
  2. Check job postings weekly and ensure you have at least one job interview a year.
  3. Almost no one applying for a certain position lacks the qualifications. People who can hardly go wrong even if chosen with eyes closed are the ones who get the interview opportunities. Eventually, those slightly more familiar tend to get selected.
  4. In the same context, office politics is merely about forming relationships, and there’s no need to view it negatively.
  5. There’s no great significance in judging the right and wrong of office politics. Even if you don’t participate, everyone else does.
  6. Working hard and performing well is a given; promotion relies on relationships and reputation.

Link: https://twitter.com/shinhh/status/1671678952551718912

Go 성능 최적화 팁

created: 2023-06-04 | updated: 2023-06-10
#go

Go 성능 최적화 팁

박재완


Airbridge 와 Luft

  • Airbridge
    • 합리적인 비용의 올인원 모바일 마케팅 솔루션
  • Luft
    • Airbridge 에서 유저행동 분석을 위해 사용하는 OLAP 데이터베이스
    • Ziegel 을 스토리지 엔진으로 사용
    • Go 로 작성