Information about http://www.mysql.com/why-mysql/case-studies/mysql-pivex-casestudy.pdf
Behind the Scenes with MySQL Pivex Folio Exchange MySQL Makes…
Tags: account reconciliation, accounts receivable system, american airlines, american airlines vacations, bollinger, business environment, car rental agencies, continuous uptime, efficiencies, hospitality industries, hotel clerks, innovative solutions, outrigger hotels resorts, pleasant hawaiian holidays, receivable systems, reconciliation issues, resorts travel, tight margins, travel and hospitality, travel wholesalers,Pages: 4
Language: english
Created: Tue Jul 20 08:32:14 2004
Display cached document
Page 1
Page 2
Page 3
Page 4
Behind the Scenes with MySQL
Pivex Folio Exchange
MySQL Makes Travel & Hospitality Profits Soar
Pivex, headquartered in Denver, Colorado, provides
innovative solutions to increase efficiency and profit for
the travel and hospitality industries. Pivex has processed
over $200 million in billings for some of the world's lead-
ing travel wholesalers and hotels including American
Airlines Vacations, Pleasant Hawaiian Holidays, and
Outrigger Hotels & Resorts.
Travel wholesalers and hotels typically rely on time-
consuming and error-prone, manual keying of invoices
and payments into their respective accounts payable and
accounts receivable systems. For example, it could take
6 hotel clerks all day to manually key a single wholesaler
invoice into their accounts receivable system. Entry errors
from such extensive, repetitive keying led to frequent
account reconciliation issues with business partners.
For hotels, resorts, and car rental agencies, getting paid
on-time often became a challenge. Plus, payments
received near the end of the month often made it hard
to close the books in a timely manner.
Working in a business environment with tight margins,
travel wholesalers and hotels are always looking for ways "In three years of operation,
to reduce manual labor costs, increase business process
efficiencies and ultimately improve profitability. MySQL has processed over
$200 million in invoice
transactions with continuous
uptime."
Joe Bollinger
CEO, Pivex
Behind the Scenes with MySQL Pivex
MySQL Delivers Reliability, Performance & Cost-savings
To solve this problem, Pivex Reliability
developed Folio Exchange, a
Pivex needed a database with
centralized electronic hub that
proven reliability. Pivex's clients
seamlessly connects hotels
are located across the US as
and resorts electronically with
well as internationally, so
traditional travel wholesalers,
providing a system that was
internet resellers, tour opera-
available 24x7 was critical.
tors, and airline affiliates.
Database reliability is the key to
Folio Exchange is a complete delivering on Pivex's core value
turn-key solution which elimi- improving the profitability of
nates up to 90% of the costs their business partners
of submitting invoices and
remitting payments between
partners. Using Folio Exchange, Performance
tasks that used to take 6 clerks
Pivex required a system that
an entire day are now complet-
was high-performance and able
Cost
ed in less than 30 seconds.
to provide the transactional Pivex considered Oracle and
MySQL provides the database
capabilities for electronic Microsoft SQL Server. However,
reliability and performance
billing between trading partners. after investigating licensing,
that contributes to this massive
MySQL's pluggable storage support and maintenance terms,
labor savings.
engine architecture gave them MySQL proved to be the most
the power and flexibility to cost-effective solution for Pivex.
make Folio Exchange successful. After factoring in the perform-
ance and reliability, MySQL
became the clear winner.
Flexibility of a Pluggable Storage Engine
The primary value of Folio The Folio Exchange "Keying a large Pleasant
Exchange is that it converts,
Folio Exchange is a complete Hawaiian Holidays payment
reconciles, and processes
turn-key solution which
transactions in real-time
eliminates paperwork and used to take 6 clerks all day but
between hotels, resorts, and
all manual effort for Hotel -
travel wholesalers world-wide. now is fully automated thanks
Wholesaler invoicing and
The InnoDB storage engine
remittance. Folio Exchange
is used to reliably process to MySQL and Folio Exchange.
is built on the LAMP (Linux,
the summary information of
Apache, MySQL, PHP) open Eliminating the manual effort
individual invoices. Plus,
source stack. MySQL is the
each invoice contains large
database that powers Folio required to key these large
amounts of detail information
Exchange to:
amounting to over 2 million wholesaler payments allows
rows. MyISAM is a low over- x Turn hours of costly manual
head storage engine and is effort into automated my staff to focus on key
used to enable fast look-ups electronic processes
of this information allowing business tasks such getting
x Automates invoice approval
users to instantly locate the
and resolves problem our books closed faster and
details of any invoice or
invoices faster
payment in the system. As a more accurately."
result, users are amazed how x Accelerates payment cycles
fast 18 months of invoices and greatly improving cash Sharon Matsumoto
can be viewed on the screen. flow Credit Manager
Aston Hotels & Resorts
How It Works
Traditional Wholesalers
Core Wholesale Business Your Hotels and Resorts
Linked to Your Customers
Tour Operators Through One Simple Interface
Books Groups and Tours
Airline Affiliates
Bundles Rooms and Flights Folio Exchange
The Central Hub That Seamlessly
Internet Resellers Connects You to Your Wholesalers,
Internet Based Reseller Converts, Reconciles and Processes
Transactions in Real Time.
Foreign Wholesalers
Internationally Based
Folio Exchange changes the economics of Wholesaler business transactions creating
the opportunity to reduce overhead, payroll costs, and increase profitability.
Technical Environment About MySQL AB
Hardware: Dell Poweredge 2650 MySQL AB develops and markets a family of high
performance, affordable database servers and
OS: Red Hat Linux
tools. The company's flagship product is MySQL,
CPU: Dual XEON, 1.8 Ghz the world's most popular open source database,
RAM: 1.5 GB RAM with more than 5 million active installations.
Many of the world's largest organizations, includ-
Storage: 5 x 18gb Ultra 160 Raid Array ing Yahoo!, Sabre Holdings, Cox Communications,
Language: PHP, JavaScript The Associated Press and NASA, are realizing
significant cost savings by using MySQL to power
Database: MySQL Server Web sites, business-critical enterprise applications
Database Size: x 4 Gb and packaged software. MySQL AB is a second
x 3 million records generation open source company, with dual
x >100 tables licensing that supports open source values and
methodology in a profitable, sustainable business.
For more information about MySQL, please go to
www.mysql.com.
MySQL Worldwide Offices
North America Headquarters Worldwide Headquarters
2510 Fairview Avenue East Bangårdsgatan 8
Seattle, WA 98102 USA S-753 20 Uppsala
+1-425-743-5635 P Sweden
The World's Most Popular Open Source Database
+1-425-671-0771 F +46-730-234-111 Sales
France Spain, Portugal, Latin America
+33-(0)1-43-077-099 +1-425-373-3434
Copyright © 2004, MySQL AB. MySQL is a registered trademark
of MySQL AB in the U.S. and in other countries. Other products Germany, Austria, Switzerland Finland
mentioned are the trademarks of their respective corporations. +49-(0)7022-9256-30 +358-(0)-9-2517-5553