|
Diio Teams with Vertica to Improve Aviation Market Planning Decisions
Thursday, November 20, 2008
Vertica's blazingly fast analytic database reduces query wait times from 20 minutes to 8 seconds over traditional database engine
BILLERICA, Mass., Nov. 20 /PRNewswire/ -- Market intelligence firm Diio is
enabling airlines to make wiser network planning decisions and potentially
greater profits, thanks in part to new ultra-fast database technology from
Vertica.
Diio has implemented the Vertica Analytic Database to power a web-based
aviation market intelligence tool for analyzing airline passenger demand.
Major airlines around the world use the data to continuously monitor route
performance and passenger behavior. They rely on fast access to more than one
billion passenger itinerary records stored in Vertica. Additionally, many
major airports around the world use the data to monitor passenger traffic
patterns in their regions, as well as to attract new airline services. Diio
partnered with Vertica to optimize this web-based tool because the
ever-growing influx of data combined with sophisticated query demands was
overwhelming the system's traditional database engine.
"We're thrilled with Vertica's performance," said Max Klee, Diio
architect. "Large numbers of concurrent users were eating us alive -- queries
could take as long as 20 minutes to execute. With Vertica as our new database
platform, queries average around eight seconds, even under maximum user loads.
It's vital for our clients to be able to do extremely fast analysis to
optimize market performance and maximize revenue in today's dynamic air
service environment. With Vertica driving the application, users don't have to
sit and wait to make those decisions."
Vertica is a grid-based, column-oriented database built to handle massive
analytic workloads such as those experienced by Diio. With its aggressive data
compression and columnar storage, the Vertica Analytic Database enables Diio
to store and analyze much larger volumes of passenger data and run queries
orders of magnitude faster than conventional relational databases. Vertica is
self-optimizing, which eliminates manual tuning and configuration overhead;
combining that with its economic use of hardware and highly differentiated
performance makes it an ideal database to embed within commercial analytic
software and appliances.
Cloud Computing Facilitated the Evaluation of Vertica
Diio also took advantage of Vertica's cloud-based offering to lower the
cost of evaluating the Vertica Analytic Database. The Diio IT infrastructure
consisted entirely of Sun hardware running Solaris, and rather than purchase
new x-86-based Linux hardware just to test Vertica, Diio had a one-node
Vertica for the Cloud instance created. Diio loaded the cloud with a billion
rows of data and then performed extensive head-to-head performance tests
against a fully optimized production row-oriented database. Vertica for the
Cloud out-performed Diio's production system, and they eventually decided to
license Vertica and bring it in house. The cloud was such an easy, scalable
environment that Diio may consider it for future projects.
"Leading carriers realize that advanced tools with fast access to huge
data stores are required to analyze airline passenger demand," said Colin
Mahony, Vertica's senior director of business development. "Historically,
these tools have been expensive to buy, slow to perform and cumbersome to use.
By using Vertica, Diio has provided its clients with an affordable yet highly
accurate tool with the blazingly fast responsiveness needed to out-perform
their competitors."
About Diio
Diio is Data in, Information Out. Diio has worked since its inception to
develop unique capabilities for processing voluminous and complex market
intelligence data. Diio designs and builds its tools with user interfaces that
are both easy-to-use and highly effective, helping its customers distill data
into actionable information. Diio is also an industry leader in providing its
clients with valuable advisory services, as the firm's superior quantitative
capabilities are complemented by exceptional communication skills. With its
roots in the aviation sector, Diio has an impressive history of improving the
analytical capabilities of many of the world's largest and most technically
sophisticated airlines. Diio has created Internet-based aviation data products
that have revolutionized market intelligence for the aviation industry. In
fact, airlines providing over half of the world's capacity currently use Diio
products, including 17 of the Top 20 carriers in North America. More
information on Diio can be found at http://www.diio.net.
About Vertica
Vertica Systems is the market innovator for high-performance analytic
database management systems that run on industry-standard hardware. Co-founded
by database pioneer Dr. Michael Stonebraker, Vertica has developed grid-based,
column-oriented analytic database technology that lets companies of any size
store and query very large databases orders of magnitude faster and more
affordably than other solutions. The Vertica Analytic Database is available as
software only, as an appliance or online as a cloud computing solution. The
technology's unmatched speed, scalability, flexibility and ease of use helps
customers like JP Morgan Chase, Verizon, Mozilla, Comcast, Level 3
Communications and Vonage capitalize on business opportunities in real time.
Vertica is headquartered in Billerica, Mass. For more information, visit the
company's Web site at http://www.vertica.com.
SOURCE Vertica
|
|
|
|
 |
Banks ‘run system of virtual extortion’ | Jan 8, 2009
|
|
Microsoft's Ballmer: Windows 7 is nearly final | Jan 8, 2009
|
|
Brave techies can try Microsoft's new Windows 7 | Jan 8, 2009
|
|
Mediation board declares Delta, NWA a single system | Jan 8, 2009
|
|
WMS Software supports Oracle and SQL Server platforms. | Jan 8, 2009
|
|
Latest Windows operating system ready | Jan 8, 2009
|
|
The Princeton Review and USA TODAY Present The Princeton Review's 100 'Best Value Colleges for 2009' | Jan 8, 2009
|
|
Online Reputation Management Important For Small Businesses Too | Jan 8, 2009
|
|
Microsoft Research Helps Novice Musicians Discover Their Inner Songwriters | Jan 8, 2009
|
|
Microsoft Mediaroom Gets More Power and Gives TV a Reverse Gear | Jan 8, 2009
|
|
|
