{"id":"https://openalex.org/W2927734714","doi":"https://doi.org/10.2478/amcs-2019-0003","title":"Modeling and querying facts with period timestamps in data warehouses","display_name":"Modeling and querying facts with period timestamps in data warehouses","publication_year":2019,"publication_date":"2019-03-01","ids":{"openalex":"https://openalex.org/W2927734714","doi":"https://doi.org/10.2478/amcs-2019-0003","mag":"2927734714"},"language":"en","primary_location":{"id":"doi:10.2478/amcs-2019-0003","is_oa":true,"landing_page_url":"https://doi.org/10.2478/amcs-2019-0003","pdf_url":"https://content.sciendo.com/downloadpdf/journals/amcs/29/1/article-p31.pdf","source":{"id":"https://openalex.org/S117679522","display_name":"International Journal of Applied Mathematics and Computer Science","issn_l":"1641-876X","issn":["1641-876X","2083-8492"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320322","host_organization_name":"De Gruyter Open","host_organization_lineage":["https://openalex.org/P4310320322","https://openalex.org/P4310313990"],"host_organization_lineage_names":["De Gruyter Open","De Gruyter"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Applied Mathematics and Computer Science","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://content.sciendo.com/downloadpdf/journals/amcs/29/1/article-p31.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5055767432","display_name":"Giovanni Mahlknecht","orcid":"https://orcid.org/0000-0003-3415-4422"},"institutions":[{"id":"https://openalex.org/I171543936","display_name":"Free University of Bozen-Bolzano","ror":"https://ror.org/012ajp527","country_code":"IT","type":"education","lineage":["https://openalex.org/I171543936"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Giovanni Mahlknecht","raw_affiliation_strings":["Faculty of Computer Science , Free University of Bozen-Bolzano , Dominikanerplatz 3, 39100 Bozen , Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Computer Science , Free University of Bozen-Bolzano , Dominikanerplatz 3, 39100 Bozen , Italy","institution_ids":["https://openalex.org/I171543936"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037964119","display_name":"Anton Dign\u00f6s","orcid":"https://orcid.org/0000-0002-7621-967X"},"institutions":[{"id":"https://openalex.org/I171543936","display_name":"Free University of Bozen-Bolzano","ror":"https://ror.org/012ajp527","country_code":"IT","type":"education","lineage":["https://openalex.org/I171543936"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Anton Dign\u00f6s","raw_affiliation_strings":["Faculty of Computer Science , Free University of Bozen-Bolzano , Dominikanerplatz 3, 39100 Bozen , Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Computer Science , Free University of Bozen-Bolzano , Dominikanerplatz 3, 39100 Bozen , Italy","institution_ids":["https://openalex.org/I171543936"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5060276929","display_name":"Nat\u0101lija Kozmina","orcid":"https://orcid.org/0000-0001-9133-5671"},"institutions":[{"id":"https://openalex.org/I91123046","display_name":"University of Latvia","ror":"https://ror.org/05g3mes96","country_code":"LV","type":"education","lineage":["https://openalex.org/I91123046"]}],"countries":["LV"],"is_corresponding":false,"raw_author_name":"Natalija Kozmina","raw_affiliation_strings":["Faculty of Computing , University of Latvia , Rai\u0146a bulv\u0101ris 19, Riga , LV-1586 , Latvia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Computing , University of Latvia , Rai\u0146a bulv\u0101ris 19, Riga , LV-1586 , Latvia","institution_ids":["https://openalex.org/I91123046"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5037964119"],"corresponding_institution_ids":["https://openalex.org/I171543936"],"apc_list":{"value":4080,"currency":"PLN","value_usd":1100},"apc_paid":{"value":4080,"currency":"PLN","value_usd":1100},"fwci":0.4908,"has_fulltext":true,"cited_by_count":5,"citation_normalized_percentile":{"value":0.60828365,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"29","issue":"1","first_page":"31","last_page":"49"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994999766349792,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9991999864578247,"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/computer-science","display_name":"Computer science","score":0.7557553052902222},{"id":"https://openalex.org/keywords/period","display_name":"Period (music)","score":0.6670351624488831},{"id":"https://openalex.org/keywords/timestamp","display_name":"Timestamp","score":0.6402704119682312},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.6263828873634338},{"id":"https://openalex.org/keywords/dimension","display_name":"Dimension (graph theory)","score":0.5542635917663574},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5440860986709595},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.44651710987091064},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.43355119228363037},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3613264858722687},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.10819137096405029},{"id":"https://openalex.org/keywords/real-time-computing","display_name":"Real-time computing","score":0.08578106760978699}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7557553052902222},{"id":"https://openalex.org/C2781291010","wikidata":"https://www.wikidata.org/wiki/Q178580","display_name":"Period (music)","level":2,"score":0.6670351624488831},{"id":"https://openalex.org/C113954288","wikidata":"https://www.wikidata.org/wiki/Q186885","display_name":"Timestamp","level":2,"score":0.6402704119682312},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6263828873634338},{"id":"https://openalex.org/C33676613","wikidata":"https://www.wikidata.org/wiki/Q13415176","display_name":"Dimension (graph theory)","level":2,"score":0.5542635917663574},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5440860986709595},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.44651710987091064},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.43355119228363037},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3613264858722687},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.10819137096405029},{"id":"https://openalex.org/C79403827","wikidata":"https://www.wikidata.org/wiki/Q3988","display_name":"Real-time computing","level":1,"score":0.08578106760978699},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C24890656","wikidata":"https://www.wikidata.org/wiki/Q82811","display_name":"Acoustics","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.2478/amcs-2019-0003","is_oa":true,"landing_page_url":"https://doi.org/10.2478/amcs-2019-0003","pdf_url":"https://content.sciendo.com/downloadpdf/journals/amcs/29/1/article-p31.pdf","source":{"id":"https://openalex.org/S117679522","display_name":"International Journal of Applied Mathematics and Computer Science","issn_l":"1641-876X","issn":["1641-876X","2083-8492"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320322","host_organization_name":"De Gruyter Open","host_organization_lineage":["https://openalex.org/P4310320322","https://openalex.org/P4310313990"],"host_organization_lineage_names":["De Gruyter Open","De Gruyter"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Applied Mathematics and Computer Science","raw_type":"journal-article"},{"id":"pmh:oai:alma.39UBZ_INST:11235136310001241","is_oa":false,"landing_page_url":"https://www.amcs.uz.zgora.pl/?action=paper&paper=1473","pdf_url":null,"source":{"id":"https://openalex.org/S4210197018","display_name":"View","issn_l":"2688-268X","issn":["2688-268X","2688-3988"],"is_oa":false,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},{"id":"pmh:oai:doaj.org/article:4f020588f8ad41449bc9b29e48ba712a","is_oa":false,"landing_page_url":"https://doaj.org/article/4f020588f8ad41449bc9b29e48ba712a","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"International Journal of Applied Mathematics and Computer Science, Vol 29, Iss 1, Pp 31-49 (2019)","raw_type":"article"},{"id":"pmh:oai:zenodo.org:118061","is_oa":true,"landing_page_url":"https://www.openaccessrepository.it/record/118061","pdf_url":null,"source":{"id":"https://openalex.org/S4306402478","display_name":"INFM-OAR (INFN Catania)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210116497","host_organization_name":"Istituto Nazionale di Fisica Nucleare, Sezione di Catania","host_organization_lineage":["https://openalex.org/I4210116497"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"doi:10.2478/amcs-2019-0003","is_oa":true,"landing_page_url":"https://doi.org/10.2478/amcs-2019-0003","pdf_url":"https://content.sciendo.com/downloadpdf/journals/amcs/29/1/article-p31.pdf","source":{"id":"https://openalex.org/S117679522","display_name":"International Journal of Applied Mathematics and Computer Science","issn_l":"1641-876X","issn":["1641-876X","2083-8492"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320322","host_organization_name":"De Gruyter Open","host_organization_lineage":["https://openalex.org/P4310320322","https://openalex.org/P4310313990"],"host_organization_lineage_names":["De Gruyter Open","De Gruyter"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Applied Mathematics and Computer Science","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320325400","display_name":"Libera Universit\u00e0 di Bolzano","ror":"https://ror.org/012ajp527"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2927734714.pdf","grobid_xml":"https://content.openalex.org/works/W2927734714.grobid-xml"},"referenced_works_count":44,"referenced_works":["https://openalex.org/W57116089","https://openalex.org/W85525024","https://openalex.org/W108771532","https://openalex.org/W1513469429","https://openalex.org/W1534804396","https://openalex.org/W1554212881","https://openalex.org/W1602435040","https://openalex.org/W1666647178","https://openalex.org/W1773168468","https://openalex.org/W1782046864","https://openalex.org/W1945920115","https://openalex.org/W1979795383","https://openalex.org/W1983721754","https://openalex.org/W1986050705","https://openalex.org/W2012964802","https://openalex.org/W2016218534","https://openalex.org/W2039614607","https://openalex.org/W2050000254","https://openalex.org/W2062245195","https://openalex.org/W2067426207","https://openalex.org/W2082974912","https://openalex.org/W2120538868","https://openalex.org/W2125317812","https://openalex.org/W2146581901","https://openalex.org/W2164086463","https://openalex.org/W2171497557","https://openalex.org/W2172031037","https://openalex.org/W2173239517","https://openalex.org/W2293307430","https://openalex.org/W2402410286","https://openalex.org/W2444247778","https://openalex.org/W2460071091","https://openalex.org/W2460705648","https://openalex.org/W2479522004","https://openalex.org/W2546460896","https://openalex.org/W2590972148","https://openalex.org/W2739205407","https://openalex.org/W2751785830","https://openalex.org/W2884270003","https://openalex.org/W3019609263","https://openalex.org/W4205311374","https://openalex.org/W4298841833","https://openalex.org/W4299900315","https://openalex.org/W4301232451"],"related_works":["https://openalex.org/W2060561905","https://openalex.org/W1417711376","https://openalex.org/W1986883493","https://openalex.org/W2469862403","https://openalex.org/W2166378262","https://openalex.org/W2035891203","https://openalex.org/W4379524643","https://openalex.org/W2367807705","https://openalex.org/W2011027677","https://openalex.org/W3029152356"],"abstract_inverted_index":{"Abstract":[0],"In":[1],"this":[2],"paper,":[3],"we":[4],"study":[5],"various":[6],"ways":[7],"of":[8,64,75,81,111,125,153,169],"representing":[9],"and":[10,47,77,86,134,147,150,171],"querying":[11],"fact":[12],"data":[13,23],"that":[14,36,58,90,159],"are":[15,37,91],"time-stamped":[16],"with":[17,39,106],"a":[18,22,69,82,95],"time":[19,34,60,66,79],"period":[20,70,83,97,102,161],"in":[21,42,68,94,167],"warehouse.":[24],"The":[25,101],"main":[26],"focus":[27],"is":[28,104,163],"on":[29,145],"how":[30],"to":[31,44,128],"represent":[32,59],"the":[33,40,109,116,138,151,154,160,164],"periods":[35,61],"associated":[38],"facts":[41],"order":[43],"support":[45],"convenient":[46],"efficient":[48],"aggregations":[49],"over":[50,137],"time.":[51],"We":[52,120],"propose":[53],"three":[54,139],"distinct":[55],"logical":[56],"models":[57],"as":[62,73,87],"sets":[63],"all":[65,174],"points":[67,80],"(instant":[71],"model),":[72,85],"pairs":[74],"start":[76],"end":[78],"(period":[84],"atomic":[88],"units":[89],"explicitly":[92],"stored":[93],"new":[96],"dimension":[98,103],"(period\u2217":[99],"model).":[100],"enriched":[105],"information":[107],"about":[108],"days":[110],"each":[112],"period,":[113],"thereby":[114],"combining":[115],"former":[117],"two":[118],"models.":[119,140],"use":[121],"four":[122,175],"different":[123],"classes":[124],"aggregation":[126],"queries":[127],"analyze":[129],"query":[130,132,135,155,176],"formulation,":[131],"execution,":[133],"performance":[136],"An":[141],"extensive":[142],"empirical":[143],"evaluation":[144],"synthetic":[146],"real-world":[148],"datasets":[149],"analysis":[152],"execution":[156],"plans":[157],"reveal":[158],"model":[162],"best":[165],"choice":[166],"terms":[168],"runtime":[170],"space":[172],"for":[173],"classes.":[177]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":2}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2019-04-11T00:00:00"}