Premium Essay

Database and Data Warehousing Design

In: Computers and Technology

Submitted By yolandaM
Words 880
Pages 4
Running head: DATABASE AND DATA WAREHOUSING DESIGN

Database and Data Warehousing Design
Yolanda McCollum
Dr. Constance D. Blanson
CIS499: Information Systems Capstone
February 11, 2014

Database and Data Warehousing Design Why does one need data warehousing? According to Total Metrics (2013): 1. The prime purpose of a Data Warehouse is to store, in one system, data and information that originates from multiple applications within, or across, organizations. The data may be stored ‘as received’ from the source application, or it may be processed upon input to validate, translate, aggregate, or derive new data/information.
2. Most of the data load functions are processed in batch. There are few on-line data maintenance functions. The on-line functions that do exist tend to update the reference files and data translation tables.
3. A database alone does not constitute a Data Warehouse system. At a minimum, a Data Warehouse system must include the database and corresponding load functions. Data reporting functions are optional. They may, or may not be an integral part of the Data Warehouse system.
4. The prime purpose of storing the data is to support the information reporting requirements of an organization i.e. multiple users and multiple applications.
5. The Data Warehouse may, or may not, provide the required reporting functions. In some cases, external applications access the Data Warehouse files to generate their own reports and queries.
6. Data Warehouse functions are often based upon packaged software. An example is the Business Objects product.
7. Where the data within the Warehouse supports the reporting requirements of multiple applications and users, the data may be physically stored based upon the user requirements. Separate database segments may store the ‘user views’ for a particular user. This results in the physical storage

Similar Documents

Premium Essay

Cis 499 Project Deliverable 3

...DELIVERABLE 3: DATABASE AND DATA WAREHOUSING DESIGN This assignment consists of two (2) sections: a design document and a revised project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment. One of the main functions of any business is to be able to use data to leverage a strategic competitive advantage. This feat hinges upon a company’s ability to transform data into quality information. The use of relational databases is a necessity for contemporary organizations; however, data warehousing has become a strategic priority due to the enormous amounts of data that must be analyzed along with the varying sources from which data comes. Since you are now the CIO of a data-collection company which gathers data by using Web analytics and operational systems, you must design a solution overview that incorporates data warehousing. The executive team needs to be clear about what data warehousing can provide the company. Section 1: Design Document 1.Write a four to six (4-6) page design document in which you: ◦Support the need for data warehousing within your company and elaborate on the best practices that the company will adhere to. ◦Create a schema that supports the company’s business and processes. Explain and support the database schema with relevant...

Words: 2167 - Pages: 9

Premium Essay

Dbm460Syllabus

...Course Design Guide DBM/460 Version 2 Syllabus College of Information Systems & Technology DBM/460 Version 2 Enterprise Database Management Systems Copyright © 2012, 2009 by University of Phoenix. All rights reserved. Course Description This course covers distributed computing, middleware, and industry standards as relating to the enterprise data repository. Data warehousing, data mining, and data marts are covered from an enterprise perspective. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • • University policies: You must be logged into the student website to view this document. Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending on the modality in which you attend class. If you have recently changed modalities, read the policies governing your current class modality. Course Materials Coronel, C., Morris, S., & Rob, P. (2011). Database systems: Design, implementation and management (9th ed.). Mason, OH: Cengage Learning. Eckerson, W. W. (2011). Performance dashboards: Measuring, monitoring, and managing your business (2nd ed.). Hoboken, NJ: John Wiley & Sons, Inc. Hoffer, J. A., Ramesh, V., & Topi, H. (2011). Modern database management (10th ed.). Upper Saddle River, NJ:...

Words: 2603 - Pages: 11

Premium Essay

Test

...Data Warehousing Methodologies Using a common set of attributes to determine which methodology to use in a particular data warehousing project. DATA INTEGRATION TECHNOLOGIES have experienced explosive growth in the last few years, and data warehousing has played a major role in the integration process. A data warehouse is a subjectoriented, integrated, time-variant, and nonvolatile collection of data that supports managerial decision making [4]. Data warehousing has been cited as the highest-priority post-millennium project of more than half of IT executives. A large number of data warehousing methodologies and tools are available to support the growing market. However, with so many methodologies to choose from, a major concern for many firms is which one to employ in a given data warehousing project. In this article, we review and compare several prominent data warehousing methodologies based on a common set of attributes. Online transaction processing (OLTP) systems are useful for addressing the operational data needs of a firm. However, they are not well suited for supporting decision-support queries or business questions that managers typically need to address. Such questions involve analytics including aggregation, drilldown, and slicing/dicing of data, which are best supported by online analytical processing (OLAP) systems. Data warehouses support OLAP applications by storing and maintaining data in multidimensional format. Data in an OLAP warehouse is extracted and loaded...

Words: 4067 - Pages: 17

Premium Essay

Data Warehousing

...Data Warehousing Saikrishna Burugula IST 7000 Data Management Wilmington University Abstract A data storage could be a subject-oriented, integrated, time-variant, non-updateable assortment of knowledge utilized in business intelligence and support of organizing decision-making method (Inmon, Strauss & Neushloss, 2008). In data warehousing when the data is stored it is not updated, commonly data warehousing intended for evaluation connected with data source in addition to addressing queries it can be called copy of addressing data (Prabhu, 2002). The key intention with this paper is typically to target on the actual design connected with data warehouse in addition to modeling techniques like ER modeling and Dimensional modeling. Introduction A Data Warehouse is not just a new combination of all of the in business databases in an organization. Because of its attention on business intelligence, exterior data, and time variant information, a data warehouse is usually a special type of database. The good thing is, you should not learn another number of database abilities to do business with a new information storage place. Most data warehouses tend to be relational databases designed in many ways optimized pertaining to selection assistance, definitely not in business information running. Facts warehousing could be the procedure whereby organizations create and gaze after information...

Words: 1513 - Pages: 7

Premium Essay

Data Warehousing

...Data warehousing: what is it, why do we want to do it, how is it done? How do data warehouses compare with operational databases? What do we want to consider when doing so, and what are our options in terms of implementation? In this article, I discuss data warehouses: what they are, how they compare to operational databases, and how they are designed, implemented and maintained. An operational database is one which is used by the enterprise to run its day to day operations. They are created to support fast transaction processing, with frequent updates. Speed is key to operational databases. They typically are used by clerical staff, and are on the order of megabytes of data to gigabytes. Database consistency is very important to operational databases, and consistency checks and constraints are rigidly enforced. They contain the most current set of data applicable to running enterprise operations. These are our sales and inventory databases. A data warehouse differs from this in many ways. They are used by management for making decisions, watching trends, and running reports. They are typically used offline, have few users and are very large: gigabytes to terabytes. They contain historical data, are read only, and are added to but rarely or never updated (the rows in the database are not changed, I mean). The data in the data warehouse is time sensitive – each row is the warehouse is timestamped so that trending of data versus time can be done. The kinds...

Words: 1530 - Pages: 7

Premium Essay

Business Intelligence

...Business Intelligence and Data Warehouses Kevin Gainey Mr. Brown CIS 111 Data warehouses support business decisions by collecting, consolidating, and organizing data for reporting and analysis with tools such as online analytical processing (OLAP) and data mining. Although data warehouses are built on relational database technology, the design of a data warehouse database differs substantially from the design of an online transaction processing system (OLTP) database. The topics in this paper address approaches and choices to be considered when designing and implementing a data warehouse. The paper begins by contrasting data warehouse databases with OLTP databases and introducing OLAP and data mining, and then adds information about design issues to be considered when developing a data warehouse with Microsoft® SQL Server™ 2000. A data warehouse supports an OLTP system by providing a place for the OLTP database to offload data as it accumulates, and by providing services that would complicate and degrade OLTP operations if they were performed in the OLTP database. Without a data warehouse to hold historical information, data is archived to static media such as magnetic tape, or allowed to accumulate in the OLTP database. If data is simply archived for preservation, it is not available or organized for use by analysts and decision makers. If data is allowed to accumulate in the OLTP so it can be used for analysis, the OLTP database continues to grow in size and...

Words: 721 - Pages: 3

Free Essay

Teradata Introduction

...Coffing Data Warehousing Education Outline 02/17/05 TERADATA EDUCATION OUTLINE Coffing Data Warehousing has provided quality Teradata education, products and services for over a decade. We offer customized solutions to maximize your warehouse. Toll Free: 1-877-TERADAT Business Phone: 1-937-855-4838 Email: mailto:CDWSales@CoffingDW.com Website: http://www.CoffingDW.com In addition to the course material listed in this outline, we also offer Teradata classes in Teradata Basics, Implementation, SQL, Database Administration, Design and Utilities. Please contact us so we can customize a course to fit your specific needs. © 2006 Coffing Data Warehousing – All rights reserved. Confidential. 1 Coffing Data Warehousing Education Outline 02/17/05 PURPOSE Coffing Data Warehousing has been providing quality Teradata education for over a decade. We offer customized courses to maximize the effectiveness of each class. The purpose of this proposal is to build a lasting relationship with your company. To this end, we have combined our comprehensive Teradata education services in a unique package that we feel best suits the diverse needs of your company while offering our high quality product at competitive pricing. Coffing Data Warehousing is excited to offer you, our preferred partner, an innovative new way to look at training at the CoffingDW Teradata University (CDW-TU). This approach provides the ability to maximize learning potential. Our goal is to make your employees...

Words: 1512 - Pages: 7

Premium Essay

High Minister of Funk

...Data warehousing History: "Data Warehouse" (QW) as a term was first coined and used by Bill Inmon in 1990. He asserted that Data warehouse is subject Oriented, Integrated, Time-Variant and nonvolatile collection of facts that can be useful in supporting decision making if studied or critically analysed. Definition: A DW is a centralized repository that stores data and information from multiple sources and can be used to transforms this data into a common, multidimensional data model for efficient and effective querying and analysis. A data warehouse can also be considered to be a repository generally used for research as well as supporting decision making based on transaction operating system On-line Transaction processor (OLTP) or on-line analytical processing (OLAP). A data warehouse is designed for query and analysis rather than for transaction processing, separates analysis workload from transaction workload and enables an organization to consolidate data from several sources. Additionally important, data warehouse will include a way of extracting, transporting, transformation and techniques of providing solutions. It also provides client analysis tools, anaylysis engines (OLAP), plus a series of other applications that manage the process of capturing data as it occurs. Facts about a DW * Less frequent updating done * Kept separate from the organization's operational database * Is made up of consolidated historical data which help the organizations’...

Words: 751 - Pages: 4

Premium Essay

"Enterprise Level Data Work Flows and Data Warehouse

...CSCI 1507 (1903) "Enterprise level data work flows and Data Warehousing" Professor Rajni Palikhey University of Northern Virginia Acknowledgement This Research Paper would not have been possible without the guidance and the help of my co-students and respected Professor who in one way or the other contributed and extended their valuable assistance in the preparation and completion of this research paper. I would to like to convey my sense of gratitude to Professor.Rajni Palikhey who helped and supported us right throughout the semester. This paper would not have been possible without her cooperation and technical assistance. We would also thank our Institution and our faculty members without whom this project would have been a distant reality. We also extend our heartfelt thanks to our family and well wishers. I would like to take this occasion to specially thank University of Northern Virginia to provide us with excellent faculty and also in supporting us getting quality education remotely. Contents SL No Title Page no 1 Abstract 5 2 Introduction to Databases 6 3 OLTP and OLAP Systems 7 4 Difference between OLTP and OLAP 9 5 Data Modeling 13 6 Workflows in Enterprise level Data warehousing 18 7 Business Intelligence tools used in Data flow and Data Warehousing 21 8 Analysis in Data warehousing 24 9 Conclusion 28 10 Foot Note 30 11 References 31 ABSTRACT These days majority...

Words: 6349 - Pages: 26

Premium Essay

Eljerizen

...R. Canopin Discussion Questions #9 IT 193 - Systems Analysis & Design Chapter 9: Data Design 1. Explain the main difference between a file processing system and a database system. Answer: File processing is the method by which a file-oriented system stores and managesdata.Today, file processing is less common than database systems, although in somecases, file processing is more efficient and cost-effective. Database systems provide aframework for storing data within a real-time, dynamic environment, without the risk ofdata redundancy. A database management system (DBMS) is a collection of tools,features, and interfaces that allows users to manage the contents of a database. Link: https://www.coursehero.com/file/7367193/CH9doc/?justUnlocked=1 2. What is a DBMS? Briefly describe the components of a DBMS. Answer: DBMS stands for Database Management System. A DBMS is a collection of tools,features, and interfaces that enable users to add, update, manage, access, and analyze thecontents of a database. A DBMS provides an interface between a database and the users,database administrators (DBAs), and the other information systems with which theDBMS interacts. In addition to interfaces, other DBMS components include a datamanipulation language, a schema, and a physical data repository. A data manipulationlanguage, or DML, controls the operations of the database. Link: https://www.coursehero.com/file/7367193/CH9doc/?justUnlocked=1 3....

Words: 988 - Pages: 4

Premium Essay

Data Warehousing

...Data Warehousing Essay, Research Paper Contents 1. Introduction 2. What is a data warehouse 3. Past, Present and Future 4. Data Warehouses and Business Organisations 5. Conclusion 6. Bibliography 1.0 Introduction In recent years, data warehousing has emerged as the primary method of analysing sales and marketing data for a competitive advantage. As the number of knowledge workers using the data warehouse/data mart grows and the amount of data increases daily, performance problems have become a major concern of both the Information Systems staff and the users. Many options have been tried in an attempt to solve the performance problems – from bigger hardware to different software or database tuning and redesign using star schemas or snowflake data structures. However, all have limitations – either in functionality or in terms of cost – and their strengths are almost inevitably outstripped by users’ demands. During the past three years, data warehousing has emerged as one of the hottest trends in information technology for corporations seeking to utilise the massive amounts of data they are accumulating. Managers from all business disciplines want enterprise wide information access, as well as the ability to manipulate and analyse information that the company has gathered for a single purpose, to make more intelligent business decisions. Whether to increase customer value, identify new markets or improve the management of the firm’s assets, the data warehouse...

Words: 3367 - Pages: 14

Premium Essay

The Design and Development of Business Warehousw Systems

...The Design and Development of Business Warehouse Systems CIS 537 July 31, 2011 What type of new BW System you would want? The system that I want is the SAP NetWeaver Business Warehouse systems on the IBM InfoSphere Warehouse that is on IBM. With a business intelligence database with common properties in a class that can be a wide variation. The SAP NetWeaver Business Warehouse databases tend to have some features that are typical, of a standard BI database. It will fit into the InfoSphere Balanced Warehouse design and there are many benefits to running SAP NetWeaver BW on InfoSphere Balance Warehouse. Timely access to relevant information has always been critical to business success, with new data sources and increased access, managing, processing and making sense of data volumes is important. With the SAP NetWeaver Business Warehouse will lead the way to providing a complete business from data sources. A comprehensive set of tools, planning and simulation capabilities as the components of the SAP NetWeaver platform to combines powerful business warehouse infrastructure and data warehousing functionality. It will give a timely access to relevant information that has been critical to business success. The decision will be based on the full range of information available as the volume of available information grows. The InfoSphere Balanced Warehouse is a complete data warehousing solution that is comprised on pretested, scalable and fully integrated system. The system is...

Words: 626 - Pages: 3

Premium Essay

Warehouse Handling

...European Journal of Operational Research, 2009, Vol 193, pp425-436 Authors: Baker P. & Canessa, M. Warehouse design: a structured approach Abstract: In spite of the importance of warehousing to the customer service and cost levels of many businesses, there is currently not a comprehensive systematic method for designing warehouses. In this paper, the current literature on the overall methodology of warehouse design is explored, together with the literature on tools and techniques used for specific areas of analysis. The general results from the literature have then been validated and refined with reference to warehouse design companies. The output is a general framework of steps, with specific tools and techniques that can be used for each step. This is intended to be of value to practitioners and to assist further research into the development of a more comprehensive methodology for warehouse design. Keywords: Facilities planning and design; Decision support models; Logistics; Warehouse design. 1 Warehouse design: a structured approach 1. Introduction Warehouses are a key aspect of modern supply chains and play a vital role in the success, or failure, of businesses today (Frazelle, 2002a). Although many companies have examined the possibilities of synchronised direct supply to customers, there are still many circumstances where this is not appropriate. This may be because the supplier lead times cannot be reduced cost effectively to the short lead times...

Words: 8488 - Pages: 34

Premium Essay

What Is Datawarehouse

...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 an organization is stored and...

Words: 2065 - Pages: 9

Premium Essay

Review Questions 1-10

...Module 9 Review Questions 1-10 1. Explain the main difference between a file-oriented system and a database system. a. A file-oriented system utilizes data in a regular OS file based format where a database system uses a database engine that organizes data in a database in a table format utilizing rows for each record. 2. What is a DBMS? Briefly describe the components of a DBMS. a. DBMS stands for Database Management System. A DBMS is a collection of tools, features, and interfaces that enables users to add, update, manage, access, and analyze the contents of a database. A DBMS is made up of a DML (data manipulation language), Schema and subschemas, Physical data repository, and an Interface to allow access to the database from DBA’s, Users, and Related Information Systems. 3. Describe a primary key, candidate key, secondary key, foreign key, and common field. a. Primary Key – a field or combination of fields that uniquely and minimally identifies an entity. Candidate Key – Any field or combination of fields that can act as the primary key but are not. Secondary Key – Any field of combination of fields that can be use to identify a entity. Foreign Key – A field that exists in an entity that is the PK of another entity. Common Field – An attribute (field) that appears in more than one entity (record). 4. What are entity-relationship diagrams and how are they used? What symbol is used to represent and entity in an ERD? What symbol is used for a relationship...

Words: 842 - Pages: 4