{"id":"https://openalex.org/W1965605976","doi":"https://doi.org/10.1145/1099554.1099676","title":"Towards automatic association of relevant unstructured content with structured query results","display_name":"Towards automatic association of relevant unstructured content with structured query results","publication_year":2005,"publication_date":"2005-10-31","ids":{"openalex":"https://openalex.org/W1965605976","doi":"https://doi.org/10.1145/1099554.1099676","mag":"1965605976"},"language":"en","primary_location":{"id":"doi:10.1145/1099554.1099676","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1099554.1099676","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 14th ACM international conference on Information and knowledge management","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/A5100836787","display_name":"Prasan Roy","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210103279","display_name":"IBM Research - India","ror":"https://ror.org/014wt7r80","country_code":"IN","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210103279","https://openalex.org/I4210114115"]}],"countries":["IN","US"],"is_corresponding":true,"raw_author_name":"Prasan Roy","raw_affiliation_strings":["IBM India Research Lab, New Delhi, India","IBM, India Research Lab., New Delhi, India#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM India Research Lab, New Delhi, India","institution_ids":["https://openalex.org/I4210103279"]},{"raw_affiliation_string":"IBM, India Research Lab., New Delhi, India#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047987914","display_name":"Mukesh Mohania","orcid":"https://orcid.org/0000-0003-4429-1412"},"institutions":[{"id":"https://openalex.org/I4210103279","display_name":"IBM Research - India","ror":"https://ror.org/014wt7r80","country_code":"IN","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210103279","https://openalex.org/I4210114115"]},{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]}],"countries":["IN","US"],"is_corresponding":false,"raw_author_name":"Mukesh Mohania","raw_affiliation_strings":["IBM India Research Lab, New Delhi, India","IBM, India Research Lab., New Delhi, India#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM India Research Lab, New Delhi, India","institution_ids":["https://openalex.org/I4210103279"]},{"raw_affiliation_string":"IBM, India Research Lab., New Delhi, India#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5002696075","display_name":"Bhuvan Bamba","orcid":null},"institutions":[{"id":"https://openalex.org/I4210103279","display_name":"IBM Research - India","ror":"https://ror.org/014wt7r80","country_code":"IN","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210103279","https://openalex.org/I4210114115"]},{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]}],"countries":["IN","US"],"is_corresponding":false,"raw_author_name":"Bhuvan Bamba","raw_affiliation_strings":["IBM India Research Lab, New Delhi, India","IBM, India Research Lab., New Delhi, India#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM India Research Lab, New Delhi, India","institution_ids":["https://openalex.org/I4210103279"]},{"raw_affiliation_string":"IBM, India Research Lab., New Delhi, India#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5109919606","display_name":"Shree Raman","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210103279","display_name":"IBM Research - India","ror":"https://ror.org/014wt7r80","country_code":"IN","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210103279","https://openalex.org/I4210114115"]}],"countries":["IN","US"],"is_corresponding":false,"raw_author_name":"Shree Raman","raw_affiliation_strings":["IBM India Research Lab, New Delhi, India","IBM, India Research Lab., New Delhi, India#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM India Research Lab, New Delhi, India","institution_ids":["https://openalex.org/I4210103279"]},{"raw_affiliation_string":"IBM, India Research Lab., New Delhi, India#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5100836787"],"corresponding_institution_ids":["https://openalex.org/I1341412227","https://openalex.org/I4210103279"],"apc_list":null,"apc_paid":null,"fwci":3.5565,"has_fulltext":false,"cited_by_count":39,"citation_normalized_percentile":{"value":0.93398922,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"405","last_page":"412"},"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.9995999932289124,"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.9995999932289124,"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.9984999895095825,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.996999979019165,"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.8958228826522827},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7147748470306396},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5830419659614563},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5821908712387085},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5786672234535217},{"id":"https://openalex.org/keywords/unstructured-data","display_name":"Unstructured data","score":0.546360433101654},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5251571536064148},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.5132675170898438},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.47790321707725525},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.4353683590888977},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.41557735204696655},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.4018828868865967},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3988659679889679},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.23536694049835205},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.11244964599609375},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.10425880551338196}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8958228826522827},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7147748470306396},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5830419659614563},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5821908712387085},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5786672234535217},{"id":"https://openalex.org/C2781252014","wikidata":"https://www.wikidata.org/wiki/Q1141900","display_name":"Unstructured data","level":3,"score":0.546360433101654},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5251571536064148},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.5132675170898438},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.47790321707725525},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4353683590888977},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.41557735204696655},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.4018828868865967},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3988659679889679},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.23536694049835205},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.11244964599609375},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.10425880551338196}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1099554.1099676","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1099554.1099676","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 14th ACM international conference on Information and knowledge management","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.91.9044","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.91.9044","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cc.gatech.edu/grads/b/bhuvan/Papers/CIKM2005 SCORE.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":27,"referenced_works":["https://openalex.org/W72853727","https://openalex.org/W119481552","https://openalex.org/W137375444","https://openalex.org/W142207922","https://openalex.org/W143852345","https://openalex.org/W166877056","https://openalex.org/W828641074","https://openalex.org/W1518100098","https://openalex.org/W1539585011","https://openalex.org/W1660390307","https://openalex.org/W1980775755","https://openalex.org/W1988879967","https://openalex.org/W2029036662","https://openalex.org/W2030277392","https://openalex.org/W2031900922","https://openalex.org/W2052581258","https://openalex.org/W2072419714","https://openalex.org/W2100485384","https://openalex.org/W2103229629","https://openalex.org/W2106091572","https://openalex.org/W2121350579","https://openalex.org/W2142132842","https://openalex.org/W2169624745","https://openalex.org/W2207067200","https://openalex.org/W2989499211","https://openalex.org/W4206002161","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2572349046","https://openalex.org/W2096359267","https://openalex.org/W1981131819","https://openalex.org/W2146885082","https://openalex.org/W3125756434","https://openalex.org/W2406556739","https://openalex.org/W2970853428","https://openalex.org/W1966669067","https://openalex.org/W2026739340","https://openalex.org/W2186703450"],"abstract_inverted_index":{"Faced":[0],"with":[1,137],"growing":[2],"knowledge":[3],"management":[4],"needs,":[5],"enterprises":[6],"are":[7],"increasingly":[8],"realizing":[9],"the":[10,31,36,41,56,61,70,82,107,116,125],"importance":[11],"of":[12,52,94],"seamlessly":[13],"integrating":[14],"critical":[15],"business":[16],"information":[17,28,74,123],"distributed":[18],"across":[19],"both":[20],"structured":[21,43,83],"and":[22,48,85,119],"unstructured":[23,58,103],"data":[24,44,59],"sources.":[25],"In":[26],"existing":[27],"integration":[29],"solutions,":[30],"application":[32,71],"needs":[33,75],"to":[34,39,54,100],"formulate":[35],"SQL":[37,79],"logic":[38],"retrieve":[40,55,101],"needed":[42],"on":[45,60,81],"one":[46],"hand,":[47],"identify":[49],"a":[50,66,78,92],"set":[51,93],"keywords":[53,95,113],"related":[57,122],"other.":[62],"This":[63],"paper":[64],"proposes":[65],"novel":[67],"approach":[68],"wherein":[69],"specifies":[72],"its":[73],"using":[76],"only":[77],"query":[80,87,117],"data,":[84],"this":[86],"is":[88],"automatically":[89],"``translated''":[90],"into":[91],"that":[96,131],"can":[97],"be":[98],"used":[99,109],"relevant":[102],"data.":[104],"We":[105,128],"describe":[106],"techniques":[108,133],"for":[110],"obtaining":[111],"these":[112,132],"from":[114],"(i)":[115],"result,":[118],"(ii)":[120],"additional":[121],"in":[124],"underlying":[126],"database.":[127],"further":[129],"show":[130],"achieve":[134],"high":[135],"accuracy":[136],"very":[138],"reasonable":[139],"overheads.":[140]},"counts_by_year":[{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":6},{"year":2012,"cited_by_count":1}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}