Article

Free access

Microsoft TerraServer: a spatial data warehouse

Authors:

Tom Barclay,

Jim Gray,

Don SlutzAuthors Info & Claims

SIGMOD '00: Proceedings of the 2000 ACM SIGMOD international conference on Management of data

Pages 307 - 318

https://doi.org/10.1145/342009.335424

Published: 16 May 2000 Publication History

PDF eReader

Abstract

Microsoft® TerraServer stores aerial, satellite, and topographic images of the earth in a SQL database available via the Internet. It is the world's largest online atlas, combining eight terabytes of image data from the United States Geological Survey (USGS) and SPIN-2. Internet browsers provide intuitive spatial and text interfaces to the data. Users need no special hardware, software, or knowledge to locate and browse imagery. This paper describes how terabytes of “Internet unfriendly” geo-spatial images were scrubbed and edited into hundreds of millions of “Internet friendly” image tiles and loaded into a SQL data warehouse. All meta-data and imagery are stored in the SQL database.

TerraServer demonstrates that general-purpose relational database technology can manage large scale image repositories, and shows that web browsers can be a good geo-spatial image presentation system.

References

[1]

Barclay, T., et. al., The Microsoft TerraServer, Microsoft Technical Report MS TR 98 17, Microsoft Corp, Redmond, WA. http://research.microsoft.com/scripts/pubDB/pubsasp.a sp?RecordID=155

Google Scholar

[2]

F. Davis, W. Farrell, Jim Gray, R. Mechoso, R. Moore, S. Sides, M. Stonebraker., "EOSDIS Alternative Architecture Final Report," Sept., 1994, http://research.microsoft.com/~gray/EOS_DIS/

Google Scholar

[3]

B. Kobler, J. Berbert, P. Caulk, P. C. Hariharan: "Architecture and Design of Storage and Data Management for the NASA Earth Observing System Data and Information System (EOSDIS)". IEEE Symposium on Mass Storage Systems 1995: 65-76

Digital Library

Google Scholar

[4]

Laurence Moore, "Transverse Mercator Projections and U.S. Geological Survey Digital Products", U.S. Geological Survey, Professional Paper.

Google Scholar

[5]

Arther H. Robinson, Joel L. Morrison, Phillip C. Muehrcke, A. Jon Kimerling, Stehen C. Guptill, Elements of Cartography, Sixth Edition, John Wiley & Sons, Inc., U.S.A. 1995, ISBN 0-471-55579-7.

Google Scholar

[6]

H. Samet, The Design and Analysis of Spatial Data Structures, Addison-Wesley, Reading, MA, 1990. ISBN 0-201-50255-0.

Digital Library

Google Scholar

[7]

Snyder, J.P., "An Album of Map Projections", U.S. Geological Survey, Professional Paper, 1453, (1989).

Google Scholar

[8]

Microsoft SQL Server 7.0 http://microsoft.com/SQL/

Google Scholar

Cited By

View all

Uta AGhit BDave ARellermeyer JBoncz P(2022)In-Memory Indexed Caching for Distributed Data Processing2022 IEEE International Parallel and Distributed Processing Symposium (IPDPS)10.1109/IPDPS53621.2022.00019(104-114)Online publication date: May-2022
https://doi.org/10.1109/IPDPS53621.2022.00019
Godfrey B(2022)Image Files, Web Services, Web Applications, and Partnerships: Two Decades of Managing Digital Georeferenced Aerial Imagery Collections of IdahoJournal of Map & Geography Libraries10.1080/15420353.2022.204152917:1(39-57)Online publication date: 25-Apr-2022
https://doi.org/10.1080/15420353.2022.2041529
Tang XYao XLiu DZhao LLi LZhu DLi G(2021)A Ceph-based storage strategy for big gridded remote sensing dataBig Earth Data10.1080/20964471.2021.19897926:3(323-339)Online publication date: 27-Dec-2021
https://doi.org/10.1080/20964471.2021.1989792
Show More Cited By

Index Terms

Microsoft TerraServer: a spatial data warehouse
1. Human-centered computing
  1. Visualization
    1. Visualization application domains
      1. Geographic visualization
2. Information systems

Recommendations

Microsoft TerraServer: a spatial data warehouse

Microsoft® TerraServer stores aerial, satellite, and topographic images of the earth in a SQL database available via the Internet. It is the world's largest online atlas, combining eight terabytes of image data from the United States Geological Survey (...
Interacting with image collections: visualisation and browsing of image repositories
MM '12: Proceedings of the 20th ACM international conference on Multimedia

In this tutorial paper, we look at a variety of techniques and methods for effective and intuitive image database visualisation and browsing. While interaction with traditional image retrieval systems can lead to a confusing and frustrating user ...
Interactive exploration of large remote image databases
MM '12: Proceedings of the 20th ACM international conference on Multimedia

Mapping-based visualisations of image databases are well suited to users wanting to survey the overall content of a collection. Given the large amount of image data contained within such visualisations, however, this approach has yet to be applied to ...

Comments

Information & Contributors

Information

Published In

SIGMOD '00: Proceedings of the 2000 ACM SIGMOD international conference on Management of data

May 2000

604 pages

ISBN:1581132174

DOI:10.1145/342009

Chairmen:
Maggie Dunham
Southern Methodist Univ.
,
Jeffrey F. Naughton
Univ. of Wisconsin-Madison
,
Weidong Chen
Southern Methodist Univ.
,
Nick Koudas
AT &T Labs

ACM SIGMOD Record Volume 29, Issue 2
June 2000
609 pages
ISSN:0163-5808
DOI:10.1145/335191
Editors:
Weidong Chen
Southern Methodist Univ., Dallas, TX
,
Jeffrey Naughton
Univ. of Wisconsin-Madison, Madison
,
Philip A. Bernstein
Microsoft
Issue’s Table of Contents

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]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 16 May 2000

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Article

Conference

SIGMOD/PODS00

Sponsor:

SIGMOD

SIGMOD/PODS00: ACM International Conference on Management of Data and Symposium on Principles of Database Systems

May 15 - 18, 2000

Texas, Dallas, USA

Acceptance Rates

SIGMOD '00 Paper Acceptance Rate 42 of 248 submissions, 17%;

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

67
Total Citations
View Citations
464
Total Downloads

Downloads (Last 12 months)150
Downloads (Last 6 weeks)27

Reflects downloads up to 25 Dec 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Uta AGhit BDave ARellermeyer JBoncz P(2022)In-Memory Indexed Caching for Distributed Data Processing2022 IEEE International Parallel and Distributed Processing Symposium (IPDPS)10.1109/IPDPS53621.2022.00019(104-114)Online publication date: May-2022
https://doi.org/10.1109/IPDPS53621.2022.00019
Godfrey B(2022)Image Files, Web Services, Web Applications, and Partnerships: Two Decades of Managing Digital Georeferenced Aerial Imagery Collections of IdahoJournal of Map & Geography Libraries10.1080/15420353.2022.204152917:1(39-57)Online publication date: 25-Apr-2022
https://doi.org/10.1080/15420353.2022.2041529
Tang XYao XLiu DZhao LLi LZhu DLi G(2021)A Ceph-based storage strategy for big gridded remote sensing dataBig Earth Data10.1080/20964471.2021.19897926:3(323-339)Online publication date: 27-Dec-2021
https://doi.org/10.1080/20964471.2021.1989792
Wei HYuheng Z(2017)The Massive Remote Sensing Data Organization and Management StrategiesMATEC Web of Conferences10.1051/matecconf/201712802011128(02011)Online publication date: 25-Oct-2017
https://doi.org/10.1051/matecconf/201712802011
Suh YSnodgrass RCurrim S(2017)An empirical study of transaction throughput thrashing across multiple relational DBMSesInformation Systems10.1016/j.is.2016.12.00466:C(119-136)Online publication date: 1-Jun-2017
https://dl.acm.org/doi/10.1016/j.is.2016.12.004
Li SCheng CChen BMeng L(2016)Integration and management of massive remote-sensing data based on GeoSOT subdivision modelJournal of Applied Remote Sensing10.1117/1.JRS.10.03400310:3(034003)Online publication date: 14-Sep-2016
https://doi.org/10.1117/1.JRS.10.034003
Gao FJiang PLi XWang H(2015)A massive tile data organization and management strategy based on file tree2015 2nd IEEE International Conference on Spatial Data Mining and Geographical Knowledge Services (ICSDM)10.1109/ICSDM.2015.7298047(171-174)Online publication date: Jul-2015
https://doi.org/10.1109/ICSDM.2015.7298047
Predoehl AMorris SBarnard K(2013)A Statistical Model for Recreational Trails in Aerial ImagesProceedings of the 2013 IEEE Conference on Computer Vision and Pattern Recognition10.1109/CVPR.2013.50(337-344)Online publication date: 23-Jun-2013
https://dl.acm.org/doi/10.1109/CVPR.2013.50
Lü XCheng CGong JGuan L(2011)Review of data storage and management technologies for massive remote sensing dataScience China Technological Sciences10.1007/s11431-011-4549-z54:12(3220-3232)Online publication date: 25-Aug-2011
https://doi.org/10.1007/s11431-011-4549-z
Quinn SGahegan M(2010)A Predictive Model for Frequently Viewed Tiles in a Web MapTransactions in GIS10.1111/j.1467-9671.2010.01191.x14:2(193-216)Online publication date: Apr-2010
https://doi.org/10.1111/j.1467-9671.2010.01191.x
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

Microsoft TerraServer: a spatial data warehouse

Interacting with image collections: visualisation and browsing of image repositories

Interactive exploration of large remote image databases