{"id":"https://openalex.org/W7220760305","doi":null,"title":"Accelerating queries for structured and unstructured data","display_name":"Accelerating queries for structured and unstructured data","alternate_titles":[],"publication_year":2024,"publication_date":"2024-04-30","ids":{"openalex":"https://openalex.org/W7220760305"},"language":"en","primary_location":{"id":"pmh:oai:www.ideals.illinois.edu:2142/124567","doi":null,"is_oa":true,"landing_page_url":"https://hdl.handle.net/2142/124567","pdf_url":"https://www.ideals.illinois.edu/items/131667/bitstreams/437442/data.pdf","source":{"id":"https://openalex.org/S4306401358","display_name":"Illinois Digital Environment for Access to Learning and Scholarship (University of Illinois at Urbana-Champaign)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I2801919071","host_organization_name":"University of Illinois System","host_organization_lineage":["https://openalex.org/I2801919071"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"parent_works":[],"lineage":["https://openalex.org/W7220760305"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://www.ideals.illinois.edu/items/131667/bitstreams/437442/data.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5103188343","display_name":"Tengjun Jin","orcid":"https://orcid.org/0009-0005-0353-4184","observed_orcids":["https://orcid.org/0009-0005-0353-4184"]},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Jin, Tengjun","raw_affiliation_strings":["Graduate College of the University of Illinois Urbana-Champaign , 2024 Urbana , Illinois"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Graduate College of the University of Illinois Urbana-Champaign , 2024 Urbana , Illinois","institution_ids":["https://openalex.org/I157725225"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5103188343"],"corresponding_institution_ids":["https://openalex.org/I157725225"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9976000189781189,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9976000189781189,"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.000699999975040555,"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/T11891","display_name":"Big Data and Business Intelligence","score":0.00019999999494757503,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/approximate-query-processing","display_name":"approximate query processing","score":0.9990000128746033},{"id":"https://openalex.org/keywords/aggregate-queries","display_name":"aggregate queries","score":0.7229999899864197},{"id":"https://openalex.org/keywords/unstructured-data","display_name":"unstructured data","score":0.7990000247955322},{"id":"https://openalex.org/keywords/machine-learning-model-integration","display_name":"machine learning model integration","score":0.7490000128746033},{"id":"https://openalex.org/keywords/virtual-tables","display_name":"virtual tables","score":0.9769999980926514},{"id":"https://openalex.org/keywords/online-sampling","display_name":"online sampling","score":0.9430000185966492},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.5529999732971191},{"id":"https://openalex.org/keywords/middleware","display_name":"middleware","score":0.37299999594688416}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7013999819755554},{"id":"https://openalex.org/C2781252014","wikidata":"https://www.wikidata.org/wiki/Q1141900","display_name":"Unstructured data","level":3,"score":0.5605000257492065},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.32600000500679016},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.28780001401901245},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.26930001378059387},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2644999921321869},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.24390000104904175},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.23929999768733978},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.23849999904632568},{"id":"https://openalex.org/C165064840","wikidata":"https://www.wikidata.org/wiki/Q1321061","display_name":"Matching (statistics)","level":2,"score":0.23759999871253967}],"mesh":[],"locations_count":1,"locations":[{"id":"pmh:oai:www.ideals.illinois.edu:2142/124567","doi":null,"is_oa":true,"landing_page_url":"https://hdl.handle.net/2142/124567","pdf_url":"https://www.ideals.illinois.edu/items/131667/bitstreams/437442/data.pdf","source":{"id":"https://openalex.org/S4306401358","display_name":"Illinois Digital Environment for Access to Learning and Scholarship (University of Illinois at Urbana-Champaign)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I2801919071","host_organization_name":"University of Illinois System","host_organization_lineage":["https://openalex.org/I2801919071"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"}],"best_oa_location":{"id":"pmh:oai:www.ideals.illinois.edu:2142/124567","doi":null,"is_oa":true,"landing_page_url":"https://hdl.handle.net/2142/124567","pdf_url":"https://www.ideals.illinois.edu/items/131667/bitstreams/437442/data.pdf","source":{"id":"https://openalex.org/S4306401358","display_name":"Illinois Digital Environment for Access to Learning and Scholarship (University of Illinois at Urbana-Champaign)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I2801919071","host_organization_name":"University of Illinois System","host_organization_lineage":["https://openalex.org/I2801919071"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7220760305.pdf","grobid_xml":"https://content.openalex.org/works/W7220760305.grobid-xml"},"referenced_works_count":29,"referenced_works":["https://openalex.org/W1592355944","https://openalex.org/W1656389077","https://openalex.org/W1973264045","https://openalex.org/W2002791618","https://openalex.org/W2020584928","https://openalex.org/W2068634907","https://openalex.org/W2071989194","https://openalex.org/W2152029707","https://openalex.org/W2421547754","https://openalex.org/W2429510775","https://openalex.org/W2436406362","https://openalex.org/W2613577383","https://openalex.org/W2752236330","https://openalex.org/W2786278116","https://openalex.org/W2795530455","https://openalex.org/W2808184646","https://openalex.org/W2891345706","https://openalex.org/W2949054050","https://openalex.org/W3000318171","https://openalex.org/W3032112964","https://openalex.org/W3082972076","https://openalex.org/W3106772683","https://openalex.org/W3185475042","https://openalex.org/W4205750058","https://openalex.org/W4250212406","https://openalex.org/W4251617391","https://openalex.org/W4281996556","https://openalex.org/W4287670127","https://openalex.org/W4386768626"],"related_works":["https://openalex.org/W3144468514","https://openalex.org/W7220821596","https://openalex.org/W7220758351","https://openalex.org/W2409967274","https://openalex.org/W7220761354","https://openalex.org/W7220761444","https://openalex.org/W122707235","https://openalex.org/W783149486","https://openalex.org/W7220815799","https://openalex.org/W7053419503"],"abstract_inverted_index":{"Data":[0],"analytics":[1,23,122],"is":[2],"important":[3],"for":[4,21,182],"making":[5],"data-driven":[6],"decisions.As":[7],"data":[8,112,155],"volumes":[9],"expand,":[10],"the":[11,64,194,208],"efficiency":[12],"and":[13,61,94,116,138,172,186,204],"cost":[14],"of":[15,66,200,210,219],"executing":[16],"queries":[17,37,67,93,188],"become":[18],"critical":[19],"concerns":[20],"analysts.Traditionally,":[22],"systems":[24,123],"have":[25,42,75],"prioritized":[26],"structured":[27],"data.Approximate":[28],"Query":[29],"Processing":[30],"(AQP)":[31],"systems,":[32],"which":[33],"provide":[34,198],"faster":[35],"aggregation":[36,92],"by":[38,214],"delivering":[39],"approximate":[40,185],"results,":[41],"been":[43],"developed":[44],"to":[45,55,90,118,136,142,160,202,216],"enhance":[46],"efficiency.However,":[47],"they":[48,68],"are":[49,106],"limited":[50],"used":[51],"in":[52,101,109,189],"real-application":[53],"due":[54],"compatibility":[56],"issues":[57],"with":[58],"popular":[59],"databases":[60],"restrictions":[62],"on":[63],"types":[65],"can":[69,95,133,197,206],"handle.To":[70],"overcome":[71],"these":[72,149],"limitations,":[73],"we":[74,151],"designed":[76],"an":[77],"innovative":[78],"AQP":[79,195],"system":[80,85,196],"that":[81,193],"functions":[82,130],"as":[83,165,177,179],"middleware.This":[84],"uses":[86],"online":[87],"sampling":[88],"techniques":[89],"accelerate":[91],"meet":[96],"user-specified":[97],"error":[98],"targets.With":[99],"advancements":[100],"machine":[102],"learning":[103],"(ML),":[104],"analysts":[105],"increasingly":[107],"interested":[108],"analyzing":[110],"unstructured":[111],"(videos,":[113],"images,":[114],"text,":[115],"audio)":[117],"extract":[119],"semantic":[120],"information.Current":[121],"typically":[124],"integrate":[125],"ML":[126,162,211],"models":[127],"through":[128,169],"user-defined":[129],"(UDFs).These":[131],"UDFs":[132],"be":[134],"difficult":[135],"optimize":[137],"require":[139],"application":[140],"users":[141,159],"write":[143],"complex,":[144],"nested":[145],"table":[146],"expressions.To":[147],"address":[148],"challenges,":[150],"introduce":[152],"a":[153],"new":[154],"model,":[156],"AIDM,":[157,176],"enabling":[158],"query":[161],"model":[163,212],"outputs":[164],"standard":[166],"SQL":[167],"tables,":[168],"virtual":[170,173],"columns":[171],"tables.We":[174],"implement":[175],"well":[178],"novel":[180],"optimizations":[181],"accelerating":[183],"both":[184],"exact":[187],"AIDB.Our":[190],"evaluations":[191],"show":[192],"speedups":[199],"up":[201,215],"87x":[203],"AIDB":[205],"reduce":[207],"number":[209],"invocations":[213],"98%.":[217],"Table":[218],"contentsChapter":[220],"1":[221],"Introduction":[222],".":[223,224,225,226,227,228]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W7220760305","counts_by_year":[],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2026-10-07T00:00:00"}
