{"id":"https://openalex.org/W2154598451","doi":"https://doi.org/10.1109/tkde.2003.1161592","title":"A scalable approach to integrating heterogeneous aggregate views of distributed databases","display_name":"A scalable approach to integrating heterogeneous aggregate views of distributed databases","publication_year":2003,"publication_date":"2003-01-01","ids":{"openalex":"https://openalex.org/W2154598451","doi":"https://doi.org/10.1109/tkde.2003.1161592","mag":"2154598451"},"language":"en","primary_location":{"id":"doi:10.1109/tkde.2003.1161592","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2003.1161592","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","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/A5022378204","display_name":"Sally McClean","orcid":"https://orcid.org/0000-0002-6871-3504"},"institutions":[{"id":"https://openalex.org/I138801177","display_name":"University of Ulster","ror":"https://ror.org/01yp9g959","country_code":"GB","type":"education","lineage":["https://openalex.org/I138801177"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"S. McClean","raw_affiliation_strings":["School of Computing and Information Engineering, University of Ulster, Coleraine, UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computing and Information Engineering, University of Ulster, Coleraine, UK","institution_ids":["https://openalex.org/I138801177"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5025293749","display_name":"Bryan Scotney","orcid":"https://orcid.org/0000-0002-8243-2223"},"institutions":[{"id":"https://openalex.org/I138801177","display_name":"University of Ulster","ror":"https://ror.org/01yp9g959","country_code":"GB","type":"education","lineage":["https://openalex.org/I138801177"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"B. Scotney","raw_affiliation_strings":["School of Computing and Information Engineering, University of Ulster, Coleraine, UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computing and Information Engineering, University of Ulster, Coleraine, UK","institution_ids":["https://openalex.org/I138801177"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5019029374","display_name":"Kieran Greer","orcid":"https://orcid.org/0000-0003-0441-9602"},"institutions":[{"id":"https://openalex.org/I138801177","display_name":"University of Ulster","ror":"https://ror.org/01yp9g959","country_code":"GB","type":"education","lineage":["https://openalex.org/I138801177"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"K. Greer","raw_affiliation_strings":["School of Computing and Information Engineering, University of Ulster, Coleraine, UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computing and Information Engineering, University of Ulster, Coleraine, UK","institution_ids":["https://openalex.org/I138801177"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I138801177"],"apc_list":null,"apc_paid":null,"fwci":4.7056,"has_fulltext":false,"cited_by_count":24,"citation_normalized_percentile":{"value":0.95868241,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"15","issue":"1","first_page":"232","last_page":"236"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994999766349792,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994999766349792,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9990000128746033,"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/T10637","display_name":"Advanced Clustering Algorithms Research","score":0.9944999814033508,"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.8444348573684692},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.734669029712677},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.5959911942481995},{"id":"https://openalex.org/keywords/data-integration","display_name":"Data integration","score":0.5315485000610352},{"id":"https://openalex.org/keywords/ontology","display_name":"Ontology","score":0.528117299079895},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5152073502540588},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4680737257003784},{"id":"https://openalex.org/keywords/construct","display_name":"Construct (python library)","score":0.4586828052997589},{"id":"https://openalex.org/keywords/distributed-database","display_name":"Distributed database","score":0.4580051898956299},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.43689513206481934},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.4104066491127014},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.38038530945777893},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.33927929401397705}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8444348573684692},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.734669029712677},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.5959911942481995},{"id":"https://openalex.org/C72634772","wikidata":"https://www.wikidata.org/wiki/Q386824","display_name":"Data integration","level":2,"score":0.5315485000610352},{"id":"https://openalex.org/C25810664","wikidata":"https://www.wikidata.org/wiki/Q44325","display_name":"Ontology","level":2,"score":0.528117299079895},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5152073502540588},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4680737257003784},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.4586828052997589},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.4580051898956299},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.43689513206481934},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.4104066491127014},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.38038530945777893},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.33927929401397705},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"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/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","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},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tkde.2003.1161592","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2003.1161592","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W86668647","https://openalex.org/W2005334784","https://openalex.org/W2005815137","https://openalex.org/W2005992727","https://openalex.org/W2033009109","https://openalex.org/W2049633694","https://openalex.org/W2134516133","https://openalex.org/W2168002512","https://openalex.org/W2482485328"],"related_works":["https://openalex.org/W2384379346","https://openalex.org/W2369660510","https://openalex.org/W2364093074","https://openalex.org/W2675742494","https://openalex.org/W2284149529","https://openalex.org/W121285780","https://openalex.org/W2588847345","https://openalex.org/W2356650720","https://openalex.org/W2246532623","https://openalex.org/W2480595743"],"abstract_inverted_index":{"Aggregate":[0],"views":[1],"are":[2,47,104,114,160,185],"commonly":[3],"used":[4],"for":[5,85],"summarizing":[6],"information":[7,168],"held":[8],"in":[9,17,63,191],"very":[10],"large":[11,20,110],"databases":[12,32,113],"such":[13,67,89,183],"as":[14],"those":[15],"encountered":[16],"data":[18,44,101,127],"warehousing,":[19],"scale":[21],"transaction":[22],"management,":[23],"and":[24,37,43,129],"statistical":[25],"databases.":[26],"Such":[27],"applications":[28],"often":[29],"involve":[30],"distributed":[31],"that":[33,55,103,124,152],"have":[34,56,81],"developed":[35,82,94],"independently":[36],"therefore":[38],"may":[39,70,177],"exhibit":[40],"incompatibility,":[41],"heterogeneity,":[42],"inconsistency.":[45],"We":[46],"here":[48],"concerned":[49],"with":[50],"the":[51,64,86,91,149,154,158,166,171,195],"integration":[52,87],"of":[53,66,88,112,165,193],"aggregates":[54,159,184,196],"heterogeneous":[57,155],"classification":[58,68,156],"schemes":[59],"where":[60],"local":[61],"ontologies,":[62],"form":[65],"schemes,":[69],"be":[71],"mapped":[72],"onto":[73],"a":[74,83,109,143],"common":[75],"ontology.":[76],"In":[77,117,136],"previous":[78],"work,":[79],"we":[80,120,140,176],"method":[84,92],"aggregates;":[90],"previously":[93],"is":[95,130],"efficient,":[96],"but":[97],"cannot":[98],"handle":[99,126],"innate":[100],"inconsistencies":[102,128],"likely":[105],"to":[106],"arise":[107],"when":[108],"number":[111],"being":[115],"integrated.":[116],"this":[118],"paper,":[119],"develop":[121],"an":[122],"approach":[123],"can":[125],"thus":[131],"inherently":[132],"much":[133],"more":[134],"scalable.":[135],"our":[137],"new":[138],"approach,":[139],"first":[141],"construct":[142],"dynamic":[144],"shared":[145],"ontology":[146],"by":[147,163],"analyzing":[148],"correspondence":[150],"graph":[151],"relates":[153],"schemes;":[157],"then":[161],"derived":[162],"minimization":[164],"Kullback-Leibler":[167],"divergence":[169],"using":[170],"EM":[172],"(Expectation-Maximization)":[173],"algorithm.":[174],"Thus,":[175],"assess":[178],"whether":[179],"global":[180],"queries":[181],"on":[182],"answerable,":[186,188],"partially":[187],"or":[189],"unanswerable":[190],"advance":[192],"computing":[194],"themselves.":[197]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}