Abstract: The invention supports the study of operations and provides a large data store of surface and terminal area operations, as well as means of analyzing and understanding that data. It fuses multiple surveillance and flight data sources to provide analysis functionality for both airborne and surface based flights. This provides a wider range of data to make intelligent categorization and derived data analysis decisions. The invention implements custom logic for matching flights to corresponding data messages by maintaining its own key mappings between data tables during import so that keys are unique to an installation and do not require sequences. This provides the ability to export datasets through the PostgreSQL dump utility and then import it into an existing database (using the PostgreSQL restore utility) without creating overlapping, duplicate or conflicting keys. XML based format is used and import and export features is that allow users to share these custom queries.