Java EE 8 Design Patterns and Best Practices

Explaining the index table pattern

These days, the volume of data is ever-increasing, and applications need to be able to read a large quantity of data. To make it possible to read data faster, it is common to resort to a data structure or index. In a business environment, data can be organized as a collection of entities that have a primary key. However, we also want to be able to read data using attributes that don't contain an index as a filter in a query. The following diagram illustrates the data organization; if data stays organized, we can use an algorithm that retrieves it faster.

The relational database works with an index and allows us to create one in order to read data faster. Other data stores will not work with an index to read ...