A computer implemented method for data integration. An event relational database having a plurality of event frames related in a hierarchical structure is accessed. Each event frame representing a corresponding event within a corresponding timeframe. A graphical representation of the hierarchical structure of the event relational database is displayed in a graphical user interface. A user input is received selecting an event frame of the hierarchical structure from the graphical representation. A hierarchical search template is displayed based on the selected event frame of the hierarchical structure. The event relational database is searched with a search query corresponding to the hierarchical search template to identify one or more matching event frames of the hierarchical structure. The method also includes retrieving, from a time series database that includes time series data, a portion of the time series data corresponding to the one or more matching event frames.