{"id":"https://openalex.org/W7155388270","doi":"https://doi.org/10.1145/3810900.3810913","title":"Technical Perspective: PRISM and the Case for Strategic Opacity in UDF Optimization","display_name":"Technical Perspective: PRISM and the Case for Strategic Opacity in UDF Optimization","publication_year":2026,"publication_date":"2026-04-23","ids":{"openalex":"https://openalex.org/W7155388270","doi":"https://doi.org/10.1145/3810900.3810913"},"language":"en","primary_location":{"id":"doi:10.1145/3810900.3810913","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3810900.3810913","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"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":"ACM SIGMOD Record","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/A5072082268","display_name":"Alkis Simitsis","orcid":"https://orcid.org/0009-0006-6078-5323"},"institutions":[{"id":"https://openalex.org/I4210156054","display_name":"Athena Research and Innovation Center In Information Communication & Knowledge Technologies","ror":"https://ror.org/0576by029","country_code":"GR","type":"facility","lineage":["https://openalex.org/I4210156054"]}],"countries":["GR"],"is_corresponding":true,"raw_author_name":"Alkis Simitsis","raw_affiliation_strings":["Athena Research Center, Athens, Greece"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Athena Research Center, Athens, Greece","institution_ids":["https://openalex.org/I4210156054"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5072082268"],"corresponding_institution_ids":["https://openalex.org/I4210156054"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.7311047,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"55","issue":"1","first_page":"73","last_page":"73"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.6352999806404114,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.6352999806404114,"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"}},{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.0478999987244606,"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/T11106","display_name":"Data Management and Algorithms","score":0.025800000876188278,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/opacity","display_name":"Opacity","score":0.8610000014305115},{"id":"https://openalex.org/keywords/transparency","display_name":"Transparency (behavior)","score":0.805899977684021},{"id":"https://openalex.org/keywords/path","display_name":"Path (computing)","score":0.478300005197525},{"id":"https://openalex.org/keywords/prism","display_name":"Prism","score":0.45089998841285706},{"id":"https://openalex.org/keywords/trajectory","display_name":"Trajectory","score":0.4016000032424927},{"id":"https://openalex.org/keywords/fusion","display_name":"Fusion","score":0.3873000144958496}],"concepts":[{"id":"https://openalex.org/C60056205","wikidata":"https://www.wikidata.org/wiki/Q691914","display_name":"Opacity","level":2,"score":0.8610000014305115},{"id":"https://openalex.org/C2780233690","wikidata":"https://www.wikidata.org/wiki/Q535347","display_name":"Transparency (behavior)","level":2,"score":0.805899977684021},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5551999807357788},{"id":"https://openalex.org/C2777735758","wikidata":"https://www.wikidata.org/wiki/Q817765","display_name":"Path (computing)","level":2,"score":0.478300005197525},{"id":"https://openalex.org/C67666897","wikidata":"https://www.wikidata.org/wiki/Q165896","display_name":"Prism","level":2,"score":0.45089998841285706},{"id":"https://openalex.org/C199639397","wikidata":"https://www.wikidata.org/wiki/Q1788588","display_name":"Engineering drawing","level":1,"score":0.4131999909877777},{"id":"https://openalex.org/C13662910","wikidata":"https://www.wikidata.org/wiki/Q193139","display_name":"Trajectory","level":2,"score":0.4016000032424927},{"id":"https://openalex.org/C158525013","wikidata":"https://www.wikidata.org/wiki/Q2593739","display_name":"Fusion","level":2,"score":0.3873000144958496},{"id":"https://openalex.org/C2780155792","wikidata":"https://www.wikidata.org/wiki/Q1441983","display_name":"Redevelopment","level":2,"score":0.31690001487731934},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.28630000352859497},{"id":"https://openalex.org/C121684516","wikidata":"https://www.wikidata.org/wiki/Q7600677","display_name":"Computer graphics (images)","level":1,"score":0.27300000190734863},{"id":"https://openalex.org/C173246807","wikidata":"https://www.wikidata.org/wiki/Q7833062","display_name":"Trajectory optimization","level":3,"score":0.27230000495910645},{"id":"https://openalex.org/C94966114","wikidata":"https://www.wikidata.org/wiki/Q29256","display_name":"Black box","level":2,"score":0.2655999958515167},{"id":"https://openalex.org/C2776527387","wikidata":"https://www.wikidata.org/wiki/Q1671839","display_name":"Invocation","level":2,"score":0.2623000144958496},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.2590000033378601},{"id":"https://openalex.org/C44154836","wikidata":"https://www.wikidata.org/wiki/Q45045","display_name":"Simulation","level":1,"score":0.2538999915122986}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3810900.3810913","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3810900.3810913","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"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":"ACM SIGMOD Record","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":2,"referenced_works":["https://openalex.org/W4386768666","https://openalex.org/W4407385483"],"related_works":[],"abstract_inverted_index":{"The":[0,68],"history":[1],"of":[2,12],"UDF":[3],"optimization":[4],"in":[5],"relational":[6],"databases":[7],"reads":[8],"as":[9,37],"a":[10],"story":[11],"increasing":[13],"transparency":[14,53],"[2].":[15],"Compilation":[16],"makes":[17],"UDFs":[18,36,56],"faster":[19],"but":[20,33],"leaves":[21],"them":[22],"opaque":[23],"to":[24,50,74],"the":[25,51,62,72],"optimizer.":[26],"Batching":[27],"and":[28],"fusion":[29],"amortize":[30],"invocation":[31],"costs":[32],"still":[34],"treat":[35],"black":[38],"boxes.":[39],"Inlining,":[40],"most":[41],"notably":[42],"demonstrated":[43],"by":[44,54],"Microsoft's":[45],"FROID":[46],"system":[47],"[3],":[48],"aspires":[49],"ultimate":[52],"converting":[55],"entirely":[57],"into":[58],"SQL,":[59],"hence":[60],"letting":[61],"optimizer":[63],"reason":[64],"about":[65],"their":[66],"contents.":[67],"trajectory":[69],"seems":[70],"inevitable:":[71],"path":[73],"better":[75],"performance":[76],"runs":[77],"through":[78],"making":[79],"everything":[80],"visible.":[81]},"counts_by_year":[],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2026-04-24T00:00:00"}