The Portland Group
CSCS Top Right Frontpage
HPCwire

Since 1986 - Covering the Fastest Computers
in the World and the People Who Run Them

Language Flags

Visit additional Tabor Communication Publications

Enterprise Tech
Datanami
HPCwire Japan

Diio, Vertica Improve Aviation Market Planning Decisions


BILLERICA, Mass., Nov. 20 -- 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/.

Most Read Features

Most Read Around the Web

Most Read This Just In

Most Read Blogs


Sponsored Whitepapers

Breaking I/O Bottlenecks

10/30/2013 | Cray, DDN, Mellanox, NetApp, ScaleMP, Supermicro, Xyratex | Creating data is easy… the challenge is getting it to the right place to make use of it. This paper discusses fresh solutions that can directly increase I/O efficiency, and the applications of these solutions to current, and new technology infrastructures.

A New Ultra-Dense Hyper-Scale x86 Server Design

10/01/2013 | IBM | A new trend is developing in the HPC space that is also affecting enterprise computing productivity with the arrival of “ultra-dense” hyper-scale servers.

Sponsored Multimedia

Xyratex, presents ClusterStor at the Vendor Showdown at ISC13

Ken Claffey, SVP and General Manager at Xyratex, presents ClusterStor at the Vendor Showdown at ISC13 in Leipzig, Germany.

HPCwire Live! Atlanta's Big Data Kick Off Week Meets HPC

Join HPCwire Editor Nicole Hemsoth and Dr. David Bader from Georgia Tech as they take center stage on opening night at Atlanta's first Big Data Kick Off Week, filmed in front of a live audience. Nicole and David look at the evolution of HPC, today's big data challenges, discuss real world solutions, and reveal their predictions. Exactly what does the future holds for HPC?

Newsletters

Stay informed! Subscribe to HPCwire email Newsletters.

HPCwire Weekly Update
HPC in the Cloud Update
Digital Manufacturing Report
Datanami
HPCwire Conferences & Events
Job Bank
HPCwire Product Showcases


Xyratex

HPC Job Bank


Featured Events


HPCwire Events