Data Warehouse Technology
A data warehouse, as its name suggests, is a computer-based storage system of data that can be drawn from, based upon the user's needs. "Data warehouses contain a wide variety of data that present a coherent picture of business conditions at a single point in time," (What is data warehousing, 2009, Webopedia). However, unlike a file cabinet in the 'real world,' data warehousing through computer technology provides a number of uniquely useful features for a user. Managers can extract different varieties of data from different operating systems and engage in multifaceted cross-comparison of the results. For example, a manager could examine sales data from a particular quarter, and compare that with advertising revenue or sales from previous years. This type of flexible access to the data enabled by the "combination of many different databases across an entire enterprise" enables more accurate and creative approaches to decision-making (What is data warehousing, 2009, Webopedia).
Privacy issues may arise in terms of obtaining the data -- customers may be directly solicited for feedback on their satisfaction with a product but data might also be kept was not directly and knowingly given to the company by the purchaser. Additionally, there are concerns about selling such technology to third parties, and as a result more companies are promising to keep such information confidential. Oracle and MSQL are two of the most notable vendors of data warehouse technology, and have vastly improved the size and also the variety and 'scalability' of available data. Effective data warehouses have data mining models that enable "clustering, associations, classification, and prediction" of available data yet also allow for the collection of unstructured data, so new models can be created that are suitable to changing situations (InfoSphere Warehouse, 2009, IBM). A good data warehouse enables the user to "exact structured information out of previously untapped business text" (InfoSphere Warehouse, 2009, IBM). The business value is immense," of an effective data warehouse, and should enable "fraud detection, product defect analysis, better customer profiling, and early warning on customer attrition" (InfoSphere Warehouse, 2009, IBM).
Works Cited
InfoSphere Warehouse. (2009). IBM. Retrieved August 16, 2009 at http://www-01.ibm.com/software/data/infosphere/warehouse/features.html?S_CMP=rnav
What is data warehousing? (2009). Webopedia. Retrieved August 16, 2009 at http://www.webopedia.com/TERM/D/data_warehouse.html
Data Warehousing Data Warehouse technology has changed the way that global organizations conduct business. Many have found it impossible to create a business strategy without a data warehouse. The purpose of this discussion is to research and explain the importance of data warehouse management. We will begin by defining data warehouse and describing the business uses for the technology. Our discussion will then focus of data warehouse management. We will examine the
However, many, if not most data warehouses have yet to deal effectively with this very real problem. Additionally, in the near future new parallel database servers are likely to improve the power of data warehousing exponentially. Not only will these servers allow the user to access immense pools of data, but they will also allow them to do so in a fraction of the time (ICFAI, 2004). Finally, it is also very
This form of technology serves to not only eliminate unneeded expenses, as it does the work that previously required numerous employees and technology formats, at a relatively low costs, it tracks and ships merchandise quicker and more accurately. Whereas in the past the function of product tracking and inventory maintenance involved a complex system of labels, bar codes and inkjet stenciling, according to Carver, "With RFID you have the
Data Warehouse and Business Intelligence In order to write a paper on the similarities and contrast between data warehouse and business intelligence, we need to first define each term before finding the similarities and contrasts between the two. Data Warehouses Data warehouse are used for storing data for archival, analysis, and security purposes. The warehouses themselves are made up of one or many computers (i.e. servers) that are connected together into one giant
Data Mining in Health Care Data mining has been used both intensively and extensively in many organizations.in the healthcare industry data mining is increasingly becoming popular if not essential. Data mining applications are beneficial to all parties that are involved in the healthcare industry including care providers, HealthCare organizations, patients, insurers and researchers (Kirby, Flick,.&Kerstingt, 2010). Benefits of using data mining in health care Care providers can make use of data analysis in
Data Warehousing and Data Mining Executive Overview Analytics, Business Intelligence (BI) and the exponential increase of insight and decision making accuracy and quality in many enterprises today can be directly attributed to the successful implementation of Enterprise Data Warehouse (EDW) and data mining systems. The examples of how Continental Airlines (Watson, Wixom, Hoffer, 2006) and Toyota (Dyer, Nobeoka, 2000) continue to use advanced EDW and data mining systems and processes to streamline
Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.
Get Started Now