• 2 trillion rows of financial trade data analyzed in Vertica
• 450 trillion rows of internet gaming data analyzed in Vertica
• 1 trillion rows of call detail records analyzed in Vertica
• 500 billion rows of weblog data analyzed in Vertica
• 300 billion rows of airline passenger traffic data analyzed in Vertica

What is Vertica?

The leader in analytic DBMS price/performance:
• Columnar DBMS
• Scale-out MPP architecture
• Aggressive data compression
• Real-time loading & querying
• Automatic tuning, HA and recovery
• Runs on Linux, VMware or Amazon Cloud

Industry Focused Business Solutions.


Use Vertica to store and query CDR, SNMP, IPDR, and other subscriber / network data for: • Revenue assurance • Service assurance • Network performance management • Customer experience management	"Vertica opened doors to analyses that otherwise were either too time-intensive or impossible. A larger team of business managers now have faster, easier access to more information. That knowledge is invaluable in an aggressively competitive market like ours."


Store and analyze all your tick data in Vertica: • Back-test against larger volumes of historical data • Create faster, less costly compliance applications • View trade & quote data over longer time periods • Analyze more financial instruments, markets & geographies	"The Vertica Database provides us with a solution for cost-effectively storing large market data time series and trade repositories, and for quickly performing and processing complex analyses of the data."


Use Vertica to store and query clickstream and log data to: • Perform customer behavior analysis • Store & analyze more game history • Conduct real-time, in-game A/B tests • Determine effectiveness of in-game promotions	"With over 40 million players, 3TB of new data a day and 230 nodes spread across two clusters Zynga's columnar data warehouse from Vertica is no analytical windup toy."


Use Vertica in the healthcare industry for: • Claims data analysis • Revenue management applications • Fast analysis of millions of patient data records • Efficiently analyzing clinical data with hundreds of columns	"The results were so astounding that I didn't believe it at first. One query on our Medicare database ran so fast - five milliseconds - that I told my team member that he must have misunderstood the units. That he must have meant five seconds."


Use Vertica in Retail industry for: • Customer behavior at the transaction level • Loyalty analysis on millions of customers • SKU level sales and inventory analysis • Marketing campaign metrics at any level of detail	"After looking at several alternatives, we selected Vertica because it simply delivers the answers the business needs in record time and at much lower cost than the other databases and appliances we evaluated."

MPP COLUMN DATABASES FOR DATA WAREHOUSING

The Rise of Column Databases and MPP Databases for Data Warehousing

Over the last decade, data warehouses have been pushed to answer more ad-hoc questions from more people analyzing vastly larger volumes of data warehouse data, often in real time.

The problem is, traditional data warehouse databases like Oracle, were written 30 years ago and struggle to support the analysis of large, fast-growing volumes of data warehouse data by lots of users.

Recently, scores of new data warehouse databases have entered the market. There are two major DBMS innovations transforming data warehousing:

Column Databases

Unlike row databases such as Oracle or MySQL, column databases answer queries much faster because they only read the data columns referenced by the query (row databases must scan every row and column in the table). Columnar data is also more compressible than row data because the values in a column are much more homogenous. Column database compression can reduce database size by a factor of 20x, which further speeds up performance and lowers storage costs.

MPP Databases

Also known as shared-nothing databases, massively parallel processing (MPP) technology allows data warehouse databases to work faster by spreading (partitioning) the data and the workload across a cluster of inexpensive servers. MPP databases can also grow bigger and more inexpensively than traditional databases; just add servers to the MPP cluster to increase performance or storage.

MPP Column Database

While many of the new data warehouse database products support either MPP (e.g., Netezza) or Column (Sybase IQ), Vertica is the only data warehouse database to include BOTH of these innovations as well as many other innovations like automatic tuning, recovery and high-availability, trickle loading, and just-in-time decompression, etc. As a result, Vertica runs faster on less hardware than any other data warehouse database.

Latest from Vertica

RT @multithreading: @jameskobielus Most "normal" databases are row based like #Oracle and #SQL Server. #Vertica is column based. Columns ...
RT @multithreading: I could not go back using a regular SQL database for data warehousing. #Vertica runs circles around #SQL Server and ...
if you're in Seattle, come here David Botkin, Playdom's VP of BI, talk about using @vertica & @tableau #tcc2010
Check out Michael Stonebraker's Top 10 Assertions about Data Warehouses http://goo.gl/7iNW no. 2 C-store DBs will dominate the DW market
RT @ccgillett: Doing big analytical rollups w/Vertica: unique-ing, grouping, ordering on 50M rows in 500 milliseconds puts a smile on my ...
RT @cpmahony: @EventCloudPro I promise you @Vertica's MR strategy is NOT proprietary MR using UDF's- there is a far better approach. Sta ...