%0 Journal Article %J Journal of Systems and Software %D 2012 %T Using Pig as a data preparation language for large-scale mining software repositories studies: An experience report %A Weiyi Shang %A Adams, Bram %A Hassan, Ahmed E. %K flossmole cited %X The Mining Software Repositories (MSR) field analyzes software repository data to uncover knowledge and assist development of ever growing, complex systems. However, existing approaches and platforms for MSR analysis face many challenges when performing large-scale MSR studies. Such approaches and platforms rarely scale easily out of the box. Instead, they often require custom scaling tricks and designs that are costly to maintain and that are not reusable for other types of analysis. We believe that the web community has faced many of these software engineering scaling challenges before, as web analyses have to cope with the enormous growth of web data. In this paper, we report on our experience in using a web-scale platform (i.e., Pig) as a data preparation language to aid large-scale MSR studies. Through three case studies, we carefully validate the use of this web platform to prepare (i.e., Extract, Transform, and Load, ETL) data for further analysis. Despite several limitations, we still encourage MSR researchers to leverage Pig in their large-scale studies because of Pig's scalability and flexibility. Our experience report will help other researchers who want to scale their analyses. %B Journal of Systems and Software %V 85 %P 2195 - 2204 %8 10/2012 %U http://www.sciencedirect.com/science/article/pii/S0164121211002007 %N 10 %! Journal of Systems and Software %R 10.1016/j.jss.2011.07.034