VeronicaLagrangeMemorySolutionsLabSamsungSemiconductor,Inc.SanJose,U.S.A.veronica.l@samsung.comHarry(Huan)LiMemorySolutionsLabSamsungSemiconductor,Inc.SanJose,U.S.A.harry.li@samsung.comAnahitaShayestehMemorySolutionsLabSamsungSemiconductor,Inc.SanJose,U.S.A.ModelingAnalyticsforComputationalStorage群内每日免费分享5份+最新资料300T网盘资源+40万份行业报告为您的创业、职场、商业、投资、亲子、网赚、艺术、健身、心理、个人成长……全面赋能！添加微信，备注“入群”立刻免费领取200套知识地图+最新研报收钱文案、增长黑客、产品运营、品牌企划、营销战略、办公软件、会计财务、广告设计、摄影修图、视频剪辑、直播带货、电商运营、投资理财、汽车房产、餐饮烹饪、职场经验、演讲口才、风水命理、心理思维、恋爱情趣、美妆护肤、健身瘦身、格斗搏击、漫画手绘、声乐训练、自媒体打造、效率软件工具、游戏影音……扫码先加好友，以备不时之需行业报告/思维导图/电子书/资讯情报致终身学习者社群致终身学习者社群关注公众号获取更多资料ModelingAnalyticsforComputationalStorage2AbstractNextgenerationflashstoragewillbearmedwithasubstantialamountofcomputingpower.Inthispaper,weinvestigateopportunitiestoutilizethiscomputationalcapabilitytooptimizeOnlineAnalyticalProcessing(OLAP)applications.WehavedirectedouranalysisattheperformanceofasubsetofTPC-DSqueriesusingApacheHadoopclustersandtwodatabaseengines,ApacheSPARK-SQLandPresto1.Wemodeltheexpectedspeed-upachievedbyoffloadingafewoperationsthatareexecutedfirstwithinmostSQLplans.Offloadingtheseoperationsrequiresminimalcooperationfromthedatabaseengine,andnochangestotheexistingplan.Weshowthatthespeed-upachievedvariessignificantlyamongqueriesandbetweenengines,andthatthequeriesbenefitingthemostareI/Oheavywithhighselectivityofthe“needleinthehaystack”variety.Ourmaincontributionisestimatingthespeed-upanticipatedfrompushingtheexecutionofafewkeySQLbuildingblocks(scan,filter,andprojectoperations)tocomputationalstoragewhenusingreadoptimized,columnarApacheParquetformatfiles2.CCSConcepts•Computingmethodologies→Modelingandsimulation→Modeldevelopmentandanalysis→Modelverificationandvalidatio...
