{"id":"https://openalex.org/W2114948500","doi":"https://doi.org/10.1145/1963192.1963219","title":"SmartInt","display_name":"SmartInt","publication_year":2011,"publication_date":"2011-03-28","ids":{"openalex":"https://openalex.org/W2114948500","doi":"https://doi.org/10.1145/1963192.1963219","mag":"2114948500"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/1963192.1963219","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-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/A5013313513","display_name":"Ravi Gummadi","orcid":null},"institutions":[{"id":"https://openalex.org/I55732556","display_name":"Arizona State University","ror":"https://ror.org/03efmqc40","country_code":"US","type":"education","lineage":["https://openalex.org/I55732556"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ravi Gummadi","raw_affiliation_strings":["Arizona State University , Tempe , AZ , USA"],"affiliations":[{"raw_affiliation_string":"Arizona State University , Tempe , AZ , USA","institution_ids":["https://openalex.org/I55732556"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057365872","display_name":"Anupam Khulbe","orcid":null},"institutions":[{"id":"https://openalex.org/I55732556","display_name":"Arizona State University","ror":"https://ror.org/03efmqc40","country_code":"US","type":"education","lineage":["https://openalex.org/I55732556"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Anupam Khulbe","raw_affiliation_strings":["Arizona State University , Tempe , AZ , USA"],"affiliations":[{"raw_affiliation_string":"Arizona State University , Tempe , AZ , USA","institution_ids":["https://openalex.org/I55732556"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5065343423","display_name":"Aravind Kalavagattu","orcid":null},"institutions":[{"id":"https://openalex.org/I55732556","display_name":"Arizona State University","ror":"https://ror.org/03efmqc40","country_code":"US","type":"education","lineage":["https://openalex.org/I55732556"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Aravind Kalavagattu","raw_affiliation_strings":["Arizona State University , Tempe , AZ , USA"],"affiliations":[{"raw_affiliation_string":"Arizona State University , Tempe , AZ , USA","institution_ids":["https://openalex.org/I55732556"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041454781","display_name":"Sanil Salvi","orcid":null},"institutions":[{"id":"https://openalex.org/I55732556","display_name":"Arizona State University","ror":"https://ror.org/03efmqc40","country_code":"US","type":"education","lineage":["https://openalex.org/I55732556"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sanil Salvi","raw_affiliation_strings":["Arizona State University , Tempe , AZ , USA"],"affiliations":[{"raw_affiliation_string":"Arizona State University , Tempe , AZ , USA","institution_ids":["https://openalex.org/I55732556"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5023323170","display_name":"Subbarao Kambhampati","orcid":"https://orcid.org/0000-0002-9069-0265"},"institutions":[{"id":"https://openalex.org/I55732556","display_name":"Arizona State University","ror":"https://ror.org/03efmqc40","country_code":"US","type":"education","lineage":["https://openalex.org/I55732556"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Subbarao Kambhampati","raw_affiliation_strings":["Arizona State University , Tempe , AZ , USA"],"affiliations":[{"raw_affiliation_string":"Arizona State University , Tempe , AZ , USA","institution_ids":["https://openalex.org/I55732556"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.163,"has_fulltext":true,"fulltext_origin":"ngrams","cited_by_count":4,"citation_normalized_percentile":{"value":0.715831,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":78,"max":80},"biblio":{"volume":null,"issue":null,"first_page":"51","last_page":"52"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality Assessment and Improvement","score":0.9998,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality Assessment and Improvement","score":0.9998,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"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/T10317","display_name":"Data Stream Management Systems and Techniques","score":0.9991,"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":"Trajectory Data Mining and Analysis","score":0.9987,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/spurious-relationship","display_name":"Spurious relationship","score":0.5871127},{"id":"https://openalex.org/keywords/normalization","display_name":"Normalization (sociology)","score":0.558715},{"id":"https://openalex.org/keywords/column-oriented-database-systems","display_name":"Column-oriented Database Systems","score":0.549014},{"id":"https://openalex.org/keywords/relational-database-systems","display_name":"Relational Database Systems","score":0.537801},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query Optimization","score":0.526712},{"id":"https://openalex.org/keywords/data-integration","display_name":"Data Integration","score":0.525982},{"id":"https://openalex.org/keywords/web-data-extraction","display_name":"Web Data Extraction","score":0.520956},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.49593648}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8472781},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.80689085},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.60412025},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.59393245},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.58768755},{"id":"https://openalex.org/C97256817","wikidata":"https://www.wikidata.org/wiki/Q1462316","display_name":"Spurious relationship","level":2,"score":0.5871127},{"id":"https://openalex.org/C136886441","wikidata":"https://www.wikidata.org/wiki/Q926129","display_name":"Normalization (sociology)","level":2,"score":0.558715},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.49593648},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.44071653},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3427881},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.32766977},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.103705704},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.091444045},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C144024400","wikidata":"https://www.wikidata.org/wiki/Q21201","display_name":"Sociology","level":0,"score":0.0},{"id":"https://openalex.org/C19165224","wikidata":"https://www.wikidata.org/wiki/Q23404","display_name":"Anthropology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/1963192.1963219","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":21,"referenced_works":["https://openalex.org/W1506285740","https://openalex.org/W1539585011","https://openalex.org/W1593317353","https://openalex.org/W1992673035","https://openalex.org/W2098388305","https://openalex.org/W2102489964","https://openalex.org/W2111071245","https://openalex.org/W2113487403","https://openalex.org/W2130607970","https://openalex.org/W2132610455","https://openalex.org/W2152191782","https://openalex.org/W2154711808","https://openalex.org/W2156543375","https://openalex.org/W2156580346","https://openalex.org/W2160770893","https://openalex.org/W2166549982","https://openalex.org/W2169624745","https://openalex.org/W2171350931","https://openalex.org/W2171498518","https://openalex.org/W2184196111","https://openalex.org/W2950528741"],"related_works":["https://openalex.org/W941090075","https://openalex.org/W3134374554","https://openalex.org/W3113091479","https://openalex.org/W2393491644","https://openalex.org/W2382891957","https://openalex.org/W2237480245","https://openalex.org/W2162899405","https://openalex.org/W2088925915","https://openalex.org/W2075065631","https://openalex.org/W2044987316"],"abstract_inverted_index":{"Many":[0],"web":[1,143],"databases":[2,144],"can":[3,120],"be":[4],"seen":[5],"as":[6],"providing":[7],"partial":[8],"and":[9,89,147,167],"overlapping":[10],"information":[11,26],"about":[12,27],"entities":[13,30,78,127],"in":[14,92,122],"the":[15,25,28,43,65,69,77,82,87,94,153],"world.":[16],"To":[17],"answer":[18],"queries":[19],"effectively,":[20],"we":[21,61],"need":[22],"to":[23,58,63],"integrate":[24],"individual":[29],"that":[31,137,158],"are":[32,96],"fragmented":[33,142],"over":[34,116,141],"multiple":[35],"sources.":[36],"At":[37],"first":[38],"blush":[39],"this":[40],"is":[41],"just":[42],"inverse":[44],"of":[45,75,86,124],"traditional":[46],"database":[47],"normalization":[48],"problem":[49],"-":[50,105],"rather":[51],"than":[52],"go":[53],"from":[54],"a":[55,134,162],"universal":[56,66],"relation":[57,67],"normalized":[59],"tables,":[60],"want":[62],"reconstruct":[64],"given":[68],"tables":[70,110],"(sources).":[71],"The":[72],"standard":[73],"way":[74,91],"reconstructing":[76],"will":[79],"involve":[80],"joining":[81],"tables.":[83],"Unfortunately,":[84],"because":[85],"autonomous":[88],"decentralized":[90],"which":[93],"sources":[95],"populated,":[97],"they":[98],"often":[99],"do":[100,111],"not":[101],"have":[102],"Primary":[103],"Key":[104,107],"Foreign":[106],"relations.":[108],"While":[109],"share":[112],"attributes,":[113],"direct":[114],"joins":[115],"these":[117],"shared":[118],"attributes":[119],"result":[121],"reconstruction":[123],"many":[125],"spurious":[126],"thus":[128],"seriously":[129],"compromising":[130],"precision.":[131],"We":[132],"present":[133],"unified":[135],"approach":[136],"supports":[138],"intelligent":[139],"retrieval":[140,160],"by":[145],"mining":[146],"using":[148],"inter-table":[149],"dependencies.":[150],"Experiments":[151],"with":[152],"prototype":[154],"implementation,":[155],"SmartInt,":[156],"show":[157],"its":[159],"strikes":[161],"good":[163],"balance":[164],"between":[165],"precision":[166],"recall.":[168]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2114948500","counts_by_year":[{"year":2016,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2024-12-02T16:21:21.615113","created_date":"2016-06-24"}