Data Warehousing Essay, Research Paper
Abstract
Data warehousing is the technology trend most often associated with enterprise
computing in today’s business environment. The data warehouse, in fact, is a
culmination of new developments in database technology, including entity-relationship
modeling, heuristic searches, mass data storage, neural networks, multiprocessing, and
natural-language interfaces. The data warehouse is a centralized, integrated repository of
information, one which can provide a vital competitive edge for corporate decision-
making and product development. Types of data warehouses include the operational data
store (ODS), the data mart, which is of great value in analyzing sales information, and the
enterprise data warehouse, which can take either a centralized or distributed approach,
PC Week, Feb 8, 1999.
Data Warehouses
The type of data warehouse an organization adopts should depend on the way the
business operates and the types of decision support it needs. One of the simplest types of
data warehouse, an operational data store (ODS) is a replicated production database that
has been adjusted for errors. An ODS is used primarily to generate standard operations
reports and to provide transaction detail for summary-level analysis. Since an ODS
replicates an OLTP system, some experts do not consider it a true data warehouse type.
However, because ODS fit the broad definition and many data warehouses contain
them. Depending on an organization’s reporting needs, an ODS may be updated
monthly, weekly, or more frequently, sometimes almost in real time (PC Week, Feb 8
1999). The main advantage is that it enhances production system performance, since
reporting and query functions are off-loaded from the OLTP system to the ODS (PC
Week, Feb 8 1999).
Another type of data warehouse is the data mart. Data marts are limited in scope,
usually taking their information from a single department or business process. Data marts
may be used for analyzing sales information in a specific region or for a particular
product line, for example. Data marts usually contain only summary data but they can be
linked to operational data stores for drilling down to transaction details if necessary. Data
marts can be managed by IT departments, but only as often as they are managed directly
by users in a department or work group (PC Week, Feb 8 1999).
While many OLAP applications can be performed on data marts, cross-
departmental analysis, executive information systems, and data-mining applications need
information gathered from the entire enterprise to be most effective. The enterprise data
warehouse is used for this type of extensive data collection and analysis. Because of its
scope and complexity, the enterprise data warehouse is usually managed by the central IT
group.
As its name implies, an enterprise data warehouse contains information taken
from throughout an organization. This is the most complex type of warehouse to build
and maintain, since data must be merged from multiple systems into common subject
areas (PC Week, Feb 8 1999).
Data-mining tools work with various statistical techniques for modeling data and
for estimating and predicting outcomes based on what they have learned. Data-mining
work best with large data sets (PC Week, Feb 8 1999).
Data Warehouse Components
Although a data warehouse sounds like a single entity, it is really a multi-tiered,
multi-application conglomerate that comprises several components. Each component may
be handled by one or more pieces of hardware or software. No vendor has a complete
data warehouse package, (PC Week, Feb 8 1999).
Functionally, a data warehouse extracts data from operational systems and loads
it into a holding area where it is “scrubbed”, which means it is made to conform with
warehouse standards. Then the data will be merged, time-stamped and dated in the right
order, and loaded into databases for use by data access tools. Since the data goes through
a number of transformations and it is ultimately placed in data structures different from
the ones it came from, those changes are mapped in catalogs or dictionaries. Such
catalogs are managed with metadata tools. Data that defines or describes data in the
warehouse is called metadata. There are typically two kinds of metadata. Information that
users need to know, such as table and column names and definitions, are called frontend
metadata. Everything else, such as how a particular data element maps to its original
database, is backend metadata.
Security.
Security considerations for data warehouses are different from those for OLTP
systems. For a data warehouse to pay for itself, lots of users have to be able to benefit
from it, and therefore more users will need access to data than are traditionally authorized
by OLTP security (Computerworld, Feb 15,1999).
Conclusion
Today, many corporations come to appreciate that the information they gather
each day is an asset, they will rely more and more on data warehousing. But while a data
warehouse can provide managers with the means to ask questions of their data and get
back meaningful answers, it can not automatically make a company more profitable.
“Good technology can not substitute for good management.”
References
1. Computerworld, Feb 15, 1999 p14, “Human side key to data warehousing.”
By: Stewart Deck.
2. PC Week, Feb 8 1999 v16 i6 p56, “Data Warehouses in Need of Renovation.”
By: John Taschek.
3. PC Week, Feb 8, 1999 v16 i6 p71, “100 Top Data Warehousing Leaders Step Up.” By: Jeff Moad.
Другие работы по теме:
Tattoos Essay Research Paper Its impossible to
Tattoos Essay, Research Paper It?s impossible to walk through the mall for more than a couple of minutes without spotting people of all ages with tattoos. Big tattoos, small tattoos, tasteful ones, tacky ones, colored ones, hennaed ones, probably some temporary ones — in all kinds of designs — eagles, Celtic crosses, Betty Boop, tribal art, military symbols, flowers, abstract art.
Untitled Essay Research Paper MATERIAL SAFETY DATA
Untitled Essay, Research Paper MATERIAL SAFETY DATA SHEET WOMEN: A Chemical Analysis ELEMENT: Woman SYMBOL: WO DISCOVERER Adam ATOMIC MASS: Accepted as 118 lbs, known to vary from 110 to 550 lbs. OCCURRENCE: Copious quantities throughout the world. PHYSICAL PROPERTIES: 1. Surface usually covered with a painted film. 2.
Moon Essay Research Paper Conclusion on the
Moon Essay, Research Paper Conclusion on the Moon Watch When I first got this assignment I was thinking I am never going to be able to do this every night for a month. I surprised myself once again. This class has made me doubt myself many times but I always seem to pull myself up to do it. I believe I did very well on this experiment and I achieved the purpose.
Gorky Essay Research Paper The painter Arshile
Gorky Essay, Research Paper The painter Arshile Gorky was born Vostanig Adolan in eastern Turkey. Raised in a poor Armenian farming family, Gorky’s childhood was shaped by two disasters: the first being the massacres of 1896, the second was the genocide of 1915, that affected the entire Armenian population, and which claimed the life of Gorky’s mother.
Carreer Essay Research Paper Ahsan ZamanPer1 Mrs
Carreer Essay, Research Paper Ahsan Zaman Per.1 Mrs. Posin I learned a lot from going to my mother?s work. I learned how mainframe computer work through a system of chips called central units. I learned that they print out everything by sorting files and using terminals to occupy the source and then print. I got a tour of my mom?s department the data entry basically my mom has to key in different kind of information and data on to spread sheets and then she transfer the files so they can be printed out.
Vdg Essay Research Paper Raintree
Vdg Essay, Research Paper Raintree’s website is dedicated to providing information and education on the important plants of the Amazon Rainforest, therefore this section is the most extensive. The Plant Database section is continuously under construction as we continue to add more rainforest plants which are under research.
The Human Abstract Essay Research Paper Romantic
The Human Abstract Essay, Research Paper Romantic Traits In “The Human Abstract” My aim for this essay is to try to bring out and analyse the romantic themes, that can be reflected from “The Human Abstract” written by William Blake. If there now are any? Let us find out.
Batch Essay Research Paper Discuss your stately
Batch Essay, Research Paper Discuss your stately for testing this algorithm, making sure that you include any problems that you think you may encounter. Also give examples of test data and expected results of your test data.
Percy ShelleyS Hymn To Intellectual Beauty Essay
, Research Paper In Percy Shelley?s poem ?Hymn to Intellectual Beauty?, he writes about many abstract powers. Through his usage of similes, the reader is able to get a sense of what his relationships are with abstract thoughts, in particular Power and Beauty. We are especially able to get this feel by looking at Shelley?s infusion of mortal phenomena with these abstracts.
Beef It
’s What’s For Dinner Essay, Research Paper Abstract #1: American Beef Consumption in the United States In my research argument, my working thesis claim will be that American people should consume more of American beef products and be less afraid of, and more correctly informed about, the benefits of eating beef products.
Storage Technologies Essay Research Paper Summary of
Storage Technologies Essay, Research Paper Summary of findings about Innovations in Magnetic and Optical storage systems. Using Nanotechnology scientists ar Rice University have been able to store 10 billion gigabytes of data on physical storage small enough to fit into a small vial. The story appeared in The Philadelphia Inquirer.
Velocity Essay Research Paper Instantaneous Versus Average
Velocity Essay, Research Paper Instantaneous Versus Average Velocity A position versus time graph or a displacement versus time graph can be used to analyze the motion of an object in one dimension. The slope gives the object’s velocity. The slope of a line segment joining two points on the graph gives the average velociy during that interval.
Database Design Essay Research Paper Before you
Database Design Essay, Research Paper Before you use Microsoft Access to actually build the tables, forms, and other objects that will make up your database, it is important to take time to design your database. A good database design is the keystone to creating a database that foes what you want it to do effectively, accurately, and efficiently.
Acidity Of Apple Juice In Different Temperature
Essay, Research Paper Acidity of Apple Juice in Different Temperature Question Does temperature effect the pH of apple juice? Hypothesis An increase of the temperature will lower the acidity level of the apple juice.
Crime And Resources Essay Research Paper Crime
Crime And Resources Essay, Research Paper Crime in the United States (CIUS), published annually by the FBI, is a compilation of the Uniform Crime Reports (UCR) provided by over 16,000 policing jurisdictions. It represents one of the two primary sources of data about crime in the United States, the National Crime Victimization Survey (NCVS) being the other.
Telecommunication Systems Essay Research Paper Joseph Maria
Telecommunication Systems Essay, Research Paper Joseph Maria 530 BIS Telecommunication Systems Coursework 2 1) If the noise pulse signal cross the decision level of the detector then an error will occur in the bit value. If the noise is Gaussian there is equal probability for the noise voltage to increase the sample value and to decrease the sample value.
Chromotography Essay Research Paper ChromatographyA widely used
Chromotography Essay, Research Paper Chromatography A widely used separation tool Purpose: Given a sample of unknown ink, we were to use chromatography paper to determine the identity of the sample. And also, we were to separate two dyes of different color using a silica gel column, made in lab.
Data Mining Essay Research Paper In today
Data Mining Essay, Research Paper In today s business world, information about the customer is a necessity for a businesses trying to maximize its profits. A new, and important, tool in gaining this knowledge is Data Mining. Data Mining is a set of automated procedures used to find previously unknown patterns and relationships in data.
Scholarship Essay Essay Research Paper No greater
Scholarship Essay Essay, Research Paper No greater contribution can be made to a specific field than research that leads to the development of a new and superior technology. Universities and businesses constantly attempt to remain on the cutting edge of new design, manufacturing, and application systems through research and development.
Lyrical Poems Essay Research Paper Lyrical poems
Lyrical Poems Essay, Research Paper Lyrical poems on the other hand can be compared to a painting in which society is depicted, but has also been done so in a manner which serves the authors/painters point of view or their own personal agenda. The painter is not painting still life, but instead an abstract portrait of society through which the reader must filter fact from opinion.
Geographical Information System Essay Research Paper GIS
Geographical Information System Essay, Research Paper GIS Geographical Information System originated in the 1960s. During the early days of the technology the use was limited to a small group of practicioners. It is a information technology which analizes, stores, and displays both spatial and non-spatial data.
Paper Towels On Trial Essay Research Paper
Paper Towels On Trial Have you ever wondered what the best brand of paper towels is? Or what “the best” actually means? Well, our group adventured out to find “the best” paper towel! We tested seven different brands of paper towels. We did 3 different controlled experiments to collect data. The data will help to determine the best paper towel out of the seven brands we tested.
Data Warehousing Essay Research Paper Data CompressionData
Data Warehousing Essay, Research Paper Data Compression Data Compression just sounds complicated. Don t be afraid, compression is our good friend for many reasons. It saves hard drive space. It makes data files easier to handle. It also cuts down those immense file download times from the Internet. Wouldn t it be nice if we could compress all files down to just a few bytes?
Abstract For Water Lab Essay Research Paper
This lab that we had done was to test water for chemicals such as chlorine, calcium, surfate, and iron. We accomplished this lab by getting a 12-well wellplate. We put in the well plate Iron (3), calcium, chlorine, and sulfate. Underneath each we put tap water, and underneath that we put distilled water for a control.
Blah Essay Research Paper For my senior
Blah Essay, Research Paper For my senior thesis, I will be conducting further research on my project, and the idea from which my project came. This research will include different experimental approaches and setups, the outcomes of these new schematics, and the way in which the project was originally approached.
Mr Essay Research Paper An investigation into
Mr Essay, Research Paper An investigation into Hotel Users expectations of The Best Hotel Chain 1. Aims and Objectives 1. To examine what the expectations of hotel users are of The Best Hotel Chain.
Look At Myself In The Mirror Essay
, Research Paper When you look in the mirror, what do you see? Evil or good? When I look at in the mirror, I see the art, the way the natural expresses the human beings; the way nature expresses the imagines. Look in the mirror shows the reflection of the object, imagine is the favor of all the artists, art is the expression of all the imagines; art is the reflection of the object.
Cpu Internal Organisations Essay Research Paper CPU
Cpu Internal Organisations Essay, Research Paper CPU Internal Organisations The input/output (I/O) interface, bus structures, microprocessor, memories and peripherals (also known as external or I/O devices) are the major components of a computer system. These components constantly trade information and instructions to complete assigned operations.
Market Research Essay Research Paper Before I
Market Research Essay, Research Paper Before I started to manufacture my products I had to find out if there was a market for it. This is called market research. Like any other business I had to decide what market research methods are most likely to give me the information I need.
Abstract Expressionism Essay Research Paper Abstract ExpressionismAbstract
Abstract Expressionism Essay, Research Paper Abstract Expressionism Abstract expressionism is a movement in American painting of the late 1940s and early 1950s acclaimed throughout the world. The dominance of American art dates from the success of the Abstract Expressionists, their formal innovations and new techniques were crucial to the development of Western art, and many artists today still make use of their ideas or react against them.