Nobody downloaded yet

Database and Data Warehousing Design - Assignment Example

Comments (0) Cite this document
The data warehouse is recognized to assist in incorporating data acquired from a number of data means and yields a primary main repository of…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER92.2% of users find it useful
Database and Data Warehousing Design
Read TextPreview

Extract of sample "Database and Data Warehousing Design"

Download file to see previous pages 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 ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
(“Database and Data Warehousing Design Assignment”, n.d.)
Retrieved from
(Database and Data Warehousing Design Assignment)
“Database and Data Warehousing Design Assignment”, n.d.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Database and Data Warehousing Design

Data Warehousing and data mining

...warehouse. In simplest terms, a data warehouse is a set of multiple applications, concepts, methodologies, tool and techniques to gain some knowledge based on historical data that may come from multiple systems and sources to assist managers in decision-making process. Vercellis (2009) defines “A data warehouse is the foremost repository for the data available for developing business intelligence architectures and decision support systems.” However, it is not a comprehensive definition and Vercellis (2009) himself admits, “The term data warehousing indicates the whole set of interrelated activities involved in designing,...
10 Pages(2500 words)Research Paper

Smart Database Design to Avoid Fault Data

...Every organization deals with information regarding products, people including employees, s, prospective benefactor(s), who (might)protract organization’s functions and services. Therefore, the crucial information needs to be accurate and stored correctly in reliable storages/databases for its enduring usage. This paper reveales the diverse ways of entering data into databases along with reasons of entered and stored poor quality data in databases and its impacts on the organizations. One of the reasons is improper database design, therefore in order to avoid poor quality data in...
9 Pages(2250 words)Research Paper

Data Warehousing and Mining

...? Data Warehousing and Mining By Table of Contents INTRODUCTION Data mining refers to the method of examining data from diverse viewpoints and transforming it into valuable information (information that can be used to raise income, reduce expenditures, or both). Additionally, data mining is also known as data or knowledge discovery. In addition, data mining uses a comparatively high computing power working on a massive collection of data to find out relationships and regularities between data points. Moreover, data mining uses a lot of techniques from machine learning,...
18 Pages(4500 words)Essay

Data Management: Data Warehousing and Data Mining

...-based environment. Decision making becomes faster and more accurate, and IT is freed up for projects that add greater value to the company. It gives the freedom to access the large amount data of various integrated Databases. It's more efficient, fast and saves queries over various SAP or non SAP databases. The implementation of SAP businessObjects is easy as it is web based. The main purpose of BusinessObects is the use of business intelligence products. Its tools provide performance management and query and analysis of the provided information. This addresses various business issues some of them are: Speedy generation of reports Data Duplication Self-service reporting...
2 Pages(500 words)Research Paper

Data Warehousing & Data Mining

...?Data Warehousing & Data Mining a. Why are organizations moving toward implementation of data warehouses? What are the benefits of data warehouses? Data warehousing and data mining are critical aspect of modern healthcare practices. Data mining (DM) is a process that aims to use existing data to uncover new relationships unknown thorough common analysis practices. The process is similar to the extraction of valuable metal hence the term “mining” (Jackson, 2003). Data mining is the process of analyzing extensive data with the aim of...
3 Pages(750 words)Assignment

Data Warehousing and Data Mining

...issues. The objective is to deploy the highest acceptable level of normalization. If we compare three of these NF’s, the 1NF removes replication in groups. The 2NF reduces data replication or redundancy and the 3NF reduces columns from the tables that are not reliant on primary keys. Therefore, database design must demonstrate the highest level of normalization possible, in order to make database efficient and robust. In order to maintain 3 large databases for a VLDB and to keep them efficient for two years if required, there is a requirement for constructing a ‘store and forward’ mechanism that will process the data or information from...
6 Pages(1500 words)Essay

Data Warehousing

...that need to manage and transact large volumes of data it is appropriate to use this database as it helps in capturing data from different multiple and external sources (McDonald et al. 2002). Challenges of warehousingData warehousing is important to any business organization but it faces challenges which every organization should be made aware of. Data warehouses store very old and historical information that may not be very useful to the organization in the current business environment. The high technological changes and a very high competitive world are some of the things that could render such data...
10 Pages(2500 words)Essay

Data Warehousing in Healthcare

...of information to allow for research and reorganization refers to data warehousing. The concept is as old as the ancient libraries. However, the tools for data storage are no longer large tomes of papyrus and paper, but IT based databases. Manufacturers of the Technology The setting up of data warehouses is not a preserve of any specific company. In fact, data warehouses have components made by different manufacturers. A consultant, usually a systems engineer, designs, and sets up a data warehouse for different clients based on their needs[Hya07]. In this sense, a data warehouse is not...
5 Pages(1250 words)Article

Data Warehousing

...Data Warehousing Introduction Data warehouse can be d as a database system through which several data can be analyzed and evaluated at a time. The concept of data warehouse has been introduced to extract, filter, classify and cluster data.. The actual purpose of developing data warehouse is to perform data analysis quickly and efficiently. In modern era, unprecedented advancement can be observed in the field of science and technology. Thus, in the current era people can be identified to have little time engaging in data processing unlike in the past decades. Notably,...
7 Pages(1750 words)Research Paper

W7D Review Data Warehousing

...Review Data Warehousing al Affiliation Review Data Warehousing What is the most practical and easily applied lesson on Datawarehouse? From among the lessons learned on data warehousing, the most practical and easily applied is the module on defining business requirements. Practitioners could easily understand concepts on requirements gathering methods (Chapter 5), including the types of questions to be used as well as the other techniques that were discussed (Ponniah, 2010). These techniques and skills learned in the process could also be applied in other endeavors: research, applications for employment, and other information-gathering...
1 Pages(250 words)Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Assignment on topic Database and Data Warehousing Design for FREE!

Contact Us