Importance of Datawarehousing

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.

Reference
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
URL: http://0-ieeexplore.ieee.org.opac.library.csupomona.edu/stamp/stamp.jsp?tp=&arnumber=6021598&isnumber=6021499

9 thoughts on “Importance of Datawarehousing”

  1. As amateur database managers, we find more and more rules that we must adhere too. We must learn that everything is about quality, quality, and quality. We cannot afford to lose quality in security, integrity of data, and managing information. All it takes is one mistake before the curtains will fall down for everything.

  2. Its definitely important to ensure that the data that companies are working with is correct. There's a lot of quality checks that must be made to keep the data free from corruption. If a company ends up working with incorrect data that could impact them greatly in terms of time and information. Since companies have to manage a lot of data, it's very important to keep things organized.

  3. Great article, it provides insight into how to categorize data. I had been wondering how these companies plan for consolidating their data. It also directly relates to our in-class discussion about how this happens with acquisitions and mergers.

  4. good article, i found it interesting that ISO came in and set standards. It is also good to know how the data is categorized and that the companies have to abide by a set standard for putting the data into categories.

  5. Very informative. I agree that the issue of data warehouse use to have is missing data or data located at different area that is hard to find. Thank you for posting this article Jorge.

  6. Nice article. It seem understandable that there is a rise to the use of data warehouses. You want to make sure that the information in your system is correct because as you stated, incorrect results will be unacceptable when trying to base a decision on that information. This just shows the importance of why data quality is so important!

  7. Being in the information age and with data being collected almost all the time , I agree that the quality of data is very important in any organization. It doesn't matter if you have a well designed database or data warehouse if you have data that lacks in quality then it is not much us and just a waste of space.

  8. Is very true that QUALITY is the key for data warehouse. Without quality it can jeopardize a company.

Comments are closed.