Premium Essay

Dimensional Model Hands-on-Project

In:

Submitted By cptnkilt
Words 991
Pages 4
Dimensional Model Hands-On-Project
David A. McCormack
DBM 460 / Enterprise Database Management Systems
December 2, 2011
Professor Kurt Jost

Dimensional Model Hands-On-Project
Riordan Manufacturing in a global plastic manufacturer that specializes in plastic containers, custom plastic parts, and plastic fan parts. The company has many manufacturing location in the United States and one location in China. The company is a subsidiary of Riordan Industries, a fortune 1000 enterprise (Apollo Group, Inc., 2006).
Riordan Manufacturing is looking to increase their market presence by offering a better product based upon their product sales and past and present marketing and sales plans. However, the data needed is in several different databases, paper files and microfiche. A data warehouse would solve the issue of having the information disbursed in many locations and allow the company to quickly analyze the information for better decision making.
To pull the information needed for proper analysis a few things must take place. The first item to tackle would be to complete a enterprise wide analysis of the data requirements. This would include having the data that are in paper files and microfiche integrated into the current operational source systems. Once completed a data warehouse will need to be constructed to that will extract data from the existing databases and consolidate the data in one location. The data warehouse architecture that should be used in situation would be the hub and spoke.
The hub and spoke architecture is a design were a main data mart is created to house all the clean data. The operational sources are connected to the main data mart and provide all the data regarding the company's operations. This new data is stored by subject matter in an atomic level with a minimum of third normal form (3NF). The data from the operational sources are

Similar Documents

Free Essay

Technological Impact on Creativity: Assessing the Impact of Computer Modeling and Rapid Prototyping on Perceived Creativity

...THE FLORIDA STATE UNIVERSITY COLLEGE OF VISUAL ARTS, THEATER, AND DANCE TECHNOLOGICAL IMPACT ON CREATIVITY: ASSESSING THE IMPACT OF COMPUTER MODELING AND RAPID PROTOTYPING ON PERCEIVED CREATIVITY By ANTHONY L. CONETTA A thesis submitted to the Florida State University in partial fulfillment of the requirements for the degree of Masters of Fine Arts in Interior Design Degree Awarded: Fall, 2012 i Anthony Conetta defended this thesis on June 26, 2012. The members of the supervisory committee were: Marlo Ransdell Professor Directing Thesis Eric Wiedegreen Committee Member Jim Dawkins Committee Member The Graduate School has verified and approved the above-named committee members, and certifies that the thesis has been approved in accordance with university requirements. ii ACKNOWLEDGEMENTS [Type or paste your acknowledgements paragraph(s) here] iii TABLE OF CONTENTS LIST OF TABLES .......................................................................................................................... 1  LIST OF FIGURES ........................................................................................................................ 2  ABSTRACT .................................................................................................................................... 3  CHAPTER ONE ............................................................................................................................. 4  INTRODUCTION...

Words: 16731 - Pages: 67

Free Essay

Virtual Imaging

...Marcella Mazlan Professor Sassan Barkeshli CIS10 Research Project 10/3/2011 Virtual Imaging On a New Level There are two technologies that are being presented in the video clip, which is called Photosynth and Sea Dragon. Photosynth is a software application that is jointly developed by Microsoft Live Labs and the University of Washington, and is powered by Sea Dragon, which is an acquisition of Microsoft. Sea Dragon is created to give Photosynth the capability of zooming smoothly and in more detailed with its high-resolution digital photographs. Regardless of the size and amount of image data, end users can navigate through an image smoothly by using Sea Dragon. On the other hand, Photosynth is a technology that takes a wide variety of images and fusing the images according to similarities to generate three-dimensional models. What I was looking at on the screen in the beginning of the clip are the collective of images on Sea Dragon and its feature of being able to access photos and data either remotely or locally interactive with numerous amount of images. The only way to limit the performance system is depending on the number of pixels on the screen of every end user. Blaise Aguera y Arcas, speaker for Photosynth demo, continues to introduce a project called Photosynth that connects two different technologies, Sea Dragon and computer vision research by a graduate student of University of Washington. An example model of Notre Dame Cathedral is shown, which each of the images...

Words: 582 - Pages: 3

Free Essay

3d Mouse Controlling with Wrist Watch

...frequency range and in virtual mouse is based on Image Subtraction Algorithm and user has to wear different colour sticker to control the operations. Keywords: Human Computer Interaction, Image Processing, RF Communication, Texas MSP430, Fitt‟s law. V.Ravi Kumar Manasa Nagaruru Much of our technology for creating and displaying colour is based on empirical observation that a wide variety of colours can be obtained by mixing green, red and blue light in different proportions. For this reason red(R), green (G) and blue (B) are described as primary colours of the additive colour systems. In a colour image conforming o the RGB model, the value of f (x, y) is a vector with three components, corresponding to R, G and B. In a normalized model, these components each vary between 0.0 and 1.0 R, G and B can be regarded as orthogonal axes defining a three-dimensional colour space....

Words: 1537 - Pages: 7

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

Geographic Information Systems

...An Extended Entity-Relationship Model for Geographic Applications * Thanasis Hadzilacos Computer Technology Institute, University of Patras Box 1122, GR-26110, Patras, Greece thh@cti.gr Nectaria Tryfona National Center for Geographic Information and Analysis Univ. of Maine, Orono, ME 04469-5711, U.S.A nectaria@spatial.maine.edu Abstract. A special-purpose extension of the EntityRelationship model for the needs of conceptual modeling of geographic applications, called the Geo-ER Model, is presented. Handling properties associated to objects not because of the objects’ nature but because of the objects’ position, calls for dealing -at the semantic modeling levelwith space, location and dimensionality of objects, spatial relationships, space-depending attributes, and scale and generalization of representations. In order to accomplish this in the framework of ER and its derivatives, we introduce special entity sets, relationships, and add new constructs. The rationale as well as examples of usage of the Geo-ER model from actual projects are presented. 1. Introduction Is everybody special or are we all alike? Should we develop applications according to a special methodology for each class of applications, such as medical, business process and geographic, or should we use a single blanket approach for all? Personal preferences and philosophical discussions aside, it does seem that the general purpose side has won most battles in computer science, from hardware to programming languages...

Words: 4100 - Pages: 17

Free Essay

Assessment Plan for Augmented Reality

...June 26, 2016 | Submitted to: | Mr. Wes Smith | | Version History Version # | Implemented By | Revision Date | Approved By | Approval Date | Reason | 1.0 | GG | 06/16/2016 | WS | 06/25/2016 | Initial version | | | | | | | | | | | | | | | | | | | Table of Contents 1 | Executive Summary……………………………………………………………………… | 3 | 2 | Scope……...……………………………………………………………………………… | 5 | 3 | Technology Description and Alternatives……..……………………………………….... | 6 | 4 | Ancillaries……………...………………………………………………………………… | 7 | 5 | Human Resources………………………………………………………………………... | 8 | 6 | Schedule and Tasks………………………………………………………………………. | 8 | | 6.1 Milestones……………………………………………………………………….. | 9 | | 6.2 Project Timeline…………………………………………………………………. | 10 | 7 | Cost………………………………………………………………………………………. | 11 | 8 | Risk Assessment…………………………………………………………………………. | 12 | 9 | Appendix A: References…………………………………………………………………. | 14 | 10 | Appendix B: Key Terms…………………………………………………………………. | 15 | 11 | Appendix C: Detailed Tasks and Schedule……………………………………………… | 16 | 12 | Appendix D: Risk Matrix and Impact Definitions………………………………………. | 17 | 13 | Appendix E: Technology Assessment Approval………………………………………… | 19 | 14 | Appendix F: Technology Assessment Results Form…………………………………….. | 20 | 1. EXECUTIVE SUMMARY This report was developed to provide a plan of implementing Augmented Reality (AR) Software as a supplemental learning tool into the Engineering Graphics...

Words: 3707 - Pages: 15

Free Essay

Preparing to Use Rapid Prototyping: Lessons Learned from Design and Manufacturing Projects

...LESSONS LEARNED FROM DESIGN AND MANUFACTURING PROJECTS Dr. Hung-da Wan, University of Texas, San Antonio Hung-da Wan is an Assistant Professor of the Mechanical Engineering Department and the Director of Machine Shop of College of Engineering at the University of Texas at San Antonio (UTSA). He has been teaching undergraduate and graduate courses in the areas of computer integrated manufacturing systems, Six Sigma and lean methodologies, and manufacturing systems engineering. He also manages two rapid prototyping systems at UTSA. His current research interests include sustainability of manufacturing systems and web-based applications in manufacturing. Mr. Firasath Ahmed Syed, University of Texas, San Antonio Syed Firasath Ahmed is a master’s student in advanced manufacturing and enterprise engineering at the University of Texas, San Antonio. He is a Graduate Research Assistant and helps with 3D Printing needs that arise in the Mechanical Engineering Department. He has experience in working with two rapid prototyping machines present in the university namely ”dimension SST 1200es” and ”Z Printer ZP450.” He received his B.S. degree from Osmania University, India, in 2010. His research interests include rapid prototyping, manufacturing engineering, system simulation, and lean systems. c American Society for Engineering Education, 2012 Preparing to Use Rapid Prototyping: Lessons Learned from Design and Manufacturing Projects Abstract Rapid prototyping (RP), also known...

Words: 6053 - Pages: 25

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

Free Essay

Cad Benefits Today

...developed and initially released in 1982 by Autodesk. This software enables the architects, cartographers, drafters and engineers to create three-dimensional (3D) and two-dimensional (2D) models of solid and mesh surfaces. The models are made possible by the software ability to offers a robust set of features and automated drafting tools. Prior to its invention, manual drafting and drawing tools such as drafting boards, geometrical set instrument and pencils were used but they only offered a subset of what now is accomplished by the programs such as the AutoCAD. Manual drafting was a difficult task for the professionals since it consumed a lot of time and resources. Therefore, this paper will examine some of the key benefits of the AutoCAD. AutoCAD has led to increasing the productivity of the designer. The AutoCAD software aids the designer in visualizing the final product to be made, its constituents and subassemblies parts. The design can also be given animation to figure out how the final product will work thus giving the designer room for any modification if required. The software also helps the designer in analyzing, synthesizing and documenting the designs. All these aspects ultimately assist in improving the productivity of the designer thus translating to lower cost of designing, faster designing and shortening of the project completion time (Groover & Zimmers, 1984). AutoCAD also helps in enhancing the quality of the design. AutoCAD offers a set of tools for...

Words: 759 - Pages: 4

Free Essay

Design for Instruction

...Nathan Clark Design for Instruction Task The information gathered from my contextual factors and pre-assessment inform me of what type of students I will be teaching. The contextual factors help me to have a better understanding of the type of demographic my students belong to and what type of learning styles they attain. This information will also allow me to know of any outside characteristics that may inhibit learning for an individual student and the students as a whole. For example, some students may have learning disabilities and the student’s as a whole may react negatively to artworks involving polytheism. Giving the pre-assessment allowed me to fully understand what level my students are performing for that particular unit. I have found that I need to focus a lot of time on vocabulary definitions and how to apply the terms to artwork. Prompt Results of Pre-Assessment The students in this introductory level drawing class consists of students that are required to take this class as an elective or students who have an interest in drawing and wish to pursue it. The students in this class have limited experience with the concepts and skills in drawing. The pre-assessment results allow for an analysis of where the students are in terms of general knowledge. The pre-assessment for learning goal one allowed me to have a base quality level of the students’ performance. It enables me to see what each student is capable of in terms of skill and...

Words: 2426 - Pages: 10

Free Essay

Industrial Design

...INDUSTRIAL DESIGN Product Design Industrial design is the use of both applied art and science to create and develop products that benefit both the user and manufacture. Industrial designers also known as Product designers prepare drawings and illustrations of products that assist in the decision making process. Once the decisions have been made they then prepare the models or prototypes to be demonstrated or tested. However products such as textiles and furniture have designers who specialise in their development. From original idea to final product there is a long and involved process even for something as simple as a small home appliance. A large amount of development time is required to design a product that is marketing success. Industrial designers Paul Taylor and Gerry Mussett designed the Axis kettle in 1993. Although Gerry Musset explains how Kambrook and The Key Centre for Design were involved in the concept development and models he left the project when it got to the production drawing stage. Kambrook then took over the kettle’s production. The Axis kettle is designed for all demographics with safe, convenient everyday use, easy to pick up, cordless electrical connection, at affordable prices. Constructed mostly of stainless steal or plastic materials. In time researchers observed that kettles were often over filled and that users would typically boil a kettle and walk away only to return and boil it again. To try and prevent this from happening the...

Words: 1579 - Pages: 7

Free Essay

Metro

...13-22) • Help old people. (Roll No. 23-38) 2. Write an article giving suggestions on ways to inculcate values in the students of your school. 3. Compose a poem, a rap or a song describing each and every student of your class. You may include your teachers also. The Holiday Homework should be done in the English assignment note book. PHYSICS Prepare an investigatory project report as part of the practical syllabus prescribed by CBSE for class XI. The project should be done in a display file compiled under the following headings: • Index • Certificate • Acknowledgement • Experiment (a) Aim (b) Apparatus and materials required (c) Basic principle and theory (d) Diagram (e) Procedure (f) Observations & calculations (g) Result • Bibliography CHEMISTRY Project and presentation on s and p block elements as prescribed by CBSE. Guideline For Project Submit the hard copy in a display file as prescribed by CBSE. (report should include the following) TE 1. 2. 3. 4. 5. 6. 7. 8. Cover page of the project Index Certificate Acknowledgement Project summary Aim of the project Conclusion Bibliography Hand written project would be appreciated. Use a4 size coloured drawing sheets,...

Words: 860 - Pages: 4

Premium Essay

Application of Olap to the Analysis of the Curriculum Chosen by Students

...edu.cn Abstract—With development of the scale of higher education, more and more data about curriculum chosen by students has been produced. This paper analyzes the application of data warehouse, on-line analytical processing and data mining on the analysis of curriculum chosen by students, accomplishes the design of data warehouse about universities curriculum chosen by students, extracts and transforms curriculum chosen by students data and then loads them into the data warehouse. This paper builds curriculum chosen by students multidimensional cube analysis data model by taking use of OLAP technology, and realizes the query, analysis and show of curriculum chosen by students multidimensional data, so it can analyze the curriculum's establishment situation from many angles, and serve the university teaching decision support system. (Abstract) Keywords-Data Warehouse, OLAP, Dimensional Table, Fact Table, Star Model. Ⅰ. INTRODUCTION Data warehouse is a new database technology that has rapidly developed since 1990s. It can serve the policy-maker well, and it is one of data congregations that have the features of facing theme, integration, variation with time and supporting decision. In the past more than 20 years, with the development and widespread application of database, enterprise has accumulated massive data. Personnel of different levels in enterprise hope that they can extract the meaningful information from these chaotic data rapidly, conveniently and effectively in order...

Words: 2276 - Pages: 10

Premium Essay

Maths Essay

...EMM310 Assessment Item 2 Due: 15th October Length: 10 – 12 pages (Assessment marking criteria & Appendix 1 not included in page count) Measurement and Geometry A student: - makes, compares, sketches and names three-dimensional objects, including prisms, pyramids, cylinders, cones and spheres, and describes their features MA2-14MG | Working mathematically A student: - uses appropriate terminology to describe, and symbols to represent, mathematical ideas MA2-1WM - checks the accuracy of a statement and explains the reasoning used MA2-3WM | | Outcome/s | Lesson activities/ content | Prior knowledge | Relation to other strands | Other KLAs | Diverse learners | 1 | Measurement and GeometryMA2-14MG Working mathematically MA2-1WMMA2-3WM | - Revise 2D shapes- Find out prior knowledge of 3D objects – what do the students already know? Are there any misconceptions?- Using large versions of various 3D shapes, identify each object. Discuss the features of each shape e.g. faces, edges etc. - As a class, place the objects into groups based on similar features. Ensure students use reasoning for placing shapes into a certain group | - Students are already familiar with recognising and describing 3D shapes from stage 1 | Working mathematically MA2-1WM,MA2-3WM | EnglishEN2-1A | Visual Auditory/ linguistic | 2 | Measurement and GeometryMA2-14MG | - Discuss features of 3D shapes describing similarities and differences – focus on language e.g. faces, vertex, base, side...

Words: 3508 - Pages: 15

Free Essay

Computer Graphics

...Computer Graphics –B.C.A. (VIth sem ) Viral B. Polishwala Chapter - 6 : Applications of Computer Graphics Computers have become a powerful tool for the rapid and economical production of pictures. There is virtually no area in which graphical displays cannot be used to some advantage, and so it is not surprising to find the use of computer graphics so widespread. Although early applications in engineering and science had to rely on expensive and cumbersome equipment, advances in computer technology have made interactive computer graphics a practical tool. Today, we find computer graphics used routinely in such diverse areas as science, engineering, medicine, business, industry, government, art, entertainment, advertising, education, and training. Figure 1-1 summarizes the many applications of graphics in simulations, education, and graph presentations. Before we get into the details of how to do computer graphics, we first take a short tour through a gallery of graphics applications. 6.1 Presentation Graphics One of the major application areas is presentation graphics, used to produce illustrations for reports or to generate 35-mm slides or transparencies for use with projectors. It is used to produce illustrations for reports or to generate slide for with projections. Examples of presentation graphics are bar charts, line graphs, surface graphs, pie charts and displays showing relationships between parameters. 3-D graphics can provide more attraction to the presentation...

Words: 1314 - Pages: 6