{"id":"https://openalex.org/W2753023756","doi":"https://doi.org/10.14778/3137765.3137772","title":"Statisticum","display_name":"Statisticum","publication_year":2017,"publication_date":"2017-08-01","ids":{"openalex":"https://openalex.org/W2753023756","doi":"https://doi.org/10.14778/3137765.3137772","mag":"2753023756"},"language":"en","primary_location":{"id":"doi:10.14778/3137765.3137772","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3137765.3137772","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","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/A5109865053","display_name":"Anisoara Nica","orcid":null},"institutions":[{"id":"https://openalex.org/I4210133614","display_name":"Systems, Applications & Products in Data Processing (United Kingdom)","ror":"https://ror.org/04k7gd586","country_code":"GB","type":"company","lineage":["https://openalex.org/I4210132444","https://openalex.org/I4210133614"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Anisoara Nica","raw_affiliation_strings":["SAP SE"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP SE","institution_ids":["https://openalex.org/I4210133614"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078807750","display_name":"Reza Sherkat","orcid":null},"institutions":[{"id":"https://openalex.org/I4210133614","display_name":"Systems, Applications & Products in Data Processing (United Kingdom)","ror":"https://ror.org/04k7gd586","country_code":"GB","type":"company","lineage":["https://openalex.org/I4210132444","https://openalex.org/I4210133614"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Reza Sherkat","raw_affiliation_strings":["SAP SE"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP SE","institution_ids":["https://openalex.org/I4210133614"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113488710","display_name":"Mihnea Andrei","orcid":null},"institutions":[{"id":"https://openalex.org/I4210133614","display_name":"Systems, Applications & Products in Data Processing (United Kingdom)","ror":"https://ror.org/04k7gd586","country_code":"GB","type":"company","lineage":["https://openalex.org/I4210132444","https://openalex.org/I4210133614"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Mihnea Andrei","raw_affiliation_strings":["SAP SE"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP SE","institution_ids":["https://openalex.org/I4210133614"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112126487","display_name":"Xun Cheng","orcid":null},"institutions":[{"id":"https://openalex.org/I4210133614","display_name":"Systems, Applications & Products in Data Processing (United Kingdom)","ror":"https://ror.org/04k7gd586","country_code":"GB","type":"company","lineage":["https://openalex.org/I4210132444","https://openalex.org/I4210133614"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Xun Cheng","raw_affiliation_strings":["SAP SE"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP SE","institution_ids":["https://openalex.org/I4210133614"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5020445242","display_name":"Martin Heidel","orcid":null},"institutions":[{"id":"https://openalex.org/I4210133614","display_name":"Systems, Applications & Products in Data Processing (United Kingdom)","ror":"https://ror.org/04k7gd586","country_code":"GB","type":"company","lineage":["https://openalex.org/I4210132444","https://openalex.org/I4210133614"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Martin Heidel","raw_affiliation_strings":["SAP SE"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP SE","institution_ids":["https://openalex.org/I4210133614"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5017509320","display_name":"Christian Bensberg","orcid":null},"institutions":[{"id":"https://openalex.org/I4210133614","display_name":"Systems, Applications & Products in Data Processing (United Kingdom)","ror":"https://ror.org/04k7gd586","country_code":"GB","type":"company","lineage":["https://openalex.org/I4210132444","https://openalex.org/I4210133614"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Christian Bensberg","raw_affiliation_strings":["SAP SE"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP SE","institution_ids":["https://openalex.org/I4210133614"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5082063023","display_name":"Heiko Gerwens","orcid":null},"institutions":[{"id":"https://openalex.org/I4210133614","display_name":"Systems, Applications & Products in Data Processing (United Kingdom)","ror":"https://ror.org/04k7gd586","country_code":"GB","type":"company","lineage":["https://openalex.org/I4210132444","https://openalex.org/I4210133614"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Heiko Gerwens","raw_affiliation_strings":["SAP SE"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP SE","institution_ids":["https://openalex.org/I4210133614"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I4210133614"],"apc_list":null,"apc_paid":null,"fwci":1.2621,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.82929543,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"10","issue":"12","first_page":"1658","last_page":"1669"},"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.9994000196456909,"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/T11719","display_name":"Data Quality and Management","score":0.9987000226974487,"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.7256342172622681},{"id":"https://openalex.org/keywords/data-integrity","display_name":"Data integrity","score":0.6746190786361694},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5133280158042908},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4989614486694336},{"id":"https://openalex.org/keywords/constraint","display_name":"Constraint (computer-aided design)","score":0.4738883376121521},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.4649907946586609},{"id":"https://openalex.org/keywords/consistency","display_name":"Consistency (knowledge bases)","score":0.4464516043663025},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2669915556907654},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.1783008873462677},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.1593608260154724},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.15463662147521973},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.14262551069259644}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7256342172622681},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.6746190786361694},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5133280158042908},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4989614486694336},{"id":"https://openalex.org/C2776036281","wikidata":"https://www.wikidata.org/wiki/Q48769818","display_name":"Constraint (computer-aided design)","level":2,"score":0.4738883376121521},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.4649907946586609},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.4464516043663025},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2669915556907654},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.1783008873462677},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.1593608260154724},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.15463662147521973},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.14262551069259644},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3137765.3137772","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3137765.3137772","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":27,"referenced_works":["https://openalex.org/W1494049834","https://openalex.org/W1510305954","https://openalex.org/W1585029481","https://openalex.org/W1588213250","https://openalex.org/W1967091776","https://openalex.org/W1981988185","https://openalex.org/W1997375126","https://openalex.org/W2037192958","https://openalex.org/W2039795745","https://openalex.org/W2039910065","https://openalex.org/W2040428289","https://openalex.org/W2059009730","https://openalex.org/W2081315591","https://openalex.org/W2113607096","https://openalex.org/W2133741724","https://openalex.org/W2142550009","https://openalex.org/W2145269645","https://openalex.org/W2151873965","https://openalex.org/W2169196165","https://openalex.org/W2171543585","https://openalex.org/W2396727930","https://openalex.org/W2426280924","https://openalex.org/W2430301697","https://openalex.org/W2547104946","https://openalex.org/W2574861468","https://openalex.org/W2581526937","https://openalex.org/W2614742302"],"related_works":["https://openalex.org/W2354398425","https://openalex.org/W2115871986","https://openalex.org/W2085847495","https://openalex.org/W2015692847","https://openalex.org/W2753397301","https://openalex.org/W1496178365","https://openalex.org/W1480149093","https://openalex.org/W1515303450","https://openalex.org/W2362685264","https://openalex.org/W4229944339"],"abstract_inverted_index":{"We":[0,39,134,150,190,211],"introduce":[1],"a":[2,110,239,286],"new":[3],"concept":[4,125,143],"of":[5,43,126,138,155,178,246,254,278],"leveraging":[6],"traditional":[7,91],"data":[8,12,16,44,48,68,132,141,156,166,187,197,228,258],"statistics":[9,17,45,49,69,142,157,167,198,229,259],"as":[10,25,27,90],"dynamic":[11,183,208],"integrity":[13,64,80,129,222,249],"constraints.":[14],"These":[15],"produce":[18],"transient":[19],"database":[20,92],"constraints,":[21,93],"which":[22,82,203],"are":[23,78,83,168],"valid":[24,79],"long":[26],"they":[28],"can":[29,204],"be":[30,33,205],"proven":[31],"to":[32,108,275],"consistent":[34],"with":[35],"the":[36,117,139,152,227,235,244,247],"current":[37,153,193],"data.":[38],"denote":[40],"this":[41,115,121,173,179],"type":[42],"by":[46,57,66],"constraint":[47,140,165,196,257],",":[50,60],"their":[51,62,145,213],"properties":[52,214],"needed":[53],"for":[54,74,186,195,207,220,252,285],"consistency":[55,58,218],"checking":[56,219],"metadata":[59],"and":[61,105,123,144,162,170,215,238,266,270],"implied":[63,67,72,128,221,248],"constraints":[65,70,73,77,81,130,223],"(":[71],"short).":[75],"Implied":[76],"powerful":[84,124],"query":[85,96,99,148,282],"optimization":[86],"tools":[87],"employed,":[88],"just":[89],"in":[94,159,200,226,262,281],"semantic":[95],"transformation":[97],"(aka":[98],"reformulation),":[100],"partition":[101,184,209],"pruning,":[102],"runtime":[103],"optimization,":[104],"semi-join":[106],"reduction,":[107],"name":[109],"few.":[111],"To":[112],"our":[113,192],"knowledge,":[114],"is":[116,224],"first":[118],"work":[119],"introducing":[120],"novel":[122],"deriving":[127],"from":[131],"statistics.":[133],"discuss":[135,191],"theoretical":[136],"aspects":[137],"integration":[146],"into":[147,172],"processing.":[149],"present":[151],"architecture":[154],"management":[158],"SAP":[160,201],"HANA":[161,202],"detail":[163],"how":[164,217],"designed":[169],"integrated":[171],"architecture.":[174,230],"As":[175],"an":[176,290],"instantiation":[177],"framework,":[180],"we":[181,272],"consider":[182],"pruning":[185,263],"aging":[188],"scenarios.":[189],"implementation":[194],"objects":[199],"used":[206],"pruning.":[210],"enumerate":[212],"show":[216],"supported":[225],"Our":[231],"experimental":[232],"evaluations":[233],"on":[234],"TPC-H":[236,255],"benchmark":[237],"real":[240,287],"customer":[241,288],"application":[242],"confirm":[243],"effectiveness":[245],"constraints;":[250],"(1)":[251],"59%":[253],"queries,":[256],"utilization":[260],"results":[261],"cold":[264],"partitions":[265],"reducing":[267],"memory":[268],"consumption,":[269],"(2)":[271],"observe":[273],"up":[274],"3":[276],"orders":[277],"magnitude":[279],"speed-up":[280],"processing":[283],"time,":[284],"running":[289],"S/4HANA":[291],"application.":[292]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2017-09-15T00:00:00"}