|
Resources
Customer App Catalog
Vertica Analytic Database Cloud Edition
|
|
Average Review:
|
|
The Vertica Analytic Database Cloud Edition is a high-performance column-oriented SQL database hosted on Amazon Elastic Compute Cloud (EC2). Use it on a pay-as-you-go basis (for a monthly fee) to store and query terabytes of data.
|
| Company:
|
|
| Inquiry e-mail address:
|
download@vertica.com |
| Amazon Web Services used:
|
- Amazon S3
- Amazon Elastic Compute Cloud (Beta)
- Amazon Flexible Payments Service (Beta)
|
| Solution URL:
|
http://www.vertica.com/cloud |
| Audience:
|
Developers |
| Pricing:
|
For a fee |
| Description |
Vertica’s column-oriented grid database architecture, aggressive data compression, and automatic tuning make it the fastest database in the cloud. It scales easily from 100s of gigs to 100s of terabytes.
It’s ideal for short-lived business intelligence projects, analytic SaaS companies (providing out-sourced analytics) looking to get to market fast with a competitive performance advantage.
The monthly Vertica Cloud Edition fee is determined by the amount of raw user data you manage and includes Vertica Analytic Database and EC2 usage, Amazon S3 fees for data backup and technical support.
Vertica works with any SQL application via ODBC/JDBC, Ruby, Python, PHP, and others.
|
|
|
Great environment for try-before-buy for this revolutionary product, May 12, 2008 7:30 PM
Reviewer: Kenneth M. Klee
I work for an organization which hosts sensitive mission-critical strategy data for the travel industry. We were starting to get fed up with the sluggish performance of our Oracle database on our larger data sets when we first discovered Vertica. We had heard that Vertica could help us achieve 10x speed improvements over Oracle while running on (relatively) cheap Linux boxes. However, our IT infrastructure consisted entirely of Sun hardware running Solaris, and we weren't ready to jump into purchasing new hardware with a different O/S just to test out this promising new database.
Enter the cloud. The Vertica engineers worked directly with me to set up a one-node test environment in a cloud where we could evaluate Vertica without the expensive commitment of buying any new hardware. We loaded up Vertica with almost a billion rows of dummy data and then performed extensive head-to-head tests, comparing results from our fully optimized, live Oracle database with the cloud's un-optimized single-node Vertica database which only used super-projections.
Although this test wasn’t quite fair, we still found Vertica to be 3-4 times faster than Oracle. And that was without investing any time into building specialized projections or deploying Vertica in a multi-node cluster. I’m quite convinced that had we added more nodes and some specialized projections we would have seen 10x or greater performance improvements from Vertica. The cloud was such an easy, scalable environment that we would have liked to continue using the Vertica database there with our real data. However our executive team decided that since our data was quite sensitive that it would be better for us to maintain direct control over all harware. So we ultimately decided to purchase our own hardware and run Vertica in-house after testing it in the cloud for many months. Even so, the cloud remains an option for future expansion with less sensitive data sets.
|
|
|
|
 |
|
|
Sign in to the AWS Management Console
Create an AWS Account
