Data Warehousing in the Aviation Sector

Big Data and Information as a Service

Data Warehousing in the Aviation Sector


Aviation Industry


The Problem

Customers find it difficult to get a complete picture of their operations as a result of their business activities through various operation channels in multiple countries.


The Solution

This problem can be solved through the implementation of the Orcha platform to provide comprehensive reporting, revenue assurance, data records, short-term storage of the data, long-term storage of the data for regulatory purposes, dashboarding and visualising of the data generated.


The functionality implemented includes:

  • Reporting
  • Revenue Assurance
  • Data records
  • Short-term storage of data
  • Long-term storage of data
  • Visualisation of data


How it Works

Using a cloud-based deployment of the Orcha technology platform, the data warehousing and data processing of the information and data records provided comprehensive revenue assurance and visualisation of the customer data. This can provide information which can be strategically used by management to make decisions and monitor the performance of the operations at a coarse-grained and a fine-grained level.


The Orcha Platform is able to provide XaaS (Anything as a Service), which includes:

  • DBaaS – Database as a Service
  • IaaS – Information as a Service
  • PaaS – Process as a Service
  • AaaS – Application as a Service
  • IaaS – Integration as a Service
  • SaaS – Security as a Service
  • MaGaaS – Management and Governance as a Service
  • IaSaaS – Infrastructure and storage as a service


Specific features which can be implemented:

  • Comprehensive REST web services API used to retrieve information from the data warehouse
  • Full API management
  • Web portal
  • Comprehensive reporting framework
  • Statistical information processing
  • Dashboarding and visualisation supported through:
    • data collectors
    • intermediate processing queues
    • pipeline processors
    • data processing and ETL
    • real-time indexing and search
    • dashboarding and visualisation
  • Revenue accounting and reporting:
    • report on financial aspects of the business by inspecting and loading reservation information from systems into various accounting platforms
  • Additional functionality:
    • data management
    • data security
    • API access control
    • portal access control
    • system access


The Advantages

Some of the advantages associated with implementing this solution:

  • support real-time spatial analysis
  • third parties, such as agencies and international partners, can onboard the platform functions using API integration without the risk of API errors
  • the enhanced user experience of the customers
  • APIs allow you to retrieve information for in-house web portals, custom reporting and dashboarding
  • customised reports providing you with greater visibility of the organisation
  • seamless integration between airline’s systems allowing for flexibility and no vendor lock-in of systems

Big Data and Information as a Service