Patent 10198159 was granted and assigned to OSIsoft on February, 2019 by the United States Patent and Trademark Office.
A data integration system accesses a time series database and an asset relational database. The asset relational database is comprised of a plurality of asset nodes related in a hierarchical structure. Each asset node may represent a physical asset in an industrial setting. The data integration system displays a graphical representation of the hierarchical structure of the asset relational database, receives user input selecting an asset node from the hierarchical structure, and displays a hierarchical search template based on the selected asset node. The data integration system searches the asset relational database for matching asset nodes and retrieves corresponding time series data from the time series database. The data integration system generates a report from the retrieved data.