{"id":"https://openalex.org/W2133986470","doi":"https://doi.org/10.14778/2095686.2095693","title":"Putting lipstick on pig","display_name":"Putting lipstick on pig","publication_year":2011,"publication_date":"2011-12-01","ids":{"openalex":"https://openalex.org/W2133986470","doi":"https://doi.org/10.14778/2095686.2095693","mag":"2133986470"},"language":"en","primary_location":{"id":"doi:10.14778/2095686.2095693","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2095686.2095693","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5021101350","display_name":"Yael Amsterdamer","orcid":"https://orcid.org/0000-0001-8032-9962"},"institutions":[{"id":"https://openalex.org/I16391192","display_name":"Tel Aviv University","ror":"https://ror.org/04mhzgx49","country_code":"IL","type":"education","lineage":["https://openalex.org/I16391192"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Yael Amsterdamer","raw_affiliation_strings":["Tel Aviv University, Israel"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Tel Aviv University, Israel","institution_ids":["https://openalex.org/I16391192"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5081006850","display_name":"Susan B. Davidson","orcid":"https://orcid.org/0009-0003-9259-9662"},"institutions":[{"id":"https://openalex.org/I36788626","display_name":"California University of Pennsylvania","ror":"https://ror.org/01spssf70","country_code":"US","type":"education","lineage":["https://openalex.org/I36788626"]},{"id":"https://openalex.org/I79576946","display_name":"University of Pennsylvania","ror":"https://ror.org/00b30xv10","country_code":"US","type":"education","lineage":["https://openalex.org/I79576946"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Susan B. Davidson","raw_affiliation_strings":["University of Pennsylvania","#N# * University of Pennsylvania"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Pennsylvania","institution_ids":["https://openalex.org/I36788626"]},{"raw_affiliation_string":"#N# * University of Pennsylvania","institution_ids":["https://openalex.org/I36788626","https://openalex.org/I79576946"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073835385","display_name":"Daniel Deutch","orcid":"https://orcid.org/0009-0001-0838-0162"},"institutions":[{"id":"https://openalex.org/I124227911","display_name":"Ben-Gurion University of the Negev","ror":"https://ror.org/05tkyf982","country_code":"IL","type":"education","lineage":["https://openalex.org/I124227911"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Daniel Deutch","raw_affiliation_strings":["Ben Gurion University, Israel","Ben Gurion University, ISRAEL"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ben Gurion University, Israel","institution_ids":["https://openalex.org/I124227911"]},{"raw_affiliation_string":"Ben Gurion University, ISRAEL","institution_ids":["https://openalex.org/I124227911"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110095410","display_name":"Tova Milo","orcid":null},"institutions":[{"id":"https://openalex.org/I16391192","display_name":"Tel Aviv University","ror":"https://ror.org/04mhzgx49","country_code":"IL","type":"education","lineage":["https://openalex.org/I16391192"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Tova Milo","raw_affiliation_strings":["Tel Aviv University, Israel"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Tel Aviv University, Israel","institution_ids":["https://openalex.org/I16391192"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5082830839","display_name":"Julia Stoyanovich","orcid":"https://orcid.org/0000-0002-1587-0450"},"institutions":[{"id":"https://openalex.org/I36788626","display_name":"California University of Pennsylvania","ror":"https://ror.org/01spssf70","country_code":"US","type":"education","lineage":["https://openalex.org/I36788626"]},{"id":"https://openalex.org/I79576946","display_name":"University of Pennsylvania","ror":"https://ror.org/00b30xv10","country_code":"US","type":"education","lineage":["https://openalex.org/I79576946"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Julia Stoyanovich","raw_affiliation_strings":["University of Pennsylvania","#N# * University of Pennsylvania"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Pennsylvania","institution_ids":["https://openalex.org/I36788626"]},{"raw_affiliation_string":"#N# * University of Pennsylvania","institution_ids":["https://openalex.org/I36788626","https://openalex.org/I79576946"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5036528289","display_name":"Val Tannen","orcid":"https://orcid.org/0009-0008-6847-7274"},"institutions":[{"id":"https://openalex.org/I36788626","display_name":"California University of Pennsylvania","ror":"https://ror.org/01spssf70","country_code":"US","type":"education","lineage":["https://openalex.org/I36788626"]},{"id":"https://openalex.org/I79576946","display_name":"University of Pennsylvania","ror":"https://ror.org/00b30xv10","country_code":"US","type":"education","lineage":["https://openalex.org/I79576946"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Val Tannen","raw_affiliation_strings":["University of Pennsylvania","#N# * University of Pennsylvania"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Pennsylvania","institution_ids":["https://openalex.org/I36788626"]},{"raw_affiliation_string":"#N# * University of Pennsylvania","institution_ids":["https://openalex.org/I36788626","https://openalex.org/I79576946"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":24.3307,"has_fulltext":false,"cited_by_count":121,"citation_normalized_percentile":{"value":0.9940215,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":100},"biblio":{"volume":"5","issue":"4","first_page":"346","last_page":"357"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11937","display_name":"Research Data Management Practices","score":0.9932000041007996,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9922000169754028,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/workflow","display_name":"Workflow","score":0.873764157295227},{"id":"https://openalex.org/keywords/provenance","display_name":"Provenance","score":0.7457938194274902},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7447616457939148},{"id":"https://openalex.org/keywords/black-box","display_name":"Black box","score":0.5104435682296753},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.49429965019226074},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.46709033846855164},{"id":"https://openalex.org/keywords/granularity","display_name":"Granularity","score":0.45473864674568176},{"id":"https://openalex.org/keywords/graph-rewriting","display_name":"Graph rewriting","score":0.4440491199493408},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.37571364641189575},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.35146063566207886},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3279606103897095},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.11844280362129211}],"concepts":[{"id":"https://openalex.org/C177212765","wikidata":"https://www.wikidata.org/wiki/Q627335","display_name":"Workflow","level":2,"score":0.873764157295227},{"id":"https://openalex.org/C2780049196","wikidata":"https://www.wikidata.org/wiki/Q23582628","display_name":"Provenance","level":2,"score":0.7457938194274902},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7447616457939148},{"id":"https://openalex.org/C94966114","wikidata":"https://www.wikidata.org/wiki/Q29256","display_name":"Black box","level":2,"score":0.5104435682296753},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.49429965019226074},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.46709033846855164},{"id":"https://openalex.org/C177774035","wikidata":"https://www.wikidata.org/wiki/Q1246948","display_name":"Granularity","level":2,"score":0.45473864674568176},{"id":"https://openalex.org/C558772884","wikidata":"https://www.wikidata.org/wiki/Q1508564","display_name":"Graph rewriting","level":3,"score":0.4440491199493408},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.37571364641189575},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.35146063566207886},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3279606103897095},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.11844280362129211},{"id":"https://openalex.org/C127313418","wikidata":"https://www.wikidata.org/wiki/Q1069","display_name":"Geology","level":0,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C5900021","wikidata":"https://www.wikidata.org/wiki/Q163082","display_name":"Petrology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/2095686.2095693","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2095686.2095693","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320308633","display_name":"Computing Research Association","ror":"https://ror.org/00agrkd75"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W22495568","https://openalex.org/W39730884","https://openalex.org/W135267584","https://openalex.org/W161296890","https://openalex.org/W1543276876","https://openalex.org/W1552694902","https://openalex.org/W1858703999","https://openalex.org/W1971744183","https://openalex.org/W1975612259","https://openalex.org/W1988545508","https://openalex.org/W2019379313","https://openalex.org/W2027172230","https://openalex.org/W2028980140","https://openalex.org/W2058651674","https://openalex.org/W2098935637","https://openalex.org/W2104791905","https://openalex.org/W2107571548","https://openalex.org/W2125332694","https://openalex.org/W2126880670","https://openalex.org/W2130872776","https://openalex.org/W2134318033","https://openalex.org/W2137653635","https://openalex.org/W2143102052","https://openalex.org/W2146015265","https://openalex.org/W2150616017","https://openalex.org/W2156399060","https://openalex.org/W2165766811","https://openalex.org/W2167541073","https://openalex.org/W2293299776","https://openalex.org/W2605173815","https://openalex.org/W6605500462","https://openalex.org/W6606537055","https://openalex.org/W6902549019"],"related_works":["https://openalex.org/W2945640130","https://openalex.org/W1550441670","https://openalex.org/W4299639459","https://openalex.org/W2951983716","https://openalex.org/W1788565084","https://openalex.org/W1534251038","https://openalex.org/W4375869919","https://openalex.org/W2098021795","https://openalex.org/W2295302253","https://openalex.org/W1599733302"],"abstract_inverted_index":{"Workflow":[0],"provenance":[1,70,109,143],"typically":[2],"assumes":[3],"that":[4,11,72,111],"each":[5,12],"module":[6,113],"is":[7,101],"a":[8,30,47,68,105,117,127,164,169],"\"black-box\",":[9],"so":[10],"output":[13,42],"depends":[14],"on":[15,45,59],"all":[16],"inputs":[17,52],"(":[18,53],"coarse-grained":[19],"dependencies).":[20],"Furthermore,":[21],"it":[22],"does":[23],"not":[24],"model":[25],"the":[26,51,60,64,84,102,137,159,176],"internal":[27,61,90],"state":[28,62,91],"of":[29,50,63,86,104,108,120,129,140,168,178],"module,":[31],"which":[32],"can":[33],"change":[34],"between":[35],"repeated":[36],"executions.":[37],"In":[38],"practice,":[39],"however,":[40],"an":[41],"may":[43],"depend":[44],"only":[46],"small":[48],"subset":[49],"fine-grained":[54,93,121,182],"dependencies)":[55],"as":[56,58],"well":[57],"module.":[65],"We":[66,154],"present":[67],"novel":[69,106,130],"framework":[71],"marries":[73],"database-style":[74],"and":[75,92,115,146,148,162,180],"workflow-style":[76],"provenance,":[77],"by":[78],"using":[79],"Pig":[80],"Latin":[81],"to":[82,135],"expose":[83],"functionality":[85],"modules,":[87],"thus":[88],"capturing":[89],"dependencies.":[94],"A":[95],"critical":[96],"ingredient":[97],"in":[98,142,158,166],"our":[99,156],"solution":[100],"use":[103],"form":[107],"graph":[110,131],"models":[112],"invocations":[114],"yields":[116],"compact":[118],"representation":[119],"workflow":[122,151,183],"provenance.":[123,184],"It":[124],"also":[125],"enables":[126],"number":[128],"transformation":[132],"operations,":[133],"allowing":[134],"choose":[136],"desired":[138],"level":[139],"granularity":[141],"querying":[144,181],"(ZoomIn":[145],"ZoomOut),":[147],"supporting":[149],"\"what-if\"":[150],"analytic":[152],"queries.":[153],"implemented":[155],"approach":[157],"Lipstick":[160],"system":[161],"developed":[163],"benchmark":[165],"support":[167],"systematic":[170],"performance":[171],"evaluation.":[172],"Our":[173],"results":[174],"demonstrate":[175],"feasibility":[177],"tracking":[179]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":10},{"year":2020,"cited_by_count":5},{"year":2019,"cited_by_count":13},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":17},{"year":2016,"cited_by_count":12},{"year":2015,"cited_by_count":13},{"year":2014,"cited_by_count":13},{"year":2013,"cited_by_count":14},{"year":2012,"cited_by_count":7}],"updated_date":"2026-07-15T18:14:33.161393","created_date":"2025-10-10T00:00:00"}