{"id":"https://openalex.org/W3196855244","doi":"https://doi.org/10.1145/3484622.3484624","title":"Database Principles and Challenges in Text Analysis","display_name":"Database Principles and Challenges in Text Analysis","publication_year":2021,"publication_date":"2021-08-24","ids":{"openalex":"https://openalex.org/W3196855244","doi":"https://doi.org/10.1145/3484622.3484624","mag":"3196855244"},"language":"en","primary_location":{"id":"doi:10.1145/3484622.3484624","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3484622.3484624","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/A5082548231","display_name":"Johannes Doleschal","orcid":null},"institutions":[{"id":"https://openalex.org/I878454856","display_name":"Hasselt University","ror":"https://ror.org/04nbhqj75","country_code":"BE","type":"education","lineage":["https://openalex.org/I878454856"]},{"id":"https://openalex.org/I54009628","display_name":"University of Bayreuth","ror":"https://ror.org/0234wmv40","country_code":"DE","type":"education","lineage":["https://openalex.org/I54009628"]}],"countries":["BE","DE"],"is_corresponding":true,"raw_author_name":"Johannes Doleschal","raw_affiliation_strings":["University of Bayreuth & Hasselt University"],"affiliations":[{"raw_affiliation_string":"University of Bayreuth & Hasselt University","institution_ids":["https://openalex.org/I878454856","https://openalex.org/I54009628"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006706357","display_name":"Benny Kimelfeld","orcid":"https://orcid.org/0000-0002-7156-1572"},"institutions":[{"id":"https://openalex.org/I174306211","display_name":"Technion \u2013 Israel Institute of Technology","ror":"https://ror.org/03qryx823","country_code":"IL","type":"education","lineage":["https://openalex.org/I174306211"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Benny Kimelfeld","raw_affiliation_strings":["Technion, Israel"],"affiliations":[{"raw_affiliation_string":"Technion, Israel","institution_ids":["https://openalex.org/I174306211"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5016412428","display_name":"Wim Martens","orcid":"https://orcid.org/0000-0001-9480-3522"},"institutions":[{"id":"https://openalex.org/I54009628","display_name":"University of Bayreuth","ror":"https://ror.org/0234wmv40","country_code":"DE","type":"education","lineage":["https://openalex.org/I54009628"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Wim Martens","raw_affiliation_strings":["University of Bayreuth"],"affiliations":[{"raw_affiliation_string":"University of Bayreuth","institution_ids":["https://openalex.org/I54009628"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5082548231"],"corresponding_institution_ids":["https://openalex.org/I54009628","https://openalex.org/I878454856"],"apc_list":null,"apc_paid":null,"fwci":0.8532,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.79603122,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":97},"biblio":{"volume":"50","issue":"2","first_page":"6","last_page":"17"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12016","display_name":"Web Data Mining and Analysis","score":0.9966999888420105,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9966999888420105,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9959999918937683,"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/T10028","display_name":"Topic Modeling","score":0.9930999875068665,"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/computer-science","display_name":"Computer science","score":0.8705729246139526},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5745036602020264},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5493549704551697},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4995434284210205},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.4215441346168518},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.4150620698928833},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3904411196708679},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.32462209463119507},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.07697632908821106}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8705729246139526},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5745036602020264},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5493549704551697},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4995434284210205},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.4215441346168518},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.4150620698928833},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3904411196708679},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.32462209463119507},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.07697632908821106},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3484622.3484624","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3484622.3484624","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"},{"id":"pmh:oai:documentserver.uhasselt.be:1942/35394","is_oa":false,"landing_page_url":"http://hdl.handle.net/1942/35394","pdf_url":null,"source":{"id":"https://openalex.org/S4306401926","display_name":"Document Server@UHasselt (UHasselt)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I878454856","host_organization_name":"Hasselt University","host_organization_lineage":["https://openalex.org/I878454856"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":75,"referenced_works":["https://openalex.org/W1423339008","https://openalex.org/W1493270114","https://openalex.org/W1495981708","https://openalex.org/W1579803282","https://openalex.org/W1599188306","https://openalex.org/W1828401780","https://openalex.org/W1934084512","https://openalex.org/W1985558974","https://openalex.org/W1991018417","https://openalex.org/W2014729492","https://openalex.org/W2050453134","https://openalex.org/W2051283034","https://openalex.org/W2064838169","https://openalex.org/W2098720114","https://openalex.org/W2107005506","https://openalex.org/W2114524997","https://openalex.org/W2129657639","https://openalex.org/W2141456009","https://openalex.org/W2144416276","https://openalex.org/W2251135946","https://openalex.org/W2293299776","https://openalex.org/W2296283641","https://openalex.org/W2319151433","https://openalex.org/W2363785281","https://openalex.org/W2536131596","https://openalex.org/W2565515778","https://openalex.org/W2616567161","https://openalex.org/W2750884547","https://openalex.org/W2769041395","https://openalex.org/W2785321994","https://openalex.org/W2798396931","https://openalex.org/W2799038541","https://openalex.org/W2883227679","https://openalex.org/W2890631112","https://openalex.org/W2895689912","https://openalex.org/W2913389685","https://openalex.org/W2948686875","https://openalex.org/W2949802031","https://openalex.org/W2949894935","https://openalex.org/W2959716049","https://openalex.org/W2962679309","https://openalex.org/W2963170321","https://openalex.org/W2963265283","https://openalex.org/W2963383248","https://openalex.org/W2967222032","https://openalex.org/W2968303554","https://openalex.org/W2995170783","https://openalex.org/W3007878418","https://openalex.org/W3013294921","https://openalex.org/W3014011840","https://openalex.org/W3031875365","https://openalex.org/W3035327456","https://openalex.org/W3093809904","https://openalex.org/W3099884787","https://openalex.org/W3111890340","https://openalex.org/W3118416566","https://openalex.org/W3123650326","https://openalex.org/W3137215238","https://openalex.org/W3139067882","https://openalex.org/W3155438827","https://openalex.org/W3198906529","https://openalex.org/W4206192903","https://openalex.org/W4285719527","https://openalex.org/W6609216092","https://openalex.org/W6629633590","https://openalex.org/W6635684370","https://openalex.org/W6636393250","https://openalex.org/W6744318443","https://openalex.org/W6747299006","https://openalex.org/W6755174803","https://openalex.org/W6768726467","https://openalex.org/W6769206166","https://openalex.org/W6771205838","https://openalex.org/W6774691911","https://openalex.org/W6784855945"],"related_works":["https://openalex.org/W2267077731","https://openalex.org/W1510134535","https://openalex.org/W2386578196","https://openalex.org/W2483382562","https://openalex.org/W3091612633","https://openalex.org/W2085988990","https://openalex.org/W1528519853","https://openalex.org/W2376710457","https://openalex.org/W1897774768","https://openalex.org/W3006903421"],"abstract_inverted_index":{"A":[0,44],"common":[1],"conceptual":[2],"view":[3],"of":[4,9,53,79,87],"text":[5,19,31,74],"analysis":[6,32,75],"is":[7,51],"that":[8,46,52,68],"a":[10,24],"two-step":[11],"process,":[12],"where":[13],"we":[14,60,84],"first":[15],"extract":[16],"relations":[17],"from":[18],"documents":[20],"and":[21,37,93],"then":[22],"apply":[23],"relational":[25,42],"query":[26,88,95],"over":[27],"the":[28,54,77],"result.":[29],"Hence,":[30],"shares":[33],"technical":[34],"challenges":[35],"with,":[36],"can":[38],"draw":[39],"ideas":[40],"from,":[41],"databases.":[43],"framework":[45],"formally":[47],"instantiates":[48],"this":[49,58],"connection":[50],"document":[55,80],"spanners.":[56,81],"In":[57],"article,":[59],"review":[61],"recent":[62],"advances":[63],"in":[64],"various":[65],"research":[66],"efforts":[67],"adapt":[69],"fundamental":[70],"database":[71],"concepts":[72],"to":[73],"through":[76],"lens":[78],"Among":[82],"others,":[83],"discuss":[85],"aspects":[86],"evaluation,":[89],"aggregate":[90],"queries,":[91],"provenance,":[92],"distributed":[94],"planning.":[96]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2023,"cited_by_count":3}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}