{"id":"https://openalex.org/W3204877237","doi":"https://doi.org/10.1145/3475726.3476451","title":"Unified Optimization of Declarative and Imperative Code in Relational Databases","display_name":"Unified Optimization of Declarative and Imperative Code in Relational Databases","publication_year":2021,"publication_date":"2021-08-16","ids":{"openalex":"https://openalex.org/W3204877237","doi":"https://doi.org/10.1145/3475726.3476451","mag":"3204877237"},"language":"en","primary_location":{"id":"doi:10.1145/3475726.3476451","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3475726.3476451","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The 18th International Symposium on Database Programming Languages","raw_type":"proceedings-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/A5039165136","display_name":"Young-Koo Lee","orcid":"https://orcid.org/0000-0003-2314-5395"},"institutions":[{"id":"https://openalex.org/I35928602","display_name":"Kyung Hee University","ror":"https://ror.org/01zqcg218","country_code":"KR","type":"education","lineage":["https://openalex.org/I35928602"]}],"countries":["KR"],"is_corresponding":true,"raw_author_name":"Young-Koo Lee","raw_affiliation_strings":["Kyung Hee University"],"affiliations":[{"raw_affiliation_string":"Kyung Hee University","institution_ids":["https://openalex.org/I35928602"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5039165136"],"corresponding_institution_ids":["https://openalex.org/I35928602"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.17354066,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"2","last_page":"2"},"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.9987000226974487,"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.9987000226974487,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9975000023841858,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9905999898910522,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.80704265832901},{"id":"https://openalex.org/keywords/business-logic","display_name":"Business logic","score":0.684317946434021},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5601102709770203},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.541344165802002},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.5158185362815857},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.4997262954711914},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4828527569770813},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.40073996782302856}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.80704265832901},{"id":"https://openalex.org/C146222976","wikidata":"https://www.wikidata.org/wiki/Q1204997","display_name":"Business logic","level":2,"score":0.684317946434021},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5601102709770203},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.541344165802002},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5158185362815857},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.4997262954711914},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4828527569770813},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.40073996782302856}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3475726.3476451","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3475726.3476451","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The 18th International Symposium on Database Programming Languages","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2505630977","https://openalex.org/W2383709723","https://openalex.org/W1567213510","https://openalex.org/W2626533837","https://openalex.org/W2375584934","https://openalex.org/W2761120596","https://openalex.org/W1575529579","https://openalex.org/W2525788546","https://openalex.org/W1988380406","https://openalex.org/W2949223857"],"abstract_inverted_index":{"In":[0],"relational":[1],"databases":[2],"stored":[3],"procedures":[4],"and":[5,23,49],"user":[6],"defined":[7],"functions":[8],"(UDFs)":[9],"have":[10,56],"been":[11],"used":[12],"to":[13,58,62],"express":[14],"application":[15],"business":[16,44],"logic":[17,22],"by":[18],"using":[19],"control":[20],"flow":[21],"DMLs.":[24],"Recently":[25],"their":[26],"use":[27],"is":[28],"increasing":[29],"with":[30],"the":[31,39,64],"rising":[32],"popularity":[33],"of":[34,66],"real-time":[35],"analytics":[36],"applications":[37,40],"since":[38],"often":[41],"contain":[42],"complex":[43],"logic.":[45],"Thus":[46],"hybrid":[47],"transactional":[48],"analytical":[50],"processing":[51],"systems":[52],"like":[53],"SAP":[54],"HANA":[55],"started":[57],"put":[59],"more":[60],"efforts":[61],"optimize":[63],"execution":[65],"UDFs.":[67]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}