All Forums General
omarsaeed22 17 posts Joined 11/13
21 Nov 2013
MVC Tool

Hi Guys,
Can you please provide the MVC tool? Is it possible to download it from any website?
 
Thanks.

MOHAMMAD OMAR SAEED
M.Saeed Khurram 544 posts Joined 09/12
21 Nov 2013

What do you mean by MVC tool? If you are talking about Teradata Multi Value Compression, then you only have to define the Compression values in the Column definition which you want to compress and Teradata will handle it automatically.
 

Khurram

pietro.nardella 7 posts Joined 06/10
25 Nov 2013

Hi Omar,
                    you can try to find a tool written by a teradata colleague. The name of the tool il TSlam. You can search it in teradata intranet.
regards,
Pietro.

Pietro Nardella
pietro.nardella@teradata.com
Teradata Italia

omarsaeed22 17 posts Joined 11/13
25 Nov 2013

Hi Pietro,
I am not able to access that  MVC tool. Can you please send it to my personal mail id:- uel.omar@gmail.com. Please help me if you can.
 
Thanks and Regards

MOHAMMAD OMAR SAEED

nkardos 12 posts Joined 10/10
26 Nov 2013

Hi,
 
I would recommend PRISE Compress Wizard to optimize MVC on a regular basis.
About the product: http://www.prisetools.com/products/compress-wizard
You can request your evaluation copy here : https://www.prisetools.com/product-request
 
You can also check out the other products to handle the statistics related and query optimization tasks easily.

Kawish_Siddiqui 37 posts Joined 03/07
26 Nov 2013

Did you try to find  tool called "WinMVC" (developed by GCC folks)? This was Teradata GCC Pakistan development effort and it is internal asset. So this won't be available for externals.
By the way, this was developed long way back. I am not sure how much this would be fruitful for you. 

Kawish Siddiqui -

vidyadutt.s 6 posts Joined 09/13
27 Nov 2013

Atanasuite is a good one, but requires license.

-Vidyadutt

omarsaeed22 17 posts Joined 11/13
27 Nov 2013

Hi,
In PRISE Compress Wizard it does give exact output in Excel Sheet on the Columns which can which are to be compressed or like it does not provide any recommendation on the columns to be compressed. Can you please suggest a better tool for compression.
 
One more question, how can I go for buying the license key of Atanasuite, please provide any link for buying the tool.
 
Thanks and Regards,

MOHAMMAD OMAR SAEED

Raja_KT 1246 posts Joined 07/09
29 Nov 2013

Hi,
I m just trying to evaluate the tools both(Prise and Atanasuite) if time permits. I dont know when I will get the download. I dont know if they covers all types of compressions (ALC,BLC,temperature-based,MVC)and consider all business cases.
We compress only if there is a need for those tables.
Yes, it is a pain if it does not recommend on the columns, because if we have tables with many columns and on top of that many tables , then it is cumbersome. Only those who work will know the pain.
Cheers,
Raja
 
 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

r.sagner 6 posts Joined 08/05
05 Dec 2013

see http://forums.teradata.com/forum/database/mvc-generated-out-of-v14-00-statistics for an idea
BR Roland

geethareddy 37 posts Joined 10/11
20 Dec 2013

I personally likes Prise tool. It gives you the amount of gain  on the list of tables that you selected. In our system, some of the tables are already compressed, so first i run my own query to seggreage the NONMVC ones from MVC ones. And I simply select the NONMVC ones from Prise tool. It will analyze all the tables and gives a nice report with how much we are going to gain, and how many cpu cycles consumed by the tool for the analysis (by prise tool). Compare to the manual analysis the amount of cpu consumed by this tool is considerably low.
Atana compression tool also a better tool, but compare to Prise i do not feel Atana is the best option, becauase of its features (like, we can use this for very big tbls in tbs, automatic compressn helath check ...etc).
One last important thing is PRISE is far cheaper than ATANA with full site licencing for unlimited users.

 

Thanks,
Geeta

brian.graham 1 post Joined 01/12
08 Jan 2014

My team has created a perl program to suggest MVC and algorithmic compression.  I'm happy to email it to anyone interested.  It's probably a bit primative compared to other tools, but has worked quite well for me.
 
Brian

omarsaeed22 17 posts Joined 11/13
04 Feb 2014

Hi Brian,
Please forward your Pearl Program to my mail id :- uel.omar@hotmail.com.
 
Thanks and Regards,
Mohammad Omar Saeed.

MOHAMMAD OMAR SAEED

Adeel Chaudhry 773 posts Joined 04/08
05 Feb 2014

Can you share your logic briefly on deciding which values will be selected for MVC?

-- If you are stuck at something .... consider it an opportunity to think anew.

alevai 4 posts Joined 10/11
24 Feb 2014

Programming a comprehensive optimum calculation is a bit complex. Do not forget that you have to collect the value frequency statistics and mind special cases like varchar compression (510 byte limit), and byte alignment that means that the optimum cannot be calculated on column level, but on the whole table. After you got the values you have to asseble the DDL, whic can be rather boring manual (or PERL) job.
If you have to optimize more tables, I definitely suggest using ready-made tools like PRISE Compress Wizard (GUI based), that can:

  • Help selecting good candidate tables
  • Analyze tables w/o modify them, resulting accurate expectable gain and structure DDL
  • Generates the BTEQ SQL script with ALTER/CREATE DDL and/or able to run them from the GUI
  • Log consumed CPU and I/O resources (from DBQL data)
  • Generates excel report of reachable and reached space gains

Downloadable from here: http://www.prisetools.com/free-trial
Ákos
 

You must sign in to leave a comment.