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

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

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

    • 2077 Words
    • 9 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
  • 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

    Upara Mane Sparknotes

    • 255 Words
    • 2 Pages

    In his foreword to Upara, Mane recalls that while writing the book, he had re-lived the tortures he had seen and suffered in the past and that his intention in writing the book was to acquaint society of the sufferings of homeless people and thus motivate them to do something substantial and constructive in the struggle of human liberation. Mane’s message through his autobiography is apparent. It is a plea for liberation from the shackles of the caste system which holds certain communities in bondage and servitude, bringing them nothing but negation, rejection, and denial wherever they turn to. The text delineates the protagonist/author’s incessant efforts to rise upwards in society.…

    • 255 Words
    • 2 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
  • 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
  • Good Essays

    Case Study

    • 487 Words
    • 2 Pages

    a data warehouse or enterprise data warehouse (DW, DWH, or EDW) is adatabase used for reporting and data analysis. It is a central repository of data which is created by integrating data from one or more disparate sources. 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.…

    • 487 Words
    • 2 Pages
    Good 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

    A data warehouse is a “subject-oriented, integrated, time varying, non-volatile collection of data that is used primarily in organizational…

    • 2507 Words
    • 11 Pages
    Best Essays