{"id":"https://openalex.org/W2130607970","doi":"https://doi.org/10.1109/icde.2010.5447729","title":"SMARTINT: A system for answering queries over web databases using attribute dependencies","display_name":"SMARTINT: A system for answering queries over web databases using attribute dependencies","publication_year":2010,"publication_date":"2010-01-01","ids":{"openalex":"https://openalex.org/W2130607970","doi":"https://doi.org/10.1109/icde.2010.5447729","mag":"2130607970"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2010.5447729","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2010.5447729","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2010 IEEE 26th International Conference on Data Engineering (ICDE 2010)","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/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":true,"raw_author_name":"Ravi Gummadi","raw_affiliation_strings":["Department of Computer Science, Arizona State University, Tempe, AZ, USA","Dept. of Computer Science, Arizona State University, Tempe, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Arizona State University, Tempe, AZ, USA","institution_ids":["https://openalex.org/I55732556"]},{"raw_affiliation_string":"Dept. of Computer Science, Arizona State University, Tempe, 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":["Department of Computer Science, Arizona State University, Tempe, AZ, USA","Dept. of Computer Science, Arizona State University, Tempe, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Arizona State University, Tempe, AZ, USA","institution_ids":["https://openalex.org/I55732556"]},{"raw_affiliation_string":"Dept. of Computer Science, Arizona State University, Tempe, 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":["Department of Computer Science, Arizona State University, Tempe, AZ, USA","Dept. of Computer Science, Arizona State University, Tempe, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Arizona State University, Tempe, AZ, USA","institution_ids":["https://openalex.org/I55732556"]},{"raw_affiliation_string":"Dept. of Computer Science, Arizona State University, Tempe, 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":["Department of Computer Science, Arizona State University, Tempe, AZ, USA","Dept. of Computer Science, Arizona State University, Tempe, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Arizona State University, Tempe, AZ, USA","institution_ids":["https://openalex.org/I55732556"]},{"raw_affiliation_string":"Dept. of Computer Science, Arizona State University, Tempe, 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":["Department of Computer Science, Arizona State University, Tempe, AZ, USA","Dept. of Computer Science, Arizona State University, Tempe, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Arizona State University, Tempe, AZ, USA","institution_ids":["https://openalex.org/I55732556"]},{"raw_affiliation_string":"Dept. of Computer Science, Arizona State University, Tempe, USA","institution_ids":["https://openalex.org/I55732556"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5013313513"],"corresponding_institution_ids":["https://openalex.org/I55732556"],"apc_list":null,"apc_paid":null,"fwci":1.2086,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.83028701,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1149","last_page":"1152"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9998999834060669,"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 and Management","score":0.9998999834060669,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9988999962806702,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9987999796867371,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8351811170578003},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.7624475955963135},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.6409798264503479},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5815584063529968},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.5286553502082825},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5227553844451904},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.4900733232498169},{"id":"https://openalex.org/keywords/spurious-relationship","display_name":"Spurious relationship","score":0.47749918699264526},{"id":"https://openalex.org/keywords/normalization","display_name":"Normalization (sociology)","score":0.4473518431186676},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.392002671957016},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.32436394691467285},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1004178524017334}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8351811170578003},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.7624475955963135},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6409798264503479},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5815584063529968},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.5286553502082825},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5227553844451904},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.4900733232498169},{"id":"https://openalex.org/C97256817","wikidata":"https://www.wikidata.org/wiki/Q1462316","display_name":"Spurious relationship","level":2,"score":0.47749918699264526},{"id":"https://openalex.org/C136886441","wikidata":"https://www.wikidata.org/wiki/Q926129","display_name":"Normalization (sociology)","level":2,"score":0.4473518431186676},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.392002671957016},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.32436394691467285},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1004178524017334},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","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/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.0},{"id":"https://openalex.org/C19165224","wikidata":"https://www.wikidata.org/wiki/Q23404","display_name":"Anthropology","level":1,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/icde.2010.5447729","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2010.5447729","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2010 IEEE 26th International Conference on Data Engineering (ICDE 2010)","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.148.4894","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.148.4894","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://rakaposhi.eas.asu.edu/smartint-icde10.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.41999998688697815,"display_name":"Partnerships for the goals","id":"https://metadata.un.org/sdg/17"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":19,"referenced_works":["https://openalex.org/W47621535","https://openalex.org/W145332093","https://openalex.org/W1630964756","https://openalex.org/W1839867872","https://openalex.org/W1992673035","https://openalex.org/W2098388305","https://openalex.org/W2102489964","https://openalex.org/W2111071245","https://openalex.org/W2148942721","https://openalex.org/W2153487405","https://openalex.org/W2156543375","https://openalex.org/W2156580346","https://openalex.org/W2159552643","https://openalex.org/W2160770893","https://openalex.org/W2166549982","https://openalex.org/W2169624745","https://openalex.org/W2184196111","https://openalex.org/W6683065386","https://openalex.org/W6686545972"],"related_works":["https://openalex.org/W3113091479","https://openalex.org/W2162899405","https://openalex.org/W2016456293","https://openalex.org/W2161128265","https://openalex.org/W1997896902","https://openalex.org/W2138101384","https://openalex.org/W2140894225","https://openalex.org/W2125826941","https://openalex.org/W4212828571","https://openalex.org/W1973373052"],"abstract_inverted_index":{"Many":[0],"web":[1],"databases":[2],"can":[3,120],"be":[4],"seen":[5],"as":[6],"providing":[7],"partial":[8],"and":[9,89,165,186],"overlapping":[10],"information":[11,26],"about":[12,27],"entities":[13,30,78,127],"in":[14,92,122,144],"the":[15,25,28,43,65,69,77,82,87,94,139,153],"world.":[16],"To":[17],"answer":[18],"queries":[19],"effectively,":[20],"we":[21,61],"need":[22],"to":[23,58,63,157,179],"integrate":[24],"individual":[29],"that":[31],"are":[32,96,177],"fragmented":[33],"over":[34,116],"multiple":[35],"sources.":[36],"At":[37],"first":[38],"blush":[39],"this":[40],"is":[41,135],"just":[42],"inverse":[44],"of":[45,75,86,124,141,162],"traditional":[46],"database":[47],"normalization":[48],"problem":[49,140],"-":[50,105],"rather":[51],"than":[52],"go":[53],"from":[54],"a":[55,148,160,181],"universal":[56,66],"relation":[57,67],"normalized":[59],"tables,":[60],"want":[62],"reconstruct":[64],"given":[68],"tables":[70,110,164],"(sources).":[71],"The":[72,170],"standard":[73],"way":[74,91],"reconstructing":[76],"will":[79],"involve":[80],"joining":[81,168],"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],"naive":[114],"joins":[115],"these":[117],"shared":[118],"attributes":[119],"result":[121,171],"reconstruction":[123],"many":[125],"spurious":[126],"thus":[128],"seriously":[129],"compromising":[130],"precision.":[131],"Our":[132],"system,":[133],"SMARTINT":[134],"aimed":[136],"at":[137],"addressing":[138],"data":[142],"integration":[143],"such":[145],"scenarios.":[146],"Given":[147],"query,":[149],"our":[150,175],"system":[151,176],"uses":[152],"Approximate":[154],"Functional":[155],"Dependencies(AFDs)":[156],"piece":[158],"together":[159],"tree":[161],"relevant":[163],"schemas":[166],"for":[167],"them.":[169],"tuples":[172],"produced":[173],"by":[174],"able":[178],"strike":[180],"favorable":[182],"balance":[183],"between":[184],"precision":[185],"recall.":[187]},"counts_by_year":[],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}