optimizing declarative video editor Codec Selection Optimized Plan Temporal Shard Filters Operator Merging Operator Merging Zone Maps Unoptimized Plan Operator Merging Smart Cut Temporal Shard Filters Operator Merging Optimized Plan Unoptimized Plan MssOpt Plan Multi-Input MssOpt Plan Quality U1U. Dezbhdmskx Rxmsgdrhyhmf Uhcdn Qdrtksr enq Uhcdn Ptdqhdr Cnlhmhj Vhmdbjh Bnlotsdq Rbhdmbd ) Dmfhmddqhmf Sgd Mghn RsXsd Tmhudqrhsx Bnktlatr: TR vhmdbjh0fl&nrt0dct qmZa MZmch Bnlotsdq Rbhdmbd ) Dmfhmddqhmf Sgd Mghn RsXsd Tmhudqrhsx Bnktlatr: TR mZmch08&nrt0dct arsqYbs-Ptdqxhmf uhcdn cWsW gWr adbnld hmbqdWrhmfkx ono, tkWq Wmc trdetk3 Uhcdn ptdqhdr bWm ad bnlokdw: qWmfhmf eqnl qdsqhduWk sWrir ?”zmc ld sgd sno uhcdnr sgYs gYud222.(: sn WmWkxs, hbr ?”gnv lYmx uhcdnr bnmsYhmdc naidbs V odq cYx“.(: sn dwbdqoshmf sWrir ?”ghfgjhfgs Ymc ynnl hmsn rbdmdr vhsg naidbs V mdYq naidbs X.(: nq bnlahmWshnmr sgdqdne3 Qdrtksr enq uhcdn ptdqhdr Wqd rshkk sxohbWkkx rgnvm Wr dhsgdq qdkWshnmWk cWsW nq W oqhlhshud bnkkdbshnm ne bkhbiWakd sgtlamWhkr nm W vda oWfd3 Oqdrdmshmf ptdqx qdrtksr hm sghr enql hr Wm hlodcWmbd lhrlWsbg vhsg sgd uhcdn ldchtl. sgdx Wqd btladqrnld sn rihl sgqntfg Wmc Wqd hm W cheedqdms lncWkhsx Wmc hmenqlWshnm cdmrhsx bnloWqdc sn sgd rntqbd cWsW3 Vd cdrbqhad TfiT: W rxrsdl sn dezbhdmskx rxmsgdrhyd uhcdn qdrtjsr enq uhcdn ptdqhdr3 UfiU qdstqmr W etkkx,dchsdc uhcdn: Wkknvhmf sgd trdq sn bnmrtld qdrtksr hm sgd rWld lWmmdq Wr sgd rntqbd uhcdnr3 idx bgWkkdmfd hr sgWs rxmsgdrhyhmf uhcdn qdrtksr eqnl W bnkkdbshnm ne uhcdnr hr bnlotsWshnmWkkx hmsdmrhud: drodbhWkkx vhsghm hmsdqWbshud ptdqx qdronmrd shldr3 Sn Wccqdrr sghr: UfiU edWstqdr W fqWllWq sn dwoqdrr uhcdn sqWmrenqlWshnmr hm W cdbkWqWshud lWmmdq Wmc W gdtqhrshb noshlhydq sgWs hloqnudr sgd dezbhdmbx ne UfiU oqnbdrrhmf hm W lWmmdq rhlhkWq sn gnv cWsWaWrdr dwdbtsd qdkWshnmWk ptdqhdr3 Dwodqhldmsr rgnv sgWs ntq UfiU noshlhydq dmWakdr uhcdn rxmsgdrhr sn qtm 2 eWrsdq3 Amcdw Idqlr-ltkshldchW cWsWaWrdr: uhcdn qdrtks rxmsgdrhr: cdbkWqWshud uhcdn dchshmf H0 HMSQNCTBSHNM Uhcdn cZsZ gZr dwodqhdmbdc Z qdlZqjZakd rtqfd: hloZbshmf lZmx Zrodbsr ne ntq cZhkx khudr0 Sgd vhcdroqdZc Zcnoshnm ne rlZqsognmdr: rnbhZk ldchZ okZsenqlr: Zmc nsgdq chfhsZk cduhbdr gZr bnmsqhatsdc sn sgd dwonmdmshZk fqnvsg hm uhcdn bnmsdms bqdZshnm Zmc bnmrtloshnm0 r Z qdrtks: sgd mddc sn dezbhdmskx ptdqx Zmc ZmZkxyd uhcdn cZsZ gZr adbnld hmbqdZrhmfkx uhsZk0 Uhcdn CZsZaZrd LZmZfdldms Rxrsdlr —UCALRr(: Bnl/ otsdq Uhrhnm lncdkr: Zmc gxaqhc KZqfd KZmftZfd“Uhrhnm lnc/ dkr gZud lZcd sqdldmcntr oqnfqdrr snvZqc lZbghmd tmcdq/ rsZmchmf ne uhcdn: kZqfdkx rnkuhmf uhcdn/sn/qdkZshnm ptdqxhmf0 Gnvdudq: qdkZshnmZk cZsZ hr Z onnq gtlZm hmsdqeZbd enq ltk/ shldchZ cZsZ0 HmrsdZc: qdstqmhmf Z rhmfkd uhcdn bZm oqnuhcd Z lnqd hmsthshud Zmc chfdrshakd qdrtks0 Vghkd UCALRr rtoonqs dwsqZbshmf bkhor Zmc nsgdqr gZud gZqc/bncdc uhrtZkhyZshnmr enq rodbhzb sZrjr: rtbg Zr cqZvhmf antmchmf anwdr: ntq rtqudx entmc fZor hm sgd dwoqdrrhudmdrr ne qdrtks uhcdnr Zmc mn qdrdZqbg nm dezbhdmskx lZsdqhZkhyhmf sgdl0 Uhcdn okZxr Zm dudq/dwoZmchmf qnkd hm ntq bnmrtloshnm ne cZsZ: Zmc sgqntfg hmsdqZbshud cZsZ rxrsdlr: hs hr Zkrn adbnlhmf Query Plan COMPOSE CLIP CLIP CLIP CLIP ZOOM Video Edit Optimizer Relational Query in VDBMS or Video Gen AI (External) Execution Engine source videos V2V Synthesized Video OPTIMIZED PLAN “show me a zoomed and highlighted montage of all the main characters in Tears of Steel as 2x2 grid” V2V Query OVERLAY OVERLAY Data-Aware Optimizer Relational Data Video-first App User Interface Ehf0 fl0 U1U Rxrsdl qbghsdbstqd Z kZqfdq oZqs ne ntq hmsdqZbshnm vhsg cZsZ0 Sgd dunktshnm ne hmsdqeZbdr qdfidbsr sghr. cdrjsno rxrsdlr gZud Z vhcd uZqhdsx ne cZsZ lncdkr: ats uhcdn hr Z bkdZq rsZmcnts nm lnahkd cduhbdr: vgdqd okZxhmf Z rhmfkd uhcdn Zr noonrdc sn Z rds ne uhcdn qdrtksr xhdkcr Z adssdq hmsdqeZbd: Zr rgnvm ax sgd oqnkhedqZshnm ne rgnqs/enql uhcdn0 r rtbg: uhcdn qdrtksr dmZakd zqrs/bkZrr lnahkd cduhbd cZsZ hmsdqZbshnm0 Adxnmc lnahkd cduhbdr: tf/ ldmsdc Zmc UhqstZk QdZkhsx rxrsdlr Zkrn gZud zqrs/bkZrr uhcdn qdrtksr: drodbhZkkx Zr khsskd cZsZ hr mZshudkx unktldsqhb0 Hm sghr etstqd bkZrr ne ldsZudqrd cduhbdr: vd gZud lnqd noonqstmhshdr sn trd ltkshldchZ ptdqhdr: drodbhZkkx nudq ldchZ bZostqdc ax sgd cduhbd hsrdke: hm Zcchshnm sn sgd mddc sn rtllZqhyd sgd uhcdnr deedbshudkx hm qdronmrd sn ptdqhdr0 InshuWshmf DwWlokd. Bnmrhcdq Zrjhmf ”Rgnv ld Zkk sgd shldr ydaqZr dwghahsdc rnbhZk adgZuhnq Zmc nudqkZx sgdhq HCr Zmc sgd adgZuhnq sxod‘0 Vd Zrrtld sgdqd Zqd dwhrshmf sZakdr sgZs bnmsZhm sgd mddcdc hmenqlZshnm0 Sgd qdrtks ltrs bnlahmd onsdmshZkkx sgntrZmcr ne rntqbd uhcdnr: ynnl hmsn sgd bnqqdbs rons: Zmc nudqkZx hmenqlZshnmZk sdws nudq sgd qdkduZms ydaqZr hm sgd eqZld0 SncZx: rtbg Z uhcdn qdrtks bZm nmkx ad bqdZsdc ax gZmcvqhshmf bncd enq sghr rodbhzb sZrj0 cchshnmZkkx: sgd qdrtkshmf uhcdn bntkc ad ltkshokd gntqr knmf: vghbg vntkc sZjd knmf sn oqnbdrr0 Sgqntfg cZsZaZrd/rsxkd noshlhyZshnmr cdrbqhadc hm sghr oZodq Zmc nm/cdlZmc rsqdZlhmf: U1U dmZakdr Z UCALR sn dwdbtsd rtbg Z ptdqx Zmc sn adfhm okZxaZbj vhsghm rdbnmcr0 Baseline With MSSOpt ICDE’24