Preview

A Data Warehouse Appliance Can Have a Huge Positive Impact on Businesses and Organizations

Best Essays
Open Document
Open Document
4105 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
A Data Warehouse Appliance Can Have a Huge Positive Impact on Businesses and Organizations
Abstract

Businesses and organizations of all sizes are becoming increasingly dependent on data analytics, and data warehouses or business analytic infrastructure has become a business critical application for many (if not most) companies. Indeed, these companies have always searched for better ways to understand their customers, and anticipate their needs. They have longed to improve the speed and accuracy of operational decision-making. Equally important as timeliness is the depth of the data analysis. Generally, the companies want to decipher all secrets hidden within the massive amounts of ever-increasing data. A data warehouse appliance, which is an integrated collection of hardware and software designed for a specific purpose typically involving the high throughput of data and analytic functions, can be used by organizations to optimize various areas of data processing. Its main intent is to supplant conventional business intelligence functions, such as warehousing, extract-transform-load (ETL), analysis and reporting. Due to its cost-effectiveness and efficiency, the data warehouse appliance has become an important segment of the data warehousing market. In this paper, I will examine the data warehouse appliances and describe its positive impact on business enterprises.

Introduction

Since introduced in the early 1990s, data warehouse (DW) has proven to be the key platform for strategic and tactical decision support systems in the competitive business environment today. It has become a major technology for building data management infrastructure, and resulted in many benefits for various organizations, including providing “a single version of the truth, better data analysis and time savings for users, reductions in head count, facilitation of the development of new applications, better data, and support for customer-focused business strategies” (Rahman, 2007). The technology has become extremely important in an environment where increasing



References: O 'Brien, J. A. & Marakas, G. M. (1999). Management Information Systems (9th edition). 190- 193. New York, NY: McGraw-Hill/Irwin. Kaula, R. (2009). Business Rules for Data Warehouse. International Journal of Information Technology. Retrieved March 22, 2011, from Business Source Complete. McKnight, W. (2005). Introducing the Data Warehouse Appliance. DM Review. 15(3), 16-16. Retrieved March 22, 2011, from Business Source Complete. Hong, S., Katerattanakul, P., Hong, S. & Cao, Q. (2006). USAGE AND PERCEIVED IMPACT OF DATA WAREHOUSES: A STUDY IN KOREAN FINANCIAL COMPANIES. International Journal of Information Technology & Decision Making. 5(2), 297-315. Retrieved March 22, 2011, from ABI/Inform Complete. Hinshaw, F. (2004). Data Warhouse Appliances: Driving the Business Intelligence Revolution. DM Review. Retrieved March 22, 2011, from Business Source Complete. Ramamurthy, K., Sen, A. & Sinha, A. P. (2008). An empirical investigation of the key determinants of data warehouse adoption. Decision Support Systems. 44(4), 817-841. Retrieved March 22, 2011, from ScienceDirect. Watson, H. J. & Wixom, B. H. (2007). The current state of Business Intelligence. IT Systems Perspective. 96-99. Retrieved April 23, 2011, from http://www.teradata.com/library/pdf/IEEEComputerWatsonWixom.pdf Wikipedia. (2011). Data warehouse appliance. Wikimedia Foundation Inc. Retrieved April 24, 2011, from http://en.wikipedia.org/wiki/Data_warehouse_appliance#Benefits Briggs, L. L. & Eve, R. (2010). Q&A: Pair Appliances and Virtualization to Beef Up Performance. TDWI.org. Retrieved April 24, 2011, from http://tdwi.org/Articles/2010/08/25/Appliances-and-Virtualization.aspx?Page=2

You May Also Find These Documents Helpful

  • Powerful Essays

    Ibm 211 Week 3

    • 4383 Words
    • 18 Pages

    IBM® Telecommunications Data Warehouse V8.4 delivers the following capabilities to communication providers: • • • Common customer view: Helps integrate customer identifiers, organizational structures, and account hierarchies across lines of business and functions. Product life cycle management: Helps integrate product management and performance measurement across lines of business and functions. Campaign performance management: Helps improve program planning, tracking of sales and marketing activities, and performance metrics across channels and touch points. Service management: Helps analyze usage, availability, and customer experience of new services, self-service, and new monetary services.…

    • 4383 Words
    • 18 Pages
    Powerful Essays
  • Satisfactory Essays

    This document is a proposal for building a data warehouse architecture that will consolidate and transform data into useful information for the purpose of decision-making and for establishing a new function that offers a broad array of decision support services to all units at ABC Retail Chain Corporation. Executives and decision-makers often need information to analyze the past, describe current circumstances, and anticipate the future. Presently, decision-makers across the Institute rely on hard copy reports or Excel Sheets to provide information. Typically, any request for information is forwarded to the operational areas of the Organization, which provide hard copy reports reflecting the data gathered in their functional area. To analyze and transform data into useful information, decision-makers and their staff have to manually re-enter the non-integrated data into their own mini-systems. This type of operation hinders the ability of decision making and the executives are either drowning in too much data with no option to analyze it or too little data, which means they are back to square one and must request additional information. Often executives receive multiple, conflicting information or information that is based on incomplete assumptions about the types of analysis required.…

    • 641 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    The most important aspect of having data warehousing is the fact that it allows for data storage and presentation of this data enabling executives to make sound decisions. Another important use of data warehousing is it takes the separate areas the company is divided up in and takes it all and lumps it in to one single entity. One great benefit of data warehousing is that Huffman will be able to handle server task connected to all queries which is not commonly found in all systems. “Another powerful benefit of data warehouses is that they allow companies to use data modeling for querying tasks that are quite difficult for transaction processing” (Exforsys, 2007). Huffman trucking is already successful but by implementing a success data warehousing system they would be able to understand and analyze all data coming in and leaving the system better and at a more efficient rate. Attached to this report is a…

    • 891 Words
    • 3 Pages
    Good Essays
  • Good Essays

    If I were to design Ben & Jerry's data warehouse I would use several dimensions of information. The first dimension would consist of the company's products; ice cream, frozen yogurt or merchandise. The marketing department has to know which products are selling, if Ben & Jerry's didn't know that their T-shirts are selling out as soon as they hit the stores, then they wouldn't be able to take advantage of the opportunity to sell the shirts. The second dimension would consist of the different areas of sales; US, Canada, Mexico, or Europe. I am not sure if they sell their ice cream in Mexico, but with data collection they can find out if their ice cream would be a better seller in the hot climate, rather than pushing for greater distribution in Canada. The third dimension would consist of the "specifics"; where the sale was made, when the sale was made, and who purchased the product. This information can help in the design of the product to focus on the buyer; it can tailor flavors to seasons, and packaging to buyer who looks for the better-looking product. If Ben & Jerry's could know when a season was coming to an end in a specific area, then they could forecast the need or the decline in need and speed up, or slow down distribution to those areas. The focus of the information is that it needs to be useful, and almost any information is useful.…

    • 605 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Many companies are successful in understanding how to meet customer expectations, gain new customers and increase productivity and efficiency by using business intelligence and data analytics. The tools and techniques used by business intelligence give real time insight so that companies can identify opportunities, risks and track trends quickly. Collecting data alone is useless until it is analyzed. This is where data analytics come in. Data analytics is the process of obtaining and evaluating data using specialized software with the purpose of extracting useful information. (4) Data analytics is used in many industries to allow companies and organizations to make better business decisions quickly. The speed at which data is collected, organized and evaluated is critical given the speed at which technology continues to change. I believe more and more companies are utilizing data analytics so they can gain advantages over their competitors. Technology is obtaining more data than in the past so companies are seeking better ways to receive value from that data. The term business…

    • 1233 Words
    • 4 Pages
    Powerful Essays
  • Satisfactory Essays

    Fac Case Study

    • 650 Words
    • 3 Pages

    FAC’s data warehouse platform was the NCR 5150M. It run the Teradata Relational Data Base System with 5 SMP nodes. This platform provided 1.5TB of data storage to FAC. Data from many sources like VSAM, IMS which stored in this storage could be accessed by dependent data mart created in an Oracle relational DBMS and Cognos cubes. The analysts in the company can analyze the profitability with tools called PAR which can be run by ad-hoc SQL queries and predefined reports. These kinds of analyzed data could be the information to decision makers by using VIEW in DBMS or many other…

    • 650 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    A data warehouse is a database that stores current and historical data of potential interest to decision makers throughout the company. [1] After the events of September 11, 2001, the US Government determined the need for a comprehensive single source to identify and deter all persons either suspected to engage in terrorist activities against the US. Thus, the Terrorist Watch List and Database were created, bringing together all the information from various government agencies who had previously been maintaining separate lists of persons, into the Watch List in a standard format and available to all. This database is an example of data warehousing.…

    • 1645 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    ch03 c

    • 1817 Words
    • 8 Pages

    11. Data warehouses integrate data from multiple databases and data silos and organize them for complex analysis, knowledge discovery, and to support decision making.…

    • 1817 Words
    • 8 Pages
    Powerful Essays
  • Good Essays

    A data warehouse is a database that stores current and historical data of potential interest to decision makers throughout the company.[1] In the Terrorist Watch List Database case, the information about suspected terrorists are consolidated and standardized from multiple government agencies so that the information can be centralized into a single list, from which different agencies can communicate and share information with each other. This centralized database is a specific example of data warehouse. In this case, the data warehouse containing the relevant information of individuals from each agency’s list enhancing effectiveness of communication between agencies as well as increase the consistency of information from separate databases.…

    • 860 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Relational Databases

    • 750 Words
    • 3 Pages

    References: O 'Brien, J. A., & Marakas, G. M. (2011). Management information systems. (10th ed.). New York, NY:…

    • 750 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    1. Data warehouses store current as well as historical data and are used for creating trending reports for senior management reporting such as annual and quarterly comparisons. REI is building a data warehouse because they want to better serve their customers with their products. The data ware house allows REI to make the customers experience with their company a much more fulfilling one ensuring their return.…

    • 310 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    As we discuss the possibility of emerging into business intelligence software we must keep in mind the overall purpose of using any type of software is to reach strategic goals in order to increase market shares. I will discuss how business intelligence software will allow us to meet those strategic goals. We will establish what type of information and analysis capabilities will be available once this business intelligence software is implemented. We will discuss hardware and system software that will be required to run specific business intelligence software. Lastly, I will give a brief synopsis on three vendors (IBM, Microsoft Microsoft and Oracle) that are dominating the business information software industry today.…

    • 1173 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Bi Canadian Tire

    • 345 Words
    • 2 Pages

    The IT group at Canadian Tire Corporation (CTC), located at the headquarters of a network of five major business groups, is faced with developing an implementation plan for the development of a business intelligence (BI) infrastructure and business capability at Canadian Tire Retail (CTR). Concurrent to this initiative is the development and implementation of an IT strategy for CTC that places a number of programs on the priority list, with BI seen as a high priority item for which the organization can score some “quick win” business success.…

    • 345 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Sap Bw Parallel Data Load

    • 550 Words
    • 3 Pages

    activities in a way that fits your needs best. This could mean that you would like to have…

    • 550 Words
    • 3 Pages
    Good Essays
  • Best Essays

    Data Warehousing and Olap

    • 2507 Words
    • 11 Pages

    In the 1990s, as businesses grew more complex, corporation spread globally, and competition became fiercer, business executives became desperate for information to stay competitive and improve the bottom line. Data warehousing technologies have been successfully deployed in many industries: manufacturing (for order shipment and customer support), retail (for user profiling and inventory management), financial services (for claims analysis, risk analysis, credit card analysis, and fraud detection), transportation (for fleet management), telecommunications (for call analysis and fraud detection), utilities (for power usage analysis), and healthcare (for outcomes analysis). This paper presents a roadmap of data warehousing technologies, focusing on the special requirements that data warehouses place on database management systems (DBMSs).…

    • 2507 Words
    • 11 Pages
    Best Essays