Unpredictable & interactive analysis of terabytes of data Amadeus - PowerPoint PPT Presentation

Click ’Insert’ Click ‘Picture’ Unpredictable & interactive analysis of terabytes of data Amadeus Revenue Accounting Metadata Search Big Data Paris , 11 March 2015 Laurent Dollé ldolle@amadeus.com 265ced1609a17cf1a5979880a2ad364653895ae8

265ced1609a17cf1a5979880a2ad364653895ae8 1 Amadeus today Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Amadeus In a few words Amadeus is a technology company dedicated to the global travel industry . We are present in 195 countries with a worldwide team of more than 11,000 people. Our solutions help improve the business performance of travel agencies, corporations, airlines, airports, hotels, railways and more. Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Connecting Cruiselines The travel industry Airlines Hotels Insurance companies Car rental Travel agencies Ground handlers Airports Ferry operators Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Ground transportation Click ‘Apply to All’

Supporting The traveler life cycle Post-trip Inspire On trip Search Pre-trip Buy/Purchase Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Robust Global operations We designed & own our Data Processing Centres _ Central DC @ Erding, Germany _ Remote DCs all over the globe _ Recovery DC on standby in case of natural disasters 502+ 615+ 1.6 + 95% million million billion of the world’s travel agency Passengers scheduled network transactions bookings Boarded airline seats processed per day processed in 2013 in 2013 Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Close To our customers Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Our commitment To innovation _ Amadeus has invested € 2.9bn in Research & Development since 2004. _ Nominated within “top 3” software companies in 2013 European Union Industrial R&D Investment Scorecard. Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Global air travel Is a growth industry 3.91 billion air passengers 31 % growth Amadeus growth is powered by a sustainable 2.98 billion air passengers transaction-based business model Click ‘Insert’ in Top menu 2017 2012 Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’ Source: IATA. Airline Industry forecast 2013-2017

265ced1609a17cf1a5979880a2ad364653895ae8 2 Amadeus Revenue Accounting Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Passenger Revenue Accounting What for? Revenue of a flight ticket Amadeus is shared Revenue Accounting handles cash flows _ Travel agent on behalf of airlines _ Governments _ Tracking _ Airlines: many can be involved _ Error handling & optimisation (marketing & operating) _ Reporting: analysis & audit Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Increasing accuracy By leveraging our GDS position In common • Data centres • Platforms and applications IT Distribution Real-time tracking • Sales & marketing infrastructure of airline’s • Customers passenger sales revenue _ at usage time: effective revenue _ at sale time, weeks before: expected revenue Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Amadeus Revenue Accounting Key benefits & features _ Facilitate strategic decisions _ Optimise revenue accounting processes Web apps , APIs & feeds hosted in the Amadeus cloud (SaaS) Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

265ced1609a17cf1a5979880a2ad364653895ae8 3 Metadata Search business needs Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Business needs Gathered from a launch partner One of our launch partners is a Migrating large European airline _ from their _ transporting 35m+ in-house data warehouse passengers a year _ to our _ key player in the cloud-based solution revenue accounting industry They requested a user-friendly way to query any data in our main operational database _ Unpredictable ad-hoc search Click ‘Insert’ in Top menu _ Many advanced reporting requirements Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Metadata Search The main promises _ Graphical user interface edit , import , save & share queries _ Data warehouse fed in real time 4 years history ( 140m+ documents , versioned) _ Interactive response times _ Search further using chained queries (patent pending) Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Project milestones And possible impacts November 2013 User acceptance testing December 2014 Migration & parallel running validation on production Summer 2015 Production cut-over SLA & optimisation based on usage statistics Post cut-over Any delay or functional gap may impact the whole project as application is used to validate Click ‘Insert’ in Top menu migration and parallel running phases. Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

265ced1609a17cf1a5979880a2ad364653895ae8 4 User-friendly SQL graphical user interface Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

SQL paradigm Split into 2 functional areas SELECT A , SUM( B ) WHERE A > C AND B > D GROUP BY A ORDER BY A 2 functional areas can be defined _ Search criteria predicates filtering the results _ Displayed data projections and related functions Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Graphical user interface Query editor Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Graphical user interface Query editor Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

265ced1609a17cf1a5979880a2ad364653895ae8 5 Technical constraints Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Expecting fast answer to unpredictable queries No index , no hint (almost) _ Fields to be scanned unknown _ Main-memory full scans to decrease response time Need to scale out for sustainable performances Support mainstream SQL DML statements _ Aggregation _ Cross-column comparison, Boolean logic _ Sort Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Resilient & user-friendly versioning Featuring a document timeline last 4.x Flags last 1.x final event last 3.x last exchange last issuance last issuance confirmation last 2.x last usage 1.1 1.0 2.0 3.0 3.1 4.0 Timeline Issuance confirmation Issuance Exchange Usage Usage ( replay ) Exchange conflict conflict : 3.2 bumped out of timeline 2.1 3.2 Events out of timeline Exchange (replay) Usage ( replay ) Document timeline implemented to retrieve efficiently the particular version of a document based on arbitrary date, event name, flags Efficient upserts & transactions needed to Click ‘Insert’ in Top menu Click ’Header & Footer’ replace or update multiple versions at each write in field ‘Footer’ Click ‘Apply to All’

Schema-less document store For agile integration Our main operational database is an Oracle document store containing Protocol Buffers documents (4000+ fields) A schema-less document store would ease _ the ETL transformation process (400+ metadata fields to load) _ the data model maintenance & synchronization between both databases Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Consistency & availability And their impacts Consistency favoured over availability (CAP) _ Expecting accuracy since data used by auditors _ However: no operational impact application is not MCA No contractual SLA _ To be agreed after benchmarking on production _ Interactive response times expected with very few parallel users _ Full outages out of business hours accepted Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’

Integration In the Amadeus standards Runs on standard x86 architecture C++ , Python & Java drivers Enterprise-grade security _ SSL encryption _ Kerberos authentication _ Data-at-rest encryption Click ‘Insert’ in Top menu Click ’Header & Footer’ in field ‘Footer’ Click ‘Apply to All’