Remotely-sensed geophysical databases: experience and implications for generalized DBMS

ABSTRACT

This paper presents the characteristics of scientific remotely-sensed databases that are relevant to --- and pose unique challenges for --- general-purpose database management systems (DBMSs). We describe a prototype system that integrates geophysical data and its metadata from both satellite and in situ sources, using a relational general-purpose DBMS to manage the catalog and observational data, and a video optical disk to archive images. Based upon our experience with this application, we suggest augmentations to DBMSs that would facilitate their use not only for scientific databases, but also for engineering, document, and even commercial database applications.

REFERENCES

• 1: {BEET 82} A. Beetem, J. Milton, and G. Wiederhold, "Performance of Database Management Systems in VLSI Design", IEEE Database Engineering 5, 2 (June 1982), pp. 15--20.
• 2: A. Blaser, Data Base Techniques for Pictorial Applications, Springer-Verlag New York, Inc., Secaucus, NJ, 1980
• 3: {BRCK 80} Peter A. Bracken, "Earth Observation Data Systems in the 1980's", Proc. of 1980 Annual Mtg. of American Astronautical Society, Boston, MA, 20--23 Oct. 1980.
• 4: James W. Brown, Controlling the complexity of menu networks, Communications of the ACM, v.25 n.7, p.412-418, July 1982 [doi>10.1145/358557.358562]
• 5: {BRYN 76} Nevin A. Bryant and Albert L. Zobrist, "IBIS: A Geographic Information System Based on Digital Image Processing and Image Raster Datatype", Machine Processing of Remotely Sensed Data, IEEE, 1976, pp. 1A--1 to 1A--7.
• 6: {CCA 80} Computer Corporation of America, Model 204 User's Manual, Cambridge, MA, 1980.
• 7: {CHAN 81} Shi Kuo Chang and Tosiyasu L. Kunii, "Pictorial Data-Base Systems", Computer 14, 11 (November 1981), pp. 13--21.
• 8: Peter Pin-Shan Chen, The entity-relationship model—toward a unified view of data, ACM Transactions on Database Systems (TODS), v.1 n.1, p.9-36, March 1976 [doi>10.1145/320434.320440]
• 9: {CHOC 81} Margaret Chock, Alfonso F. Cardenas, and Allen Klinger, "Manipulating Data Structures in Pictorial Information Systems", Computer 14, 11 (November 1981), pp. 43--50.
• 10: {CODA 78} CODASYL Data Description Language Committee, "CODASYL Data Storage Description Language, 1978", Journal of Development, January 1978.
• 11: {COX 80} Nicholas J. Cox, Barry K. Aldred, and David W. Rhind, "A Relational Data Base System and a Proposal for a Geographic Data Type", Geo-Processing 1, (1980), Elsevier Scientific Publishing Co., Amsterdam, pp. 217--229.
• 12: {ENGL 82} J.L. Engel and Oscar Weinstein, "The Thematic Mapper: an Overview", Proc. of International Geophysical Remote Sensing Symposium, IEEE Geophysics Section, Munich, June 1982.
• 13: {GUTT 82} A. Guttman and M. Stonebraker, "Using a Relational Database Management System for Computer Aided Design Data", IEEE Database Engineering 5, 2 (June 1982), pp. 21--28.
• 14: {HASK 82a} R. Haskin and R. Lorie, "Using a Relational Database System for Circuit Design", IEEE Database Engineering 5, 2 (June 1982), pp. 10--14.
• 15: Roger L. Haskin , Raymond A. Lorie, On extending the functions of a relational database system, Proceedings of the 1982 ACM SIGMOD international conference on Management of data, June 02-04, 1982, Orlando, Florida [doi>10.1145/582353.582390]
• 16: {HLKN 79} Patrick F. Holkenbrink, Manual on Characteristics of Landsat Computer-Compatible Tapes Produced by the EROS Data Center Digital Image Processing System, Version 1.0, Change 1, USGS/NASA, U.S. Govmt. Printing Office, No. 024-001-03116-7, 1 Aug. 1979.
• 17: {JOHN 82} H.R. Johnson and D.L. Bernhardt, "Engineering Data Management Activities within the IPAD Project", IEEE Database Engineering 5, 2 (June 1982), pp. 2--9.
• 18: {KATZ 82} R.H. Katz, "DAVID: Design Aids to VLSI using Integrated Databases", IEEE Database Engineering 5, 2 (June 1982), pp. 29--32.
• 19: Won Kim, On optimizing an SQL-like nested query, ACM Transactions on Database Systems (TODS), v.7 n.3, p.443-469, Sept. 1982 [doi>10.1145/319732.319745]
• 20: {LOHM 81} Guy M. Lohman, "Generic Functional Requirements for a NASA General-Purpose Data Base Management System," JPL Internal Document No. 82--6, Jet Propulsion Laboratory, Pasadena, CA, 1 October 1981.
• 21: Mary E. S. Loomis, The 78 CODASYL database model: a comparison with preceding specifications, Proceedings of the 1980 ACM SIGMOD international conference on Management of data, May 14-16, 1980, Santa Monica, California [doi>10.1145/582250.582256]
• 22: {LPTK 78} Richard S. Lopatka and Thomas G. Johnson, "CAD/CAM Data Management Needs, Requirements and Options", Engineering and Scientific Data Management, NASA Conference Publication No. 2055, Proc. of Conf. at Langley Research Center, Hampton, VA, 18--19 May 1978, pp. 25--40.
• 23: {MARB 77} Duane F. Marble and Donna J. Peuquet, "Computer Software for Spatial Data Handling: Current Status and Future Development Needs", working paper, Geographic Information Systems Laboratory, State University of New York at Buffalo, 1977.
• 24: John L. McCarthy, Metadata Management for Large Statistical Databases, Proceedings of the 8th International Conference on Very Large Data Bases, p.234-243, September 08-10, 1982
• 25: {MEIE 82} Andreas Meier and Raymond A. Lorie, "Implicit Hierarchical Joins for Complex Objects", IBM Research Laboratory RJ3775, San Jose, Calif., February 1983.
• 26: {NCSS 77} National CSS, Inc., NOMAD Reference Manual, Norwalk, CT, June 1977.
• 27: George Nagy , Sharad Wagle, Geographic Data Processing, ACM Computing Surveys (CSUR), v.11 n.2, p.139-181, June 1979 [doi>10.1145/356770.356777]
• 28: {NASA 81} National Aeronautics and Space Administration, Applications Notice for Participation in the Landsat-D Image Quality Analysis Program, Washington, DC, 23 Oct. 1981.
• 29: Ricky Overmyer , Michael Stonebraker, Implementation of a time expert in a data base system, ACM SIGMOD Record, v.12 n.3, p.51-60, April 1982 [doi>10.1145/984505.984509]
• 30: {RAMY 83} Timothy L. Ramey, Robert R. Brown, Michael A. Melkanoff, and Guillermo Rodriguez-Ortiz, "The ELKA Information Model", Information Systems (to appear in 1983).
• 31: {RTI 82} Relational Technology, Inc. INGRES Reference Manual, Relational Technology, Inc., Berkeley, CA, 1982.
• 32: {SBS 80} SBS, Inc., The Impact of Optical Disc Memories (Videodiscs) on the Computer and Image Processing Industries, Strategic Business Services, Inc., San Jose, CA, May 1980.
• 33: P. Griffiths Selinger , M. M. Astrahan , D. D. Chamberlin , R. A. Lorie , T. G. Price, Access path selection in a relational database management system, Proceedings of the 1979 ACM SIGMOD international conference on Management of data, May 30-June 01, 1979, Boston, Massachusetts [doi>10.1145/582095.582099]
• 34: Dennis G. Severance , Guy M. Lohman, Differential files: their application to the maintenance of large databases, ACM Transactions on Database Systems (TODS), v.1 n.3, p.256-267, Sept. 1976 [doi>10.1145/320473.320484]
• 35: Arie Shoshani, Statistical Databases: Characteristics, Problems, and some Solutions, Proceedings of the 8th International Conference on Very Large Data Bases, p.208-222, September 08-10, 1982
• 36: Michael Stonebraker , Kenneth Keller, Embedding expert knowledge and hypothetical data bases into a data base system, Proceedings of the 1980 ACM SIGMOD international conference on Management of data, May 14-16, 1980, Santa Monica, California [doi>10.1145/582250.582261]
• 37: {STON 82a} Michael Stonebraker, "Application of Artificial Intelligence Techniques to Database Systems", Memorandum No. UCB/ERL M82/31, Electronics Research Laboratory, Univ. of CA, Berkeley, CA, 6 May 1982.
• 38: {STON 82b} Michael Stonebraker, et al. "Document Processing in a Relational Data Base System", Memorandum No. UCB/ERL M82/32, Electronics Research Laboratory, Univ. of CA, Berkeley, CA, 6 May 1982.
• 39: Michael Stonebraker , Joseph Kalash, TIMBER: A Sophisticated Relation Browser (Invited Paper), Proceedings of the 8th International Conference on Very Large Data Bases, p.1-10, September 08-10, 1982
• 40: Tateyuki Tsurutani , Yutaka Kasahara , Masaru Naniwada, ATLAS: A geographic database system data structure and language design for geographic information, ACM SIGGRAPH Computer Graphics, v.14 n.3, p.71-77, July 1980
• 41: {ZBRS 81} Albert L. Zobrist and George Nagy, "Pictorial Information Processing of Landsat Data for Geographic Analysis", Computer 14, 11 (November 1981), pp. 34--41.