{"id":"https://openalex.org/W2154503480","doi":"https://doi.org/10.1109/69.404035","title":"Domains and active domains: what this distinction implies for the estimation of projection sizes in relational databases","display_name":"Domains and active domains: what this distinction implies for the estimation of projection sizes in relational databases","publication_year":1995,"publication_date":"1995-01-01","ids":{"openalex":"https://openalex.org/W2154503480","doi":"https://doi.org/10.1109/69.404035","mag":"2154503480"},"language":"en","primary_location":{"id":"doi:10.1109/69.404035","is_oa":false,"landing_page_url":"https://doi.org/10.1109/69.404035","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/A5010984921","display_name":"Paolo Ciaccia","orcid":"https://orcid.org/0000-0002-1794-6244"},"institutions":[{"id":"https://openalex.org/I9360294","display_name":"University of Bologna","ror":"https://ror.org/01111rn36","country_code":"IT","type":"education","lineage":["https://openalex.org/I9360294"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"P. Ciaccia","raw_affiliation_strings":["Dipartimento di Elettronica, Informatica e Sistemistica, University of Bologna, Bologna, Italy"],"affiliations":[{"raw_affiliation_string":"Dipartimento di Elettronica, Informatica e Sistemistica, University of Bologna, Bologna, Italy","institution_ids":["https://openalex.org/I9360294"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5056262479","display_name":"Dario Maio","orcid":"https://orcid.org/0000-0002-0094-0022"},"institutions":[{"id":"https://openalex.org/I9360294","display_name":"University of Bologna","ror":"https://ror.org/01111rn36","country_code":"IT","type":"education","lineage":["https://openalex.org/I9360294"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"D. Maio","raw_affiliation_strings":["Dipartimento di Elettronica, Informatica e Sistemistica, University of Bologna, Bologna, Italy"],"affiliations":[{"raw_affiliation_string":"Dipartimento di Elettronica, Informatica e Sistemistica, University of Bologna, Bologna, Italy","institution_ids":["https://openalex.org/I9360294"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5010984921"],"corresponding_institution_ids":["https://openalex.org/I9360294"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.26277428,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"7","issue":"4","first_page":"641","last_page":"655"},"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.9998000264167786,"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.9998000264167786,"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.9988999962806702,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9955999851226807,"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.7221337556838989},{"id":"https://openalex.org/keywords/domain","display_name":"Domain (mathematical analysis)","score":0.590173602104187},{"id":"https://openalex.org/keywords/independence","display_name":"Independence (probability theory)","score":0.5783032774925232},{"id":"https://openalex.org/keywords/projection","display_name":"Projection (relational algebra)","score":0.5692798495292664},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5464585423469543},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.5328327417373657},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4823129177093506},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.46735242009162903},{"id":"https://openalex.org/keywords/invariant","display_name":"Invariant (physics)","score":0.4513319432735443},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4349318742752075},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4272426962852478},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.4214520752429962},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.3758646249771118},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.241441547870636},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.10372093319892883}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7221337556838989},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.590173602104187},{"id":"https://openalex.org/C35651441","wikidata":"https://www.wikidata.org/wiki/Q625303","display_name":"Independence (probability theory)","level":2,"score":0.5783032774925232},{"id":"https://openalex.org/C57493831","wikidata":"https://www.wikidata.org/wiki/Q3134666","display_name":"Projection (relational algebra)","level":2,"score":0.5692798495292664},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5464585423469543},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.5328327417373657},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4823129177093506},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.46735242009162903},{"id":"https://openalex.org/C190470478","wikidata":"https://www.wikidata.org/wiki/Q2370229","display_name":"Invariant (physics)","level":2,"score":0.4513319432735443},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4349318742752075},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4272426962852478},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.4214520752429962},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3758646249771118},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.241441547870636},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.10372093319892883},{"id":"https://openalex.org/C37914503","wikidata":"https://www.wikidata.org/wiki/Q156495","display_name":"Mathematical physics","level":1,"score":0.0},{"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/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/69.404035","is_oa":false,"landing_page_url":"https://doi.org/10.1109/69.404035","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"},{"id":"pmh:oai:cris.unibo.it:11585/918326","is_oa":false,"landing_page_url":"https://hdl.handle.net/11585/918326","pdf_url":null,"source":{"id":"https://openalex.org/S4306402579","display_name":"Archivio istituzionale della ricerca (Alma Mater Studiorum Universit\u00e0 di Bologna)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210117483","host_organization_name":"Istituto di Ematologia di Bologna","host_organization_lineage":["https://openalex.org/I4210117483"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":38,"referenced_works":["https://openalex.org/W56012926","https://openalex.org/W1545406293","https://openalex.org/W1608665031","https://openalex.org/W1969914452","https://openalex.org/W1977570286","https://openalex.org/W1991782662","https://openalex.org/W1993436282","https://openalex.org/W2000025733","https://openalex.org/W2007069074","https://openalex.org/W2008185459","https://openalex.org/W2008365755","https://openalex.org/W2010890196","https://openalex.org/W2018490621","https://openalex.org/W2020191321","https://openalex.org/W2040892657","https://openalex.org/W2042940152","https://openalex.org/W2046981631","https://openalex.org/W2048341095","https://openalex.org/W2054338562","https://openalex.org/W2061570003","https://openalex.org/W2064102738","https://openalex.org/W2066226422","https://openalex.org/W2074753105","https://openalex.org/W2075278905","https://openalex.org/W2079656678","https://openalex.org/W2081457867","https://openalex.org/W2083009278","https://openalex.org/W2089183512","https://openalex.org/W2094482767","https://openalex.org/W2108717033","https://openalex.org/W2122949840","https://openalex.org/W2153329411","https://openalex.org/W2167679350","https://openalex.org/W2168447405","https://openalex.org/W2752853835","https://openalex.org/W4240823481","https://openalex.org/W4248343126","https://openalex.org/W4300694379"],"related_works":["https://openalex.org/W2267077731","https://openalex.org/W1510134535","https://openalex.org/W2386578196","https://openalex.org/W2483382562","https://openalex.org/W3091612633","https://openalex.org/W2085988990","https://openalex.org/W1528519853","https://openalex.org/W2376710457","https://openalex.org/W1897774768","https://openalex.org/W3006903421"],"abstract_inverted_index":{"Database":[0],"optimizers":[1],"require":[2],"statistical":[3],"information":[4],"about":[5],"data":[6],"distributions":[7,178],"in":[8,48],"order":[9],"to":[10,123,173],"evaluate":[11],"result":[12],"sizes":[13],"and":[14,74,97,179],"access":[15],"plan":[16],"costs":[17],"for":[18],"processing":[19],"user":[20],"queries.":[21],"In":[22],"this":[23],"context,":[24],"we":[25,135,167],"consider":[26],"the":[27,31,34,49,60,69,82,85,98,118,128,142,158,162,169,174,184,188],"problem":[28],"of":[29,33,36,71,77,90,104,161,176,187],"estimating":[30],"size":[32],"projections":[35],"a":[37,56,111],"database":[38],"relation,":[39],"when":[40],"measures":[41],"on":[42,156],"attribute":[43,72,78,94],"domain":[44,87,101,164],"cardinalities":[45],"are":[46,107,121],"maintained":[47],"system.":[50],"Our":[51],"main":[52],"theoretical":[53],"contribution":[54],"is":[55,66,131],"new":[57],"formal":[58],"model,":[59,64,141],"AD":[61,129],"(active":[62],"domain)":[63,147],"which":[65],"valid":[67],"under":[68,117],"hypotheses":[70],"independence":[73],"uniform":[75],"distribution":[76],"values,":[79],"derived":[80],"considering":[81],"difference":[83],"between":[84],"time-invariant":[86],"(the":[88,102],"set":[89,103],"values":[91,105],"that":[92,106],"an":[93,138],"can":[95],"assume)":[96],"time-dependent":[99],"(\"active\")":[100],"actually":[108],"assumed,":[109],"at":[110],"certain":[112],"time).":[113],"Early":[114],"models":[115],"developed":[116],"same":[119],"assumptions":[120],"shown":[122],"be":[124],"formally":[125],"incorrect.":[126],"Since":[127],"model":[130,148,172],"computationally":[132],"highly":[133],"demanding,":[134],"also":[136],"introduce":[137],"approximate,":[139],"easy-to-compute":[140],"A/sup":[143,170],"2/D":[144,171],"(approximate":[145],"active":[146,163],"that,":[149],"unlike":[150],"previous":[151],"approximations,":[152],"yields":[153],"low":[154],"errors":[155],"all":[157],"parameter":[159],"space":[160],"cardinalities.":[165],"Finally,":[166],"extend":[168],"case":[175],"nonuniform":[177],"present":[180],"experimental":[181],"results":[182],"confirming":[183],"good":[185],"behavior":[186],"model.<":[189],"<ETX":[190],"xmlns:mml=\"http://www.w3.org/1998/Math/MathML\"":[191],"xmlns:xlink=\"http://www.w3.org/1999/xlink\">&gt;</ETX>":[192]},"counts_by_year":[{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}