{"id":"https://openalex.org/W2033439396","doi":"https://doi.org/10.1145/2320765.2320835","title":"Towards scalable data integration under constraints","display_name":"Towards scalable data integration under constraints","publication_year":2012,"publication_date":"2012-03-30","ids":{"openalex":"https://openalex.org/W2033439396","doi":"https://doi.org/10.1145/2320765.2320835","mag":"2033439396"},"language":"en","primary_location":{"id":"doi:10.1145/2320765.2320835","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2320765.2320835","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2012 Joint EDBT/ICDT Workshops","raw_type":"proceedings-article"},"type":"conference-paper","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/A5000674196","display_name":"George Konstantinidis","orcid":"https://orcid.org/0000-0002-3962-9303"},"institutions":[{"id":"https://openalex.org/I1174212","display_name":"University of Southern California","ror":"https://ror.org/03taz7m60","country_code":"US","type":"education","lineage":["https://openalex.org/I1174212"]},{"id":"https://openalex.org/I2801204180","display_name":"Marina Del Rey Hospital","ror":"https://ror.org/05wqyfz02","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I2801204180"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"George Konstantinidis","raw_affiliation_strings":["University of Southern California, Marina Del Rey, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Southern California, Marina Del Rey, CA","institution_ids":["https://openalex.org/I1174212","https://openalex.org/I2801204180"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5033175043","display_name":"Jos\u00e9 Luis Ambite","orcid":"https://orcid.org/0000-0003-0087-080X"},"institutions":[{"id":"https://openalex.org/I1174212","display_name":"University of Southern California","ror":"https://ror.org/03taz7m60","country_code":"US","type":"education","lineage":["https://openalex.org/I1174212"]},{"id":"https://openalex.org/I2801204180","display_name":"Marina Del Rey Hospital","ror":"https://ror.org/05wqyfz02","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I2801204180"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jose Luis Ambite","raw_affiliation_strings":["University of Southern California, Marina Del Rey, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Southern California, Marina Del Rey, CA","institution_ids":["https://openalex.org/I1174212","https://openalex.org/I2801204180"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"251","last_page":"256"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9998999834060669,"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"}},"topics":[{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9998999834060669,"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.9997000098228455,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.8348556160926819},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.795745849609375},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6973909735679626},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.6745462417602539},{"id":"https://openalex.org/keywords/rewriting","display_name":"Rewriting","score":0.6025246381759644},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5737971067428589},{"id":"https://openalex.org/keywords/data-integration","display_name":"Data integration","score":0.5370456576347351},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.527695894241333},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.5102474689483643},{"id":"https://openalex.org/keywords/variety","display_name":"Variety (cybernetics)","score":0.5081486701965332},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5048866868019104},{"id":"https://openalex.org/keywords/ontology","display_name":"Ontology","score":0.467406302690506},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.4509895443916321},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.4340646266937256},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.41902679204940796},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4029057025909424},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.27246516942977905},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2627960443496704},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2211262583732605},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.18944287300109863},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.13891109824180603},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.10784390568733215}],"concepts":[{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.8348556160926819},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.795745849609375},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6973909735679626},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.6745462417602539},{"id":"https://openalex.org/C154690210","wikidata":"https://www.wikidata.org/wiki/Q1668499","display_name":"Rewriting","level":2,"score":0.6025246381759644},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5737971067428589},{"id":"https://openalex.org/C72634772","wikidata":"https://www.wikidata.org/wiki/Q386824","display_name":"Data integration","level":2,"score":0.5370456576347351},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.527695894241333},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.5102474689483643},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.5081486701965332},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5048866868019104},{"id":"https://openalex.org/C25810664","wikidata":"https://www.wikidata.org/wiki/Q44325","display_name":"Ontology","level":2,"score":0.467406302690506},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.4509895443916321},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.4340646266937256},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.41902679204940796},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4029057025909424},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.27246516942977905},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2627960443496704},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2211262583732605},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.18944287300109863},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.13891109824180603},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.10784390568733215},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1145/2320765.2320835","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2320765.2320835","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2012 Joint EDBT/ICDT Workshops","raw_type":"proceedings-article"},{"id":"pmh:oai:eprints.soton.ac.uk:504281","is_oa":false,"landing_page_url":"https://eprints.soton.ac.uk/504281/","pdf_url":null,"source":{"id":"https://openalex.org/S4306401019","display_name":"ePrints Soton (University of Southampton)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I43439940","host_organization_name":"University of Southampton","host_organization_lineage":["https://openalex.org/I43439940"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":null,"raw_type":"Conference or Workshop Item"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.352.7879","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.352.7879","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www-scf.usc.edu/~konstant/ScalableDataIntegrationUnderConstraintsCR.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.433.5238","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.433.5238","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.edbt.org/Proceedings/2012-Berlin/papers/workshops/phd_workshop/a5-konstantinidis.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.44999998807907104,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W1507099003","https://openalex.org/W1555563750","https://openalex.org/W1558832481","https://openalex.org/W1606607399","https://openalex.org/W1975733288","https://openalex.org/W1979514837","https://openalex.org/W1992673035","https://openalex.org/W2038608154","https://openalex.org/W2094394144","https://openalex.org/W2097989803","https://openalex.org/W2102729564","https://openalex.org/W2108414652","https://openalex.org/W2119046278","https://openalex.org/W2137862151","https://openalex.org/W2145285202","https://openalex.org/W2152191782","https://openalex.org/W3005907268","https://openalex.org/W3146347964","https://openalex.org/W4285719527","https://openalex.org/W6633513001","https://openalex.org/W6912992434"],"related_works":["https://openalex.org/W2572349046","https://openalex.org/W1981131819","https://openalex.org/W5304494","https://openalex.org/W2017989738","https://openalex.org/W3197639690","https://openalex.org/W2146885082","https://openalex.org/W2397627326","https://openalex.org/W2171068308","https://openalex.org/W1922016388","https://openalex.org/W4236234562"],"abstract_inverted_index":{"In":[0],"this":[1],"paper":[2],"we":[3,34,57,129],"consider":[4],"the":[5,61,68,85,94,103,123,146,210],"problem":[6,69,124],"of":[7,112,189,220],"answering":[8],"queries":[9,53,81,228],"using":[10,93,229],"views,":[11,55],"with":[12],"or":[13],"without":[14],"ontological":[15],"constraints,":[16,67],"which":[17,79,140],"is":[18,30,70],"important":[19],"for":[20,36,48,209],"data":[21,26,31],"integration,":[22,32],"query":[23,77,91],"optimization,":[24],"and":[25,45,54,56,88,106,137,149,171,192,203],"warehouses.":[27],"Our":[28],"context":[29],"so":[33],"search":[35],"maximally-contained":[37],"rewritings.":[38],"We":[39,179],"have":[40,98,107],"produced":[41],"a":[42,109,126,134,176,183,187,201],"very":[43],"scalable":[44,204],"efficient":[46],"solution":[47,184],"its":[49],"simplest":[50],"form,":[51],"conjunctive":[52],"are":[58,130],"working":[59],"towards":[60],"full":[62],"relational":[63,211],"case.":[64],"When":[65],"considering":[66],"usually":[71],"divided":[72],"in":[73,145,161,175],"two":[74,218],"phases:":[75],"(1)":[76],"expansion,":[78],"rewrites":[80],"w.":[82],"r.":[83],"t.":[84],"intentional":[86],"knowledge":[87],"(2)":[89],"expanded":[90],"reformulation":[92],"views.":[95],"Relevant":[96],"algorithms":[97],"given":[99],"little":[100],"attention":[101],"to":[102,132,158,168,181],"second":[104],"phase":[105],"studied":[108],"limited":[110],"form":[111],"view":[113,195],"definition":[114,196],"languages":[115,197],"overall":[116],"(namely,":[117],"only":[118],"GAV).":[119],"By":[120],"looking":[121],"at":[122],"from":[125],"graph":[127],"perspective":[128],"able":[131],"gain":[133],"better":[135],"insight":[136],"develop":[138],"designs":[139],"compactly":[141],"represent":[142],"common":[143],"patterns":[144],"source":[147],"descriptions,":[148],"(optionally)":[150],"push":[151],"some":[152],"computation":[153],"offline.":[154],"This":[155],"allows":[156],"us":[157],"contribute":[159],"significantly":[160],"both":[162],"aforemention":[163],"phases":[164],"individually,":[165],"tailor":[166],"one":[167],"each":[169],"other,":[170],"moreover":[172],"address":[173],"them":[174],"unified":[177],"way.":[178],"intend":[180],"provide":[182],"that":[185],"supports":[186],"variety":[188],"ontology":[190],"languages,":[191],"all":[193],"prevalent":[194],"(G/LAV).":[198],"Towards":[199],"such":[200],"general":[202],"system":[205],"our":[206],"preliminary":[207],"results":[208],"case,":[212],"show":[213],"an":[214],"experimental":[215],"performance":[216],"about":[217],"orders":[219],"magnitude":[221],"faster":[222],"than":[223],"current":[224],"state-of-the-art":[225],"algorithms,":[226],"rewriting":[227],"over":[230],"10000":[231],"views":[232],"within":[233],"seconds.":[234]},"counts_by_year":[{"year":2014,"cited_by_count":1}],"updated_date":"2026-07-22T07:51:19.307946","created_date":"2025-10-10T00:00:00"}