The SPEA Smart Airport Statistical Data Management System (SMART STAT) is an intelligent system that transforms raw flight and Airport operational data into management information. STAT performs statistical analysis on flight and Airport operational data and makes data available to other SMART systems.

• Evaluate the current status of ground handling operations.
• Optimize the deployment of existing Airport resources.
• Determine future need for additional Airport resources.
• Consolidate data for billing.

• Improved tactical and strategic planning.
• Improved management decision making.
• Reduced operating cost and capital required for Airport expansion.
• Availability of concise structured information from customized reports.
• Flexibility in accessing data using standard query languages.
• Accurate and precise information for billing.
• Authorized users can access information via workstations or the Internet.

The SPEA Smart Airport Statistical Data Management System (SMART STAT) is an intelligent system that transforms raw flight and Airport operational data into management information. The ability to manipulate and perform statistical analysis on historical data from any source is a powerful tool for Airport Management. It allows them to evaluate the current status of ground handling operations and to make informed decisions on current and future operations and resource requirements.

Simple selections allow the user to run queries and also create useful customized reports on data within the SMART system and other Airport databases. SMART STAT allows users to access the database via Standard Query Language (SQL). Microsoft .Net, Open Database Connectivity (ODBC), Java Database Connectivity (JDBC) and other.

The following flight data is available for statistical analysis:

• Flight information - flight number, flight date and airline.
• Complete flight routing - scheduled time of departure and arrival for all Airports, including multiple city/leg flights.
• Flight qualification - flight type, traffic type, loading type and service type.
  •Aircraft information - aircraft type, aircraft registration number and aircraft configuration.
• Passenger information - terminating/transfer/transit passengers, passengers per weight category, passengers per class and special requirements.
• Baggage information – number and type bags, mishandling and irregularities.
  •Load information - mail, cargo, crew and passengers.
• Times - scheduled times, estimated times, touch-down/take-off times, block on/off times, red times, zone-in times and boarding/last call/flight closed times.
• Resources allocated to the flight - check-in counters, boarding gate, baggage reclaim belt and parking stand.
• Punctuality and regularity - flight delays and delay codes.

SMART STAT integrates fully with the Airport Operational DataBase System (SMART AODB) and other SMART Systems and interfaces with other Airport databases. Data is immediately available for analysis as it is recorded in any database. The Airport Billing System (SMART BILL) extracts data from SMART STAT for accurate billing. Statistical data can also be exported to any other billing software operated at the Airport.

• High performing and secure Oracle 10g database.
• Access the database via SQL, Microsoft . Net, ODBC, JDBC and other.
• User-friendly and highly configurable Windows browser based Graphical User Interface (GUI).
• Comply with International Air Transport Association (IATA) standards.
• Full seamless integration with all SMART Systems.
• Robust, reliable and scalable system.
• Supports concurrent users and is accessible from any authorized workstation.
• Data can be automatically backed-up on different media types.