skip to main content
10.1145/1497308.1497344acmconferencesArticle/Chapter ViewAbstractPublication PagesiiwasConference Proceedingsconference-collections
research-article

Data warehouse architecture for GIS applications

Published: 24 November 2008 Publication History

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]
Ballard Chuck et al. Data Modeling Techniques for Data Warehousing. - San Jose: International Business Machines Corporation, 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]
Chaudhuri, S. and Dayal, U. 1997. An overview of data warehousing and OLAP technology. SIGMOD Records, Vol. 26, No. 1, pp. 65--74, Mar. 1997.
[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]
Golfarelli M., Maio D., and Rizzi, S., Conceptual Design of Data Warehouses from E/R Schema. In Proceedings of the Annual Hawaii international Conference on System Sciences- January 1998. HICSS.
[10]
Greenfield L., The Data Warehousing Information Center. LGI Systems Incorporated, 2006. www.dwinfocenter.org/
[11]
Jukic N., Modeling Strategies and Alternatives for Data Warehousing Projects. Communications of. ACM, Vol. 49, No. 4, pp. 83--88, 2006.
[12]
Kimball R., et al., The Data Warehouse Lifecycle Toolkit, New York: Wiley Computer Publishing, 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]
Bonifati, A., Cattaneo, F., Ceri, S., Fuggetta, A., and Paraboschi, S., Designing data marts for data warehouses. ACM Transactions on Software Engineering and Methodology. Vol. 10, No. 4, October 2001.
[16]
Gardner, S., Building the data warehouse. Communications of the ACM. Vol. 41, No. 9, September 1998.
[17]
Giorgini, P. Rizzi, S., and Garzetti, M., Goal-oriented requirement analysis for data warehouse design. Proceedings of the 8th ACM international workshop on Data warehousing and OLAP. Germany: Bremen, November 2005.
[18]
Gorla, N., Features to consider in a data warehousing system. Communications of the ACM. Vol. 46, No. 11, November 2003.
[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]
Sen, A., and Sinha, A., A comparison of data warehousing methodologies. Communications of the ACM. Vol. 48, No. 3, March 2005.
[21]
Winter, R., and Strauch, B., Information requirements engineering for data warehouse systems. Proceedings of ACM symposium on applied computing. Cyprus: Nicosia, March 2004.
[22]
Zepeda, L., Celma, M., and Zatarain, R., A methodological framework for conceptual data warehouse design. Proceedings of the 43rd ACM southeast conference. GA: Kennesaw, March 2005.

Cited By

View all
  • (2010)Development of a business intelligence environment for e-gov using open source technologiesProceedings of the 12th international conference on Data warehousing and knowledge discovery10.5555/1881923.1881944(203-214)Online publication date: 30-Aug-2010
  • (2010)Design and Implementation of an Environmental Data Warehouse System2010 2nd International Conference on Information Engineering and Computer Science10.1109/ICIECS.2010.5678254(1-4)Online publication date: Dec-2010

Index Terms

  1. Data warehouse architecture for GIS applications

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    iiWAS '08: Proceedings of the 10th International Conference on Information Integration and Web-based Applications & Services
    November 2008
    703 pages
    ISBN:9781605583495
    DOI:10.1145/1497308
    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

    Sponsors

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 24 November 2008

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. GIS system
    2. data warehouse architecture
    3. data warehouse design
    4. enterprise data model

    Qualifiers

    • Research-article

    Conference

    iiWAS08
    Sponsor:

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)1
    • Downloads (Last 6 weeks)0
    Reflects downloads up to 18 Feb 2025

    Other Metrics

    Citations

    Cited By

    View all
    • (2010)Development of a business intelligence environment for e-gov using open source technologiesProceedings of the 12th international conference on Data warehousing and knowledge discovery10.5555/1881923.1881944(203-214)Online publication date: 30-Aug-2010
    • (2010)Design and Implementation of an Environmental Data Warehouse System2010 2nd International Conference on Information Engineering and Computer Science10.1109/ICIECS.2010.5678254(1-4)Online publication date: Dec-2010

    View Options

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Figures

    Tables

    Media

    Share

    Share

    Share this Publication link

    Share on social media