{"id":"https://openalex.org/W4399117327","doi":"https://doi.org/10.1145/3650203.3663329","title":"AIDB: a Sparsely Materialized Database for Queries using Machine Learning","display_name":"AIDB: a Sparsely Materialized Database for Queries using Machine Learning","publication_year":2024,"publication_date":"2024-05-29","ids":{"openalex":"https://openalex.org/W4399117327","doi":"https://doi.org/10.1145/3650203.3663329"},"language":"en","primary_location":{"id":"doi:10.1145/3650203.3663329","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3650203.3663329","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Eighth Workshop on Data Management for End-to-End Machine Learning","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3650203.3663329","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5103188343","display_name":"Tengjun Jin","orcid":"https://orcid.org/0009-0005-0353-4184"},"institutions":[{"id":"https://openalex.org/I308392441","display_name":"International University of the Caribbean","ror":"https://ror.org/02rv57d03","country_code":"JM","type":"education","lineage":["https://openalex.org/I308392441"]}],"countries":["JM"],"is_corresponding":false,"raw_author_name":"Tengjun Jin","raw_affiliation_strings":["UIUC"],"raw_orcid":"https://orcid.org/0009-0005-0353-4184","affiliations":[{"raw_affiliation_string":"UIUC","institution_ids":["https://openalex.org/I308392441"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061237485","display_name":"Akash Mittal","orcid":"https://orcid.org/0009-0001-9041-8376"},"institutions":[{"id":"https://openalex.org/I308392441","display_name":"International University of the Caribbean","ror":"https://ror.org/02rv57d03","country_code":"JM","type":"education","lineage":["https://openalex.org/I308392441"]}],"countries":["JM"],"is_corresponding":false,"raw_author_name":"Akash Mittal","raw_affiliation_strings":["UIUC"],"raw_orcid":"https://orcid.org/0009-0001-9041-8376","affiliations":[{"raw_affiliation_string":"UIUC","institution_ids":["https://openalex.org/I308392441"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5065967981","display_name":"Chenghao Mo","orcid":"https://orcid.org/0009-0003-9860-6325"},"institutions":[{"id":"https://openalex.org/I308392441","display_name":"International University of the Caribbean","ror":"https://ror.org/02rv57d03","country_code":"JM","type":"education","lineage":["https://openalex.org/I308392441"]}],"countries":["JM"],"is_corresponding":false,"raw_author_name":"Chenghao Mo","raw_affiliation_strings":["UIUC"],"raw_orcid":"https://orcid.org/0009-0003-9860-6325","affiliations":[{"raw_affiliation_string":"UIUC","institution_ids":["https://openalex.org/I308392441"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5060135792","display_name":"Jiahao Fang","orcid":"https://orcid.org/0009-0008-0202-0597"},"institutions":[{"id":"https://openalex.org/I308392441","display_name":"International University of the Caribbean","ror":"https://ror.org/02rv57d03","country_code":"JM","type":"education","lineage":["https://openalex.org/I308392441"]}],"countries":["JM"],"is_corresponding":false,"raw_author_name":"Jiahao Fang","raw_affiliation_strings":["UIUC"],"raw_orcid":"https://orcid.org/0009-0008-0202-0597","affiliations":[{"raw_affiliation_string":"UIUC","institution_ids":["https://openalex.org/I308392441"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5012951201","display_name":"Chengsong Zhang","orcid":"https://orcid.org/0009-0008-2120-1879"},"institutions":[{"id":"https://openalex.org/I308392441","display_name":"International University of the Caribbean","ror":"https://ror.org/02rv57d03","country_code":"JM","type":"education","lineage":["https://openalex.org/I308392441"]}],"countries":["JM"],"is_corresponding":false,"raw_author_name":"Chengsong Zhang","raw_affiliation_strings":["UIUC"],"raw_orcid":"https://orcid.org/0009-0008-2120-1879","affiliations":[{"raw_affiliation_string":"UIUC","institution_ids":["https://openalex.org/I308392441"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5053483584","display_name":"Timothy Dai","orcid":"https://orcid.org/0009-0001-9074-2037"},"institutions":[{"id":"https://openalex.org/I97018004","display_name":"Stanford University","ror":"https://ror.org/00f54p054","country_code":"US","type":"education","lineage":["https://openalex.org/I97018004"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Timothy Dai","raw_affiliation_strings":["Stanford University"],"raw_orcid":"https://orcid.org/0009-0001-9074-2037","affiliations":[{"raw_affiliation_string":"Stanford University","institution_ids":["https://openalex.org/I97018004"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5072348548","display_name":"Daniel Kang","orcid":"https://orcid.org/0000-0001-9860-9938"},"institutions":[{"id":"https://openalex.org/I308392441","display_name":"International University of the Caribbean","ror":"https://ror.org/02rv57d03","country_code":"JM","type":"education","lineage":["https://openalex.org/I308392441"]}],"countries":["JM"],"is_corresponding":false,"raw_author_name":"Daniel Kang","raw_affiliation_strings":["UIUC"],"raw_orcid":"https://orcid.org/0000-0001-9860-9938","affiliations":[{"raw_affiliation_string":"UIUC","institution_ids":["https://openalex.org/I308392441"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":7,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.6244,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.67879271,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"23","last_page":"28"},"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.9977999925613403,"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.9977999925613403,"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/T11106","display_name":"Data Management and Algorithms","score":0.9972000122070312,"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"}},{"id":"https://openalex.org/T12535","display_name":"Machine Learning and Data Classification","score":0.994700014591217,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/materialized-view","display_name":"Materialized view","score":0.9378905892372131},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8948080539703369},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6064306497573853},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5693780183792114},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.4372069835662842},{"id":"https://openalex.org/keywords/database-query","display_name":"Database query","score":0.4315755367279053},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.41682168841362},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.28935837745666504}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9378905892372131},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8948080539703369},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6064306497573853},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5693780183792114},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.4372069835662842},{"id":"https://openalex.org/C2989070954","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database query","level":2,"score":0.4315755367279053},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.41682168841362},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.28935837745666504}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3650203.3663329","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3650203.3663329","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Eighth Workshop on Data Management for End-to-End Machine Learning","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3650203.3663329","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3650203.3663329","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Eighth Workshop on Data Management for End-to-End Machine Learning","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":12,"referenced_works":["https://openalex.org/W2189465200","https://openalex.org/W2752236330","https://openalex.org/W2786278116","https://openalex.org/W2808184646","https://openalex.org/W3000318171","https://openalex.org/W3032112964","https://openalex.org/W3106402164","https://openalex.org/W4281842097","https://openalex.org/W4281996556","https://openalex.org/W4383749456","https://openalex.org/W4386768626","https://openalex.org/W6687322159"],"related_works":["https://openalex.org/W2162280381","https://openalex.org/W2185691065","https://openalex.org/W2363712075","https://openalex.org/W2383931363","https://openalex.org/W1908544460","https://openalex.org/W2142569422","https://openalex.org/W2348265434","https://openalex.org/W2087983779","https://openalex.org/W2108498730","https://openalex.org/W2313759748"],"abstract_inverted_index":{"Analysts":[0],"and":[1,18,68],"scientists":[2],"are":[3],"interested":[4],"in":[5,39],"automatically":[6],"analyzing":[7],"the":[8],"semantic":[9],"contents":[10],"of":[11,36],"unstructured,":[12],"non-tabular":[13],"data":[14,26],"(videos,":[15],"images,":[16],"text,":[17],"audio).":[19],"These":[20],"analysts":[21],"have":[22],"turned":[23],"to":[24,43,58,66,70],"unstructured":[25],"systems":[27,41],"leveraging":[28],"machine":[29],"learning":[30],"(ML).":[31],"The":[32],"most":[33],"common":[34],"method":[35],"using":[37],"ML":[38],"analytics":[40],"is":[42],"call":[44],"them":[45],"as":[46],"user-defined":[47],"functions":[48],"(UDFs).":[49],"Unfortunately,":[50],"UDFs":[51],"can":[52,63],"be":[53,64],"difficult":[54,65],"for":[55],"query":[56],"optimizers":[57],"reason":[59],"over.":[60],"Furthermore,":[61],"they":[62],"implement":[67],"unintuitive":[69],"application":[71],"users.":[72]},"counts_by_year":[{"year":2025,"cited_by_count":2}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}