Abstract
 Design and Development of the USDA Geospatial Data Warehouse Track: Database Design, Automation, and Management Author(s): Kevin Clarke, Art Ullman USDA has created a geospatial data warehouse for managing and serving authoritative geospatial data to USDA agencies in support of the many agricultural and conservation based programs the USDA administers. The GDW is a multi-site, multi-server warehouse, consisting of raster and vector data sets that are managed by ArcSDE 9 in SQL Server 2000 databases hosted on Windows Server platforms. EMC SAN technology is utilized to provide data storage. All warehouse data is replicated to a fail-over site using a combination of EMC SRDF and SQL Server log shipping. The GDW currently manages in excess of 30 terrabytes of raster and vector data via ArcSDE and StorageTek near-line storage systems. This paper will provide a technical design overview of the USDA Geospatial Data Warehouse and discuss in greater detail several of the design techniques and implementation details utilized within GDW to maximize the benefit of the substantial cost outlay for the project. Kevin Clarke USDA/FSA/APFO 2222 W 2300 S Salt Lake City , UT 84119 US Phone: 801.975.3500 E-mail: kclarke4@csc.com Art Ullman USDA/NRCS/NCGC Fort Worth Federal Center 501 West Felix Street, Building 23 Fort Worth , TX 76115 US Phone: 801-673-8948 E-mail: aullman@ftw.nrcs.usda.gov |
|||||
