Data Warehousing Essay

998 words - 4 pages

Businesses around the world are faced with many challenges when attempting to compete and gain a competitive advantage over their competition. The members of the management team within these businesses need to make quick and accurate decisions which will often impact the company and all of its employees, possibly for years to come. One of the worst situations for one of these decision makers to find themselves in is when they know that all of the information they need is available; but they are unable to retrieve that information in an accurate and useful way. In no field is this truer than in the manufacturing industry, where one bad decision could cost the company millions of dollars, especially in regards to the contract proposals and bidding process. One tool which can aid in this decision making process when the required information is spread out across the company, is called data warehousing.
A Data Warehouse is a separate database that is specifically designed for aiding the decision making process. This new database can carry out this function by being subject-oriented, integrated, time-variant, and non-updateable. (Menninger, 1994) These four concepts are vitally important for a data warehouse to supply the decision making information that it is tasked to provide. In the example of the manufacturing company bidding or quoting on a contract, the Subjects would be Customers, Suppliers, Employees, and Parts. All the information found in the Data Warehouse would be oriented around these key subjects. The data, as mentioned earlier, would also be collected from many different sources and integrated together to form one set of valid information. The third element that would be important, centers on the element of time. Using time, the Data Warehouse will be able to relate trend information to the requesting user. The fourth and final element also relates to the nature and source of the data. Since the data is collected from operational databases, this new Data Warehouse database is not meant to be updated by users. (Inmon, 1992)
All of the elements mentioned form the basics of a Data Warehouse, but one key statement can be formed, there is a clear separation between Operational processing, and Informational processing. (White, 1993) For operational processing, the databases are interactive, end users have the ability to both retrieve information and commit data into the system. Databases designed around operational processing are optimized with this in mind and need to allow quick committing of this new data. Along with the quick committing, an operational database will closely match the area of use for the system. This means that a Quality Inspection system will have entities and field information that is of interest to employees in the Quality Department. The same can be said for a database that stores shipment information, it will contain information that is of interest to employees in the Shipping Department. These...

Find Another Essay On Data Warehousing

Analysis and Research for a data warehouse system

992 words - 4 pages Analysis and Research for a data warehouse system Data warehousing is a difficult system and has to have the capability deliver quality data. An operational database is one which is used by organizations to run its day to day database activities. They are designed to handle rapid transaction processes with systematically updates. Velocity is important to operational databases. They are most commonly operated by office staff, and are on

Application Architecture & Process Design Essay

708 words - 3 pages for data organization in a database.A data warehouse stores all the meaningful information that a business accumulates. The information in a data warehouse must not only make data available to organizations, but accessing the information must also be efficient. Data warehousing is comprised of stored information in a database from an organization's activities. This database was developed to store information that would aid a business in making

project plan

1475 words - 6 pages with low wages as a way to reduce the bottom line. However, companies can also build the stores or factories abroad and hire people who work there A description of the current information systems Operational systems Operational systems are optimized for preservation of data integrity and speed of recording of business transactions through use of database normalization and an entity-relationship model Databases and data warehousing

Metrics that should be developed to measure the performance of a data warehouse in the following environments: 1) health care, 2) retail and 3) pharma

1525 words - 6 pages In most of the Database guide papers, eight performance-based metrics were used to communicate areas of concern to the data warehousing vendor. Also, the ninth one was developed as a weighted average measure using four of the eight metrics, which were deemed the most critical to the organization assessing data warehouse performance to determine how the vendor stacked up relative to data quality and systems quality.The nine metrics that were

Business Intelligence Software

1304 words - 5 pages software is required.There are four major BI software providers of interest: IBM, Microsoft, SAP, and Oracle. Each developer is provided a quick review below:IBM provides several different products for Business Intelligence. DB2 Warehouse is the core of their BI software. They offer several versions of DB2 Warehouse depending on the need of the company. This product provides a single solution data warehousing and analytics software that is easy to

Evolution of DBMS

1065 words - 4 pages product when it adheres the object-oriented characteristics of the SQL: 1999. IBM DB2, Oracle database and Microsoft SQL server support the SQL: 1999 technology. Data warehousing – 1980s – present The Data Warehousing database system is used for reporting. It is a system used in an organization to gather data such as purchase records in a transactional data etc. from different data sources in to the main central data location. This data is then

Database, Data Warehouse and Mobile Internet

894 words - 4 pages data warehouse also how the data is going to be managed for the current and historical data can sometimes lead to problems. Many times the past historical data is required to make out a decision on the particular point of view and that is why to manage a historical as well as current data in to the data warehouse is much more feasible. The purpose of a data warehouse is to provide flexible access to the data to the user. Data warehousing generally

Big Data Gives Business an Advantage

939 words - 4 pages /-/asset_publisher/LCcgOeS4t85g/content/big-data-and-the-creative-destruction-of-today-s-business-models/10192 CIO- http://www.cio.com/article/733698 TDWI Business Intelligence and Data Warehousing- http://tdwi.org/articles/2012/06/26/big-data-best-practices.aspx American Civil Liberties Union- https://www.aclu.org/blog/technology-and-liberty/eight-problems-big-data

Business Requirements

1341 words - 5 pages and many more. • Lowest total cost of ownership through complete browser-based systems management for all features • Supports Windows, Linux, and UNIX servers. Key Product Features • High performance business intelligence services such as ETL, data warehousing, OLAP, and data mining • The most comprehensive and open access to Web Services through SQL, Java, XML and standard Web interfaces • Efficient management of multi-terabyte

The Innovative Database and information Research Lab

1041 words - 4 pages a professional environment. I got the chance even before my final grades were out and I joined “IMS Health” as Software Engineer. As part of my job responsibility I worked on PADDS (Processing and Data Delivery System) and MIDAS data system, the core data-warehousing sector that serves thousands IMS employees in 118 countries and almost every pharmaceutical company of the world. The existing system works by creating a normalized database

Data Quality

2366 words - 9 pages Technical University of Athens Zographou, Athens, GREECE, 2000. [98] Larry P. English, “Information Stewardship: Accountability for Information Quality,” Information Impact International, Inc, 2006. [99] Peter Block, “Stewardship: Choosing Service over Self-Interest,” San Francisco: Berett-Koehler, 1993. [100] M. Pamela Neely “Data Quality Tools for Data Warehousing – A Small Sample Survey,” Center for Technology in Government University at Albany / SUNY, 1998.

Similar Essays

Data Mining, Data Warehousing And Data Dredging

1118 words - 4 pages Over the last ten years as information technology and more precisely data storage has become less expensive the amounts of data that businesses are holding onto has been increasing. Furthermore as the amounts increase there is a need to sort through this data to discover useful and relevant information. Some of these techniques are referred to as data mining, data warehousing and data dredging. There is a caveat here because as more businesses

Olap, Data Mining, Warehousing, Data Marts

736 words - 3 pages The technology that exists with Data Mining, Warehousing, Data Marts, and OLAP is comparatively a new term but the technology is not. Data Mining is the process of digging or gathering information from various databases. This includes data from point of sales transactions, credit card purchases, online forms which are just a few of the many things that some of the large companies dig to find out more about their clients. The information is used

Data Warehousing Development Methodologies: A Comparative Analysis

3704 words - 15 pages Data warehousing provides the large-scale infrastructure for decision support inmodern organizations. Data warehousing development methodologies have been developedby hardware & software vendors and consulting companies. There has been little academiccontribution to this work. This paper analyses four influential methodologies using the Avisonand Fitzgerald (1995) comparison framework. The analysis highlights a number of issues orareas where

Implementing A Data Warehouse In A Kar Dealer Network

1378 words - 6 pages . A Business Context for Agile Business Intelligence by Jim Gallo - BeyeNETWORK. Retrieved April 16, 2014, from http://www.b-eye-network.com/view/14384 Goldfarelli, M. & Rizzi, S. (2009). Data warehouse design: Modern Principles and Methodologies. : McGraw-Hill/ Osborne Media Hammergren, T. C., & Simon, A. R. (2009). Data warehousing for dummies. (2nd ed.). Indianapolis,: Wiley Publishing, Inc. Hwang, M., & Cappel, J. J. (2002). Data warehouse