{"id":"https://openalex.org/W2103207371","doi":"https://doi.org/10.3217/jucs-015-01-0273","title":"A Formal Framework of Aggregation for the OLAP-OLTP Model","display_name":"A Formal Framework of Aggregation for the OLAP-OLTP Model","publication_year":2009,"publication_date":"2009-01-01","ids":{"openalex":"https://openalex.org/W2103207371","doi":"https://doi.org/10.3217/jucs-015-01-0273","mag":"2103207371"},"language":"en","primary_location":{"id":"pmh:oai:CiteSeerX.psu:10.1.1.166.96","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.166.96","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.jucs.org/jucs_15_1/a_formal_framework_of/jucs_15_01_0273_0303_lenz.pdf","raw_type":"text"},"type":"article","indexed_in":[],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://zenodo.org/record/7000631","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5111440199","display_name":"Hans-Joachim Lenz","orcid":null},"institutions":[{"id":"https://openalex.org/I75951250","display_name":"Freie Universit\u00e4t Berlin","ror":"https://ror.org/046ak2485","country_code":"DE","type":"education","lineage":["https://openalex.org/I75951250"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Hans-Joachim Lenz","raw_affiliation_strings":["Free University of Berlin"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Free University of Berlin","institution_ids":["https://openalex.org/I75951250"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5039350841","display_name":"Bernhard Thalheim","orcid":"https://orcid.org/0000-0002-7909-7786"},"institutions":[{"id":"https://openalex.org/I32021983","display_name":"Christian-Albrechts-Universit\u00e4t zu Kiel","ror":"https://ror.org/04v76ef78","country_code":"DE","type":"education","lineage":["https://openalex.org/I32021983"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Bernhard Thalheim","raw_affiliation_strings":["UNIVERSITY OF KIEL"],"raw_orcid":"https://orcid.org/0000-0002-7909-7786","affiliations":[{"raw_affiliation_string":"UNIVERSITY OF KIEL","institution_ids":["https://openalex.org/I32021983"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.0787,"has_fulltext":false,"cited_by_count":16,"citation_normalized_percentile":{"value":0.89144666,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"15","issue":null,"first_page":"273","last_page":"303"},"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.9993000030517578,"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.9993000030517578,"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.9930999875068665,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9908000230789185,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/online-analytical-processing","display_name":"Online analytical processing","score":0.9884365797042847},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8420480489730835},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.8041239976882935},{"id":"https://openalex.org/keywords/dimension","display_name":"Dimension (graph theory)","score":0.662668764591217},{"id":"https://openalex.org/keywords/correctness","display_name":"Correctness","score":0.6514159440994263},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5547663569450378},{"id":"https://openalex.org/keywords/data-cube","display_name":"Data cube","score":0.5539436340332031},{"id":"https://openalex.org/keywords/variety","display_name":"Variety (cybernetics)","score":0.5001649856567383},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4277435839176178},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3641301393508911},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.33399689197540283},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.30761876702308655},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.28503483533859253},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.15138211846351624},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1089453399181366},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.07648339867591858}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.9884365797042847},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8420480489730835},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.8041239976882935},{"id":"https://openalex.org/C33676613","wikidata":"https://www.wikidata.org/wiki/Q13415176","display_name":"Dimension (graph theory)","level":2,"score":0.662668764591217},{"id":"https://openalex.org/C55439883","wikidata":"https://www.wikidata.org/wiki/Q360812","display_name":"Correctness","level":2,"score":0.6514159440994263},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5547663569450378},{"id":"https://openalex.org/C78168278","wikidata":"https://www.wikidata.org/wiki/Q5227269","display_name":"Data cube","level":2,"score":0.5539436340332031},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.5001649856567383},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4277435839176178},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3641301393508911},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.33399689197540283},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.30761876702308655},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.28503483533859253},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.15138211846351624},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1089453399181366},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.07648339867591858},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"pmh:oai:CiteSeerX.psu:10.1.1.166.96","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.166.96","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.jucs.org/jucs_15_1/a_formal_framework_of/jucs_15_01_0273_0303_lenz.pdf","raw_type":"text"},{"id":"pmh:oai:zenodo.org:7000631","is_oa":true,"landing_page_url":"https://zenodo.org/record/7000631","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"JUCS - Journal of Universal Computer Science 15((1)) 273-303","raw_type":"info:eu-repo/semantics/article"},{"id":"mag:2103207371","is_oa":false,"landing_page_url":"http://www.jucs.org/jucs_15_1/a_formal_framework_of/jucs_15_01_0273_0303_lenz.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S58563349","display_name":"JUCS - Journal of Universal Computer Science","issn_l":"0948-695X","issn":["0948-695X","0948-6968"],"is_oa":false,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310317875","host_organization_name":"Verlag der Technischen Universit\u00e4t Graz","host_organization_lineage":["https://openalex.org/P4310317875"],"host_organization_lineage_names":["Verlag der Technischen Universit\u00e4t Graz"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":"JUCS - Journal of Universal Computer Science","raw_type":null}],"best_oa_location":{"id":"pmh:oai:zenodo.org:7000631","is_oa":true,"landing_page_url":"https://zenodo.org/record/7000631","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"JUCS - Journal of Universal Computer Science 15((1)) 273-303","raw_type":"info:eu-repo/semantics/article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W127768483","https://openalex.org/W161157074","https://openalex.org/W571574236","https://openalex.org/W585935133","https://openalex.org/W1491485151","https://openalex.org/W1502779941","https://openalex.org/W1507391885","https://openalex.org/W1526843800","https://openalex.org/W1528905581","https://openalex.org/W1585806150","https://openalex.org/W1842983266","https://openalex.org/W1963724650","https://openalex.org/W1991368089","https://openalex.org/W2038303453","https://openalex.org/W2098474948","https://openalex.org/W2125886825","https://openalex.org/W2134217480","https://openalex.org/W2138745909","https://openalex.org/W2140151132","https://openalex.org/W2146581901","https://openalex.org/W2158405135","https://openalex.org/W2315950466","https://openalex.org/W2339920159","https://openalex.org/W2905472553","https://openalex.org/W3015463134"],"related_works":["https://openalex.org/W2142499556","https://openalex.org/W2139103617","https://openalex.org/W2982366181","https://openalex.org/W2521495343","https://openalex.org/W151666193","https://openalex.org/W2144897876","https://openalex.org/W1567929796","https://openalex.org/W1491485151","https://openalex.org/W2125054766","https://openalex.org/W2125189508","https://openalex.org/W2153955319","https://openalex.org/W206475349","https://openalex.org/W2108294523","https://openalex.org/W2234397842","https://openalex.org/W146249702","https://openalex.org/W1483342375","https://openalex.org/W2564343449","https://openalex.org/W2075591954","https://openalex.org/W1491945093","https://openalex.org/W1990456048"],"abstract_inverted_index":{"Abstract:":[0],"OLAP":[1,28,86,99,114,121],"applications":[2,122],"are":[3,10,56,67],"widely":[4],"used":[5,68],"in":[6],"business":[7],"applications.":[8,87],"They":[9],"often":[11],"(implicitly)":[12],"defined":[13],"on":[14,102],"top":[15],"of":[16,38,53,63,113,120],"OLTP":[17],"systems":[18],"and":[19,23,49,58,93],"extensively":[20],"use":[21,94],"aggregation":[22,47,91],"transformation":[24],"functions.":[25],"The":[26],"main":[27],"data":[29],"structure":[30],"is":[31,127],"a":[32,61,83],"multidimensional":[33],"table":[34],"with":[35],"three":[36],"kinds":[37],"attributes:":[39],"so-called":[40],"dimension":[41,54],"attributes,":[42],"implicit":[43],"attributes":[44,55],"given":[45],"by":[46],"functions":[48,92],"fact":[50,75],"attributes.":[51,76],"Domains":[52],"structured":[57],"thus":[59],"support":[60],"variety":[62],"aggregations.":[64],"These":[65],"aggregations":[66],"to":[69,96],"generate":[70],"new":[71],"values":[72],"for":[73,85,117],"the":[74,123],"In":[77],"this":[78],"paper":[79],"we":[80,105],"systematically":[81],"develop":[82],"theory":[84],"We":[88],"first":[89],"define":[90],"these":[95,103],"introduce":[97],"an":[98],"algebra.":[100],"Based":[101],"foundations":[104],"derive":[106],"properties":[107],"that":[108],"guarantee":[109],"or":[110],"contradict":[111],"correctness":[112],"computations.":[115],"Finally,":[116],"pragmatical":[118],"treatment":[119],"OLTP-OLAP":[124],"specification":[125],"frame":[126],"introduced.":[128]},"counts_by_year":[{"year":2023,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":3},{"year":2012,"cited_by_count":1}],"updated_date":"2026-08-26T07:47:46.906454","created_date":"2025-10-10T00:00:00"}