The Airport Analytics (AA+) data model consists of the following
From the source systems, data is extracted and staged in the Staging Area for cleansing & transformation in order to map it to the airport data model in data warehouse. Cleansed & transformed data in the data warehouse holds historical data for low level analysis. Data from the data warehouse is aggregated into relevant marts for high level analysis
The approach as defined below is used to load all the relevant data from enterprise transactional systems and 3rd party sources in the data warehouse and accessed through Airport Analytics (AA+) platform. The key benefits of this data integration approach are:
All complex computation logic will be handled in the ETL processing
The master and transaction data load automation is scheduled based on the customer OLTP timing & data volume
Maintain alert mails for success and failure of jobs/process chain
Schedule Automated reports for data profiling, data quality and data validations
While deploying Airport Analytics (AA+), there are a number of options. It is necessary to make sure that right choices are made for deployment in order to meet requirements, such as, is the system easily maintained, is it resilient, is it secure, does it support planned user base and can it be easily expanded to accommodate additional users. Clearly 3 different deployment modes emerge whereby the Airport Analytics (AA+) system can be deployed across different numbers of physical servers for different type of environments like Development, UAT and Production.