Event timeline generation

An apparatus for selecting events from an event log which are associated with a defined time interval, comprising:

• a processor;
• and
• a memory, coupled to the processor, which stores instructions causing the processor to
• receive information associated with a timeline to define an interval of interest and a partition size, wherein the received information is indicative of a start time and an end time to define the interval of interest on the timeline,
• divide the timeline into a plurality of segments based on the partition size,
• determine, for each segment in the plurality of segments along the timeline, if at least one event starts within the corresponding segment and overlaps with the interval of interest, wherein the instructions to determine further cause the processor to perform a structured query language (SQL) query on the event log to determine events which overlap with the interval of interest to identify events of interest, and perform an SQL query on the event log for each segment to ascertain whether any events of interest start in the queried segment,
• identify that the corresponding segment includes at least one relevant event therein in response to determining that the at least one event starts within the corresponding segment and overlaps with the interval of interest, wherein the instructions to identify further cause the processor to classify the ascertained events as relevant events for the queried segment,
• determine parameters associated with the at least one relevant event for the corresponding segments, based on the identification that the corresponding segments include at least one relevant event therein, and
• provide, to a client device to generate the timeline of the at least one relevant event, the determined parameters along with an index which designates each corresponding segment.