{"id":"https://openalex.org/W2134145495","doi":"https://doi.org/10.1109/icde.2007.368986","title":"SQL Queries Over Unstructured Text Databases","display_name":"SQL Queries Over Unstructured Text Databases","alternate_titles":[],"publication_year":2007,"publication_date":"2007-01-01","ids":{"openalex":"https://openalex.org/W2134145495","doi":"https://doi.org/10.1109/icde.2007.368986","mag":"2134145495"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2007.368986","doi":"https://doi.org/10.1109/icde.2007.368986","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2007.368986","pdf_url":null,"source":{"id":"https://openalex.org/S4210210321","display_name":"IEEE International Conference on Data Engineering (ICDE)","issn_l":"1084-4627","issn":["1084-4627","2375-0286"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","norway-2"],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2007 IEEE 23rd International Conference on Data Engineering","raw_type":"proceedings-article"},"parent_works":[],"lineage":["https://openalex.org/W2134145495"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"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/A5110209854","display_name":"Alpa Jain","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I78577930","display_name":"Columbia University","ror":"https://ror.org/00hj8s172","country_code":"US","type":"education","lineage":["https://openalex.org/I78577930"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alpa Jain","raw_affiliation_strings":["Columbia University, USA","Columbia University, New York, NY;"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Columbia University, USA","institution_ids":["https://openalex.org/I78577930"]},{"raw_affiliation_string":"Columbia University, New York, NY;","institution_ids":["https://openalex.org/I78577930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110256670","display_name":"AnHai Doan","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"AnHai Doan","raw_affiliation_strings":["University of Wisconsin, Madison, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Wisconsin, Madison, USA","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5080063580","display_name":"Luis Gravano","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I78577930","display_name":"Columbia University","ror":"https://ror.org/00hj8s172","country_code":"US","type":"education","lineage":["https://openalex.org/I78577930"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Luis Gravano","raw_affiliation_strings":["Columbia University, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Columbia University, USA","institution_ids":["https://openalex.org/I78577930"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.8963,"has_fulltext":false,"cited_by_count":38,"citation_normalized_percentile":{"value":0.92043755,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":87,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"1255","last_page":"1257"},"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.9047999978065491,"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.9047999978065491,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.03229999914765358,"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/T13083","display_name":"Advanced Text Analysis Techniques","score":0.010599999688565731,"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/sql-queries","display_name":"SQL queries","score":0.7429999709129333},{"id":"https://openalex.org/keywords/information-extraction","display_name":"information extraction","score":0.8650000095367432},{"id":"https://openalex.org/keywords/query-processing-strategies","display_name":"query processing strategies","score":0.8880000114440918}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.90045166015625},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7710343599319458},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5804117321968079},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5467414855957031},{"id":"https://openalex.org/C195807954","wikidata":"https://www.wikidata.org/wiki/Q1662562","display_name":"Information extraction","level":2,"score":0.5214904546737671},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.47642526030540466},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.46050095558166504},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.45929211378097534},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.45880404114723206},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4428774416446686},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.42822009325027466},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3342617154121399},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.2533418536186218},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.1314927637577057},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.09779846668243408},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2007.368986","doi":"https://doi.org/10.1109/icde.2007.368986","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2007.368986","pdf_url":null,"source":{"id":"https://openalex.org/S4210210321","display_name":"IEEE International Conference on Data Engineering (ICDE)","issn_l":"1084-4627","issn":["1084-4627","2375-0286"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","norway-2"],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2007 IEEE 23rd International Conference on Data Engineering","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W1489949474","https://openalex.org/W1520232900","https://openalex.org/W2069140227","https://openalex.org/W2096891167","https://openalex.org/W2103224511","https://openalex.org/W2103931177","https://openalex.org/W2108126629"],"related_works":["https://openalex.org/W2045463753","https://openalex.org/W2277214757","https://openalex.org/W2026469784","https://openalex.org/W2096891167","https://openalex.org/W2059653319","https://openalex.org/W6921831891","https://openalex.org/W2582661425","https://openalex.org/W3021023778","https://openalex.org/W7212635843"],"abstract_inverted_index":{"Text":[0],"documents":[1,73],"often":[2],"embed":[3],"data":[4],"that":[5,74,92],"is":[6,48,52,80],"structured":[7,25],"in":[8,38,124],"nature.":[9],"By":[10],"processing":[11,58,99,104,122],"a":[12,22,53],"text":[13],"database":[14],"with":[15],"information":[16,50,88,91],"extraction":[17,51,63,83],"systems,":[18],"we":[19,29,118],"can":[20,30],"define":[21],"variety":[23],"of":[24,72,107,126],"\"relations\"":[26],"over":[27],"which":[28],"then":[31],"issue":[32],"SQL":[33,36,120],"queries.":[34],"Processing":[35],"queries":[37],"this":[39],"text-based":[40],"scenario":[41],"presents":[42],"multiple":[43],"challenges.":[44],"One":[45],"key":[46,78],"challenge":[47,79],"efficiency:":[49],"time-consuming":[54],"process,":[55],"so":[56],"query":[57,98,121],"strategies":[59,123],"should":[60,94],"pick":[61],"efficient":[62],"systems":[64,84],"whenever":[65],"possible,":[66],"and":[67,129,132],"also":[68],"minimize":[69],"the":[70,134],"number":[71],"they":[75,93],"process.":[76],"Another":[77],"result":[81,112,130],"quality:":[82],"might":[85],"output":[86],"erroneous":[87],"or":[89],"miss":[90],"capture;":[95],"also,":[96],"efficiency-related":[97],"decisions":[100],"(e.g.,":[101],"to":[102],"avoid":[103],"large":[105],"numbers":[106],"useless":[108],"documents)":[109],"may":[110],"compromise":[111],"completeness.":[113],"To":[114],"address":[115],"these":[116,138],"challenges,":[117],"characterize":[119],"terms":[125],"their":[127],"efficiency":[128],"quality,":[131],"discuss":[133],"(user-specific)":[135],"tradeoff":[136],"between":[137],"two":[139],"properties.":[140]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2134145495","counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":4},{"year":2012,"cited_by_count":1}],"updated_date":"2026-11-17T12:49:18.490984","created_date":"2016-06-24T00:00:00"}
