Maintenance - ElasticSearch 7.8
Customer(s)
American Airlines
Description
ElasticSearch 7.8 is now supported as datastore for Germain (in lieu of any other currently supported datastore: DB2, MemSQL, MySQL, Oracle, SQLServer). ElasticSearch 7.9 support on its way.
Measures = docvalue_fields[...levels,...values] + _source[...contentFields]
Level constraint = term { field: value }
Timeseries mapping json
Query pattern for
Multi pivot aggregations,
Increased efficiency: one at index time, and one at query time
Disjunctive filters
No difference in the way data is displayed, aggregated, analyzed, searched on Germain dashboard.
Benefits
Performance of Germain is significantly better than relational database and you will find it more obvious once you start reaching ~500 Millions metrics stored DAILY in Germain (yet you can start seeing performance benefit at 100 or 200 Million Germain unit per day for low-end hardware and storage).
Example
~200 Million Germain Units are stored on this environment where this screenshot was taken from and every navigation takes less than a second.