Premium Essay

"Enterprise Level Data Work Flows and Data Warehouse

In: Computers and Technology

Submitted By iahammod3175
Words 6349
Pages 26
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 of the applications, may it be web applications or windows applications or mobile applications, are completely database dependent. Most of the application developments are becoming database driven environments, hence rendering databases as one of the most key elements in a software environment. This dependency on databases can attributed to the increasing number of data requirements from the...

Similar Documents

Premium Essay

Research of Improve the Data Quality

...Research of improve the data quality Abstract Data Warehouse is a data collection which is subject-oriented, integrated, relativelyand relatively stable. and It can reflect the changes of history and support the management decision. It is an important segment to maintain the accuracy of the data warehouse. However, ETL is an important part to build data warehouse and occupy about 60 percent of the load. The improvement of the quality in the data warehouse helps to guarantee the reliability and also help the enterprise to summarize and use the data for a long period of time. There are many methods to improve the quality of data. However, in the view of the experience summary and practice accumulation in the practical application, the paper mainly focuses on the ETL dispatcher and way of check to improve data quality of data warehouse. First of all, the automation of data management which is realized by ETL principle make the data into a data stream., the database where the data exists become as starting point of ETL, saving the data warehouse with ultimate high-quality data as the end of ETL. Second, for the data which the ETL data flow has been formed to generate example, for the data which complete ETL processes structure to handling historical information, thus ensuring that the ETL flow can monitoring....

Words: 3026 - Pages: 13

Premium Essay

Data Information and Information System

...user needs Summarize relevant information Include all data up to present time Use attractive formats and graphical charts Information System - consists of all the components that work together to process data and produce information all contributing to the organization’s main goal....

Words: 2370 - Pages: 10

Premium Essay

.Lkmk

...* Explain the role of different functional areas in efficiently and effectively completing the procurement process * Identify the key steps in the procurement process and the data, document, and information flows associated with the process. * Explain the financial impact of the steps in the procurement process * Explain the role of enterprise systems in supporting the procurement process Chapter Outline and Teaching Suggestions 1. Key Concepts and Assumptions a. Procurement - Requisition to pay b. Business to consumer c. Business to business Explain what procurement means and differentiate between B2B and B2C procurement. 2. A Basic Procurement Process d. The framework i. Physical flow ii. Data and document flow iii. Information flow Review the framework introduced in chapter 1 e. Physical Flow iv. Create requisition v. Create and send purchase order vi. Receive shipment vii. Receive invoice viii. Send payment Explain each step in terms of purpose. Discuss how communication between process steps is accomplished. 3. Document and Data Flow f. Purchase Requisition g. Purchase Order h. Packing List i. Goods Receipt Document j. Goods Receipt Document For each document, explain its role in the process and the key data in the document....

Words: 1822 - Pages: 8

Premium Essay

Data Warehousing

...The kinds of queries that are run against data warehouses are complex, containing many WHERE, JOIN and UNION clauses. These are decision support databases that are used to make strategic decisions about the enterprise. Organizations make data warehouses in order to gain insight into trends, anomalies and exceptions in enterprise data that affect the business strategically. This kind of analysis and...

Words: 1530 - Pages: 7

Premium Essay

Crm and Dss System

...A study of the integration between CRM systems and Decision Support System (Efficient support for multi levels of management in the organization) Nehad Omar Mohamed Arab Academy for Science &Technology & Maritime Transport Faculty of computer science and information systems Department of Information system (Decision Support Systems) Cairo, Egypt NehadOmarM@gmail.com Abstract This paper reports the results of a study into the Integration between customer relationship management systems (CRM) including different level of functionality with decision support systems(DSS),and analyzes the role played by the information system and its component, briefing simple steps of building a CRM system with quality to avoid the popular known problems of integration between systems trying to produce a clear data with enough degree of quality to be used the DSS system to support different levels of management in the organization to put their strategies based on expected number of customer. A combination of survey and case studies research approach was used. is a way of knowledge and can establish a correspondence between an object identified and a general system. In a systemic approach CRM helps organization to manage their customers, their prospects and their sales....

Words: 6865 - Pages: 28

Premium Essay

Collaborative Writingbusiness Processes

...While taking down the information, the representative checks the availability of the product to the warehouse nearest to the customers shipping address. If the product is not available at the closest warehouse, a check is done for the next closest warehouse to find the product. While searching for availability, a credit check is performed before each order by the Accounting department. If the credit is approved, an invoice will be generated by Accounting and the Sales department will get the okay to process the order, pending the delivery date. If denied, the customer will have a credit hold status and will be contacted regarding it. The credit hold will be forwarded to the credit department and the customer service representative will receive a daily report on orders placed on credit hold. The product will not be shipped,...

Words: 2332 - Pages: 10

Premium Essay

Enterprise

...Marquette University e-Publications@Marquette Master's Theses (2009 -) Dissertations, Theses, and Professional Projects Design and Implementation of an Enterprise Data Warehouse Edward M. Leonard Marquette University Recommended Citation Leonard, Edward M., "Design and Implementation of an Enterprise Data Warehouse" (2011). Master's Theses (2009 -). Paper 119. http://epublications.marquette.edu/theses_open/119 DESIGN AND IMPLEMENTATION OF AN ENTERPRISE DATA WAREHOUSE By Edward M. Leonard, B.S. A Thesis submitted to the Faculty of the Graduate School, Marquette University, in Partial Fulfillment of the Requirements for the Degree of Master of Science Milwaukee, Wisconsin December 2011 ABSTRACT DESIGN AND IMPLEMTATION OF AN ENTERPRISE DATA WAREHOUSE Edward M. Leonard, B.S. Marquette University, 2011 The reporting and sharing of information has been synonymous with databases as long as there have been systems to host them. Now more than ever, users expect the sharing of information in an immediate, efficient, and secure manner. However, due to the sheer number of databases within the enterprise, getting the data in an effective fashion requires a coordinated effort between the existing systems....

Words: 20485 - Pages: 82

Premium Essay

Enterprise Systems

...MIS, 2015 How Enterprise Systems work 8     based on a suite of integrated software modules and a common central database. The database collects data from key business processes of various functional areas under various depts. and units/divisions. It also feeds the data into numerous applications that can support nearly all of an organization’s internal business activities. Note: When new information is entered by one process, the information is made immediately...

Words: 1318 - Pages: 6

Premium Essay

Erp System in Xinghe Electronic Commerce Company

...Under the new external environment, e-commerce companies need to adjust their development strategies, restructuring their business processes and organizations, also need to use modern information technology, enterprise information management. In this context, electricity providers need to use integrated enterprise management information system to provide real-time, accurate and complete information in order to enhance the effectiveness of decision-making, improve management efficiency and economic benefits. Xinghe E-commerce Company is directly under the China Government-owned Corporation. The original capital for the company was 13,500,000 RMB, and the first investment was 50,000,000 investments. And the company has been built the business as...

Words: 6467 - Pages: 26

Premium Essay

Supply Chain Management

...If the revenue derived from the sale of a product does not create a required profit margin over the cost of its production then that product is doomed to failure, and the health of the enterprise that manufactures the product will suffer.  supply chain management softwareWith that in mind it is clear that the most important factor in the life cycle of a product is the budget and time frame within which it is manufactured. The discipline of supply chain management and the ranges of software used to control it have been developed in order to make this cycle more efficient and cost effective. The field is led by the Council of Supply Chain Management Professionals (CSCMP)  Aspects of Supply Chain Management  Supply chain management is a complex field encompassing every process involved in manufacturing a product. Supply chain management software assists enterprises in controlling streamlining the process through several logistical areas.  Customer Service Management: Customer relations provide information to the manufacturer on the level of demand for the product, and also provide feedbackto the customer on promised delivery schedules.  Supply chain management software provides reporting modules to track both current demand and answer a range of ‘what if’ questions to assist in the prediction of future demand depending on changes in strategy.  Procurement Process: Strategies are developed with suppliers to ensure that materials can be provided on time to meet...

Words: 4202 - Pages: 17

Premium Essay

Role of It

...Except computer data recognition equipment, communication technologies, factory automation and other hardware and services are included. Integrated supply chain model Bi-directional arrow reflects the accommodation of reverse materials...

Words: 1523 - Pages: 7

Premium Essay

Information System - Enterprise Application

...DATA BASES............................................................................................................................................... 2 I.1. Definitions ............................................................................................................................................................... 2 I.2. Major Methods and DBMS...................................................................................................................................... 3 I.3. Information-related issues........................................................................................................................................ 4 II. COLLABORATION TOOLS (GROUPWARE) ..................................................................................... 4 II.1. Introduction & Definition ....................................................................................................................................... 4 II.2. Electronic Document Management (EDM) ............................................................................................................ 5 II.3. Process Management (Workflow) .......................................................................................................................... 6 II.4. Electronic Data Interchange (E.D.I.) ...................................................................................................................... 7 III....

Words: 9771 - Pages: 40

Premium Essay

Business Intelligence

...LITERATURE REVIEW 7 4.1 BI Architecture and components 8 4.2 Enterprise Resource Planning (ERP) 9 4.3 Levels Of Strategy Within An Organisation And Linkage To Bi 11 4.3.1 The Corporate Level Strategy 11 4.3.2 Business-Level Strategy 12 4.3.4 Operational Strategy 13 4.3.5 Bi implementation strategies 14 4.3.5 Balance Scorecard (BSC) 15 5. The Macro Environment of Sensible Solution Ltd 17 5.1 Swot Analysis 17 5.2 Pestle Analysis 18 6. CONCLUSION/RECOMMENDATIONS 19 7....

Words: 4398 - Pages: 18

Premium Essay

Warehousing and Functioning Erp in Tvs Logistics Services Ltd

...Pavan Nair, Regional head, TVS Logistics Services Ltd, Pune for giving me the opportunity to work on this project and also for his guidance as project guide. We are deeply grateful to Professor M. Kameshwara Rao, GITAM School of International Business for providing insightful and rich mentoring support for this project. The results of this study reflect the thoughtful input of all participants including the views of the eminent professionals in the company, solicited during the course of the interviews we had with them. Thank you to all who gave time to make this study useful. It was a most rewarding experience to work on such a challenging project. We believe that the results of this study would be helpful to TVS Logistics Services Ltd. in making thoughtful changes in the Third party logistics sector. Sincerely, Anand Vuppalapti Class of 2012-2014 Contents Page No. Preface i Acknowledgements ii CHAPTER-I: EXECUTIVE SUMMARY 4 CHAPTER-II: INTRODUCTION Overview of ERP 5 ERP Benefits and Limitations 5 CHAPTER-III: SECTOR REVIEW Indian Logistics Industry 7 Third Party Logistics 8 CHAPTER-IV: COMPANY...

Words: 10775 - Pages: 44

Free Essay

With the Development of Technology, More and More Robots Are Used in Various Fields,

...Subjects Lect/ No 1 Information and Network Security Middleware and Enterprise Integration Technologies Software Engineering Data Base Technologies Programming for Mobile and Remote Computers Information Technology for Management of Enterprise TOTAL Week 4 Scheme of Examinations Theory T/W Practical Oral Total Hours Marks Marks Marks Marks Marks 3 100 25 -25 150 Pract/ Week 2 Tut/ Week -- 2 4 2 -- 3 100 25 -- 25 150 3 4 5 4 4 4 2 2 2 ---- 3 3 3 100 100 100 25 25 25 --25 25 25 -- 150 150 150 6 4 24 10 1 1 3 -- 100 600 25 150 -25 25 125 150 900 INFORMATION AND NETWORK SECURITY CLASS T.E. ( INFORMATION TECHNOLOGY) HOURS PER LECTURES : WEEK TUTORIALS : PRACTICALS EVALUATION SYSTEM: THEORY PRACTICAL ORAL TERM WORK : SEMESTER VI 04 -02 HOURS 3 ---- MARKS 100 25 25 1. Introduction What is Information Security? Security Goals. 2. Cryptography Crypto Basic, Classic Cryptography, Symmetric Key Cryptography: Stream Ciphers, A5/1, RC4, Block Ciphers, Feistel Cipher, DES, Triple DES, AES, Public Key Cryptography: Kanpsack, RSA, Defiie-Hellman, use of public key crypto- Signature and Non-repudiation, Confidentiality and Non-repudiation, Public Key Infrastructure, Hash Function: The Birthday Problem, MD5, SHA-1, Tiger Hash, Use of Hash Function. 3....

Words: 3868 - Pages: 16