Research Of Improve The Data Quality

3046 words - 13 pages

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 ...view middle of the document...

Key words: ETL,, EMC ((ETL Manage Center),), Data WareHouse.

Table of Contents

1. . Introduction
1.1 Background
1.2 research status
1.3 The main contents of this article and content organization
2. Data warehouse and ETL
2.1 Data Warehouse
2.2 ETL (Extract, Transform, loading)
2.2.1 ETL Profile
2.2.2 ETL process Features
2.2.3 Data Quality Assurance
2.2.4 Metadata: expand Nova application
3. . ETL application in EMC project
3.1 Background
3.2 Examples
3.3 Overall Flow
3.4 Interface Table
3.4 enterprise data migration (EDM) model layer
3.5 fact surface
3.6 Data Mart (DM) layer
3.7 Online Analytical Processing (OLAP) layer
3.8 Overall flow process&feedback process
4.. Application of data scheduling&validation in EMC
4.1 Requirements Analysis
4.1.1 description of demand design
4.1.2 describe of Functional requirements

4.1.3 describe of Non-functional requirements
4.2 Design of the System
4.2.1 overall system design features
4.2.2 Description of The overall system design features
4.2.3 Description of System Functional Design
4.3 Summary of design
4.3.1 Summary function design
4.3.2 Functional Description (by function module)
4.4 Background Scheduler Process
4.4.1 Overview of ETL Task Scheduler
4.4.2 Task / Task Group instantiated
4.4.3 Task instance scheduling
4.5 validation process
4.5.1 Function
4.5.2 Data Structure
4.5.3 Process
4.5.4 Important Functions
Conclusion
Acknowledgement
References
Appendix

1 . . Introduction

1.1 Research background
With the advance of globalization and the rapid economic growth in China, most businesses intensified market competition. This enterprise management and business decision making timeliness, high science, accuracy requirements .Based only on data from the experience-based analysis to insight based on accurate facts, success rate can be guaranteed service quality, marketing and management, saving marketing costs, and ultimately to maximize profits and customer satisfaction. Data warehouse it is in this environment has emerged.
With the deepening reform of China's telecom industry monopoly has been broken, telecommunications, domestic communications market mobile, China Unicom, China Netcom, China railcom and other diversified competition, competition is becoming increasingly fierce. Telecom operator's business philosophy is moving from "Product Center" transferred to "customer-centric". Client's individualized needs of diverse, hierarchical, and mass marketing has lost its advantage, based on customer information, customer value and behavior, in-depth data analysis insight marketing, accurate marketing concept gradually accepted by the telecommunications operators. Business activities of the initiative be delivered into the hands of customers and keep existing customers becomes critical to telecommunications companies. Over the past few years in the telecommunications industry billing systems, integrated payment systems,97 system...

Other Essays Like Research of Improve the Data Quality

Improving the Quality of Life in Ghana

1753 words - 8 pages The Question: How can America help improve the quality of life for all Ghanaians without over running the nation and creating the "white man's burden" attitude? The Problems that Impede Ghanaian Success: The Diet: The Ghanaian diet lacks nutrition, vitamin and minerals thus leading to unhealthy undersized peoples. The primary staple in the Ghanaian diet are starchy plants such as the cassava, yams, and maize. Cassava and yams are

To What Extent Would the Wider Use of Referendums Improve Democracy in the Uk?

1073 words - 5 pages this vote but it can be quite safely argued that a group who can broadcast in higher quality to a larger audience is likely to win over more voters. In this way we can argue that a wider use of Referendums would improve Democracy within the U.K. Furthermore, Referendums being a tool of a Direct Democracy, does not take into account the views of minority groups of voters, leaving some a percentage of citizens unhappy about decisions that may

Oil vendors would remind: how to improve the yield efficiency of screw press

622 words - 3 pages precipitation.With the progress of the society and the improvement of rural demand, oil press industry in general is in progress, some aspects is a breakthrough in the past, in order to improve the yield efficiency, the three level 4 press, electric heating;In order to improve the product quality, increase the vacuum filtration device, etc., the developing trend for belt vacuum filter and high degree of automation, such as electric heating plate type oil press will gradually replace simple oil press. 6. The development of the industry restricting factors analysis and Suggestions to promote the development of industry www.ricebranoilplant.com

To What Extent Would Wider Use of Referendums Improve Democracy in the Uk?

837 words - 4 pages say and enforcing democracy at its simplest form. It can also lead to increased interest in politics, which would be a much needed boost amid the dwindling interest of the current population. However, there are a number of downsides to increased referendums; influence by self interested corporations, uneducated voters and lack of turnout amongst them. Therefore, although the wider use of referendums would improve democracy

The Effects of Quality Management on Domestic and Global Competition

994 words - 4 pages of quality control programs, both companies examined a detailed evaluation program. The program assists in evaluating the characteristics’ of their product and service necessities. This will also allow for the evaluation of all data used to create policy and procedure. This is done by the analysis of criteria derived from customer’s orientations and their own budget (Total Quality Management: A Continuous Improvement Process, 1996). 3

Data 
Data Are Raw Facts That Describe the Characteristics of an Event or Object. Before the Information Age, Managers Manually Collected

1890 words - 8 pages * Data 
Data are raw facts that describe the characteristics of an event or object. Before the information age, managers manually collected and analyzed data, a time-consuming and complicated task without which they would have little insight into how to run their business. Lacking data, managers often found themselves making business decisions about how many products to make, how much material to order, or how many employ- ees to hire based on

The Fundamentals of Research Methodology

1286 words - 6 pages Running head: RESEARCH METHODOLOGY The Fundamentals of Research Methodology Jonathan S. Carlson University of Phoenix The Fundamentals of Research Methodology Introduction In today’s internet age, research has taken on new developments. Electronic data bases full of journals and search engines allow an individual to peruse millions of pages of written material for specific information in a matter of minutes. Despite the

Understanding the Principles and Practices of Internally Assuring the Quality of Assessment. Unit 1

1538 words - 7 pages Unit 1 LO 1.1 Internal quality assurance (IQA) is vital throughout all educational organisations for a number of different reasons. Most fundamentally IQA should aim to ensure individuals experience quality throughout their learning journey in order to achieve their goals. From the providers perspective it is important that the credibility of both the organisation and the qualification is upheld by providing support from start to finish

Unit 301 Outcome 3.1 Summarise the Main Points of Legislation and Procedures Covering Confidentiality, Data

564 words - 3 pages of not taking illicit drugs and physical education. The students are educated and taught skills that will enable them to succeed an to achieve economic well- being and encouraged and motivated to strive for the best and made to feel they are included and accounted for and that their contribution counts to help build their own self- worth. Data Protection Act 1998 The school is required for many reasons to obtain important information regarding

The Influence of Climate and Soil Characteristics on Fruit Quality of Wine Grapes in New Zealand

3796 words - 16 pages weather (Berry, 1990). Imre & Mauk (2009) stated that More than 70% of vineyards in New Zealand are located on alluvium and gravels, and these free-draining subsurface have been the preferred location for vineyards for a long time. Soil Type Van Leeuwen et al. (2004) studied the factors that have the greatest effect on the quality of the vine grape and subsequent effects on wine quality. The variables measured in their research were berry

Impacting Organizational Learning - the Training and Experiences of Quality Award Examiners and Assessors

3664 words - 15 pages assessment process followed by a description of the research methodology and finally a discussion of the wider organizational learning benefits of applying the process in organizations. The Quality Award and Assessment Process Quality award volunteers are selected on the basis of experience, qualifications and expertise, not necessarily limited to quality management. A broad spectrum of knowledge and backgrounds are encouraged so that

Related Papers

Can It Improve The Quality Of Education In America?

581 words - 3 pages these categories: vouchers, tax credits, charter schools, magnet schools and even home schooling. # Support Proponents argue that if parents were given a choice where public funding should go, they would pick the better schools and under-performing schools would have to improve or lose funding. The main premise of school choice proponents’ arguments is that the school should be the focus of reform. Some school choice proponents hold that if a

The Quality Of Our Air Essay

739 words - 3 pages The Quality of Our Air Is the air that we are breathing killing us? In this speech you will learn all that you need to know about air pollution. First I will give you the causes of air pollution, then I will list the effects of it, and finally I will tell you how we can prevent air pollution. The average person takes about twenty thousand breaths a day, obviously air is essential to life. Well imagine that the air that you are breathing

‘Learning’ To Improve The Status Of Women In India

2455 words - 10 pages years the number of qualified teachers has increased because of increased efforts by the government and private groups to improve the general education and professional training of teachers ("Democratizing the quality," 2011). There is more of an emphasis on the training of rural teachers, whose educational backgrounds are generally not as sound as their urban counterparts. Those that refuse to teach in rural areas cite distance and lack of

The Gaps Model Of Service Quality

2184 words - 9 pages empowered employees to acquire accurate information about customers’ expectations. Formal and informal methods to capture information about customer expectations can be developed through market research. Techniques involving a variety of traditional research approaches must be used to stay close to the customer, among them customer visits, survey research, complaint systems, and customer panels. More innovative techniques, such as quality function