Inverted Indices in ClickHouse

ClickHouse’s MergeTree table engine uses sparse indexing for its primary index and data-skipping indices as a secondary index. These indices are used to speed up the data retrieval from the disk. More recently, ClickHouse has introduced inverted indices as an experimental feature. This is to speed up the text searching on String columns and provide […]

How do Data Scientists use Black-Scholes model on ClickHouse?

The Black-Scholes model is a mathematical formula used to estimate the price of European-style options, which are financial contracts that give the holder the right, but not the obligation, to buy or sell an underlying asset at a predetermined price within a specified time period. The formula was developed by Fischer Black and Myron Scholes […]