Database and Data Warehousing Design Assignment

Database and Data Warehousing Design - Assignment Example The functional systems, for example marketing, Enterprise Resource Planning (ERP) and so on, supply data the warehouse and making use of Extract, Transform and Load (ETL) approach the data is retrieved from the data warehouse (Rizzi, Abello, Lectenborger and Trujilo, 2006). Since the firm under discussion is concerned with a large volume of data to be considered for evaluation, for that reason, the data warehouse is suggested for execution by the company. The data warehouse would bring about the company not just in its business, but in addition delivers many different added benefits to the company. A few of the factors that motivate the execution of the data warehouse in the firm involve: the data warehouse in a position to cope with massive data, it generates reports instantly, accordingly. Saves time, it offers premium quality data and presents increased business intelligence. Nevertheless, the benefits are invariably linked to down sides, the risks of the data warehouse embody: investing time in extracting, clearing and uploading data, developing high upkeep system, and resource optimization. Keeping in mind the drawbacks of the data warehouse, there are particular rules and best procedures which the business has to stick to these while employing the data warehouse. Some of the most effective tactics that the organization ought to comply with incorporate: investing proper time in accumulating needs and style, building prototypes, correct usage of the centralized and in depth data, building data credibility checks and supply of correct training to the clients. Since the database of the firm is substantial, for that reason, the company must not deem building the relational data warehouse. On the other hand, the company is suggested to make use of the index partitioning and tables. It is advisable that the organization must comply with these best procedures to put into practice