Can someone please list out the advantages of HP Vertica over MS SQL Server 2008.
Currently we are using SQL Server 2008. We deal with millions of records. We need to confirm whether moving to Vertica will give us any edge comparing to SQL Server 2008.
Thanks in advance.
Advantages of Vertica over MS SQL Server 2008
Moderator: NorbertKrupa
Re: Advantages of Vertica over MS SQL Server 2008
Hi!
>> advantages of HP Vertica over MS SQL Server 2008
No advantages:
- Running on Linux only
- No specialized GUI client
- By default everything is in command line
- Slow INSERT/DELETE
- No Stored Procedures
but one good point I can say: Vertica just fast and returns results, not just beautiful report "TOPN Tables"
>> We deal with millions of records.
Are data less than 1TB? So you are lucky you can try Vertica Community Edition (license : 1TB raw data, 3 nodes), except license there are no differences between Enterprise Edition and Community Edition. I think that a short POC/pilot with main tables/queries should answer to you better if Vertica satisfies your needs.
IMO: wrong question.
Vertica isn't swiss knife, it has it own niche: Real Time DWH with advanced analytics features for Finance/Telco and other markets.
What do you have as service? What do you need? That's correct questions.
I will start and may be other members will add questions you need to ask (and answers of cause):
- you need analytical database
- you dealing with BigData (for small data other vendors can be faster and as platform richer than Vertica)
- your business logic is't coupled too much to the current solution (Vertica has no SP, so migration of business logic can be painful. A lot of banks dreams to do migration from current old solution, but business logics stops them)
- you have no UPDATES (or less than 5% of total data) (in DWH data shouldn't be changed at all)
- data mostly loaded in batches and not in INSERTs (Vertica isn't good with it)
- you think to build cluster (Vertica is MPP, but you will lose a lot from MPP if your system will be a single node cluster)
Good Luck
>> advantages of HP Vertica over MS SQL Server 2008
No advantages:
- Running on Linux only
- No specialized GUI client
- By default everything is in command line
- Slow INSERT/DELETE
- No Stored Procedures
but one good point I can say: Vertica just fast and returns results, not just beautiful report "TOPN Tables"
>> We deal with millions of records.
Are data less than 1TB? So you are lucky
you can try Vertica Community Edition (license : 1TB raw data, 3 nodes), except license there are no differences between Enterprise Edition and Community Edition. I think that a short POC/pilot with main tables/queries should answer to you better if Vertica satisfies your needs.IMO: wrong question.
Vertica isn't swiss knife, it has it own niche: Real Time DWH with advanced analytics features for Finance/Telco and other markets.
What do you have as service? What do you need? That's correct questions.
I will start and may be other members will add questions you need to ask (and answers of cause):
- you need analytical database
- you dealing with BigData (for small data other vendors can be faster and as platform richer than Vertica)
- your business logic is't coupled too much to the current solution (Vertica has no SP, so migration of business logic can be painful. A lot of banks dreams to do migration from current old solution, but business logics stops them)
- you have no UPDATES (or less than 5% of total data) (in DWH data shouldn't be changed at all)
- data mostly loaded in batches and not in INSERTs (Vertica isn't good with it)
- you think to build cluster (Vertica is MPP, but you will lose a lot from MPP if your system will be a single node cluster)
Good Luck