Ims Data Warehouse Essay

3449 words - 14 pages

IMS - Data WarehouseIn a large financial services organization, you have been asked by the Marketing Director to give him a report on the development of a date warehouse. This will, he sees, provide a wide variety of sales/marketing information.1) In this report, give him the details as to why & how a data warehouse differs from a traditional database. (40%)2) Identify the main functions that might be performed by such a system with respect to marketing requirements (40%)3) List & explain the benefits that might bring to the organization. (20%)(Nov 2003 - Qn 3 , Nov 02 - Qn 5, Nov 01 - Qn 1)Connolly et al (1998) offered the following definition of a data warehouse:"a subject-orientated, integrated, time variant and non-volatile collection of data in support of the management decision making process".Subject-orientated: a data warehouse is organised around subject-groups within the enterprise e.g. customer, sales etc. This reflects the need for strategic decision support, rather than operational supportIntegrated: data used within different applications is collected together. This data must be cleansed to become consistent. This data cleansing required to populate the warehouse can be difficult, time consuming and costly.Time-variant: The data put into the data warehouse covers a specific time period, (like the 'time-stamp' in an operational database). The time variance also covers the length of time that the data is held for; that is between updates. Data Warehouses are not updated on a very frequent basis, often it is monthly or quarterly.Non-volatile: The data is not updated in real time. New data is normally added to the database as an addition and not as a replacement. This sort of technology has only become a possibility in the last five years or so with the availability of cheap computer memory.Data warehousesThey support high-performance demands on an organization's data and information- They generally contain very large amounts of data from multiple sources- This may include databases from different data models and sometimes files acquired from independent systems and platforms.Several types of applications are used with data warehouses- OLAP (on-line analytical processing)The analysis of complex data from the data warehouseThey use distributed computing capabilities for analyses that require vast amounts of storage and processing power- DSS (decision support systems)Support an organization's leading decision makers with higher-level data for complex and important decisions- Data mining sometimes call knowledge discoveryWarehousing is used to store data for business analysis- It provide greater storage, more functionality and faster response time than traditional databases- Often only read-access is required- The data often comes from multiple databases, stored on different platforms- Many of the analyses needed are recurrent and predictable- Reports to management are often of prime importanceCharacteristics of a data warehouseIt...

When the Bubble Burst Essay

1539 words - 6 pages By the time I arrived state side from my second tour in the Middle East the housing bubble had already burst. I noticed a drastic change in the way that many of my friends and family were living. Several of my friends that worked in real estate had sold their boats and seconds houses. My own stock portfolio had lost a third of its value. My sister and her husband had defaulted on their home mortgage leaving them scrambling for a place to live. I

phase diagram Essay

4456 words - 18 pages consisted of a stir plate, ring stand, Erlenmeyer flask, ice water bath, and a GLX temperature probe. The temperature probe was set to take a data point every second. A stir bar was added to the ice water bath to ensure a uniform temperature throughout the bath, and thus more uniform cooling of the samples. A beaker of boiling water was set up on a hot plate in order to melt the samples. After adjusting the various settings of the probe, the

Revolutionary Work of Art

1890 words - 8 pages Walter Benjamin emphasizes in his essay, “The Work of Art in the Age of its Technological Reproducibility” that technology used to make an artwork has changed the way it was received, and its “aura”. Aura represents the originality and authenticity of a work of art that has not been reproduced. The Sistine Chapel in the Vatican is an example of a work that has been and truly a beacon of art. It has brought a benefit and enlightenment to the art

Enlightenment Thought in New Zealand Schools

1594 words - 6 pages In this essay I will be looking at how the political and intellectual ideas of the enlightenment have shaped New Zealand Education. I will also be discussing the perennial tension of local control versus central control of education, and how this has been affected by the political and intellectual ideas of the enlightenment. The enlightenment was an intellectual movement, which beginnings of were marked by the Glorious Revolution in Britain

Psychological Egoism Theory

2240 words - 9 pages The theory of psychological egoism is indeed plausible. The meaning of plausible in the context of this paper refers to the validity or the conceivability of the theory in question, to explain the nature and motivation of human behavior (Hinman, 2007). Human actions are motivated by the satisfaction obtained after completing a task that they are involved in. For example, Mother Teresa was satisfied by her benevolent actions and

How Celtic Folkore has Influenced My Family

1587 words - 6 pages Every family has a unique background that influences the way they live and interact with other people. My parents, who emigrated from Ireland to the States with my three brothers in 1989, brought over their own Celtic folklore and traditions that have helped shaped the way our family operates and lives. One aspect of folklore that has helped shape my family dynamic is the Celtic cross—both its background and what role it has played in our lives

Julia Margaret Cameron

1406 words - 6 pages At a time when women were looked upon as being homemakers, wives, mothers and such the late 1850's presented a change in pace for one woman in specific. Photography was discovered in 1826 and soon after the phenomenon of photography was being experimented with and in turn brought new and different ways of photo taking not only as documenting real time, but also conceptualizing a scene in which an image would be taken. Julia Margaret Cameron will

Evaluation of School Improvement

1403 words - 6 pages improve to incorporate planning, resources, and goals in school districts. Mandates for evaluation presented in the Title 1 Elementary and Secondary Education Act (ESEA) of 1965 became a major section to upgrade schools (Dunn, 2005). This Act and many others, such as No Child Left Behind law (NCLB) began the process of change in education reform. Evaluation actions generate objectives, reliable and useful data for the use of decision-making

Case Study: The Benefits of Animal Testing

1757 words - 7 pages Nine year old Amy has already had a rough start in life. She was born with an abnormal heart that hinders her everyday activities. Amy is unable to keep up with kids her own age because she often tires out easily. As a consequence, she has very little friends and is often alone. Amy is forced to take different medications everyday just to survive. Amy’s life consists of medicine, doctors, and constant hospital visits. However, Amy is due for a

Myth and Magic: Realism in "One Hundred Years of Solitude"

1531 words - 6 pages “He enjoyed his grandmother's unique way of telling stories. No matter how fantastic or improbable her statements, she always delivered them as if they were the irrefutable truth” (Wikipedia, 2011). Experiences are particular instances of one personally encountering or undergoing something and in these moments of time life changes for the best or the worst and memories are formed. These recollections such as riding your first bicycle, going to

Adiponectin: a Novel Indicator of Malnutrition and Inflammation in Hemodialysis Patients

2384 words - 10 pages includes two laboratory markers: serum albumin and transferrin. Each component had four levels of severity, from 0 (normal) to 3 (severely abnormal). The sum of all 10 MIS components ranges from 0 to 30; a higher score was indicative of a more severe degree of malnutrition and inflammation (11). Statistical analysis Data were evaluated using SPSS, version 11.5 (SPSS Inc., Chicago, IL). All the data were assessed for normality of distribution, using

Infromation Mamagement Systems Essay

1461 words - 6 pages 1.What is an information system?Information system (IS) or Management information systems (MIS) as American concept, refers to a gathering multiple parts of equipment and tools involved in the collection and dissemination of information. The information system support the organization tasks for example, In the Operations support systems, including transaction processing systems, IS transfer business data ( cash flow, warehouse information) into

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

Evolution Of Dbms Essay

1065 words - 4 pages tree-like structure similar to the organizational structure. This structure allows the repetition of information using parent/child relationship. One-to-many relationship is created as one parent can have many children but a child belongs to only one parent. This model is the first data base model created by IBM in 1966. It was used in Information Management System (IMS) developed by IBM. Later Microsoft employed it in Windows Registry. This data

Operation Management: Dewan Farooque Motors Motors (Pakistan)

8957 words - 36 pages to the production floor. When the product is produced, then again it is sent to the Finished Goods Quarantine; samples are drawn from the finished goods and are tested for 'quality standards'. If the finished goods are up to the required level of standards then they are sent to the Finished Goods warehouse to be distributed; or else, 'batch failure' is reported to the Production department and the concerned offices.Type of the OrganizationThe