Part 1 of the series of posts which talk about engineering design decisions to make high cardinality work in time-series databases.

According to the World Bank, two-thirds of adults around the globe currently make or receive digital payments. Businesses have come to expect quick, reliable processing, and one company at the forefront of that is Worldline. The global payment service provider (PSP) is a leading payment processor and payment provider in Europe, with about 3.4 billion e-commerce transactions made in 2022.

Indexes serve as the key to unlocking the immense potential of relational databases, enabling swift and optimized data access. They act as a roadmap, allowing the database engine to locate specific data quickly, ultimately enhancing query performance. Understanding the nuances of indexes and employing the appropriate indexing techniques can significantly impact the efficiency of a database system.