BILLERICA, Massachusetts, November 20 /PRNewswire/ --

- Vertica's blazingly fast analytic database reduces query wait times from 20 minutes to 8 seconds over traditional database engine

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

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

Ed Marshall of Beaupre Co. Public Relations for Vertica, +1-603-559-5816,,