Databases
StackOverflow2013
Postsdbo
POVertica Overall
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POVertica Overall
    text
    copied!<p>Hi all, my company and I are looking for a product that can give a hand in taking off some loads (big once) from OLTP databases! So we have stumbled on Vertica. After some tests and studies for the last 2 months we have decided that we will hit our customers with our new product (is not our is Vertica's product). Well all good and nice until the license price hit in!! And as everybody know there are not to many databases that run on more than 5 TB or at least we don't have to many!! or maybe none !! Ok, so I will get to the point!! At what point does Vertica pays off!! And I would like to compare it with Oracle. We all know Oracle license is yearly and is on top to core/proc/mem etc... ; Vertica on the other side it's license costs is up to TB use and I will bold this ROW DATA is not compressed data. </p> <p>So the question is: <strong>At what point (database size) would Vertica will be a good choice?</strong></p> <p>This point can be let's say a 5 TB database using for 5 year Vertica will bring you a benefit of XXX % in comparing it with ORACLE or SQL SERVER. Good to remember Vertica has it support service at 21 % of total license purchase price. I mean no offense to any of the company's cited in this text nor i am trying to promote none of them!! I am just looking for an opinion and please if any of my statements are wrong fell free to correct me. I have no doubts that there are companies that implemented Vertica and done their market studies along with strong bench-marking tests, so fell free to share the knowledge. As well I know this is such a general question with so many answers and opinions, all of them are welcomed!! Thank you all!!</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload