Premium Essay

Datawarehouse

In:

Submitted By malai
Words 2229
Pages 9
[Type text]

DATA WAREHOUSE
Introduction
In todays competitive and information packed age, management, executives and business users need well organized data for decision support and for the organizational planning. Decision Support Systems (DSS) were developed to aid executives and managers to better understand the information and facilitate at making better decisions. But DSS has its own limitations. Due to the information requirement and their complexity, it was difficult for Decision Support System to extract all necessary information from the data. Therefore to overcome this drawback, a new data storage system, called the Data Warehouse was developed.

What is a Data Warehouse?
A data warehouse is a relational database. It is not used for daily routine transaction processing. It contains remarkable (having great significance) data derived from the transaction data. It also contains data from other sources like external systems, or applications. It is designed for query and analysis.

Copyright 2011. Do not copy or publish any part of this document without author's permission.

[Type text]

Data Warehouse Vs Traditional Database
A database is a collection of the relational data. Database system comprises of a database and database software. Similarly, a data warehouse is a collection of relational data as well as supporting system. If we look closer at it, we will find that both the traditional database and the data warehouse have indexes, fields, keys, views and etc. We will notice that there is no difference between the traditional database and the data warehouse. But actually there is a difference between the two of them. The traditional database stores transactional data like relational, object oriented, network or hierarchical. While the data warehouses are mainly developed for retrieving historical transaction data for management, executives

Similar Documents

Free Essay

Datawarehouse Modelling

...Group-9 (Assignment- SUPPLY CHAIN NETWORK DESIGN ) Tarun Yadav (PGP30291); Shubra (PGP30283); Saurav (PGP30340); Arjun (PGP30186); Abhishek (PGP29368) ===================================================================================== Q9: How would you model a new objective (in addition to cost minimization) that the all-India average inventory turnover ratio for the Plant-to-Depot pipeline is above a minimum target value? Suggest a suitable extension/ modification of the MILP model proposed in the class. a= subscript which represents SKU’s b= subscript representing factory c = subscript representing technology/line d= subscript representing depot M= subscript representing markets Variables Depotdepot {1, the , ℎe 0} FactoryLine,factoryline {0, 1,2,…, } FlowOfUnitsFactoryToMarketa,b,c,M Number of units which are transferred from the factory to market FlowOfUnitsFactoryToDepota,b,c,d Number of units which are transferred from the factory to depot FlowOfUnitsDepotToMarketa,d,M Number of units which are transferred from the depot to market NumberOfTripsabd Number of trips of the product p from the factory f to depot d Constants_____________________________________________________________ FixedCapitalOfLine costbc = Fixed cost of setting up the line l in factory f FixedCapitalOfDepot costd = Fixed cost of setting up the depot d TransportToDepot costbd = Quantity based transport cost from the factory f to depot d TransportFromFactory...

Words: 400 - Pages: 2

Premium Essay

What Is Datawarehouse

...Table of Content | | Content | Page | 1 | Abstract | 3 | 2 | What is Data Warehouse? | 3 | 3 | Who uses Data Warehouse? | 4 | 4 | Characteristics of Data Warehouse | 4 | 5 | Basic Elements of Data Warehouse | 5 | 6 | Basic Processes of Data Warehouse | 7 | 7 | Basic Components of Data Warehouse | 8 | 8 | Data Warehouse Architecture | 9 | 9 | Steps to build successful Data Warehouse | 12 | 10 | Selection of Data Warehouse | 13 | 11 | Cost and Size of Data Warehouse | 15 | * Abstract: This document is for explaining what data warehouse is and how does it work. It also explains how data warehousing is useful for companies and organizations for the purpose of decision making and offers a broad array of decision support services to all companies. Data warehousing technique is adopted by many of the companies who use Information Technology to gain a competitive advantage. Companies who have started using this technology are building various techniques to develop hardware, software and other tools that help data warehouse to function more effectively. In this term paper I have given a brief idea about the development and basic terms that are necessary to understand data warehousing. The paper also states advantages and disadvantages encountered while developing data warehouse. * What is Data Warehouse: Data Warehouse is a database in which information of...

Words: 2065 - Pages: 9

Premium Essay

Dbms (Obms & Oracle 91)

...MC0067 - 01 Marks - 40 DBMS (OBMS & ORACLE 91) 1. Write a note on File based system/ Data base system Solution: File-Based Systems: Conventionally, Before the database Systems evolved , data in the software’s Systems was stored in and represented using flats files. Drawbacks of File-Based Systems: File - Based Systems [pic] As shown in the figure, in a file-based system, different programs in the same application may be interacting with different private data files. There is no system enforcing any standardized control on the organization and structure of these data files. • Data Redundancy and Inconsistency Since data resides in different private data files, there are chances of redundancy and resulting inconsistency. For example, in the above example shown, the same customer can have a savings account as well as a mortgage loan. Here the customer details may be duplicated since the programs for the two functions store their corresponding data in two different data files. This gives rr.>e to redundancy in the customer's data. Since the same data is stored in two files, inconsistency arises if a change made in the data in one file is not reflected in the other. • Unanticipated Queries In a file-based system, handling sudden/ad-hoc queries can be difficult, since it requires changes in the existing programs. • Data Isolation Though data used by different programs in the application may be related, they reside in isolated data files. ...

Words: 4599 - Pages: 19

Premium Essay

Financial Intelligence

...8 IDEAS FOR ACCOUNTING BI SUCCESS Business Intelligence (BI)is a phrase that can mean many things. This white paper is focused on the topic of Business Intelligence for the accounting department. Your accounting department’s BI solution should serve your needs effectively. BI for accounting should be considered successful when the authorized accounting department staff have all the necessary software tools required to see the information in all necessary formats to answer all questions asked in the allocated time. Accounting departments need to have a window into the hundreds of tables of data that are stored in databases controlled by the accounting software. They also need to be able to manipulate that data for both compliance and ad-hoc purposes. Lastly, they need the ability to do this without taxing IT resources. If your organization is involved in, or considering a BI implementation, you know there are a lot of options out there. Many solutions are even providing specialized platforms for supporting line-ofbusiness applications. The promises of these BI options are shortened implementation cycles and reduced costs. Many vendors have gone a long way towards making data warehousing and BI tools more available and affordable for the mid-market. However, the mid-market accountant’s true needs are often underserved, resulting in large additional investments. These additional costs are due to the fact that you also need to spend time building on top of the platform that the...

Words: 2072 - Pages: 9

Premium Essay

Data Mining

...Data Mining Objectives: Highlight the characteristics of Data mining Operations, Techniques and Tools. A Brief Overview Online Analytical Processing (OLAP): OLAP is the dynamic synthesis, analysis, and consolidation of large volumns of multi-dimensional data. Multi-dimensional OLAP support common analyst operations, such as: ▪ Considation – aggregate of data, e.g. roll-ups from branches to regions. ▪ Drill-down – showing details, just the reverse of considation. ▪ Slicing and dicing – pivoting. Looking at the data from different viewpoints. E.g. X, Y, Z axis as salesman, Nth quarter and products, or region, Nth quarter and products. A Brief Overview Data Mining: Construct an advanced architecture for storing information in a multi-dimension data warehouse is just the first step to evolve from traditional DBMS. To realize the value of a data warehouse, it is necessary to extract the knowledge hidden within the warehouse. Unlike OLAP, which reveal patterns that are known in advance, Data Mining uses the machine learning techniques to find hidden relationships within data. So Data Mining is to ▪ Analyse data, ▪ Use software techniques ▪ Finding hidden and unexpected patterns and relationships in sets of data. Examples of Data Mining Applications: ▪ Identifying potential credit card customer groups ▪ Identifying buying patterns of customers. ▪ Predicting trends of market...

Words: 1258 - Pages: 6

Premium Essay

Rohan

...Indian Institute of Management Bangalore Customer Relationship Management Faculty: Prof. G. Shainesh Term VI PGP (2008-09) 3 Credit Course Background – The primary purpose of any business is to win and keep customers. Its competitors also seek to do the same. Most successful firms have developed capabilities for attracting customers through their marketing programs. But they have shown mixed results when it comes to retaining these customers. Customer Relationship Management helps businesses in successfully implementing strategies aimed at winning and retaining customers profitably. It is also helping businesses shift from a short-term transaction based mode of operation in their interactions with customers to a long-term relationship mode. Objectives – The objective of this course is to help students understand the concept and practice of CRM derived from research and applications across businesses. These concepts and applications from real life case studies will help identify opportunities, which can be successfully implemented for long term profitability. Pedagogy – The teaching methodology will include a mix of lectures, discussions of pre-readings, presentations by practitioners, exercises and case analysis. The cases are integrative in nature but will also help develop an appreciation of specific elements of CRM. Group Project – Option 1 - Identify any organisation which is practicing some form of CRM. Start working with them to understand...

Words: 1490 - Pages: 6

Premium Essay

Data Mining

...Data Mining/Data Warehousing Matthew P Bartman Strayer University Ibrahim Elhag CIS 111– Intro to Relational Database Management June 9, 2013 Data Mining/Data Warehousing When it comes to technology especially in terms of storing data there are two ways that it can be done and that is through data mining and data warehousing. With each type of storage there are trends and benefits. In terms of data warehousing there are 5 key benefits one of them being that it enhance business intelligence. What this means is that business processes can be applied directly instead of things having to be done with limited information or on gut instinct. Another benefit of data warehousing is that it can also save time meaning that if a decision has to be made the data can be retrieved quickly instead of having to find data from multiple sources. Not only does data warehousing enhance business intelligence and save time but it can also enchance data quality and consistency.This is accomplished by converting all data into one common format and will make it consistent with all departments which ensures accuracy with the data as well. While these key benefits another one is that it can provide historical intelligence which means that analayze different time periods and trends to make future predictions. One other key benefit is that it provides a great return on investment. The reason being that a data warehouse generates more revenue...

Words: 2018 - Pages: 9

Premium Essay

Fedex Case : How It Help the Firm Thanks to Implementaiton of an It System ?

...FEDEX CASE 1. List the business processes displayed in the video: 1. Federal express currier picks up a package 2. Currier scans the box to electronically alter FedEx that the package is in their hands 3. Packages are brought to a hub (a large FedEx warehouse) 4. Packages are unloaded onto a conveyer belt that carries to a scanner that weighs the boxes and measures the size. This tells FedEx how much to charge the customer for shipping. 5. Packages go to a multidirectional scanner, with 40 cameras that scans and inputs the label. Labels tells the scanner where the box is being shipped 6. Any package that can not be scanned is sorted manually 7. Packages are then diverted automatically (or manually for packages that are not able to be scanned) and pushed down slides to their respective locations to be put into cargo containers 8. Each cargo container is weighed and then loaded onto a plane 9. FedEx air control center routes the plane and monitors flying conditions 10. Packages are still being monitored here 11. Plane lands, packages go to another sorting center 12. Packages are put on a truck and delivered to your door 2. List the types of information systems shown in the video. Can you describe how systems that were not shown might be used at FedEx? The information systems shown in the video are: * Management Information System (MIS): The FedEx system is set up to track packages at each point in their delivery process...

Words: 1696 - Pages: 7

Premium Essay

Exxonmobil

...Running head: PROJECT PORTFOLIO Project Portfolio Project Portfolio ExxonMobil is one of the largest publicly traded petroleum and petrochemical enterprises in the world. It started out as a regional marketer of Kerosene. They have three familiar brand names which are: Exxon, Esso and Mobil. The first oil well was built in 1859 (exxonmobil.com). ExxonMobil uses different types of technology every day like surveillance, network computers, communication devices, etc. Being a big corporation like this requires an IT Department. We’ve learned these past eight weeks about the use of technology tools, Porter’s Five Forces Model, Agent based technologies, business planning, and technology in present and future. Throughout this paper I will relate the information that I have learned and talk about how these areas can help it remain a competitive business. People, Information and Information Technology play an important role when it comes to helping the company remain competitive in the industry. ExxonMobil tries to teach their employees to have the best technical and leadership capabilities. They provide their employees with formal training and a broad range of global experiences to prepare them to be the next generation of ExxonMobil leaders. Not only do they want to hire exceptional employees at the corporate headquarters, but also at all their branch locations as well. The employees throughout the organization set goals, carry out tasks, make decisions, and serve customers...

Words: 2101 - Pages: 9

Free Essay

Virtualization Implementation

...Server Virtualization and Consolidation - A case study Ravi G Singh Consulting IT Specialist – System p rsingh@us.ibm.com Special Notices This document discusses Server Virtualization and Consolidation designed and implemented by the author for an IBM Customer. This document is presented “As-Is” without any warranty, guarantee or assurances of any kind, either express or implied. IBM does not assume responsibility for the statements expressed herein and it reflects the opinions of the author. If you have questions about the contents of this document, please direct them to the author at rsingh@us.ibm.com. Author is not responsible for errors in this document that may result in any kind of inaccuracies. Acknowledgements Thanks to John R Hock, IBM Certified IT Specialist – System p - Advanced Technical Support Americas (ATS) for reviewing this White Paper. Thanks to the customer and IBM team for their contribution and support to this project. Trademarks The following terms are registered trademarks of International Business Machines Corporation in the United States and/or other countries: AIX, AS/400, DB2, IBM, Micro Channel, MQSeries, Netfinity, NUMAQ, OS/390, OS/400, Parallel Sysplex, PartnerLink, POWERparallel, RS/6000, S/390, Scalable POWERparallel Systems, Sequent, SP2, System/390, ThinkPad, WebSphere. The following terms are trademarks of International Business Machines Corporation in the United States and/or other countries: DB2 Universal Database, DEEP BLUE...

Words: 6610 - Pages: 27

Premium Essay

Crm Curriculum

...Indian Institute of Management Bangalore Customer Relationship Management Faculty: Prof. G. Shainesh Room C-103, Tel : 3334 Term IV PGP (2014-15) 3 Credit Course Background – Businesses aim to win and keep customers. Its competitors also seek to do the same. Most successful firms have developed capabilities for attracting customers through their marketing programs. But they have shown mixed results when it comes to retaining these customers. Customer Relationship Management helps businesses in successfully implementing strategies aimed at winning and retaining customers profitably. It is also helping businesses shift from a short-term transaction based mode of operation in their interactions with customers to a long-term relationship mode. Objectives – The objective of this course is to help students understand the concept and practice of CRM derived from research and applications across businesses. These concepts and applications from real life case studies will help identify opportunities, which can be successfully implemented for long term profitability. Pedagogy – The teaching methodology will include a mix of lectures, discussions, presentations by practitioners, videos, exercises and case analysis. The cases are integrative in nature but will also help develop an appreciation of specific elements of CRM. Each session will require preparation of assigned reading / case and active participation by students. A significant portion of the performance...

Words: 2004 - Pages: 9

Premium Essay

Framework Marketing Management Summary

...Chapter 1 - Defining Marketing for the 21st Century Questions to be answered 1. Why is marketing important? 2. What is the scope of marketing? 3. What are some fundamental marketing concepts and new marketing realities? 4. What are the tasks necessary for successful marketing management? Reviewing important marketing concepts, tools, frameworks and issues. The Importance of marketing * Creating demand * Introduce and gain acceptance of new products * Increasing demand creates jobs * Allow firms to more engage in socially responsible activities The scope of marketing Marketing is about identifying and meeting human and social needs. 1. Meeting needs profitably Marketing is the activity, set of institutions, and processes for creating, communicating, delivering and exchanging offerings that have value for customers, clients, partners, and society at large. We see marketing management as the art and science of choosing target markets and getting, keeping and growing customers through creating, delivering and communicating superior customer value. Important part of Marketing (Peter Drucker) The aim of marketing is to know and understand the customer so well that the product of service fits him and sells itself. Ideally, marketing should result in a customer who is ready to buy. All that should be needed then is to make the product or service available. What is marketed Marketers market 10 main types of entities: * Goods...

Words: 2406 - Pages: 10

Free Essay

Introduction to Is

...BAB I FOUNDATION OF IS IN BUSINESS * Role of IS in business 1. Support of Strategies for Competitive Advantage 2. Support of Business Decision Making 3. Support of Business Processes and Operations * Role of e-business in business * E-Business Penggunaan teknologi internet untuk memberdayakan proses bisnis, e-commerce, dan ECS antar perusahaan, pelanggan, pemasok, dan stakeholder. Aplikasi e-business yang membantu dalam proses pertukaran informasi, uang sumber daya, jasa dll antara lain : * Intranet = Jaringan yang menghubungkan antar divisi didalam perusahaan * Extranet = Jaringan antar perusahaan dengan customer dan partner bisnis Fungsi : * Merombak internal business process * Menerapkan e-commerce dengan customer dan supplier * Mendukung kolaborasi antar tim bisnis dan kelompok kerja * Enterprise Collaboration System Mendukung komunikasi, koordinasi, dan kolaborasi di antara tim-tim jaringan / kelompok kerja * E-Commerce Pembelian, penjualan, pemasaran, dan servis produk, jasa, dan informasi melalui jaringan komputer * Types of information System * Operation Support Systems Membantu menjalankan bisnis sehari-hari, tetapi tidak memberikan banyak informasi untuk pengambilan keputusan manajerial * Transaction Processing Systems Merekam & memproses transaksi harian * Process Control Systems Memantau dan mengendalikan proses fisik * Enterprise Collaboration Systems (Office...

Words: 2333 - Pages: 10

Premium Essay

Business Intelligence Applications

...Business Intelligence Applications Paul Villela CSCI 4304:Database Systems Dr. Carolyn W. Green 2 December 2014 Business Intelligence Applications On the May 4th, 2014 episode of Mad Men (appropriately entitled “The Monolith”, a clever nod to the iconic black monolith which provides the impetus for the evolutionary leap from beast to man in Arthur C Clarke’s novel “2001: A Space Odyssey”) Sterling Cooper & Partners, the fictional ad agency around which the show revolves, purchases and installs a brand new IBM 360 computer. While the vast majority of the office greets the massive, expensive machine with much apprehension (“What man lay on his back counting stars and thought about a number?” asks Don Draper, head of the Creative Department (played by John Hamm)) (Stevenson, 2014), Senior Partner and visionary Jim Cutler (played by Harry Hamlin) understands the power and potential of just such a machine, particularly in the field of advertising. Sterling Cooper & Partners gain an edge that their competition would not have for several more years, as well as a service they can offer their customers, one many of whom would not provide for themselves for even longer. What Jim Cutler was envisioning was a strategic idea currently referred to as Business Intelligence. A Brief History of Business Intelligence The concept of Business Intelligence (BI) began as a direct descendent of an information system called the Decision Support System (DSS), a system used for complex...

Words: 2993 - Pages: 12

Premium Essay

Nt1330 Unit 3 Assignment

...this remote data will be stored locally thereby increasing the replication factor by one. It also uses a replication budget to limit the storage consumed by the dynamically created replica. An Elephant Trap , a mechanism to find the largest flows in a network link structure is used to replicate popular files. A probabilistic approach is also used for the ageing mechanism. • Advantages 1. Improves data locality with no extra network overhead. 2. Turn around and slow down time is improved. 3. It is scheduler agnostic, so it can be used in parallel with other schemes. • Limitations 1. Storage requirements are high. More data structures and synchronization mechanisms are needed. 2. Intense modification of Hadoop is required. 7. CHEETAH: Datawarehouse built on top of Hadoop with flexibility and scalability is Cheetah[7]. Cheetah combines both data warehouse and Map/Reduce technologies. It makes easier for SQL user to work. Since data is usually stored in column format, it has the overhead of query reconstruction and cannot guarantee that all fields of the needed record are present in the same Data Node. Cheetah provides only identical layout for all replicas and no column grouping. For processing any data in the cell, it has to decompress the whole cell which will result in unnecessary column reads and I/O throughput is limited. • Advantages : 1. It provides a simple query language which is easily understood by people having little SQL knowledge. 2. It utilizes Hadoop's optimization...

Words: 3188 - Pages: 13