{"id":"https://openalex.org/W2170502687","doi":"https://doi.org/10.1145/1031763.1031781","title":"On querying versions of multiversion data warehouse","display_name":"On querying versions of multiversion data warehouse","publication_year":2004,"publication_date":"2004-11-12","ids":{"openalex":"https://openalex.org/W2170502687","doi":"https://doi.org/10.1145/1031763.1031781","mag":"2170502687"},"language":"en","primary_location":{"id":"doi:10.1145/1031763.1031781","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1031763.1031781","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 7th ACM international workshop on Data warehousing and OLAP","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/A5111998472","display_name":"Tadeusz Morzy","orcid":null},"institutions":[{"id":"https://openalex.org/I46597724","display_name":"Pozna\u0144 University of Technology","ror":"https://ror.org/00p7p3302","country_code":"PL","type":"education","lineage":["https://openalex.org/I46597724"]}],"countries":["PL"],"is_corresponding":true,"raw_author_name":"Tadeusz Morzy","raw_affiliation_strings":["Poznan University of Technology, Poland"],"affiliations":[{"raw_affiliation_string":"Poznan University of Technology, Poland","institution_ids":["https://openalex.org/I46597724"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5054888563","display_name":"Robert Wrembel","orcid":"https://orcid.org/0000-0001-6037-5718"},"institutions":[{"id":"https://openalex.org/I46597724","display_name":"Pozna\u0144 University of Technology","ror":"https://ror.org/00p7p3302","country_code":"PL","type":"education","lineage":["https://openalex.org/I46597724"]}],"countries":["PL"],"is_corresponding":false,"raw_author_name":"Robert Wrembel","raw_affiliation_strings":["Poznan University of Technology, Poland"],"affiliations":[{"raw_affiliation_string":"Poznan University of Technology, Poland","institution_ids":["https://openalex.org/I46597724"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5111998472"],"corresponding_institution_ids":["https://openalex.org/I46597724"],"apc_list":null,"apc_paid":null,"fwci":5.3302,"has_fulltext":false,"cited_by_count":64,"citation_normalized_percentile":{"value":0.96073403,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"92","last_page":"101"},"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.9998999834060669,"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.9998999834060669,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9979000091552734,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.9969000220298767,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8566187024116516},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.759438157081604},{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.615533709526062},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5991599559783936},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5796360373497009},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5622029900550842},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.44561412930488586},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.41651201248168945},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.34973421692848206},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.28826025128364563},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.20291107892990112},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.16439419984817505}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8566187024116516},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.759438157081604},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.615533709526062},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5991599559783936},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5796360373497009},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5622029900550842},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.44561412930488586},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.41651201248168945},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.34973421692848206},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.28826025128364563},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.20291107892990112},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.16439419984817505}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1031763.1031781","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1031763.1031781","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 7th ACM international workshop on Data warehousing and OLAP","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W84921480","https://openalex.org/W144830792","https://openalex.org/W155432670","https://openalex.org/W1514474360","https://openalex.org/W1534906344","https://openalex.org/W1541087195","https://openalex.org/W1544363742","https://openalex.org/W1554212881","https://openalex.org/W1605324722","https://openalex.org/W1606507025","https://openalex.org/W1989532930","https://openalex.org/W2013571244","https://openalex.org/W2026130312","https://openalex.org/W2030285894","https://openalex.org/W2056553115","https://openalex.org/W2075451706","https://openalex.org/W2100879782","https://openalex.org/W2101915266","https://openalex.org/W2133054368","https://openalex.org/W2139245968","https://openalex.org/W2160457037","https://openalex.org/W2164086463","https://openalex.org/W2170517984"],"related_works":["https://openalex.org/W2383931363","https://openalex.org/W2106325388","https://openalex.org/W2162280381","https://openalex.org/W2522980826","https://openalex.org/W2160825121","https://openalex.org/W2150417377","https://openalex.org/W2533418180","https://openalex.org/W2108498730","https://openalex.org/W1597514649","https://openalex.org/W1596854687"],"abstract_inverted_index":{"A":[0,67],"data":[1,7,12,19,39,83,96],"warehouse":[2],"(DW)":[3],"is":[4,78,125],"fed":[5],"with":[6,154,172],"that":[8,14,48,156,161],"come":[9],"from":[10],"external":[11,38],"sources":[13,40],"are":[15,22],"production":[16],"systems.":[17],"External":[18],"sources,":[20],"which":[21],"usually":[23],"autonomous,":[24],"often":[25],"change":[26],"not":[27],"only":[28],"their":[29,33,63,169],"content":[30,77],"but":[31],"also":[32],"structure.":[34],"The":[35],"evolution":[36],"of":[37,100],"has":[41],"to":[42,70,113,120,134],"be":[43],"reflected":[44],"in":[45,62,73],"a":[46,56,81,87,93,103,121,136,144,149],"DW,":[47,88],"uses":[49],"the":[50],"sources.":[51],"Traditional":[52],"DW":[53,74,90,164],"systems":[54],"offer":[55],"limited":[57],"support":[58],"for":[59,108],"handling":[60,71],"dynamics":[61],"structure":[64,75],"and":[65,76,95,147,166],"content.":[66],"promising":[68],"approach":[69,133],"changes":[72],"based":[79],"on":[80],"multiversion":[82,116,137,150],"warehouse.":[84],"In":[85,111,127],"such":[86],"each":[89],"version":[91],"describes":[92],"schema":[94],"at":[97],"certain":[98],"period":[99],"time":[101],"or":[102],"given":[104],"business":[105],"scenario,":[106],"created":[107],"simulation":[109],"purposes.":[110],"order":[112],"appropriately":[114],"analyze":[115],"data,":[117],"an":[118,132],"extension":[119],"traditional":[122],"SQL":[123,145],"language":[124,146,152],"required.":[126],"this":[128,140],"paper":[129],"we":[130,142],"propose":[131],"querying":[135],"DW.":[138],"To":[139],"end,":[141],"extended":[143],"built":[148],"query":[151],"interface":[153],"functionality":[155],"allows:":[157],"(1)":[158],"expressing":[159],"queries":[160],"address":[162],"several":[163],"versions":[165],"(2)":[167],"presenting":[168],"results":[170],"annotated":[171],"metadata":[173],"information.":[174]},"counts_by_year":[{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":4},{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}