Security Icon


Data Warehouse

Powered by detailed smart ticketing data, the Rambus Data Warehouse provides comprehensive analysis of a centralized database of customer trends and travel patterns.

Data Analytics for Smart Ticketing

The Rambus Data Warehouse unlocks the true value of the data generated by smart transport schemes. Instead of data being stored in separate databases with no ability to query it, the data is collected into a single, central database where trends in customer travel, patterns of purchase and usage can be viewed and analyzed through a wide array of intuitive dashboards and reports.

The insights gained from the smart data enable operators to improve cost-effectiveness and operational efficiency by providing real-world knowledge of where peak demand starts and ends, where services are overused, and what demographics of customer are using different services. With this knowledge, operators can manage station traffic during periods of busy congestion by sending live updates to the customer’s phone, or incentivize riders to use alternative routes through promotional offers.

Similarly, the data from the Rambus Data Warehouse can be used to market effectively to customers, targeting efforts for the maximum impact and enhancing customer experience.

Data Warehouse system feeds
The Data Warehouse takes data from multiple disparate operational databases and passes it through an Extract, Transform and Load (ETL) routine that converts the operational data into a useful form for analysis and aggregation.  This data is then loaded into an OLAP cube, a specialized form of database that is optimized for performing large volume aggregation queries efficiently.  A reporting tool of your choice then allows you to view this data, slicing across the dimensions to efficiently analyze trends in depth and perform data discovery.

Solution Offerings

  • Extract, Transform and Load (ETL) routine pulls data from multiple separate systems and puts it in one place for reporting
  • Reporting from across the Rambus Smart Ticketing suite – including ITSO schemes
  • Third-party data can be added to supplement in-house data
  • OLAP cube used for efficient access to large volumes of data
  • Large volumes of data stored in database for access
  • Data can be anonymized for personal data security
  • Data is held separately to minimize impact on operational systems
  • ETL routine to extract data from Rambus Smart Ticketing systems, transform it appropriately and load it into the data cube
  • OLAP data cube maximizes efficiency and effectiveness of data aggregation queries
  • Schema of the OLAP data cube to design your own queries
  • Installation and support
  • Optional Third-party ETL development
  • Reference dashboards and UI portal
Transforming the Smart Card Ticketing Market thumbnail

Transforming the Smart Ticketing Market with Host Card Emulation

For transport operators seeking to modernize their fare systems, HCE mobile ticketing solutions, which are compatible with existing ITSO-based infrastructure, offer the same ‘shopper friendly’ convenience consumers have come to expect from their smartphones in a transport environment, as it effectively replaces yet another plastic smart card with a secure digital travel wallet.
Download eBook 

Related Markets & Applications

FREE Webinar: Secure Silicon IP Series: Complexity vs. Security