The GeoStor System: Case Study
1. Why is a data warehouse needed in the GeoStor system?
Answer: A data warehouse contain pool of data both current and of the past/historical which in turn are used to support decision making by the managers., Without it, GeoStor would lack the variety of data it needs to be able to perform different tasks for different functions. 2. List the major benefits of GeoStor to Arkansas and to private-sector users.
Answer: GeoStore is used by Arkansas state agencies for different tasks such as reducing the time needed to search for documents by a factor of 15 thereby reducing time from 23.5 hours per document to 1.5 hours. This saved $2 million of tax payer’s money in the first 18 months it was in place. It also improved access data with regards to education, transport data about the state of highways that require repair. Also in case of emergency with the up to date data, it benefits the personnel on ground to plan for recovery in a fast manner accordingly.
GeoStor is used by private sector users in that they can obtain information about what Arkansas can offer them in terms of area or location for a new plant, raw materials nearby aiding in decision making of the new plant, infrastructure in place nearby for smooth transition of product are some of the benefits. 3. Check Oracle’s Map Viewer and comment about its data visualization capabilities.
Answer: Oracle’s Map Viewer is the visualization component that supports location-based data. It is used by developers to build and display maps on the web browser. It is not directly used by end users who need to look at location-based data. Oracle Map Viewer is used to display a wide variety of maps in multiple formats using non-spatial data. Some of its advantages are that it can display a map on a pre-defined base map in addition to artwork, visual, 3D structures display. These can incorporate change in background color, size, image format, and notations. These
Answer: A data warehouse contain pool of data both current and of the past/historical which in turn are used to support decision making by the managers., Without it, GeoStor would lack the variety of data it needs to be able to perform different tasks for different functions. 2. List the major benefits of GeoStor to Arkansas and to private-sector users.
Answer: GeoStore is used by Arkansas state agencies for different tasks such as reducing the time needed to search for documents by a factor of 15 thereby reducing time from 23.5 hours per document to 1.5 hours. This saved $2 million of tax payer’s money in the first 18 months it was in place. It also improved access data with regards to education, transport data about the state of highways that require repair. Also in case of emergency with the up to date data, it benefits the personnel on ground to plan for recovery in a fast manner accordingly.
GeoStor is used by private sector users in that they can obtain information about what Arkansas can offer them in terms of area or location for a new plant, raw materials nearby aiding in decision making of the new plant, infrastructure in place nearby for smooth transition of product are some of the benefits. 3. Check Oracle’s Map Viewer and comment about its data visualization capabilities.
Answer: Oracle’s Map Viewer is the visualization component that supports location-based data. It is used by developers to build and display maps on the web browser. It is not directly used by end users who need to look at location-based data. Oracle Map Viewer is used to display a wide variety of maps in multiple formats using non-spatial data. Some of its advantages are that it can display a map on a pre-defined base map in addition to artwork, visual, 3D structures display. These can incorporate change in background color, size, image format, and notations. These
References: Efraim T, (2007). Business Intelligence: A Managerial Approach: pgs 128–129.