SUMMARY
Data warehouses are the focus for large companies today, as one of the constitutive They Mainstays for the process of managerial decision making, Henco The Importance of information is stored on reliable and quality Them. One of the Process in the construction of These and Helps to Achieve this goal is data cleansing, and together With The Standardization of addresses. To Communicate Effectively with customers by phone or by mail, a company must-Maintain a list of customers exceptionally clean and With Their Standardized way. This avoids Problems Such as loss of Credibility and image of the organization, making holly shipments to customers and give faster and more professional service.
INTRODUCTION
From The Beginning, the database Became a fundamental tool of control and management of Business Operations. So in a FEW years in large companies and Business Was A considerable amount of information stored in data sources and Theses Different Already HAD REACH considerably large size.
With This large Accumulation of information, the directors of companies and Business on Such That This Could Have A Useful purpose, to be Reflected MOST of business DURING ITS Business Operations Called Themselves the market cycles.
In turn, business markets undergone a radical transformation Have. Companies demand faster and more efficient delivery of products, and improvement in all Existing services, so it is essential to find more Effective Ways of Distributing the product, more facilities for market research information based on Operations companies’ business and Its customers and, ultimately, faster time to make decisions.
So I Thought It Would Be Different ideal to unify the available sources of information Which, in one place, to Which only relevant information is incorporated on the basis of an Organized structure, integrated, logical, dynamic and easy Exploitation. The answer to this WAS the Data Warehouse or Data Warehouse (DW).
Howeve, to make efficient use of historical information stored in a DW for aid to decision making vital to Ensure That WAS These data are readily available, Standardized and reliable.
Still, the problem of data cleansing is little or preventer Treated by Many companies, not adequately Consider the Business Impact of imperfect information stored HAVING.
Data stores. BASICS
A Data Warehouse or Data Warehouse (DW) is a topic-oriented information store to meet the Needs of Applications of Decision Support Systems (DSS) and Executive Information (EIS), Which allows access to corporate information management, control and support decision making [ 4].
This information is built from the business databases record That Transactions of Organizations (Operational Database), and Its Importance elements is as the Following:
Contribute to making tactical Phone People and Strategic Decisions by Providing automated way to Identify key information from volumes of data generated by software or Processes traditional elements.
Possible to measure the actions and results in a better way.
Business Processes Can be optimized. The time wasted waiting for information is incorrect or That Eventually found, it is removed.
It allows users to prioritize Decisions and actions, for example, Which Should Be Addressed customer segments marketing the Following Activities.
In general, a DW is a data set With The Following characteristics:
Thematic
The data are stored by subject or subjects (customers, Campaigns, products). These are from the perspective of Organized end users, while the Operational databases are from the perspective of Organized Implementation with a view to Achieving Greater efficiency in data access
Integrated
All data stored in the DW are integrated. The Operational database-oriented Applications Have Been Created Without Thought of Their integration, so That the Same type of data Can Be Expressed Differently in Different Operational two databases (eg, to Represent sex, ‘Female’ and ‘masculine’ or ‘F’ and ‘M’).
Nonvolatile
There are only two types of Operations in the DW: loading data from ‘operational environments (initial load and periodic load) and consulted Them. The data update is not normal part of the Operations of a DW.
Historical
The time must be present in all the records Contained in a DW. The Operational databases Contain the current values of the data, while the DW Contain current information and summaries of This in time.
ARCHITECTURE
The functional blocks to A Comprehensive That information CORRESPONDENCE That Uses a DW system are:
Operational Level
It contains primitive data (Operational) That are Being Constantly updated, used by traditional operating systems transactional That Perform Operations.
DW data warehouse or
It contains primitive data for loads and Some Successive data from DW. The data are derived from data generated from the primitive to Apply Some data processing (abstracts).