Integrating GIS and data warehousing in a Web environment: A case study of the US 1880 Census

While the business intelligence sector, involving data warehouses and online analytical processing (OLAP) technologies, is experiencing strong growth in the IT marketplace, relatively little attention has been devoted to the problem of utilizing such tools in conjunction with GIS. This study contributes to the development of this research area by examining the issues involved in the design and implementation of an integrated data warehouse and GIS system that delivers analytical OLAP and mapping results in real-time across the Web. The case study chosen utilizes individual records from the US 1880 population census, which have recently been made available by the North Atlantic Population Project. Although historical datasets of this kind present a number of challenges for data warehousing, the results indicate that the integrated approach adopted offers a much more flexible and powerful analytical methodology for this kind of large social science dataset than has hitherto been available.