Importance of Datawarehousing{9}

by Jorge R
My article talks about the rise in use of data warehouse systems by companies in order to store their data. The increase of data integration led to a problem, if the quality of the data being inputted was inconsistent or incorrect. The incorrect resulted data would be unacceptable when trying to base a decision from the information. In order to combat this issue, the source files need to be handled in a precise manner to have the process run without any problems. The quality characteristics that form quality management (QM) are as follows:

i.   Quality policy: Established overall quality related to intentions and goals of an organization.

ii.   Quality planning: Set quality objective, specifying the processes and related resources that are necessary to fulfill these objectives.

iii. Quality control: Execute the process to fulfill quality requirements.

iv. Quality assurance: Provide confidence that the quality requirements will be achieved.

v.   Quality improvement: Increase the ability to fulfill quality requirements.

In order to improve the quality of the data, the ISO 9000 family of standards were developed by International Organization for Standardization (ISO). The article has a lot of diagrams and bullet points trying to illustrate the process on how to properly interpret the data and try to categorize the massive amounts of data being stored. The focus of the article was to explain to the reader the importance of understanding the process first, to properly category data from external and internal sources.

Reading this article gave me insight as to how important data can be to a business. One of the major problems associated with data warehouse inconsistencies include, missing data or miss categorized data. The article goes in to good detail about all the different process in order to prepare the right system for your business specific needs. This relates to the class because of the discussion we had about data warehouse and data marts. This can be useful information for students wanting to learn more about data warehouses or trying to be the engineer that puts and maintain these systems.

Idris, N.; Ahmad, K.; , “Managing Data Source quality for data warehouse in manufacturing services,” Electrical Engineering and Informatics (ICEEI), 2011 International Conference on , vol., no., pp.1-6, 17-19 July 2011
doi: 10.1109/ICEEI.2011.6021598