{"id":"https://openalex.org/W2770540174","doi":"https://doi.org/10.1155/2017/7392349","title":"Temporal and Evolving Data Warehouse Design","display_name":"Temporal and Evolving Data Warehouse Design","publication_year":2017,"publication_date":"2017-01-01","ids":{"openalex":"https://openalex.org/W2770540174","doi":"https://doi.org/10.1155/2017/7392349","mag":"2770540174"},"language":"en","primary_location":{"id":"doi:10.1155/2017/7392349","is_oa":true,"landing_page_url":"https://doi.org/10.1155/2017/7392349","pdf_url":"http://downloads.hindawi.com/journals/sp/2017/7392349.pdf","source":{"id":"https://openalex.org/S166774750","display_name":"Scientific Programming","issn_l":"1058-9244","issn":["1058-9244","1875-919X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319869","host_organization_name":"Hindawi Publishing Corporation","host_organization_lineage":["https://openalex.org/P4310319869"],"host_organization_lineage_names":["Hindawi Publishing Corporation"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Scientific Programming","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"http://downloads.hindawi.com/journals/sp/2017/7392349.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5025768429","display_name":"Sidra Faisal","orcid":null},"institutions":[{"id":"https://openalex.org/I172780181","display_name":"University of the Punjab","ror":"https://ror.org/011maz450","country_code":"PK","type":"education","lineage":["https://openalex.org/I172780181"]}],"countries":["PK"],"is_corresponding":false,"raw_author_name":"Sidra Faisal","raw_affiliation_strings":["Punjab University College of Information Technology, Lahore, Pakistan"],"affiliations":[{"raw_affiliation_string":"Punjab University College of Information Technology, Lahore, Pakistan","institution_ids":["https://openalex.org/I172780181"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103788248","display_name":"Mansoor Sarwar","orcid":null},"institutions":[{"id":"https://openalex.org/I172780181","display_name":"University of the Punjab","ror":"https://ror.org/011maz450","country_code":"PK","type":"education","lineage":["https://openalex.org/I172780181"]}],"countries":["PK"],"is_corresponding":false,"raw_author_name":"Mansoor Sarwar","raw_affiliation_strings":["Punjab University College of Information Technology, Lahore, Pakistan"],"affiliations":[{"raw_affiliation_string":"Punjab University College of Information Technology, Lahore, Pakistan","institution_ids":["https://openalex.org/I172780181"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007446608","display_name":"Khurram Shahzad","orcid":"https://orcid.org/0000-0001-8433-6705"},"institutions":[{"id":"https://openalex.org/I172780181","display_name":"University of the Punjab","ror":"https://ror.org/011maz450","country_code":"PK","type":"education","lineage":["https://openalex.org/I172780181"]}],"countries":["PK"],"is_corresponding":true,"raw_author_name":"Khurram Shahzad","raw_affiliation_strings":["Punjab University College of Information Technology, Lahore, Pakistan"],"affiliations":[{"raw_affiliation_string":"Punjab University College of Information Technology, Lahore, Pakistan","institution_ids":["https://openalex.org/I172780181"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027531312","display_name":"S. Sarwar","orcid":"https://orcid.org/0000-0003-3074-9162"},"institutions":[{"id":"https://openalex.org/I172780181","display_name":"University of the Punjab","ror":"https://ror.org/011maz450","country_code":"PK","type":"education","lineage":["https://openalex.org/I172780181"]}],"countries":["PK"],"is_corresponding":false,"raw_author_name":"Shahzad Sarwar","raw_affiliation_strings":["Punjab University College of Information Technology, Lahore, Pakistan"],"affiliations":[{"raw_affiliation_string":"Punjab University College of Information Technology, Lahore, Pakistan","institution_ids":["https://openalex.org/I172780181"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5046503763","display_name":"Waqar Jaffry","orcid":null},"institutions":[{"id":"https://openalex.org/I172780181","display_name":"University of the Punjab","ror":"https://ror.org/011maz450","country_code":"PK","type":"education","lineage":["https://openalex.org/I172780181"]}],"countries":["PK"],"is_corresponding":false,"raw_author_name":"Waqar Jaffry","raw_affiliation_strings":["Punjab University College of Information Technology, Lahore, Pakistan"],"affiliations":[{"raw_affiliation_string":"Punjab University College of Information Technology, Lahore, Pakistan","institution_ids":["https://openalex.org/I172780181"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5010923976","display_name":"Muhammad Murtaza Yousaf","orcid":"https://orcid.org/0000-0001-9578-8811"},"institutions":[{"id":"https://openalex.org/I172780181","display_name":"University of the Punjab","ror":"https://ror.org/011maz450","country_code":"PK","type":"education","lineage":["https://openalex.org/I172780181"]}],"countries":["PK"],"is_corresponding":false,"raw_author_name":"Muhammad Murtaza Yousaf","raw_affiliation_strings":["Punjab University College of Information Technology, Lahore, Pakistan"],"affiliations":[{"raw_affiliation_string":"Punjab University College of Information Technology, Lahore, Pakistan","institution_ids":["https://openalex.org/I172780181"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5007446608"],"corresponding_institution_ids":["https://openalex.org/I172780181"],"apc_list":{"value":1800,"currency":"USD","value_usd":1800},"apc_paid":{"value":1800,"currency":"USD","value_usd":1800},"fwci":0.6216,"has_fulltext":true,"cited_by_count":5,"citation_normalized_percentile":{"value":0.73450968,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":"2017","issue":null,"first_page":"1","last_page":"18"},"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.9997000098228455,"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.9997000098228455,"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.9983999729156494,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9975000023841858,"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/data-warehouse","display_name":"Data warehouse","score":0.8581236600875854},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7332297563552856},{"id":"https://openalex.org/keywords/transaction-data","display_name":"Transaction data","score":0.6156848669052124},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.5744931697845459},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.4940348267555237},{"id":"https://openalex.org/keywords/software-versioning","display_name":"Software versioning","score":0.48626935482025146},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.4806767404079437},{"id":"https://openalex.org/keywords/logical-data-model","display_name":"Logical data model","score":0.47820138931274414},{"id":"https://openalex.org/keywords/data-model","display_name":"Data model (GIS)","score":0.47264379262924194},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.42541220784187317},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3783888816833496},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3510535955429077},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.09657219052314758}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8581236600875854},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7332297563552856},{"id":"https://openalex.org/C127722929","wikidata":"https://www.wikidata.org/wiki/Q7833714","display_name":"Transaction data","level":3,"score":0.6156848669052124},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.5744931697845459},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.4940348267555237},{"id":"https://openalex.org/C198140048","wikidata":"https://www.wikidata.org/wiki/Q10859422","display_name":"Software versioning","level":3,"score":0.48626935482025146},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.4806767404079437},{"id":"https://openalex.org/C203702819","wikidata":"https://www.wikidata.org/wiki/Q17146953","display_name":"Logical data model","level":3,"score":0.47820138931274414},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.47264379262924194},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.42541220784187317},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3783888816833496},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3510535955429077},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.09657219052314758},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1155/2017/7392349","is_oa":true,"landing_page_url":"https://doi.org/10.1155/2017/7392349","pdf_url":"http://downloads.hindawi.com/journals/sp/2017/7392349.pdf","source":{"id":"https://openalex.org/S166774750","display_name":"Scientific Programming","issn_l":"1058-9244","issn":["1058-9244","1875-919X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319869","host_organization_name":"Hindawi Publishing Corporation","host_organization_lineage":["https://openalex.org/P4310319869"],"host_organization_lineage_names":["Hindawi Publishing Corporation"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Scientific Programming","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:7f3728986beb4364b5abe8b2f6659a30","is_oa":true,"landing_page_url":"https://doaj.org/article/7f3728986beb4364b5abe8b2f6659a30","pdf_url":null,"source":{"id":"https://openalex.org/S112646816","display_name":"SHILAP Revista de lepidopterolog\u00eda","issn_l":"0300-5267","issn":["0300-5267","2340-4078"],"is_oa":true,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Scientific Programming, Vol 2017 (2017)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.1155/2017/7392349","is_oa":true,"landing_page_url":"https://doi.org/10.1155/2017/7392349","pdf_url":"http://downloads.hindawi.com/journals/sp/2017/7392349.pdf","source":{"id":"https://openalex.org/S166774750","display_name":"Scientific Programming","issn_l":"1058-9244","issn":["1058-9244","1875-919X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319869","host_organization_name":"Hindawi Publishing Corporation","host_organization_lineage":["https://openalex.org/P4310319869"],"host_organization_lineage_names":["Hindawi Publishing Corporation"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Scientific Programming","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2770540174.pdf","grobid_xml":"https://content.openalex.org/works/W2770540174.grobid-xml"},"referenced_works_count":16,"referenced_works":["https://openalex.org/W1596708276","https://openalex.org/W1971509121","https://openalex.org/W1994642127","https://openalex.org/W2008120802","https://openalex.org/W2008440502","https://openalex.org/W2066771909","https://openalex.org/W2075451706","https://openalex.org/W2082974912","https://openalex.org/W2115023597","https://openalex.org/W2126395594","https://openalex.org/W2139245968","https://openalex.org/W2173239517","https://openalex.org/W2460705648","https://openalex.org/W2468725466","https://openalex.org/W2474025926","https://openalex.org/W3000682779"],"related_works":["https://openalex.org/W2348604092","https://openalex.org/W2369215403","https://openalex.org/W2991945580","https://openalex.org/W2074395527","https://openalex.org/W638142098","https://openalex.org/W2390641883","https://openalex.org/W2365424496","https://openalex.org/W2008120802","https://openalex.org/W2821022937","https://openalex.org/W2017012227"],"abstract_inverted_index":{"The":[0,20,60,154],"data":[1,6,18,44,47,84,88,137,149,152],"model":[2,63,89],"of":[3,28,78,83,87,92,111],"the":[4,50,76,107,118,127,144],"classical":[5,61],"warehouse":[7,138],"(formally,":[8],"dimensional":[9,62,93],"model)":[10],"does":[11],"not":[12],"offer":[13],"comprehensive":[14],"support":[15],"for":[16,46,142],"temporal":[17,30,148],"management.":[19],"underlying":[21],"reason":[22],"is":[23,64],"that":[24,129],"it":[25,114],"requires":[26],"consideration":[27],"several":[29],"aspects,":[31,112],"which":[32,40],"involve":[33],"various":[34,79],"time":[35],"stamps.":[36],"Also,":[37],"transactional":[38],"systems,":[39],"serves":[41],"as":[42],"a":[43,136],"source":[45],"warehouse,":[48],"have":[49,97],"tendency":[51],"to":[52,56,69,75,116,147],"change":[53],"themselves":[54],"due":[55],"changing":[57],"business":[58],"requirements.":[59],"deficient":[65],"in":[66,151],"handling":[67],"changes":[68],"transaction":[70],"sources.":[71],"This":[72,124],"has":[73],"led":[74],"development":[77],"schemes,":[80],"including":[81],"evolution":[82,86],"and":[85,90,101,139],"versioning":[91],"model.":[94],"These":[95],"models":[96,146],"their":[98],"own":[99],"strengths":[100],"limitations,":[102],"but":[103],"none":[104],"fully":[105],"satisfies":[106],"above-stated":[108],"broad":[109],"range":[110],"making":[113],"difficult":[115],"compare":[117],"proposed":[119],"schemes":[120,128],"with":[121],"one":[122],"another.":[123],"paper":[125,155],"analyses":[126],"satisfy":[130],"such":[131],"challenging":[132],"aspects":[133],"faced":[134],"by":[135],"proposes":[140],"taxonomy":[141],"characterizing":[143],"existing":[145],"management":[150],"warehouse.":[153],"also":[156],"discusses":[157],"some":[158],"open":[159],"challenges.":[160]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}