StudentShare solutions
Triangle menu

Data Warehousing - Essay Example

Not dowloaded yet

Extract of sample
Data Warehousing

It focuses on how well the data is stored for better analysis and reporting of information by the analysts. There are tools that are used to move the data into the storage area and the intelligence tools ensure there is efficiency in delivery of services to the customers. The high changing technology is important for an organization since it integrates data for easier analysis and data reporting. It also assists organizations to get more information about the business, assists companies to meet the business requirements, demands of the customer and eventually helps a company to be at a competitive advantage over their competitors ( SCN Education BV 2001).
Most organizations gather their data from various sources such as; inventory management, online and sales services as the data has to go through the data Life cycle management so that it can be useful to the organization. The tools that are used in gathering the summarized data from various sources into the data warehouse are online analytical processing systems and the query tools. The tools are used in supporting adhoc analysis, inquiring and reporting of the data to the end-users without asking for assistance from the programmers while undertaking the required tasks in the appropriate manner (Witten & Frank 2000).
Data warehousing is easy to maintain and fast in generating reports. ...
avoid such delays then organizations would rather use a server that takes acceptable time which is cheaper and uses separate servers and therefore a data warehouse becomes an important tool that would be used to solve such a problem. In business models it can be used to speed up the querying and reporting processes that are appropriate for the transaction process. For example the Star Scheme model is not very appropriate for the transaction process as it normally slows down the process. Another example is the bit-Mapped index model that may speed up the process of transaction but slows down the reporting and querying process therefore a data warehouse becomes appropriate because it doesn't not interfere with the process in any way. For organizations 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 warehousing
Data 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 obsolete .A company structure could also be continuously changing such that the data in the organizations database may not be useful and therefore the top management may loose interest in analyzing such data (McDonald et al. 2002).
It could also be a very complicated process to a business because most organizations tend to institutionalize reports that are generated from these databases. If an organization does not have ...Show more

Summary

In the world today, many organizations are implementing advanced technologies that are aimed at improving the performance of the organizations. The importance of the technologies is to ensure that an organization achieves it goals and objectives within the stipulated period of time and in the appropriate manner…
Author : tnitzsche
Data Warehousing essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the essay on your topic
"Data Warehousing"
with a personal 20% discount.
Grab the best paper

Related Essays

Data Warehousing and Mining
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, statistics and pattern recognition to explore large databases automatically (Frand, 1998) and (Anissimov, 2011).
18 pages (4500 words) Essay
Case Studies of Data Warehousing Failures
There is several scope of what can be considered as data warehousing failures. Some of them are over budget, extended deadline (unreasonable deadline for project) or pushing back the milestone dates, management support (lack of formal commitment from
5 pages (1250 words) Essay
Impact of Data Warehousing and OLAP Models on Management Accounting
In this study, we are interested with the impact of the OLAP in the decision making of the business.  I am contacting your office to set up a mutually convenient time for this informational meeting.
160 pages (40000 words) Essay
Data warehousing and storage systems
The application and benefits of Data warehousing and storage system is further illustrated in the discussion. The types of Data warehousing are Online Analytical Processing, Data Mart, Predictive Analysis and Online Transaction
2 pages (500 words) Essay
W2 Asign Determining Requirement in Data Warehousing
Therefore, the types of possible information delivery methods are as follows: online, intranet, internet, and email (Ponniah, 2010). For power users, for instance, these users “want to be able to navigate throughout the
2 pages (500 words) Essay
W5 asig ETL and Data Warehousing
s and was noted to be “one of the largest scheduled air freight carriers in the world, providing a wide range of freight and mail services onboard Americans passenger fleet” (American Airlines, n.d., p. 1). The company’s data warehouse requirements are being served by
2 pages (500 words) Essay
W6 Asig HMO Information Delivery Framework and Data Warehousing
There are varied information delivery tools depending on the users. From the illustration, the information delivery tools range from knowledge discovery, ad hoc query, DSS applications, as well as managed query (Ponniah, 2010).
2 pages (500 words) Essay
W7A Back-up and Recovery Plan in Data Warehousing
(2) the establishment of specific schedules of backing up static data and active data; (3) more frequent back-up schedules for active data in conjunction with less frequent back-up schedules for static data; (4) a back-up scheme which incorporates differential backups and log
2 pages (500 words) Essay
W7D Review Data Warehousing
These techniques and skills learned in the process could also be applied in other endeavors: research, applications for employment, and other information-gathering activities. The lesson that seems hardest to
1 pages (250 words) Essay
Master data and data warehousing and business intelligence management
setting requires precise information, because a minor element may have critical outcomes, and probably a permanent casualty in terms of patient death. Reference data requirement is a sophisticated function, because it requires understanding the needs across an enterprise,
6 pages (1500 words) Essay
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT
Comments (0)
Rate this paper:
Thank you! Your comment has been sent and will be posted after moderation