INFORMATION FOR SUCCESS

(1)

INFORMATION

FOR SUCCESS

Oracle Fast Data Customer Reference Booklet

October 2013

(2)

(3)

3 To understand fast data, one must first look at one of the most compelling new breakthroughs in data management: big data. Oracle believes that big data solutions address the challenge today’s businesses are facing when it comes to managing the increasing volume, velocity, variety of all data - not just data within the organization but also about the organization. Velocity is about the ability to process large volumes of data in real-time and make decisions in a more rapid fashion to create value from highly-perishable, high-volumes of data in business operations.

This is where fast data comes in. Fast data is a term that was coined recently by Ovum’s Tony Baer who wrote, “Fast data, the velocity side of big data, is not new, but technology price/performance trends are making fast data applications more widely available”. Fast data is a complimentary approach to big data for managing large quantities of “in-flight” data that helps organizations get a jump on those business-critical decisions. Fast data is the continuous access and processing of events and data in real-time for the purposes of gaining instant awareness and instant action. Every business wants to be smarter about how they do business. Velocity is a critical component to achieving this end goal. By capturing data faster and moving it faster means being able to analyze it and act on it faster. Today more and more organizations are demanding the elimination of event-to-action latency as part of solving a business problem. In today’s fast paced world, data loses value at a faster rate and consequently the value you get from your data diminishes when you don’t tap into it soon enough.

While the term Fast data might be new; it’s a set of mature ideas and technologies around the rapid processing of events and high volumes of data for improved analytical insights. It’s recently been impacted by the explosion in volume and variety of data [big data]; the ubiquitous nature of devices and internet of things, and ultimately the heightened expectations of customers. No longer do we see fast data in only financial stock exchanges or limited to Hadoop based deployments; but it’s becoming more and more pervasive across industries as companies are recognizing the need to run their businesses in real-time. The following customers in this whitepaper cover a range of industries across: Financial Services, Telecommunications, High Tech, Manufacturing, Media and Entertainment, Travel and Transportation, Retail, Professional Services, and finally Public Sector.

Each of these Oracle’s customers are using the combination of Oracle technologies: Oracle Event Processing, Oracle Data Integration, Oracle Business Analytics together with Oracle Engineered systems to deliver fast data value for their organizations. For more information, go to Oracle.com/fastdata

Demed L’her

VP of Product Management Service-Oriented Architecture and Fast Data Oracle

(4)

(5)

BT Increases Sales and Customer Retention with

Real-Time Decision-Making Tool for Customer

Advisors

Oracle Customer:

BT

London, United Kingdom www.bt.com

Industry:

Communications

Annual Revenue:

Over US$5 Billion

Employees:

92,600

Oracle Products & Services: • Oracle Real-Time Decisions

• Oracle Consulting

BT Group plc is one of the world’s leading communications solutions and services providers, with operations in 170 countries. It delivers fixed-line, broadband, and mobile services, as well as TV products and networked IT services. As part of BT Group Plc, BT Retail provides communication products and services, including broadband, telephony, television, and mobile services to the consumer and small to medium enterprise (SME) markets. With 20 million customers, BT Retail receives up to 32,000 in-bound calls per day. In addition, specialist teams of 400 advisors handle up to 16,000 calls a day while approximately 50 outbound sales advisors make up to 5,000 calls a day. To provide customers with more appropriate offers and improve sales and subscriber retention, BT wanted to provide its customer advisors with more sophisticated information about individual customers at the point of contact.

BT chose Oracle Real-Time Decisions to deliver real-time information and

recommendations to its customer advisors. Since implementing, BT has significantly increased sales conversion rates and value, and reduced customer churn.

“With Oracle Real-Time Decisions, we are already reaping the rewards of improved sales conversions and reduced customer churn. The project was delivered on time, and we are all very proud of this achievement.”

–– Alistair Dixon, Head of Delivery, Retail Business Intelligence, BT

•Increased sales conversion rate and value of offers sold as a direct result of

individually-targeted recommendations provided by Oracle Real-Time Decisions

•Prevented loss of market share by retaining customers with targeted offers

•Increased customer retention and cross- and up-selling initiatives by providing more than

800 customer advisors with real-time and individually targeted sales recommendations for broadband, television, and telephony services

•Improved execution of “sales-through-service” initiatives by providing customer service

team members with the information they need to successfully sell additional communication services to customers during service calls

•Improve up-selling and cross-selling opportunities at the point of customer contact to increase

sales of broadband, telephony, television and mobile services during 32,000 calls per day

•Expand customer service representatives’ sales and marketing expertise to increase

up-selling and customer retention

•Approach customers with precisely targeted offers to increase sales effectiveness and value,

while reducing customer churn

•Replace a simplistic, in-house, tactical decisioning tool with targeted recommendations

delivered to customer operatives to drive sales

Challenges

Solutions

(8)

8

•Worked with Oracle Consulting to provide the experience, technical skill, and product

knowledge needed to replace the in-house decisioning tool with Oracle Real-Time Decisions delivered on-time and under budget

Why Oracle

“We spent more than six months evaluating the products on the market and discounted Chordiant, Unica, and Teradata during the process. We are confident that we made the right choice with Oracle Real-Time Decisions, which is both sophisticated and easy to maintain,” said Alistair Dixon, Head of Delivery, Retail Business Intelligence, BT.

After evaluating a number of products on the market, BT chose Oracle Real-Time Decisions for its flexible decision engine which can be used for a variety of purposes, such as tighter targeting in batch marketing systems, its self-learning capability that enables the engine to draw decisions from previous customer interactions, and its real-time recommendations. “The number one strength of Oracle Real-Time Decisions is that it truly does make its decisions in real-time. Therefore, it is able to take into account any contextual data that occurs in the interaction with the customer, which is exceedingly valuable. We found on closer examination that many other decisioning engines on the market do not have this level of sophistication,” Dixon said.

Implementation Process

BT worked with Oracle Consulting to implement Oracle Real-Time Decisions within tight time-scales and a pre-defined delivery schedule. Oracle Consulting worked closely with the business to ensure that Oracle Real-Time Decisions would help BT to achieve its business objectives and now provides on-going support to ensure the solution is used to optimal business benefit.

Oracle Consulting provided the technical lead and was responsible for configuring the Real-Time Decisions functions. It also advised on the infrastructure design for the technical architecture and helped to train BT’s internal resources. Oracle University delivered training through instructor-led and classroom-based courses, supplemented with one-to-one coaching by Oracle Consulting to ensure full knowledge transfer.

The initial stages of the project went live in September 2011 and further phases are being rolled out to multiple channels during 2012 and 2013, including an on-line customer self-service operation, outbound sales teams, a specialist customer retention team, and an outbound direct marketing group.

(9)

9

Tata Sky Ltd. Processes 1 Million Customer

Requests per Day, Resolves Queries 25% Faster

Oracle Customer: Tata Sky Ltd. Mumbai, India www.tatasky.com Industry: Communications Annual Revenue:

US$500 Million to US$1 Billion

Employees:

1,200

Oracle Products & Services: • Oracle GoldenGate

• Oracle Business Intelligence Standard Edition

• OSPARC T4-2

• OSPARC Enterprise M9000

• Oracle Solaris 10

Oracle Partner:

Tata Consultancy Services Ltd.

www.tcs.com

Tata Sky Ltd. is a leading, national direct-to-home (DTH) satellite broadcasting television service provider in India. The company provides and installs set-top boxes offering picture, sound, and interactive services for television, as well as high-definition content channels and recorders, and video on demand.

Tata Sky operates an extensive customer-service network to support its more than 7 million national customers. The network includes service installations; a 24-hour call center service; and multilingual customer service staff. Incorporated in 2004, the company is a joint venture between Tata Group and STAR India, and currently holds the largest market share in the national DTH, business-to-customer market. It has 25 offices across the country. To remain India’s satellite television service provider of choice, Tata Sky wanted to improve its internal, customer-order management system, so it could respond to a growing number of customer phone queries and requests for its satellite broadcasting television services. The company implemented Oracle GoldenGate to provide real-time data integration and Oracle Business Intelligence Standard Edition for reporting and analytics. It is running the applications on SPARC T4-2 and SPARC M9000 servers.

The Oracle solutions enabled Tata Sky’s customer service staff to access, retrieve, and update customer queries and process requests and payments in real time. Tata Sky can now resolve customer phone queries in less than three minutes on average, compared to four minutes previously; process 1 million requests each day, compared to 100,000 previously; and provide more accurate customer service and assistance over the phone, 24 hours a day, seven days a week.

“We have used Oracle’s world class products from the start to help us become a leader in India’s direct-to-home market and to support our business growth. We can now process 1 million customer requests per day and resolve queries 25% faster.”

–– N. Ravishanker, Chief Information Officer, Tata Sky Ltd.

•Improve its customer call center services by enabling staff to respond to more calls per day

and reduce average call-handling time

•Upgrade the customer-order management system to enable staff to access, retrieve, and

update customer data faster and in real time, and provide customer service assistance 24 hours a day, seven days a week

•Reduce time to process customer requests and payments for new channels, plans, or

packages, to deliver new services to customers immediately

Challenges

•Processed 1 million customer requests made daily by phone, compared to 100,000 previously •Resolved customer queries 25% faster—in less than three minutes on average compared to

four minutes previously—by updating customer profiles and processing requests in real time

•Accelerated the system reboot process and improved patch management using Solaris 10

Solutions

(10)

10

•Improved, by 20%, the tracking and recording of customer complaints made over the

phone, by automating its interactive voice response database to record calls in real time

•Provided more responsive customer service over the phone, 24 hours a day, seven days a

week, by moving data to a reporting database to provide staff with accurate, up-to-date customer information in real time

•Enabled customers to access new services or re-activate service payments in real time •Reduced data processing speeds and system downtime to deliver customer-service

assistance around the clock. Ensured the customer-order management platform could scale to meet the increasing number of customers and up to two million orders a day

•Generated approximately 700 new marketing and services analytics reports, which weren’t

available previously, using Oracle Business Intelligence Standard Edition

Tata Sky has been using Oracle products since its inception. The company is running an IT infrastructure that is almost 100% based on Oracle.

“We chose Oracle for our IT infrastructure, as its products are world class and optimized to handle large numbers of transactions,” said N. Ravishanker, chief information officer, Tata Sky Ltd. “Oracle can deliver the scalability and performance we need to integrate and upgrade our systems and applications to meet our growing business and customer needs. “With Oracle, we have grown to become India’s leading, national, satellite broadcasting television service provider. We will definitely continue use Oracle products in the future to help us meet our goal of processing 3 million requests per day.”

Why Oracle

Tata Sky engaged Oracle Diamond Partner Tata Consultancy Services Ltd. (TCS) to implement Oracle GoldenGate, Oracle Business Intelligence Standard Edition, and the SPARC T4-2 servers. The implementation of Oracle GoldenGate and the SPARC T4-2 servers took three months to complete—both went live in July 2012. The implementation of Oracle Business Intelligence Standard Edition took nine months, going live in June 2012. TCS customized aspects of Oracle GoldenGate and Oracle Business Intelligence. The project was delivered on time and on budget.

TCS provided Tata Sky with complete system integration services, including testing, consultation, implementation, customization, training, and post-implementation support. The company has been Tata Sky’s system integrator for the past seven years.

“We have worked with TCS on a number of IT projects over the years and the team is experienced in implementing large-scale Oracle solutions in the DTH space,” Ravishanker said. “We are happy with the service they’ve provided and will continue to partner with them in future.”

Partner

(11)

11

Türk Telekom Significantly Improves Performance

with Turkey’s First Asynchronous, Real-Time

Archiving Solution

Oracle Customer: Türk Telekom Istanbul, Turkey www.turktelekom.com.tr Industry: Communication Employees: More than 24,000

Oracle Products & Services: • Oracle \ 11g

• Oracle Management Pack for Oracle GoldenGate

• Oracle GoldenGate Veridata

Oracle Partner:

Asseco SEE

www.asseco.com

Türk Telekom, a leading communication and convergence technology company in Turkey and the country’s most valuable brand for the last four years according to Brand Finance, provides fixed line communications and broadband internet services. The company, which was founded in 1994 by separating from Posta ve Telgraf Teskilatı, the national post and telegraph directorate of Turkey, owns more than 14.5 million fixed access lines—nearly all fixed access lines in Turkey—and 7 million asymmetric, digital subscriber lines.

Türk Telekom required faster development of telecommunications operation, sales, and marketing reports to be derived from approximately 20 terabytes of data collected from mission-critical applications, like billing and customer relationship management (CRM) systems. The company also needed to ensure replication in a hybrid environment with source systems and target systems from different manufacturers in two geographical locations. To meet these goals, Türk Telekom established the first and only asynchronous, real-time archiving solution in Turkey with Oracle GoldenGate to facilitate real-time data warehousing with hybrid online replication from 16 different source systems to one target data warehouse with near-zero latency. Thanks to the new solution, the company was able to eliminate 30 hours of database downtime, reduce costs, and save approximately US$22 million.

“By using Oracle GoldenGate 11g, we have drastically improved performance and access to real-time data and eliminated many downtime hours. With almost zero-downtime migrations reaching the desired high availability ratios and flexible online replication, we reduced operational costs and saved approximately US$22 million.”

–– Serkan Karatas, Database Division Manager, Türk Telekom

•Enable faster reporting on approximately 20 terabytes of data collected from

mission-critical applications, such as billing and CRM systems, to support management decision-making

•Reduce source system overhead, development and maintenance costs, and transaction time

with an alternate approach to the company’s extract-transform-load process—to move data from online transaction processing (OLTP) systems to online analytical processing systems

•Facilitate replication in a hybrid environment with source and target systems from

different manufacturers located 450 kilometers apart

Challenges

•Established the first asynchronous, real-time archiving solution in Turkey with Oracle

GoldenGate, which moves 250 gigabytes of daily modified data in real-time from a huge OLTP database to an archive database, achieving an important increase of OLTP query performance to enable fast operational, sales, and marketing reports

•Archived historical data to save valuable disk space, decrease storage and backup costs, and

lower management and maintenance costs of the production OLTP database

Solutions

(12)

12

•Facilitated real-time data warehousing with hybrid online replication from 16 different

source systems to one target data warehouse with Oracle GoldenGate, achieving online replication with near-zero latency and enabling the company to handle data operations in shrinking batch windows

•Supported key applications—such as business analytics, campaign management, and churn

prevention—and facilitated live reporting from a dozen source systems located in Ankara to four target reporting platforms located in Istanbul without requiring any source systems modifications

•Reduced overhead costs on central processing units (CPUs) and source systems, as Oracle

GoldenGate captures data from transaction logs (not the database itself) and does not interfere with source data

•Used Oracle GoldenGate for bidirectional (active-active) migrations and upgrades of three

database platforms, with almost no-downtime eliminating 30 hours of previous downtime and saving approximately US$22 million

•Minimized risks by backing up all data from the new site to the old site with Oracle

GoldenGate’s reverse direction replication to achieve zero downtime rollback if the new system should fail

•Ensured the right data is sent to target systems in all archiving, migration, and replication

projects by comparing the source data with the replicated target data quickly and easily with Oracle GoldenGate Veridata

“When we decided to find a replication tool, we evaluated some competing products. When we saw the results delivered by Oracle GoldenGate, our choice was clear,” said Serkan Karatas, database division manager, Türk Telekom. “Oracle GoldenGate offers more advanced replication features, lower maintenance costs, and more flexible configuration options than its competitors. In addition, Oracle GoldenGate produces much less overhead for source systems.”

Why Oracle

Türk Telekom acquired GoldenGate licenses from Asseco SEE, which was GoldenGate’s distributor in Turkey. The implementation was performed by Türk Telekom’s internal teams while Asseco SEE provided consultancy services to resolve operational issues that needed specialized experience.

Partner

(13)

13

Turkcell iletisim Hizmetleri A.S. Uses

Engineered System to Analyze 10 Billion Daily,

Call-Data Records and Service Logs and to

Generate 100,000 Monthly Reports

Turkcell iletisim Hizmetleri A.S.

Istanbul, Turkey www.turkcell.com.tr

Industry:

Communications

Annual Revenue:

Over US$5 Billion

Employees:

3,583

Oracle Products & Services: • Oracle Exadata Database Machine

“Oracle Exadata was not a choice for us, but a necessity. How do you process 10 billion daily, call-data records and logs of value-added services to extract valuable information? With Oracle Exadata Database Machine, queries are so fast that we can continuously increase the number of data warehouse users to extract more value-added service information from vast volumes of data.”

–– Ferhat Sengönül, Data Warehouse Specialist, Turkcell iletisim Hizmetleri A.S. Turkcell iletisim Hizmetleri A.S. (Turkcell) is a leading provider of mobile communications in Turkey, with more than 34 million subscribers. Established in 1994, Turkcell created the first global system for a mobile communications network in Turkey, and it was the first Turkish company to be listed on the New York Stock Exchange.

Turkcell needed to process up to 10 billion daily, call-data records (CDRs) and value-added service logs for billing and to ensure continuously accelerated development of 4,000 distinct reports containing critical business data. The company combined two Oracle Exadata Database Machine X2-2 HP Full Racks to reduce the size of the company’s data warehouse from 600 TB compressed to 60 TB and enable more than 500 data warehouse users to generate more than 100,000 reports per month—twice as many reports as with the deployment on its previous, single Exadata machine. Turkcell also shortened project execution times substantially and future-proofed its storage capabilities, thanks to Oracle Exadata Database Machine’s effortless scalability.

Working with Oracle Consulting, Turkcell implemented 16 nodes on two Oracle Exadata Database Machine X2-2 HP Full Racks in just five days, without any interface changes.

•Manage one petabyte of uncompressed telecommunication data, including CDRs and

value-added service logs, in an enterprise data warehouse that includes more than 500 Oracle databases, online transaction processing, and a data warehouse

•Ensure continuous, accelerated development of 4,000 distinct reports containing critical

business data, such as regulatory and management financial reports, with 100,000 monthly report runs requested by hundreds of data warehouse users

•Support analysis of up to 10 billion daily, call-data records and logs of value-added

services, records that are needed to bill for services—such as subscriptions for weather and sport services, and more

•Ensure scalability and business continuity in the telecommunication sector where data

volumes double annually

Challenges

•Combined two Oracle Exadata Database Machine X2-2 HP Full Racks (16 nodes) to

simplify system architecture and reduce the size of the company’s data warehouse from 600 TB compressed to 60 TB

Solutions

(14)

14

•Enabled Turkcell, with Oracle Exadata’s unmatched data warehouse performance, to

double the number to more than 500 data warehouse users who extract new information from the wealth of data collected by the company to offer the best telecommunication products and services to its customer base and to generate more than 100,000 reports per month—twice as many reports as with the deployment on its previous single Exadata machine

•Enabled Turkcell to thoroughly analyze up to 10 billion daily, call-data records and

value-added service logs—such as for subscriptions to news services, stock market updates, and more—to offer the appropriate products and services ahead of the competition

•Improved and shortened the design of reporting projects substantially—such as for

management’s revenue reporting or data mining for churn analysis— as Oracle Exadata makes it possible to access raw data without summarized tables, processes queries faster than any other machine, and consequently optimizes and shortens the design phase for each project

•Future-proofed the company’s storage capabilities, thanks to the effortless scalability of

Oracle Exadata Database Machine, enabling the company to scale linearly by simply adding racks

•Worked with Oracle Consulting to implement 16 nodes on two Oracle Exadata Database

Machines X2-2 HP Full Rack in just five days, without any interface changes

•Moved 40 terabytes of data from an Oracle Exadata Database Machine V2 to SATA storage

to keep infrequently used data available at a low cost

Why Oracle

“We did not ask any other vendor for a proof of concept because it would require them to work on a migration project that would last one or two years, and it is difficult to see the end for such a project. With Oracle Exadata, we migrated without any design change or

development change, simply plugging in the new technology,” said Ferhat Sengönül, data warehouse specialist, Turkcell iletisim Hizmetleri A.S.

“With assistance from Oracle Consulting, we implemented 16 nodes of two Oracle Exadata Database Machines X2-2 HP Full Rack in just five days, without any interface changes,” Sengönül said. “Oracle Consulting was also very fast in resolving issues that we faced during the post-implementation phase. With the excellent support from Oracle Consulting, all issues were resolved quickly.”

(15)

(16)

16

Woori Bank Cuts Customer Credit Rating

Assessments from Three Hours to 15 Minutes,

Generates Management Reports in 10 Minutes

Instead of Five Hours

Woori Bank

Seoul, Republic of Korea www.wooribank.com

Industry:

Financial Services

Annual Revenue:

Over US$5 Billion

Employees:

14,363

• Oracle GoldenGate

Woori Bank is the flagship unit of Woori Financial, the Republic of Korea’s largest financial group. The bank’s credit card division wanted to shorten the time it took to load online transaction processing (OLTP) data from the accounts system—which processes and stores real-time credit card transactions—into an analysis database. Woori’s staff uses the analysis database to do customer credit rating assessments, run management reports, and generate the intelligence needed to develop effective marketing and promotional campaigns. Due to rapid growth in the credit card business, the bank needed a stable, scalable, and highly available database platform that could process large volumes of transactional data very quickly. The ability to access credit card data on the day the transaction occurred— rather than a day later—would help the bank develop effective business strategies, such as creating targeted promotions to increase chances of product take-up. The bank also wanted to minimize the cost, time, and effort of transferring existing databases to a new data processing platform, and it needed to ensure efficient storage of up to 1 TB of new data a month.

After implementing Oracle Exadata Database Machine and Oracle GoldenGate on Oracle’s Sun Fire X4170 M2 and Sun Fire X4270 M2 servers, the bank can now load OLTP data in real time, compared to one day in the past. As a result, customer credit-rating assessment tasks can be completed in 15 minutes, instead of three hours; daily marketing target selections can be made in less than 30 minutes, instead of 3.5 hours; and targeted data for business management reports can be generated in less than 10 minutes, instead of five hours. The faster OLTP loading time has significantly increased work productivity of business users and IT administrators.

Faster reporting means 120 power users in the marketing and other divisions can go beyond standardized queries to generate personalized queries in the data mart access layer, using the results to create effective and timely promotional campaigns. In the past, it had been difficult for them to revise and incorporate changes to marketing campaigns in real time because they were working with the previous day’s data. Now, users can immediately access and analyze transactions for specific trends in the data mart access layer and adjust

campaigns and strategies accordingly. Woori Bank can also send tailored offers to customers. For example, if someone applies for a credit card, the bank can follow up with an offer for a personal loan on the same day.

Woori Bank used the Hybrid Columnar Compression feature in Oracle Exadata to compress analytical and historical data, shrinking 78 TB of data down to 42 TB and reducing data storage costs by 46%. The bank also deployed Oracle’s StorageTek SL500 modular library system to efficiently store corporate data. The Oracle infrastructure can be expanded without extensive configuration or installation, simply by adding new racks to easily support the bank’s future growth.

(17)

17

Why Oracle

In December 2010, Woori Bank’s credit card division and Woori FIS (Woori Financial Group’s IT services business) ran a series of benchmark tests of integrated OLTP/OLAP solutions from four vendors. The solutions were assessed on their performance, based on queries and reports that the bank regularly generates.

The results showed Oracle Exadata offered the fastest performance and the best database integration capabilities. The platform was also optimized for loading and analyzing accounts data in real time. In addition, Oracle Exadata simplified data verification. In the past, verifying the integrity of accounts data was a load-intensive process that could take three days to complete. With Oracle Exadata, verification of all account data takes just two hours. Oracle Exadata’s Hybrid Columnar Compression feature—which can compress data by up to 10x—was another attractive feature, as it could provide efficient storage and support the expected growth in Woori Bank’s credit card business and data volumes.

Finally, Oracle offered an architecture that can process large data volumes, is easy to scale, and provides quick and stable migration, due to the use of identical databases. This would enable service continuity during the migration process and lower deployment costs.

In May 2012, Woori Bank transferred 7.5 TB of credit card transaction data from the accounts system to the Oracle Exadata platform, completing the task in just 1.5 hours. The arrangement time needed to optimize Oracle Exadata was reduced from an expected 22

hours to 7 hours.

The Oracle Exadata platform is performing stably after the bank set the data compression range and optimized application performance.

(18)

18

Zagrebacka banka d.d. Reduces Complex

Calculations from Hours to Minutes with

Engineered Business Intelligence

Oracle Customer: Zagrebacka banka d.d. Zagreb, Croatia www.zaba.hr Industry: Financial Services Annual Revenue:

US$100 to US$500 Million

Employees:

4,500

Oracle Products & Services: • Exalytics In-Memory Machine X2-4

• Oracle TimesTen In-Memory Database for Exalytics

• Oracle Business Intelligence Foundation Suite

• Oracle Exadata Database Machine

• Oracle Essbase

Zagrebacka banka d.d., part of Italian Unicredit Group, is the biggest bank in Croatia and one of the country’s largest employers. Through its 130 branches, the bank serves 80,000 corporate customers and more than 1.1 million private customers nationwide—making one in four citizens a Zagrebacka banka customer. Zagrebacka banka accounts for 25% of the total assets of the Croatian banking sector, controlling 35% of Croatia’s investment funds, 41% of obligatory pension funds, and 30% of specialized savings accounts for real estate purchases transacted through its subsidiaries. The publications Euro money and Global Finance named Zagrebacka banka Croatia’s best bank in 2011.

“We deployed Oracle Exalytics In-Memory Machine, Oracle TimesTen In-Memory Database for Exalytics, and Oracle Business Intelligence Foundation Suite to establish the most advanced business intelligence environment available on the market today. From complex forecasts, to ad-hoc analyses with detailed drill-downs—the information is readily available. We have seen remarkable gains in job performance and the ability to support more concurrent users, compared to our legacy platform, and we have substantially improved our analytical capabilities to optimize decision-making at every level of the bank.”

–– Mirko Talajic, Business Intelligence Director, Zagrebacka banka d.d.

•Deployed Exalytics In-Memory Machine X2-4 to operate the fastest business intelligence

and online analytical processing (OLAP) platform available today, for a system that is tightly connected to the bank’s data warehouse on Oracle Exadata Database Machine with unmatched analytics speed and rich visualization

•Retrieved data in profitability cubes via Oracle Essbase Smart View within three seconds

instead of 30 seconds, as before, while Oracle Business Intelligence Publisher performs up to 4x faster on Exalytics In-Memory Machine

•Deliver dynamic business intelligence reports, such as ad-hoc profitability analyses of

banking products within specific customer scenarios, periods, and regions to increase insight and facilitate better decisions

•Enhance the user experience for the bank’s Oracle Business Intelligence users, as the legacy

platform could no longer meet the increasing performance requirements for numerous ad-hoc analyses and reports

•Shorten the refresh period for planning and forecasting information by shortening the time

for complex calculations from days to hours

•Establish a consolidated business intelligence platform with superior performance,

building on the value already gained from using Oracle Business Intelligence, Oracle Business Intelligence Publisher, and Oracle Essbase

Challenges

Solutions

(19)

19

•Reduced the execution time for complex calculations from hours to minutes, enabling

better insight into critical financial information, such as profitability, through the ability to drill-down from business unit levels to customer and account levels

•Generated Oracle Business Intelligence Publisher reports within seconds instead of

minutes when opened through Oracle Essbase Smart View, substantially improving operational efficiency across the organization when delivering 100 new management reports on a monthly basis

•Enabled 300 concurrent users to generate key performance indicators (KPI’s) up to 10x

faster at the customer and contract levels—including economic value added and return on assets—substantially enhancing insight and decision-making capabilities and reducing risk associated with loss-generating customers

•Enabled sales representatives to decide immediately whether a financial product, such as a

mortgage, should be offered to a specific customer or not, based on improved KPI generation

•Provided account managers with accurate, dynamic, drill-down reports to help manage

banking customers more efficiently—as all customer information is kept in one cube and loaded instantly when required

•Loaded the planning cube almost 2x faster and performed complex forecasting calculations

up to 8x faster, reducing data preparation efforts from one day to one hour and enabling staff to spend more time on data analysis

•Used Oracle TimesTen In-Memory Database for Exalytics to build an Oracle Essbase

Aggregate Storage Option reporting cube with 10 million members, from 285 gigabytes of relational financial data—a task that could not have been achieved with the previously used platform—enabling the bank to analyze three years of banking history for

enterprisewide consumption

Why Oracle

“Our long-standing experience with Oracle Business Intelligence and Oracle Exadata has been excellent. To take full advantage of the integrated management and extreme performance of Oracle’s Engineered Systems, we decided to deploy Exalytics In-Memory Machine X2-4 and Oracle TimesTen In-Memory Database for Exalytics as the industry-leading foundation for high-speed analytics,” said Mirko Talajic, business intelligence director, Zagrebacka banka d.d.

(20)

(21)

21

Neuralitic Systems Inc. Improves Customers’

Marketing Initiatives Using Engineered Data

Warehouse to Deliver Mobile Data Intelligence

Neuralitic Systems Inc.

Montreal, Canada www.neuralitic.com Industry: High Technology Employees: 35

• Oracle Exastack Labs

Founded in 2007 and backed by well-known venture capital firms, Neuralitic Systems Inc. is a leading provider of mobile data intelligence solutions that help mobile operators unlock the value of their data to understand subscriber behaviors that influence data service adoption. SevenFlow, Neuralitic’s flagship product, turns massive amounts of unstructured data into compact and usable data sets, ready for use by multiple applications. The company draws its expertise from employees in a variety of fields related to its core business, including IP infrastructure, business intelligence, high-throughput databases, dimensional data modeling, mathematics, and wireless network engineering.

“Oracle Exadata Database Machine enables us to keep up with the constant growth in data volume in the largest mobile networks in the world, which is very important for our continued business development.”

–– Louis Brun, Chief Operating Officer and Founder, Neuralitic Systems Inc.

Challenges and Solutions

Mobile operators are experiencing phenomenal growth in data traffic, including Neuralitic’s customers who report that their traffic is tripling every year. To meet existing and future customer requirements for processing increased mobile data volume, Neuralitic deployed Oracle Exadata Database Machine X2-8 Full Rack to support its SevenFlow solution, where data is collected and continuously batch loaded every 15 minutes and then aggregated nightly, according to several different dimensions.

Oracle Exadata Database Machine enabled SevenFlow to gain 3-times faster processing time performance and also significantly improve its compression rate and scalability by 10 times. With the flexible and scalable Oracle Exadata platform, Neuralitic improved both its solution and its business model as the engineered system has enabled it to focus on developing its application, accelerating revenues, and reducing key development cost components thus, enabling a faster time to market.

With Oracle Exadata Database Machine, Neuralitic met and exceeded extract, transform, and load (ETL) scalability requirements by a factor of 1 to 3 times, and decreased the data aggregation batch window by a factor of 1.5 to 2.5 times, enabling SevenFlow customers to access information more rapidly. Moreover, the Exadata platform enabled Neuralitic to reduce the time needed to produce summary data usage and mobile activity reports by 1.3 to 2.4 times, allowing customers to meet the scaling demands of increased data and to gain deeper insight.

The positive impact for Neuralitic’s customers translates into the ability to support more subscribers and do more with data, and to have a longer retention period. The combination of Oracle Exadata and the SevenFlow application captures 100% of subscribers’ data and enables mobile operators to access detailed information about subscriber behavior. SevenFlow enriches extracted data with labeling elements, such as device name, location name, and customer relationship management information––keeping the focus on delivering meaningful information that can improve marketing effectiveness and the customer experience.

(22)

22 With Oracle Exadata Database Machine, Neuralitic now has a complete range of solutions, enabling it to support any operator, no matter the size. Furthermore, with Oracle Exadata, Neuralitic can halve the time it takes to deploy SevenFlow at customer sites, enabling customers to realize its benefits more quickly and helping Neuralitic to significantly shorten its order-to-revenue cycle.

Why Oracle

“Oracle can see the long-term potential of a relationship, which is a very positive thing when you are a startup like we are, with big ideas and an ambitious plan. Oracle has given us great support in terms of access to the technology through its Oracle Exastack Labs program, so we could perform initial testing and benchmarking. For a young company, such as Neuralitic, it is nice to see Oracle embracing the independent software vendor community with the same focus it dedicates to its resellers,” said Louis Brun, chief operating officer and founder, Neuralitic Systems.

“By using the Oracle Exadata platform, we gain a clear competitive advantage. Where most of our competitors have to spend part of their research and development budget on

developing the optimal system for their application, we can focus on our core business: developing the best mobile data intelligence solution for mobile operators,” Brun said. Neuralitic’s SevenFlow has achieved Oracle Exadata Optimized Status through the Oracle PartnerNetwork. In achieving this status, the application has been fully tested and is certified as supported on Oracle Exadata Database Machine.

(23)

(24)

24

Passoker Optimizes Online Betting with Reduced

Testing and Development Times and the Ability to

Better Assimilate High-Volume, Real-time Data

Passoker

Stockton on Tees, United Kingdom www.passoker.com

Industry:

Media and Entertainment

Oracle Products & Services: • Oracle NoSQL Database, Enterprise Edition

• MySQL Database

• Oracle Glassfish Server

• Oracle Linux

• My Oracle Support

Oracle Partner:

e-DBA

www.e-dba.com

Passoker was founded by Stuart Carr and former England soccer international player Viv Anderson to capitalize on the growing, international, in-play, betting market. Passoker delivers an innovative, multiplatform gaming solution that allows players to place bets on the results of sporting and other events. Players place their bets during the event, not before, as is customary with the traditional, sports-gambling model.

Players can place bets on what they believe will happen next in a wide range of live sporting events. They also can lay wagers on plot developments in television programs, such as soaps and reality shows, as well as on political debates and election results.

Passoker partners with a sports data provider that archives and distributes historical information, critical to gamers’ abilities to instantly assess events. The partner collects, packages, and distributes information on some 60,000 events each year, from more than 30 different sports in approximately 70 countries. The incoming data from this service is used to determine the options available for each of the many events tracked on Passoker’s betting platform, enabling bettors to wager on eventualities, such as the next goal, free kick, or penalty in a particular soccer match.

The size of the global sports betting market––between US$350 billion and US$400 billion per year––illustrates the need for database technology that can cope with exceptionally high volumes of data, providing for high availability, rapid scaling, and guaranteed ordering of events. The partnership allows Passoker to cover a wide variety of sports, receiving in-play and real-time XML database feeds to drive players’ gaming experiences.

“Passoker needed a database technology that could rapidly receive the XML files on which its gaming platform relies, and then quickly process those files for relevance. Also essential were high availability, rapid scaling, and guaranteed ordering of events, all which Oracle NoSQL Database delivered.”

–– James Anthony, Chief Technology Officer, Passoker

•Provide a platform for real-time, sports-data feeds to support the company’s rapidly

expansion of in-play, betting offerings

•Deploy a scalable, efficient, and highly resilient way of dealing with a stream of incoming

data on upcoming and in-progress sports matches and other events

•Enable the platform to receive XML-format, sports-data feeds and rapidly process them for

relevance

•Reduce development times and simplify day-to-day administration for the data

infrastructure that support in-play betting operations

•Scale-out the platform as demand grows and players take up gaming in greater numbers

Challenges

(25)

25 The Oracle solutions’ easy integration, compatibility with existing skill sets, and key-value data model allowed Passoker to rapidly process data for consistency, relevance, and accuracy. Passoker considered open source solutions, such as Voldemort, but chose Oracle NoSQL, in part, because it was integrated with Oracle Linux, Oracle’s MySQL, and Oracle Glassfish Server, which were already in place in Passoker’s environment. In addition, the solution offered professional support instead of having to rely on internet searches to find answers.

Why Oracle

•Deployed Oracle NoSQL Database as the new platform supporting the company’s gaming

solutions, reducing development and implementation times by 75% (saving 30 to 50 days) over other database options, due to Oracle NoSQL’s built-in, configurable replication capabilities

•Enabled Passoker to deploy sports-data feeds sooner than expected, thanks to the 75%

time savings on development and implementation, allowing more time for functional testing and data-quality assurance

•Allowed more time for application development and integration, without worries of basic

technological issues

•Simplified day-to-day administration through a graphical-user/command-line interface,

which is essential for the small team administering a complex product, based on high volumes of unpredictable real-time events

•Simplified rapid correlation between in-progress events and gaming options on the

platform, due to the system’s higher efficiency and performance, as compared to relational database management solutions

•Accelerated adoption of standards-based IT, since Passoker could add off-the-shelf

equipment that supports standards, such as Java, to the existing architecture with minimal adaptation needed

•Improved operational efficiency, due to ongoing commercial support, so that instead of

relying on open source documentation for support, Passoker can log service requests for problem resolution into the My Oracle Support system

•Eliminated daily maintenance related to single-node points-of-failure by moving to Oracle

NoSQL Database, which is designed to be resilient and hands-off, thus minimizing IT support costs

•Used the new system’s compatibility with the existing Oracle MySQL Database

environment to enable cross-referencing with existing data on discrete keys and ensure continuous data streams for the betting platform

•Accelerated time to market for the company’s betting platforms, due to

faster-than-anticipated integration

Solutions

(26)

26

Partner

e-DBA, an Oracle Platinum Partner and expert in Oracle technology, led the

implementation of and provides ongoing support for Passoker’s Oracle NoSQL Database solution. e-DBA scoped Passoker’s requirements, taking account of the unusually high volumes of real-time data that it must assimilate to provide users with the best possible online betting experience.

Oracle NoSQL Database’s scalability as demand grows is also essential, as is high availability and performance to support 24/7 gaming operations.

Oracle NoSQL provided the performance and scalability required to meet the company’s extreme requirements. For example, on the last day of the Premiership soccer season, 20 teams were playing 10 simultaneous matches, as well as all the other leagues which Passoker tracks in real time. Each match would have 400 or more events (where events were

individual actions during the match that could shape the result) and Passoker would need to identify and track a specific 35 to 45 of these events, based on the different bets being placed in the system at any moment. Oracle NoSQL Database scaled out to handle all these events according to demand.

“Moving to Oracle NoSQL Database allowed us to easily replicate, scale, and manage our data infrastructure, significantly reducing our development and testing times,” said James Anthony, chief technology officer, Passoker.

(27)

(28)

28

Starwood Hotels & Resorts Worldwide, Inc.

Manages Hotel Profitability, Worldwide, with

Near-Real-Time Reporting on Engineered Data

Warehouse System

Starwood Hotels & Resorts Worldwide, Inc.

Stamford, Connecticut www.starwoodhotels.com

Industry:

Travel and Transportation

Annual Revenue:

Over US$5 Billion

Employees:

154,000

• Oracle GoldenGate

• Oracle Linux

• Oracle Advanced Customer Support Services

• Oracle Solution Support Center

• Oracle Advanced Monitoring

“Oracle Exadata Database Machine enables us to move forward with an environment that provides our hotel managers and corporate executives with near-real-time information to make optimal business decisions and provide ideal amenities for our guests.”

–– Gordon Light, Business Relationship Manager, Starwood Hotels & Resorts Worldwide, Inc.

Starwood Hotels & Resorts Worldwide, Inc. is one of the leading hotel and leisure companies in the world with 1,112 properties in nearly 100 countries and 154,000 employees at its owned and managed properties. Starwood is a fully integrated owner, operator and franchisor of hotels, resorts and residences with the following internationally renowned brands: St. Regis®, The Luxury Collection®, W®, Westin®, Le Méridien®, Sheraton®, Four Points® by Sheraton, Aloft®, and ElementSM. The Company boasts one of the industry’s leading loyalty programs, Starwood Preferred Guest (SPG), allowing members to earn and redeem points for room stays, room upgrades and flights, with no blackout dates. Starwood also owns Starwood Vacation Ownership Inc., a premier provider of world-class vacation experiences through villa-style resorts and privileged access to Starwood brands.

Starwood Hotels has significantly increased the number of hotels it operates over the past few years through global corporate expansion, particularly in the Asia Pacific region. This has resulted in a dramatic rise in the need for business critical information about Starwood’s hotels and customers. All Starwood hotels globally use a single enterprise data warehouse to retrieve information critical to efficient hotel management, such an that regarding revenue, central reservations, and rate plan reports. In addition, Starwood Hotels’ management runs important daily operating reports from the data warehouse for a wide range of business functions. Starwood’s enterprise data warehouse spans almost all areas within the company, so it is essential not only for central-reservation and consumption information, but also to Starwood’s loyalty program, which relies on all guest information, sales information, corporate sales information, customer service and other data that managers, analysts, and that executives depend on to make operational decisions.

The company is committed to knowing and servicing its guests, yet, “as data growth and demands grew too great for the company’s legacy system, it was falling short in delivering the information hotel managers and administrators required on a daily basis, since central reservation system (CRS) reports could take as long as 18 hours,” said Richard Chung, Starwood Hotels’ director of data integration.

Chung added that hotel managers would receive the transient pace report—which presents market-segmented information on reservations—five hours later than it was needed. Such delays prevented managers from adjusting rates appropriately, which could result in lost revenue. After reviewing several vendor offerings, Starwood Hotels selected Oracle Exadata Database Machine X2-2 HC Full Rack and Oracle Exadata Database Machine X2-2 HP Full Rack, running on Oracle Linux.

(29)

29 “With the implementation of Exadata, Starwood Hotels can complete extract, transform, and load (ETL) operations for operational reports in 4 to 6 hours, as opposed to 18 to 24 hours previously, a six-fold improvement,” Chung said. Real-time feeds, which were not possible before, now allow transactions to be posted immediately to the data warehouse, and users can access the changes in 5 to 10 minutes instead of 24 hours, making the process up to

288-times faster.

Accelerated data access allows all Starwood properties to get the same, up-to-date data needed for their reports, globally. Previously, hotel managers in some areas could not do same-day or next-day analyses. There were some locations that got fresh data and others that got older data. Hotel managers, worldwide, now have up-to-date data for their hotels, increasing efficiency and profitability, improving customer service by making sure rooms are available for premier customers, and improving the company’s ability to manage room occupancy rates. Additional reporting tools, such as those used for CRM and sales and catering also benefited from the improved processing. Other critical reporting has benefited as well. Marketing campaign management is also more efficient now that managers can analyze results in days or weeks instead of months.

In addition, the company is using Oracle GoldenGate to feed data from central reservations systems, other OLTP applications and external vendors, improving ETL times, sometimes making them as much as 100% faster. Moving forward, Starwood plans to use GoldenGate to help the company achieve near-real-time reporting.

Starwood Hotels chose Oracle Advanced Customer Support Services to deliver Oracle Solution Support Center, which provides a technical account manager and a dedicated team of advanced support engineers that work closely with the Starwood team to provide 24/7, personalized support. Finally, Oracle Advanced Monitoring maximizes availability of the company’s database products by continually monitoring and tuning Starwood’s enterprise data warehouse solution.

Why Oracle

“We reviewed a number of vendors, but only one worked best with our architecture. Our data analysis environment requires many complex calculations, with multiple data layers. Oracle Exadata processes the information efficiently, and we have been impressed with the performance improvements. We have used Oracle products for a long time, and choosing Oracle Exadata enables us to preserve existing IT and human capital investments,

particularly in our data warehouse infrastructure” said Marcello Iannuzzi, project manager, Starwood Hotels & Resorts Worldwide, Inc.

The first phase of the implementation involved moving data from the legacy warehouse to Oracle Exadata and involved migrating 26 terabytes of data—which equates to hundreds of billions of rows and approximately 1,500 tables from the previous environment.

(30)

30

Globalia Corporación Empresarial S.A.

Accelerates Hotel Bookings, Boosts Sales by 40%

with In-Memory Data Grid Solution

Globalia Corporación Empresarial S.A. (Globalia), founded in 1997, is a leading tourism group in Spain, based on revenue and number of employees. Globalia is a collection of independent companies, such as tour operators, travel agencies, hotels, an airline, cruise lines, and an airport management company.

“From the outset, Oracle Coherence exceeded our high expectations. It enabled us to reengineer our core system for hotel bookings and deliver quotes that are innovative and pioneering for the Spanish tourism industry. Our return on investment was immediate—since we saved money immediately after go-live and delivered a highly successful summer campaign with strong sales growth. We have already started to redesign additional systems that will leverage Oracle Coherence technology.”

–– Vicente Guerola Molina, Director, Business Development, Globalia Corporación Empresarial S.A.

Globalia Corporación Empresarial S.A.

Llucmajor, Spain www.globalia-corp.com

Industry:

Annual Revenue:

US$1 to US$5 Billion

Employees:

12,000

Oracle Products & Services: • Oracle Coherence

• Oracle Management Pack for Oracle Coherence

• Oracle JRockit

• Oracle WebLogic Server

• Oracle Service Bus

• Oracle Database

• Oracle Java Mission Control

•Meet increasing, ever-changing, tourism-sector business demands with agile IT systems

that can manage tourism revenue accounting and customer interactions from business-to-consumer (B2C) or business-to-business (B2B) channels

•Provide availability, response times, and scalability to meet specific tourism and leisure

industry demands—such as activity peaks during the summer season, Christmas, and long weekends that generate 80% of annual revenue, and complex hotel sales promotion systems that put a huge burden on underlying IT infrastructures

•Support a new business unit designed to expand Globalia’s business to the worldwide

tourism and leisure market by establishing front- and back-end IT systems that can sustain business growth with ambitious service-level agreements (SLA’s)

•Optimize response times to meet group and third-party SLA’s for Welcome, the company’s

proprietary, hotel-booking system, so that it serves 95% of requests in less than 700 milliseconds—ensuring that users don’t abandon searches not answered within 2 seconds

Challenges

•Deployed Oracle Coherence, Oracle JRockit, and Oracle WebLogic Server to move

business logic from database to middleware tier, reducing IT costs and enabling new business models, based on expanded system capabilities—such as Globalia’s powerful, proprietary B2C and B2B channel for selling hotel rooms

•Used Oracle Coherence to reengineer proprietary hotel booking platforms, responsible for

daily revenue of up to US$1.35 million, with a year-on-year growth rate of 100%

•Introduced a data grid that supports highly complex business rules for sales promotion,

which boosted sales by 40% for the 2012 summer campaign, compared to the previous year’s seasonal sales

Solutions

(31)

31

•Established a future-proof system that is dimensioned to support 2.5 million B2C and

B2B requests per day—such as bookings, confirmations, and cancellations for air and ground travel, hotel rooms, and more—and provide linear scalability for expected growth, while the previous systems were limited to 100,000 requests per day

•Guaranteed low latency for B2C and B2B counterparts—who will reject Globalia’s product

offerings if they do not receive an immediate response to requests—providing an average response of 100 milliseconds for a request involving 80 hotels, while the old system required up to 30 seconds to process requests during peak hours

•Eliminated database outages due to system changes—such as updates for improved

promotions—and reduced database usage by 40%, enabling database utilization for other purposes, such as administering data for the group’s tour operators Travel plan and MK Travelplán, which meet tourism demands in Spain and North America

•Made it easier to roll out new promotions with Oracle Coherence’s ability to make

modifications while the cluster is in production mode, reducing time-to-market for new products and services from days to minutes

•Used Oracle Enterprise Manager Cloud Control’s Grid Control feature with Oracle

Management Pack for Oracle Coherence to manage and monitor the entire system—nine physical servers, with four dedicated to the company’s proprietary hotel booking platform, that host 28 Oracle Coherence nodes for 30 gigabytes of live data—which has been configured with customized alerts to detect potential problems, such as low cache hit rates

•Used Oracle Database as the main source of information, with efficient data loading when

a cluster needs to be initialized from scratch, as well as data synchronization to update information when the cluster is running

•Worked with Oracle Consulting to achieve a successful go-live within four months in June

2011, in time to deal with summer tourism

Why Oracle

“We trust in Oracle for mission-critical systems and considered Oracle Coherence to be the best approach. The data grid, aligned with our strategy to move business logic from the database to the middleware tier, offers all the features that we need to meet our technical and business requirements. Oracle executed a 15-day, proof of concept that demonstrated Oracle Coherence’s ability to meet and exceed our requirements,” said Vicente Guerola Molina, director, business development, Globalia Corporación Empresarial S.A.

(32)

32

Sabre Holdings Processes More than 200 Million

Daily Transactions, Integrates Over 50 Data

Sources, and Accelerates Platform Migrations

Sabre Holdings

Southlake, Texas www.sabre.com

Industry:

Annual Revenue:

US$1 to US$5 Billion

Employees:

Approximately 10,000

Oracle Products & Services: • Oracle GoldenGate

• Oracle Data Integrator

• Oracle Database 11g

• Oracle Real Application Clusters

Oracle Partner:

HP

www.hp.com

Sabre Holdings is a global travel technology company serving the world’s largest industry— travel and tourism. The company provides software to travel agencies, corporations, travelers, airlines, hotels, car, rail, cruise, and tour operator companies through four businesses: Sabre Travel Network, Sabre Airline Solutions, Sabre Hospitality Solutions, and Travelocity. More than 1 billion people worldwide use Sabre’s innovative technology to plan, book, and get to their destination at a time and price that is right for them. As the company captures an extremely high volume of transactional data in its reservations, booking, and ticketing systems—among others—it depends on a comprehensive, enterprisewide data warehouse to store, manage, and analyze this information. Sabre also offers a broad range of business intelligence products—that utilize the data warehouse—to provide its customers with the true business intelligence they need to improve their operations, performance, and customer service.

Sabre is focused on innovation and uses leading-edge and flexible technologies—like Oracle Data Integrator and Oracle GoldenGate—for migrations to new systems and with its data warehouse and business intelligence solutions, all which contribute to the company’s success in providing its travel industry customers with the best possible service and information to drive their businesses.

“The unique thing about Sabre Holdings is that we use Oracle technologies to offer products to our customers as well as using them internally to help Sabre run our business more effectively and understand trends and dynamics in the travel industry.”

–– Jessica Thorud, Director, Sabre Holdings

Accelerating Integration as Data Sources and Volumes Expand

Sabre invested in developing data warehousing and business intelligence solutions to meet customer needs that provide timely marketplace and customer insights. These solutions have provided value-added offerings beyond Sabre’s traditional products, enabling the company to retain and grow its customer base while enabling its customers to improve their service offerings.

Sabre launched its data warehouse in early 2003, with four source systems for input. Sabre was using highly customized shell scripting in UNIX to load data into the warehouse and as the number of data sources continued to grow, this process was labor intensive and did not provide reusability for future products.

As the number of data sources and customers grew, managing data integration timelines and reporting schedules for internal and external customers became more challenging. Sabre decided it needed a consolidated platform to quickly bring many new data sources into the warehouse—without requiring the technical know-how for each unique data source format. After evaluating several options, Sabre selected Oracle Data Integrator to meet this need. When Sabre first implemented Oracle Data Integrator, there were approximately 7 data sources being integrated into the warehouse.

(33)

33 Today, the number of data sources stands at 53, which includes core transactional sets like travel booking and ticketing data, as well as controlled data, like airport latitude/longitude, carrier operational data, customer check-in information, and traveler profile data. The frequency of loading inbound source systems into the data warehouse ranges from trickle feeds to batch files, which vary from every 15 minutes to daily, weekly and monthly. Sabre also uses Oracle Data Integrator for outbound scheduling of data extracts to customers. “When we first started using Oracle Data Integrator, we had 3 applications, which has grown to 172 applications with more than 3,000 applications executions each day,” said Jessica Thorud, director, Sabre Holdings. “Our job executions vary in frequency, from every three minutes to monthly, and when you multiply that number by the number of

applications and customers, our schedule is saturated. That’s all managed by ODI now, which has allowed Sabre to increase productivity and efficiency in development and time to market for enhancements and new solutions.”

Today, Sabre processes approximately 200 million transactions each day through Oracle Data Integrator and approximately 48 million daily transactions through Oracle GoldenGate. The company’s data warehouse environment holds 25 terabytes of data.

Sabre offers a diverse range of data and business intelligence products, from dashboards enabling airlines to measure performance against key performance indicators (KPIs), to a series of prepackaged reports designed for business users, to structured data extracts for customers wanting to run and create their own data warehouses.

Use of Oracle Data Integrator’s scheduling capability improved reliability in customer data extract deliveries through automation and monitoring of the scheduled executions. Sabre also uses Oracle GoldenGate to replicate eight sources directly from source systems on a real-time basis. The only latency in this process is network latency—less than one-300th of a second. “The unique thing about Sabre is that we use Oracle technologies to offer hosted products to our customers as well as using them internally, to help Sabre run our businesses more effectively and understand trends and dynamics within the travel industry,” Thorud said.

While the number of data sources was increasing, Sabre was also expanding its development centers globally, first from Southlake, Texas to Krakow, Poland, and then adding a center in Bangalore, India. As the development teams expanded globally, Sabre needed to standardize the development process for integrating data. When Sabre started using Oracle Data Integrator, it built standardization into the ODI, providing the framework to better control the development process, worldwide. In addition, Sabre used the product’s framework to plug data quality checks into new projects efficiently.

“Oracle Data Integrator helped us build the framework and then provide that framework to development teams across multiple development centers to help build products,” said Amjad Saeed, development and operations manager, Sabre Holdings.

Expanding to New Development Centers

INFORMATION FOR SUCCESS

INFORMATION

FOR SUCCESS

Oracle Fast Data Customer Reference Booklet

Table of Contents

BT Increases Sales and Customer Retention with

Real-Time Decision-Making Tool for Customer

Advisors

Tata Sky Ltd. Processes 1 Million Customer

Requests per Day, Resolves Queries 25% Faster

Türk Telekom Significantly Improves Performance

with Turkey’s First Asynchronous, Real-Time

Archiving Solution

Turkcell iletisim Hizmetleri A.S. Uses

Engineered System to Analyze 10 Billion Daily,

Call-Data Records and Service Logs and to

Generate 100,000 Monthly Reports

Woori Bank Cuts Customer Credit Rating

Assessments from Three Hours to 15 Minutes,

Generates Management Reports in 10 Minutes

Instead of Five Hours

Zagrebacka banka d.d. Reduces Complex

Calculations from Hours to Minutes with

Engineered Business Intelligence

Neuralitic Systems Inc. Improves Customers’

Marketing Initiatives Using Engineered Data

Warehouse to Deliver Mobile Data Intelligence

Passoker Optimizes Online Betting with Reduced

Testing and Development Times and the Ability to

Better Assimilate High-Volume, Real-time Data

Starwood Hotels & Resorts Worldwide, Inc.

Manages Hotel Profitability, Worldwide, with

Near-Real-Time Reporting on Engineered Data

Warehouse System

Globalia Corporación Empresarial S.A.

Accelerates Hotel Bookings, Boosts Sales by 40%

with In-Memory Data Grid Solution

Sabre Holdings Processes More than 200 Million

Daily Transactions, Integrates Over 50 Data

Sources, and Accelerates Platform Migrations