Preview

Data Ware House Technology

Good Essays
Open Document
Open Document
826 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Data Ware House Technology
Bashkor Biswas
TU

Data Ware House

Data is the raw materials of any information system. With the revolution of Information Technology we are improving our decision making process more quick and smart. Data warehouse technology is the process of collection, sorting, structural formation, analysis, storing and presentation of data. So we say that data warehouse is the technology is overall data management system in the organization.
In today’s business world we are facing huge competition. To secure enough profit we have no other way but to make most accurate decision quickly. We take decision on the basis of information WE HAVE. So to take accurate decision accurately it is a pre requisite to have a smart system which can – * collect sufficient relevant information * store and deliver data quickly * analysis & present data accurately

To solve the business need of those data management requirements a technology evolve which is known as data warehousing.

How does it works?
Data ware house technology has a system of extract data from operational system, these data then stored on historical snapshot basis. Data warehouse technology then classified those data into some cluster. Those data then puts in several copies with back up. Those data from various point then kept together to deliver quickly for the right & relevant user. Stored data in data ware house are periodically refreshed with continuous data from the operational data base.

Vendors:
The current data ware house leaders by revenue are IBM, INTEL. ORCLE, MICROSOFT , NETEZZA, TERRDATE. All those mega vendor are facing competition with other mega vendors. There are so many establish vendors like this mega vendors are also emerging. So we should realize that with the increasing demand new and existing vendors are increasing their capabilities of service.

Vendor | Big Data Revenue (in $US millions) | Total Revenue (in $US millions) | Big Data Revenue as Percentage of

You May Also Find These Documents Helpful

  • 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
  • Satisfactory Essays

    The data is transmitted to a central computer and stored for retrieval. Data is also organized in such a way that it can be tracked by the customer.…

    • 458 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Datawearhousing

    • 1743 Words
    • 7 Pages

    functionality is that a registered user can rate restaurants. E.g., look at the \Add a Review…

    • 1743 Words
    • 7 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

    Bis Midterm Sheet

    • 1467 Words
    • 6 Pages

    A data warehouse is to extract and clean data from operational systems and other sources to store and catalog that data for processing by BI tools. Data warehouses can include external data purchased from outside sources. Meta data is kept in the data warehouse. Physically, a data warehouse consists of a few fast computers with very large storage devices.…

    • 1467 Words
    • 6 Pages
    Good Essays
  • Good Essays

    | * The data warehouse of St George bank supports the integrated data among different departments * Data from different departments can be accessed freely * Integrated data from the data warehouse is more beneficial and creates more opportunities and BI for all departments (1+1=3) * “Most departments extract what they need from the warehouse using customer relationship management and BI applications without intervention.” * “They have access to all the data, can create their own filters, their own campaigns.”…

    • 341 Words
    • 1 Page
    Good Essays
  • Satisfactory Essays

    REI - CAHPTER 4, CASE 2

    • 2464 Words
    • 9 Pages

    A data warehouse is a database used for reporting and data analysis. REI is building a data warehouse so that they will precisely know what the customer uses indoors and outdoors.…

    • 2464 Words
    • 9 Pages
    Satisfactory Essays
  • Powerful Essays

    related to the use of various information technologies that gather and store data and perform…

    • 2077 Words
    • 9 Pages
    Powerful Essays
  • Powerful Essays

    The Voip Adoption

    • 1699 Words
    • 7 Pages

    development that occurs? In order for real time data warehousing to work many elements are required. These include the mainframe reservation system, satellite feeds from airplanes, central customer database and all other data sources such as their website, customer service applications, frequent flyer programs and reservation systems. Each of these works together and for every change that is made it is sent back to the data warehouse and displayed or is available to all customers within minutes (Brown, DeHayes, Hoffer, Martin, and Perkins, 2003).…

    • 1699 Words
    • 7 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

    worker

    • 506 Words
    • 2 Pages

    There are many data management issues that need to be considered when dealing with new data, transferring data, or just storing data for long periods of time. For instance, if a corporation or business needs to store data for long periods of time, they may have to come up with multiple ways of storing the data in the event one device or method fails. Also, all things eventually wear out in time. Therefore, servers, hard drives, databases and any other technological data storing equipment or methods, must be constantly upgraded or maintained to prevent data rot and equipment failures.…

    • 506 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Case Study

    • 487 Words
    • 2 Pages

    The data stored in the warehouse are uploaded from the operational systems (such as marketing, sales etc., shown in the figure to the right). The data may pass through anoperational data store for additional operations before they are used in the DW for reporting.…

    • 487 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Data Warehousing

    • 331 Words
    • 2 Pages

    Bill Inmon advocates a top-down development approach that adapts traditional relational database tools to the development needs of an enterprise wide data warehouse. From this enterprise wide data store, individual departmental databases are developed to serve most decision support needs.…

    • 331 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    The following alphabetical list identifies the key terms discussed in this chapter. The page number for each key term is provided.…

    • 7131 Words
    • 29 Pages
    Powerful 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