Data warehouse architecture for GIS applications

ABSTRACT

Geo-data sets are built for use in geographical information systems (GIS). The data is modeled to suit the needs of data entry and visual representations. They are optimized for simplicity and speed of modification. These models do not lend themselves to efficiently produce enterprise reports. Hence, Geo-data sets can be very challenging to query and analyze. In this paper, we create a data warehouse (DW) for a geo-dataset to facilitate report generating processes. A data warehouse is attractive as the main repository of an organization's historical data and is optimized for reporting and analysis. For better understanding of the developed architecture, we cover the data warehouse construction process as well as the enterprise data model

REFERENCES

• 1: ESRI GIS and Mapping Software. - U.S. Census Bureau. - 04 17, 2007. http://www.esri.com/data/download/census2000_tigerline/description.html.
• 2: ESRI GIS and Mapping Software. ESRI Press, 07 1998. www.esri.com/library/whitepapers/pdfs/shapefile.pdf.
• 3: Data modeling techniques for data warehousing, IBM Corp., Riverton, NJ, 1998
• 4: Census 2000 Redistricting Data (Public Law 94--171) Summary File. - California: U.S. Census Bureau, 2001.
• 5: Census 2000 Summary File 1 United States. - California: U.S. Census Bureau, 2001.
• 6: Surajit Chaudhuri , Umeshwar Dayal, An overview of data warehousing and OLAP technology, ACM SIGMOD Record, v.26 n.1, p.65-74, March 1997 [doi>10.1145/248603.248616]
• 7: ESRI Shapefile Technical Description, an ESRI White Paper, ESRI GIS and Mapping Software. - July 1998. http://www.esri.com/library/whitepapers/pdfs/shapefile.pdf.
• 8: Robson F., et al., GeoDWFrame: A Framework for Guiding the Design of Geographical Dimensional Schemas - Pernambuco: s.n., 2004.
• 9: Matteo Golfarelli , Dario Maio , Stefano Rizzi, Conceptual Design of Data Warehouses from E/R Schema, Proceedings of the Thirty-First Annual Hawaii International Conference on System Sciences-Volume 7, p.334, January 06-09, 1998 [doi>10.1109/HICSS.1998.649228]
• 10: Greenfield L., The Data Warehousing Information Center. LGI Systems Incorporated, 2006. www.dwinfocenter.org/
• 11: Nenad Jukic, Modeling strategies and alternatives for data warehousing projects, Communications of the ACM, v.49 n.4, p.83-88, April 2006 [doi>10.1145/1121949.1121952]
• 12: Ralph Kimball , Laura Reeves , Warren Thornthwaite , Margy Ross , Warren Thornwaite, The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom, John Wiley & Sons, Inc., New York, NY, 1998
• 13: Kimball R. and Caserta J., The Data Warehouse ETL Toolkit- Indianapolis: Wiley Publishing, Inc., 2004.
• 14: Rifaei M., Kianmehr K., Ridley M. and Alhajj R., "Data Warehouse Architecture for GIS," Proceedings of IEEE International Conference on Information Reuse and Integration, Las Vegas, Jul. 2008.
• 15: Designing data marts for data warehouses, ACM Transactions on Software Engineering and Methodology (TOSEM), v.10 n.4, p.452-483, Oct. 2001 [doi>10.1145/384189.384190]
• 16: Stephen R. Gardner, Building the data warehouse, Communications of the ACM, v.41 n.9, p.52-60, Sept. 1998 [doi>10.1145/285070.285080]
• 17: Paolo Giorgini , Stefano Rizzi , Maddalena Garzetti, Goal-oriented requirement analysis for data warehouse design, Proceedings of the 8th ACM international workshop on Data warehousing and OLAP, November 04-05, 2005, Bremen, Germany [doi>10.1145/1097002.1097011]
• 18: Narasimhaiah Gorla, Features to consider in a data warehousing system, Communications of the ACM, v.46 n.11, p.111-115, November 2003 [doi>10.1145/948383.948389]
• 19: Microsoft Corporation, Data Warehouse Design Considerations. Retrieved on January 2008 from http://www.microsoft.com/technet/prodtechnol/sql/2000/resk it/part5/c1761.mspx
• 20: Arun Sen , Atish P. Sinha, A comparison of data warehousing methodologies, Communications of the ACM, v.48 n.3, p.79-84, March 2005 [doi>10.1145/1047671.1047673]
• 21: Robert Winter , Bernhard Strauch, Information requirements engineering for data warehouse systems, Proceedings of the 2004 ACM symposium on Applied computing, March 14-17, 2004, Nicosia, Cyprus [doi>10.1145/967900.968174]
• 22: Leopoldo Zepeda , Matilde Celma , Ramón Zatarain, A methodological framework for conceptual data warehouse design, Proceedings of the 43rd annual Southeast regional conference, March 18-20, 2005, Kennesaw, Georgia [doi>10.1145/1167350.1167424]

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.7 Database Administration

General Terms:
Design, Documentation, Management, Standardization

Keywords:
GIS system, data warehouse architecture, data warehouse design, enterprise data model