不爲也 比不能也

This is the final post in a three-part series about Instant Aggregations. Read how it all started in The Tale of Caching and Why It Matters from Simon Willnauer and Shay Banon and the meaty middle detailed in The Great Query Refactoring: Thou Shalt Only Parse Once. Enjoy the trilogy! 이 게시물은 Instant Aggregations에 대한 시리즈 중 마지막 게시물이다. The Tale of Caching and Why It Matters에서 Simon Willnauer와 Shay B..

This is the second post in a three-part series about Instant Aggregations. Read how it all started in The Tale of Caching and Why It Matters from Simon Willnauer and Shay Banon and how the magnificent end to the story in Instant Aggregations: Rewriting Queries for Fun and Profit. Enjoy the trilogy!이 게시물은 Instant Aggregation에 대한 시리즈 중 두번째 게시물입니다. Simon Willnauer과 Shay Banon의 The Tale of Caching a..

This is the first post in a three-part series about Instant Aggregations. See how the story progresses in The Great Query Refactoring: Thou Shalt Only Parse Once and wraps up in Instant Aggregations: Rewriting Queries for Fun and Profit. Enjoy the trilogy! 이 게시물은 Instant Aggregation에 대한 시리즈 중 첫번째 게시물입니다. The Great Query Refactoring: Thou Shalt Only Parse Once에서 어떻게 진행되는지 확인하고 Instant Aggregation..

A keen observer will notice that all the queries so far in this book have operated on whole terms. To match something, the smallest unit had to be a single term. You can find only terms that exist in the inverted index.눈썰미가 좋은 독자라면, 지금까지 이 책의 모든 query는 전체 단어를 기준으로 동작된다는 것을 알아차렸을 것이다. 어떤 것과 일치한다는 것은, 가장 작은 단위가 단일 단어이어야 한다. inverted index에 존재하는 단어만을 검색할 수 있다.But what happens if you want to match p..

Leaving postcodes behind, let’s take a look at how prefix matching can help with full-text queries.Users have become accustomed to seeing search results before they have finished typing their query—so-called instant search, or search-as-you-type. Not only do users receive their search results in less time, but we can guide them toward results that actually exist in our index.우편번호를 뒤로 하고, prefix ..