{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,2,21]],"date-time":"2025-02-21T21:54:56Z","timestamp":1740174896161,"version":"3.37.3"},"reference-count":21,"publisher":"Wiley","license":[{"start":{"date-parts":[[2017,1,1]],"date-time":"2017-01-01T00:00:00Z","timestamp":1483228800000},"content-version":"unspecified","delay-in-days":0,"URL":"http:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Scientific Programming"],"published-print":{"date-parts":[[2017]]},"abstract":"<jats:p>The data model of the classical data warehouse (formally, dimensional model) does not offer comprehensive support for temporal data management. The underlying reason is that it requires consideration of several temporal aspects, which involve various time stamps. Also, transactional systems, which serves as a data source for data warehouse, have the tendency to change themselves due to changing business requirements. The classical dimensional model is deficient in handling changes to transaction sources. This has led to the development of various schemes, including evolution of data and evolution of data model and versioning of dimensional model. These models have their own strengths and limitations, but none fully satisfies the above-stated broad range of aspects, making it difficult to compare the proposed schemes with one another. This paper analyses the schemes that satisfy such challenging aspects faced by a data warehouse and proposes taxonomy for characterizing the existing models to temporal data management in data warehouse. The paper also discusses some open challenges.<\/jats:p>","DOI":"10.1155\/2017\/7392349","type":"journal-article","created":{"date-parts":[[2017,11,26]],"date-time":"2017-11-26T18:30:41Z","timestamp":1511721041000},"page":"1-18","source":"Crossref","is-referenced-by-count":3,"title":["Temporal and Evolving Data Warehouse Design"],"prefix":"10.1155","volume":"2017","author":[{"given":"Sidra","family":"Faisal","sequence":"first","affiliation":[{"name":"Punjab University College of Information Technology, Lahore, Pakistan"}]},{"given":"Mansoor","family":"Sarwar","sequence":"additional","affiliation":[{"name":"Punjab University College of Information Technology, Lahore, Pakistan"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-8433-6705","authenticated-orcid":true,"given":"Khurram","family":"Shahzad","sequence":"additional","affiliation":[{"name":"Punjab University College of Information Technology, Lahore, Pakistan"}]},{"given":"Shahzad","family":"Sarwar","sequence":"additional","affiliation":[{"name":"Punjab University College of Information Technology, Lahore, Pakistan"}]},{"given":"Waqar","family":"Jaffry","sequence":"additional","affiliation":[{"name":"Punjab University College of Information Technology, Lahore, Pakistan"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-9578-8811","authenticated-orcid":true,"given":"Muhammad Murtaza","family":"Yousaf","sequence":"additional","affiliation":[{"name":"Punjab University College of Information Technology, Lahore, Pakistan"}]}],"member":"311","reference":[{"key":"1","doi-asserted-by":"publisher","DOI":"10.1016\/j.ins.2016.07.007"},{"key":"8","doi-asserted-by":"publisher","DOI":"10.1504\/IJBIS.2016.075252"},{"issue":"1","key":"9","doi-asserted-by":"crossref","first-page":"1","DOI":"10.4018\/jdwm.2009010101","volume":"5","year":"2009","journal-title":"International Journal of Data Warehousing & Mining"},{"issue":"2","key":"12","first-page":"17","volume":"7","year":"2017","journal-title":"The Online Journal of Science and Technology"},{"key":"23","doi-asserted-by":"publisher","DOI":"10.4018\/jdwm.2009040102"},{"first-page":"106","volume-title":"On handling the evolution of external data sources in a data warehouse architecture","year":"2011","key":"24"},{"key":"26","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2005.09.004"},{"key":"27","doi-asserted-by":"publisher","DOI":"10.1142\/S0218843098000118"},{"journal-title":"Springer Encyclopedia of Database Systems","first-page":"664","year":"2009","key":"28"},{"first-page":"171","volume-title":"Data warehouse maintenance, evolution and versioning","year":"2010","key":"29"},{"key":"31","doi-asserted-by":"publisher","DOI":"10.1504\/IJDMMM.2016.077156"},{"key":"38","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2003.11.001"},{"key":"42","doi-asserted-by":"publisher","DOI":"10.1016\/S0306-4379(03)00049-8"},{"key":"43","doi-asserted-by":"publisher","DOI":"10.1016\/S0306-4379(01)00023-0"},{"issue":"2","key":"55","doi-asserted-by":"crossref","first-page":"393","DOI":"10.1145\/253262.253352","volume":"26","year":"1997","journal-title":"SIGMOD Record"},{"key":"50","first-page":"118","volume":"8","year":"2007","journal-title":"Journal of Data Semantics"},{"key":"35","doi-asserted-by":"publisher","DOI":"10.1023\/A:1016555410197"},{"key":"36","doi-asserted-by":"publisher","DOI":"10.1258\/jicp.2011.011025"},{"key":"47","doi-asserted-by":"publisher","DOI":"10.1145\/1042046.1042049"},{"volume-title":"What-if Analysis","year":"2009","key":"53"},{"key":"57"}],"container-title":["Scientific Programming"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/downloads.hindawi.com\/journals\/sp\/2017\/7392349.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/downloads.hindawi.com\/journals\/sp\/2017\/7392349.xml","content-type":"application\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/downloads.hindawi.com\/journals\/sp\/2017\/7392349.pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2017,11,26]],"date-time":"2017-11-26T18:30:45Z","timestamp":1511721045000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.hindawi.com\/journals\/sp\/2017\/7392349\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2017]]},"references-count":21,"alternative-id":["7392349","7392349"],"URL":"https:\/\/doi.org\/10.1155\/2017\/7392349","relation":{},"ISSN":["1058-9244","1875-919X"],"issn-type":[{"type":"print","value":"1058-9244"},{"type":"electronic","value":"1875-919X"}],"subject":[],"published":{"date-parts":[[2017]]}}}