Towards analternativeData Warehouses Architecture

Abstract

Data warehouses (DWs)are centralized data repositories that integrate data from various transactional, legacy, or external systems, applications, and sources. DW provides an environment separate from the operational systems and is completely designed for decision-support, analytical-reporting, ad-hoc queries, and data mining. Recently, the structure and the volume of data stored on computer systems are growing at an accelerated rate.In current DWs architectures based on n-ary-Relational DBMSs, DWs are increasing their data volume; high disk space consumption; slow query response time, and complex database administration are common problems in these environments. Furthermore, there are a number of factors making developing and maintaininga data warehouse system a painful process such as: setting up a data warehouse can takea long time, over-provisioningcan lead to high costs, organizations may lack the expertise needed to set up and maintain a data warehouse, and system crashes and downtime or system overload can have numerous consequences for an organization. Also, DWs depend on static number of external data sources that may be incomplete, do not use the same definitions, and not always available.The lack of a proper data model and an adequate architecture specifically targeted towards these environments are the root causes of these all problems. So, this paper try to explain why we need an alternative DWs architecture that takes all benefits of existing traditional DWs architecture and solving its problems, dealing with modern environment such as cloud computing, handling in efficient manner the next generation databases (NoSQL) mostly addressing some of the points, and dealing with web applications scalability (such as: big data)