{"id":"https://openalex.org/W2128299315","doi":"https://doi.org/10.1109/icde.2010.5447842","title":"Supporting real-world activities in database management systems","display_name":"Supporting real-world activities in database management systems","publication_year":2010,"publication_date":"2010-01-01","ids":{"openalex":"https://openalex.org/W2128299315","doi":"https://doi.org/10.1109/icde.2010.5447842","mag":"2128299315"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2010.5447842","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2010.5447842","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/A5074322354","display_name":"Mohamed Y. Eltabakh","orcid":"https://orcid.org/0000-0002-6344-8246"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Mohamed Y. Eltabakh","raw_affiliation_strings":["Computer Science Department, Purdue University, West Lafayette, IN, USA","[Comput. Sci. Dept., Purdue Univ., West Lafayette, IN, USA]"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, Purdue University, West Lafayette, IN, USA","institution_ids":["https://openalex.org/I219193219"]},{"raw_affiliation_string":"[Comput. Sci. Dept., Purdue Univ., West Lafayette, IN, USA]","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000123743","display_name":"Walid G. Aref","orcid":"https://orcid.org/0000-0001-8169-7775"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Walid G. Aref","raw_affiliation_strings":["Computer Science Department, Purdue University, West Lafayette, IN, USA","[Comput. Sci. Dept., Purdue Univ., West Lafayette, IN, USA]"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, Purdue University, West Lafayette, IN, USA","institution_ids":["https://openalex.org/I219193219"]},{"raw_affiliation_string":"[Comput. Sci. Dept., Purdue Univ., West Lafayette, IN, USA]","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5089912733","display_name":"Ahmed K. Elmagarmid","orcid":"https://orcid.org/0000-0002-0044-458X"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ahmed K. Elmagarmid","raw_affiliation_strings":["Computer Science Department, Purdue University, West Lafayette, IN, USA","[Comput. Sci. Dept., Purdue Univ., West Lafayette, IN, USA]"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, Purdue University, West Lafayette, IN, USA","institution_ids":["https://openalex.org/I219193219"]},{"raw_affiliation_string":"[Comput. Sci. Dept., Purdue Univ., West Lafayette, IN, USA]","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088912009","display_name":"Yasin N. Silva","orcid":"https://orcid.org/0000-0003-1852-1683"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yasin N. Silva","raw_affiliation_strings":["Computer Science Department, Purdue University, West Lafayette, IN, USA","[Comput. Sci. Dept., Purdue Univ., West Lafayette, IN, USA]"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, Purdue University, West Lafayette, IN, USA","institution_ids":["https://openalex.org/I219193219"]},{"raw_affiliation_string":"[Comput. Sci. Dept., Purdue Univ., West Lafayette, IN, USA]","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5026923999","display_name":"Mourad Ouzzani","orcid":"https://orcid.org/0000-0002-4035-3025"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mourad Ouzzani","raw_affiliation_strings":["Cyber Center, Purdue University, West Lafayette, IN, USA","Cyber Center, Purdue Univ., West Lafayette, IN, USA"],"affiliations":[{"raw_affiliation_string":"Cyber Center, Purdue University, West Lafayette, IN, USA","institution_ids":["https://openalex.org/I219193219"]},{"raw_affiliation_string":"Cyber Center, Purdue Univ., West Lafayette, IN, USA","institution_ids":["https://openalex.org/I219193219"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5074322354"],"corresponding_institution_ids":["https://openalex.org/I219193219"],"apc_list":null,"apc_paid":null,"fwci":1.1176,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.80640274,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":"1","issue":null,"first_page":"808","last_page":"811"},"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.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"}},"topics":[{"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"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/T11719","display_name":"Data Quality and Management","score":0.9980999827384949,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8422565460205078},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6845369338989258},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.5148736238479614},{"id":"https://openalex.org/keywords/database-testing","display_name":"Database testing","score":0.4867089092731476},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.4746682643890381},{"id":"https://openalex.org/keywords/syntax","display_name":"Syntax","score":0.46987253427505493},{"id":"https://openalex.org/keywords/data-manipulation-language","display_name":"Data manipulation language","score":0.4196491241455078},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.38271647691726685},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.37123727798461914},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3382856845855713},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2962985932826996},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1682397723197937}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8422565460205078},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6845369338989258},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.5148736238479614},{"id":"https://openalex.org/C78161392","wikidata":"https://www.wikidata.org/wiki/Q5227414","display_name":"Database testing","level":4,"score":0.4867089092731476},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.4746682643890381},{"id":"https://openalex.org/C60048249","wikidata":"https://www.wikidata.org/wiki/Q37437","display_name":"Syntax","level":2,"score":0.46987253427505493},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.4196491241455078},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.38271647691726685},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.37123727798461914},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3382856845855713},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2962985932826996},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1682397723197937},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1109/icde.2010.5447842","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2010.5447842","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:docs.lib.purdue.edu:ccpubs-1033","is_oa":false,"landing_page_url":"https://docs.lib.purdue.edu/ccpubs/14","pdf_url":null,"source":{"id":"https://openalex.org/S4377196310","display_name":"Purdue e-Pubs (Purdue University System)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I2801333002","host_organization_name":"Purdue University System","host_organization_lineage":["https://openalex.org/I2801333002"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Cyber Center Publications","raw_type":"text"},{"id":"pmh:oai:docs.lib.purdue.edu:cstech-2717","is_oa":false,"landing_page_url":"https://docs.lib.purdue.edu/cstech/1718","pdf_url":null,"source":{"id":"https://openalex.org/S4377196310","display_name":"Purdue e-Pubs (Purdue University System)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I2801333002","host_organization_name":"Purdue University System","host_organization_lineage":["https://openalex.org/I2801333002"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Department of Computer Science Technical Reports","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.211.6861","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.211.6861","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.purdue.edu/homes/ake/pub/ICDE10_conf_short_611.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.41999998688697815,"display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":29,"referenced_works":["https://openalex.org/W79504326","https://openalex.org/W146964180","https://openalex.org/W180578187","https://openalex.org/W206843726","https://openalex.org/W1486776102","https://openalex.org/W1527509133","https://openalex.org/W1532909273","https://openalex.org/W1536777985","https://openalex.org/W1552694902","https://openalex.org/W1555797260","https://openalex.org/W1587877137","https://openalex.org/W1657092947","https://openalex.org/W2010053008","https://openalex.org/W2027345614","https://openalex.org/W2056947248","https://openalex.org/W2066417879","https://openalex.org/W2100153179","https://openalex.org/W2111465715","https://openalex.org/W2127279146","https://openalex.org/W2134201815","https://openalex.org/W2162064942","https://openalex.org/W2162621793","https://openalex.org/W2171332293","https://openalex.org/W4242219076","https://openalex.org/W6605986943","https://openalex.org/W6608362625","https://openalex.org/W6629041467","https://openalex.org/W6636980721","https://openalex.org/W7061297332"],"related_works":["https://openalex.org/W4391150403","https://openalex.org/W2081749821","https://openalex.org/W1968572830","https://openalex.org/W2090814745","https://openalex.org/W2029896371","https://openalex.org/W2136497797","https://openalex.org/W2129469317","https://openalex.org/W2521597029","https://openalex.org/W2188578519","https://openalex.org/W1603016012"],"abstract_inverted_index":{"The":[0,57,125,187],"cycle":[1],"of":[2,59,113],"processing":[3],"the":[4,21,52,55,64,68,71,83,108,114,140,152],"data":[5,119,143,170,183],"in":[6,54,82],"many":[7],"application":[8],"domains":[9],"is":[10,190],"complex":[11],"and":[12,28,41,44,116,131,162,175,179,185],"may":[13,34],"involve":[14],"real-world":[15,32,80],"activities":[16,33,81],"that":[17,99],"are":[18,123],"external":[19],"to":[20,38,42,74,102,148,163,195],"database,":[22],"e.g.,":[23],"wet-lab":[24],"experiments,":[25],"instrument":[26],"readings,":[27],"manual":[29],"measurements.":[30],"These":[31],"take":[35],"long":[36,48,61],"time":[37,49],"prepare":[39],"for":[40,70,133,182],"perform,":[43],"hence":[45],"introduce":[46],"inherently":[47],"delays":[50,62],"between":[51,63],"updates":[53,105],"database.":[56],"presence":[58],"these":[60,94],"updates,":[65],"along":[66],"with":[67],"need":[69],"intermediate":[72],"results":[73,155],"be":[75],"instantly":[76],"available,":[77],"makes":[78],"supporting":[79],"database":[84,109],"engine":[85],"a":[86,97],"challenging":[87],"task.":[88],"In":[89],"this":[90],"paper,":[91],"we":[92],"address":[93],"challenges":[95],"through":[96,135],"system":[98,127,189],"enables":[100],"users":[101,137,150],"reflect":[103],"their":[104],"immediately":[106],"into":[107],"while":[110],"keeping":[111],"track":[112],"dependent":[115],"potentially":[117,157,176],"invalid":[118,158,177],"items":[120],"until":[121],"they":[122],"re-validated.":[124],"proposed":[126,188],"includes:":[128],"(1)":[129],"semantics":[130],"syntax":[132],"interfaces":[134],"which":[136],"can":[138],"express":[139],"dependencies":[141],"among":[142],"items,":[144],"(2)":[145],"new":[146],"operators":[147],"alert":[149],"when":[151],"returned":[153],"query":[154],"contain":[156],"or":[159,172],"out-of-date":[160],"data,":[161,178],"enable":[164],"evaluating":[165],"queries":[166],"on":[167],"either":[168],"valid":[169,174],"only,":[171],"both":[173],"(3)":[180],"mechanisms":[181],"invalidation":[184],"revalidation.":[186],"being":[191],"realized":[192],"via":[193],"extensions":[194],"PostgreSQL.":[196]},"counts_by_year":[{"year":2016,"cited_by_count":1},{"year":2013,"cited_by_count":2}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}