Processing Data for Data Warehouses

by Andrew M
The article I read was entitled “Research on Data Processing of Bank Credit System” by Guorong Xiao. This article was about the processing of date that happens to populate data warehouses. The author specifically talks about how this process works in the banking system. The steps involved in data processing are data extraction, data transformation, data loading process and the design of a data processing model. The author identifies the most important of this process as being the data processing model. This can be broken down into parts which are data source analysis, estimating the amount of data, data extraction design, data transformation, data cleaning, data loading and finally data validation. All of these processes are needed in order to have a fully functional data warehouse. The author goes to talk about how banks are using data warehouses extensively specifically in regards to credit. Banks can now do more detailed credit analysis of a potential customer with the use of data warehouses.

I found this article extremely interesting and relevant. In class we are talking about data warehousing and this article goes through the full process of creating, designing and the upkeep of a data warehouse. It also talks about the costs and problems that are involved with these processes. The only thing I did not like was that I felt the author could not write English very well. This made the article confusing and hard to read at times. I felt an editor could have been used and this article would have been made a lot better.

I know from personal experience how important data can potentially be. At the company I used to work for we used databases and data warehousing to hold important information about clients. The company was able to predict when clients would be buying more supplies for their machines and accurately predict when they need to create more stock to provide parts for the customers.

 

Guorong Xiao; , “Research on Data Processing of Bank Credit System,” Communication Systems and Network Technologies (CSNT), 2012 International Conference on , vol., no., pp.905-908, 11-13 May 2012
URL: http://0-ieeexplore.ieee.org.opac.library.csupomona.edu/stamp/stamp.jsp?tp=&arnumber=6200767&isnumber=6200561

5 thoughts on “Processing Data for Data Warehouses

  • November 25, 2012 at 1:42 pm
    Permalink

    This is a great post. I had not heard of data warehousing prior to this course, however from articles I have read, it seems to have a powerfully positive impact on organizations. Companies can better manage and access their data, and in one article I read, it totally changed a company around!

  • November 25, 2012 at 2:51 pm
    Permalink

    interesting article. I can see how database warehouse is helpful in banking especially nowadays when someone apply for a credit card online they’re immediately know if the card is approved or not within less than 2 minutes. This save a lot of time for both parties. I also like the example you give at your work place. It’s easy to understand.

  • November 25, 2012 at 2:58 pm
    Permalink

    I think data warehousing is good because it can benefit business predict customer’s behaviors and helps them enhance activities beneficial to their business. However, as a regular customer it is certainly creepy to just think about how companies are utilizing technology to certainly track people’s behavior and makes me feel that we are under a big scope that tracks all the things we do and invade our privacy.

  • November 25, 2012 at 2:58 pm
    Permalink

    Nice post! As far as I know, when design the data warehouse, both logical design and physical design are needed. The logical design is more conceptual and abstract than the physical design. In the logical design, we look at the logical relationships among the objects. In the physical design, we look at the most effective way of storing and retrieving the objects as well as handling them from a transportation and backup/recovery perspective. Thanks for sharing

  • November 25, 2012 at 3:20 pm
    Permalink

    Nice post! Making good use of data warehouse to report and analysis is definitely one of the most important way in finding out potential threads of the company itself and its customers and finally leading the company to success. It is the same to banks that applying the system model and methods in bank credit system not only help banks to better evaluate borrowers but also help banks in making better and faster decisions and plans.

Comments are closed.