The Evolution of the Data Warehouse Systems in Recent Years

• Authors: Jacek Maślankowski
• Languages of publication: EN

Abstracts

EN

The article shows the key issues of the data warehouse evolution in recent years. It is divided into six general parts – in the first part a theoretical back-ground was presented to classify the most common used definitions of the data warehouse. In the second and third part the key issues of the data warehouse evolution were presented, such as treating unstructured data. The fourth part of the paper presents the analysis of the data warehouse attributes, whether they are still valid and useful. In the fifth part the paper solutions to mitigate data warehousing weaknesses were presented. Last part shows conclusions.

Keywords

EN

data warehouse; business intelligence; business informatics

• Publisher: Wydział Zarządzania - Uniwersytet Gdański
• Journal: Zarządzanie i Finanse
• Year: 2013
• Volume: 3
• Issue: 1
• Pages: 40-53

Contributors

author

Jacek Maślankowski

• Ph.D., Department of Business Informatics, Faculty of Management, University of Gdańsk, Poland,

References

• 1. Abramowicz W., Kalczyński P., Węcel K. (2002), Filtering the Web to Feed Data Warehouses, Springer-Verlag, p. 7-8.
• 2. Bach M., Werner A., Duszeńko A. (2012), Selecting database structure based on the analytical processing optimization criteria [in:] Studia Informatica, Vol. 333, No. 2A (105), Silesian University of Technology Press, p. 147.
• 3. Bateni M., Golab L., Hajiaghayi M., Karloff H. (2011), Scheduling to Minimize Staleness and Stretch in Real-Time Data Warehouses, [in:] Theory of Computing Systems, Vol. 49, Issue 4, November 2011, p. 757.
• 4. Chen L., Rahayu W., Taniar D. (2011), Towards Near Real-Time Data Warehousing, [in:] 24th IEEE AINA, p. 1150.
• 5. Golab L., Johnson T., Shkapenyuk V. (2012), Scalable Scheduling of Updates in Streaming Data Warehouses [in:] IEEE Transactions on Knowledge & Data Engineering, Jun2012, Vol. 24 Issue 6, p. 1092-1093.
• 6. Hobbs L. (2008), Oracle Database 10g Data Warehousing, Elsevier, p. 4.
• 7. Hughes R. (2008), Agile Data Warehousing. Delivering World-Class Business Intelligence Systems using Scrum an XP, Ceregenics, p. 1-3.
• 8. Humphries M., Hawkins M.W., Dy M.C. (1999), Data warehousing. Architecture and Implementation, Prentice Hall
• 9. Inmon W.H. (2005), Bulding the Data Warehouse, Fourth Edition, Wiley Publishing Inc., p. 25, 31-32, 144, 308-310, 429.
• 10. Inmon W., Strauss D., Neushloss G. (2008), DW 2.0. The Architecture for the Next Generation of Data Warehousing, Morgan Kaufmann, Burlington, p. 9-14.
• 11. Ishikawa H., Kubota K., Noguchi Y., Kato K., Ono M., Yoshizawa N., Kanaya, A. (1998), A document warehouse: a multimedia database approach, [in:] Database and Expert Systems Applications, 1998. Proceedings. Ninth International Workshop on Date of Conference: 25-28 Aug 1998, p. 90-91.
• 12. Januszewski A. (2008), Funkcjonalność informatycznych systemów zarządzania. Tom 2. Systemy Business Intelligence., Wydawnictwo Naukowe PWN SA, p. 21.
• 13. Khan A.H. (2003), Data warehousing 101. Concepts and implementation., iUniverse, p. 8.
• 14. Kimball R., Reeves L., Ross M., Thornthwaite W. (1998), The Data Warehouse Lifecycle Toolkit, Wiley Publishing, Inc.
• 15. Kimball R., Ross. M (2002), The Data Warehouse Lifecycle Toolkit. Second Edition. The Complete Guide to Dimensional Modeling., John Wiley and Sons, p. 7-8.
• 16. Malinowski E., Zimanyi E. (2009), Advanced Data Warehouse Design. From Conventional to Spatial and Temporal Applications, Springer-Verlag, p. 1-3.
• 17. Maślankowski J. (2008), Using data warehouse systems in Polish organizations (in Polish), [in:] Infobazy 2008. Systems, applications, services, p. 44-46.
• 18. Maślankowski J. (2013), Managing methodological changes in the data warehouses (in Polish), [in:] Yearbook of Economics Collegium Analysis 2013 (in printing)
• 19. Sandler D. (2010), Best Practices for Applying Agile Techniques to Data Warehouses, [in:] Business Intelligence Journal, Vol. 15 Issue 4, 2010, p. 20.
• 20. Sinn B. (2002), Enterprise Data Warehouse Is The Next Step In Data Warehousing, [in:] National Underwriter / Life & Health Financial Services; 11/11/2002, Vol. 106 Issue 45, p. 31-32.
• 21. Papastefanatos G., Vassiliadis P., Simitsis A., Vassiliou Y. (2008), Design Metrics for Data Warehouse Evolution, [in:] ER '08 Proceedings of the 27th International Conference on Conceptual Modeling, Springer Berlin Heidelberg, p. 444.
• 22. Polyzotis N., Skiadopoulos S., Vassiliadis P., Simitsis A., Frantzell N. (2008), Meshing Streaming Updates with Persistent Data in an Active Data Warehouse, [in:] IEEE Transactions on Knowledge & Data Engineering, Jul2008, Vol. 20 Issue 7, p. 976-977.
• 23. Ponniah P. (2001), Data Warehousing Fundamentals. A Comprehensive Guide for IT Professionals, John Wiley & Sons, Inc., p. 13.
• 24. Ponniah P. (2010), Data Warehousing Fundamentals for IT Professionals, John Wiley & Sons, Inc., p. 23-24.
• 25. Prabhu C.S.R. (2006), Data Warehousing. Concepts, Techniques, Products and Applications, Prentice Hall, p. 1.
• 26. Todman C. (2001), Designing a Data Warehouse: Supporting Customer Relationship Management, Prentice Hall, p. 32-33.
• 27. Tseng F.S. (2005), Design of a multi-dimensional query expression for document warehouses, [in:] Information Sciences, June 2005, Vol. 174 Issue 1/2, p. 55-56.
• 28. Westerman P. (2001), Data Warehousing. Using the Wal-Mart model., Academic Press, p. 4.