Data Model and Data Warehouse Design Architecture & XML Essay

Data Model and Data W atomic number 18house Design Architecture & XML - Essay useFor the purpose of this scenario, the information sources are represented by these operational database systems which are actually relational databases, and are required to be integrated in the data storage warehouse. Every clinic has also a manager and a number of staff, such as, cleaners, nurses, and etc.Since, data warehouses are capable of handling server tasks connected to querying, therefore, the proposed execution of data warehouse would support the companys transactions systems to complete transactions within a desirable time frame by running the reports and queries on a server.Allow the users (company staff) to obtain reports and find queries efficiently as data warehouse gives the user control over the response time by storing the older data and the recent data in well-organized manner.Despite the fact that the company jackpot make whoopie many benefits from implementing the proposed impl ementation, there are some major drawbacks as well which are highlighted in some other article at Exforsys (The disadvantages of a data warehouse, n.d.)Since, data warehouse contains historical data about a companys transactions, the value of this information might be limited because the businesses operating in right aways market are in constant transition, and therefore, it may not be always righteous to use a historical data.The process of extracting, transforming, and loading data from the source systems in real-time can be one of the most challenging tasks for any data warehouse. The ETL process normally requires downtime of the data warehouse, and therefore, it is usually carried out late at night to avoid any inconvenience because users cannot access data warehouse during the process. However, there cant be any system downtime when the data is being loaded endlessly in real-time. Unfortunately, most of the traditional ETL tools and systems are incapable of supporting cont inuous updates in the data warehouse without