Systems and Methods for Interest-Driven Business Intelligence Systems Including Geo-Spatial Data

摘要

Systems and methods for interest-driven business intelligence systems including geo-spatial data in accordance with embodiments of the invention are illustrated. An interest-driven business intelligence system including raw data storage and perform extract, transform, and load processes, a data mart, and an intermediate processing layer, wherein the intermediate processing layer is configured to automatically generate metadata describing the raw data, derive reporting data requirements, and compile an interest-driven data pipeline based upon the reporting data requirements, where compiling the interest-driven data pipeline includes generating ETL processing jobs to generate geo-spatial data from the raw data, determining bounding data, bounding the filtered raw data based on the bounding data, generating geo-spatial data, and storing the geo-spatial data, generating reporting data including data satisfying the reporting data requirements based on the geo-spatial data, and storing the reporting data in the data mart for exploration by an interest-driven data visualization system.

主权项

1. An interest-driven business intelligence system, comprising:
raw data storage configured to contain raw data and perform extract, transform, and load (ETL) processes; a data mart configured to contain metadata that describes the raw data; and an intermediate processing layer; wherein the intermediate processing layer is configured to automatically:
generate metadata describing the raw data;derive reporting data requirements from at least one report specification based on the metadata; andcompile an interest-driven data pipeline based upon the reporting data requirements, where compiling the interest-driven data pipeline comprises:
generating ETL processing jobs to generate geo-spatial data from the raw data by:
filtering the raw data based on the metadata describing the raw data;determining bounding data based on the metadata describing the raw data;bounding the filtered raw data based on the bounding data;generating geo-spatial data based on the bounded filtered raw data; andstoring the geo-spatial data in the data mart;generating reporting data including data satisfying the reporting data requirements based on the geo-spatial data; andstoring the reporting data in the data mart for exploration by an interest-driven data visualization system.