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 computer (network system).
The data warehouse is more than a 'storing house' or archival system. It also serves as a place for categorizing and 'tidying' the data, thereby making it easy and convenient for the user to get hold of in his day-to-day business. This is essential for the business for in order to make effective decisions it needs to be able to access the right data in a speedy manner. Doing so helps the organization in its decision support system (DSS) which refers to the facts, trends, or other patterns that are needed for the organization to make relevant decisions. In fact, the entire data warehouse discipline was created in the late 1980s (by two IBM researchers Barry Devlin and Paul Murphy) due to the fact that organizations were hunkering under the redundancy of information that they were accumulating and burying their heads in as well as the consequent challenge of forming effective decisions. The problem was exaggerated for large organizations or for those that were linked to others. Many times, businesses lost huge amounts of money in their efforts to accumulate and retrieve the necessary information. The process of gathering, sorting through, revamping, and integrating data was time-consuming and costly, aside from which the data had to be constantly checked, corrected and modified (Inmon, 2005). Data warehouses came about as a result.
Data warehouses come in four different categories. These are:
1. Offline Operational Data Warehouses where data from an online system is copied and pasted into an offline system to be used at the user's convenience.
2. Offline Data Warehouses which is also an offline system that stores data for users to share. Data on this system is updated frequently on a daily, weekly, or monthly basis.
3. Real Time Data Warehouse is a virtual base where data is updated continuously as each new influx of data is fed into it.
4. Integrated Data Warehouses are...
Business Intelligence Creating, Implementing and Using Business Intelligence in Clinic and Resort Cases In the process of effective decision making for improving opportunities and performance of a business, a vital role is played by Business Intelligence (BI). Business Intelligence Systems understand the environments of organizations and follow a systematic information process. These systems have huge development costs but are widely created, implemented and used in mid-sized organizations, hospitals, resorts and hotels. The
Data Warehousing: A Strategic Weapon of an Organization. Within Chapter One, an introduction to the study will be provided. Initially, the overall aims of the research proposal will be discussed. This will be followed by a presentation of the overall objectives of the study will be delineated. After this, the significance of the research will be discussed, including a justification and rationale for the investigation. The aims of the study are to
From Supply Chain Efficiency to Customer Segmentation Focus Because of this focus on supply chain forecasting accuracy and efficiency, the need for capturing very specific customer data becomes critical. The case study portrays the capturing of segmentation data as focused on growing each of the brands mentioned that VF relies on this data to base marketing, location development and store introductions, and pricing strategies on. In reality, the data delivered for
2003, pg. 3191). While the human analysis component of this definition is important, very little research has looked at it in any level of detail. Combining the various BI definitions we will use the following definition for BI in this research: Business Intelligence consists of the use of analytical technologies and data stores by people in an organization to analyze business problems and produce related business recommendations to improve
Growth Aided by Data Warehousing Adaptability of data warehousing to changes Using existing data effectively can lead to growth Uses of data warehouses for Public Service Getting investment through data warehouse Using Data Warehouse for Business Information Ongoing changes in Data Warehousing The Origin of Data Warehousing and its current importance Relationship between new operating system and data warehousing Developing Organizations through Data Warehousing Telephone and Data Warehousing Choose your own partner Data Warehousing for Societal Causes Updating inaccessible data Data warehousing for investors Usefulness
The use of databases as the system of record is a common step across all data mining definitions and is critically important in creating a standardized set of query commands and data models for use. To the extent a system of record in a data mining application is stable and scalable is the extent to which a data mining application will be able to deliver the critical relationship data,
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