|
Track: Business Services: Marketing and Advertising
Jan van Berkel
Logisterion
Groothandelsgebouw A4
Stationsplein 45
Rotterdam, AK 3013
THE NETHERLANDS
Telephone: 011-31-10-217-0700
Fax: 011-31-10-413-9693
Bert Vermeij
Data Warehouse - Where To Locate GIS
In supporting decision making and planning, information about the business, products, and customers is most important. The data on which this decision making is based are very widespread and are being physically kept in different places, stored in transaction-based systems, accessible mostly in one way, and consisting of a huge amount of data. In most cases data are present; the problem is the inadequacy, accessibility, form, performance, and availability of the data. Data warehousing is not a technology; it is an information technology system. A data warehouse is a collection of data stored in an orderly and accessible way. Facts and related data in a data warehouse are being used for better analyses and decision support making. The basic characteristics of data in a data warehouse are consistent, subject-oriented, integrated, time-variant, and nonvolatile. Data warehousing makes it possible to view operational data in a multidimensional way and turns data into information. The advantages of using a
data warehouse lie in the better understanding of the business, the possibilities of the customer being served better, better understanding of the business risks, improvement of the business processes, and being able to make more tailor-made products and services. The spatial component in the data warehouse architecture consists of three parts. First, the tool to geocode data and spatial aggregation; second, the spatial database; and third, analyses and presentation. The most important attraction of integrating GIS in your data warehouse is being able to make dynamically geographic queries on your data and to aggregate your data to geographic areas. Logisterion has executed projects for a telecommunications company, public housing, and the ministry of public works. Although these experiences are in some cases at early stage, it is clear that there are several ways to look at a data warehouse in combination with a GIS. In all cases we see many benefits of data warehousing with a spatial component and
its additional value to the business._
|
|
