This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
An Efficient Pictorial Database System for PSQL
May 1988 (vol. 14 no. 5)
pp. 639-650

Pictorial databases require efficient and direct spatial search based on the analog form of spatial objects and relationships instead of search based on some cumbersome alphanumeric encodings of the pictures. A description is given of PSQL, a query language that allows pictorial domains to be presented to the user in their analog form and allows him or her to do direct manipulation on the objects found on those domains. Direct spatial search and computation on the pictures is done using efficient data structures, R- and R/sup trees (multidimensional B-trees), which are excellent devices for searching spatial objects and relationships found on pictures.

[1] R. Bayer and E. McCreight, "Organization and maintenance of large ordered indexes,"Acta Informatica, vol. 1, no. 3, pp. 173-189, 1972.
[2] D. D. Chamberlin, "SEQUEL 2: A unified approach to data definition, manipulation, and control,"IBM J. Res. Dev., vol. 20, no. 6, pp. 560-575, 1976.
[3] N. S. Chang and K. S. Fu, "Picture query languages for pictorial data-base systems,"IEEE Comput., vol. 14, no. 11, Nov. 1981.
[4] S. K. Chang, "Pictorial information systems: Guest editor's introduction,"IEEE Comput., vol. 14, no. 11, Nov. 1981.
[5] S. K. Chang and L. K. Kunii, "Pictorial database systems,"IEEE Comput., vol. 14, no. 11, Nov. 1981.
[6] M. Chock, A. Cardenas, and A. Klinger, "Manipulating data structures in pictorial information systems,"IEEE Comput., vol. 14, no. 11, Nov. 1981.
[7] C. Faloutsoset al., "Analysis of object oriented spatial access methods." inProc. 1987 ACM SIGMOD Conf. Management Data, San Francisco, CA, May 1987.
[8] R. A. Finkel and J. L. Bentley, "Quadtrees: A data structure for retrieval on composite keys,"ACTA Informatica, vol. 4, no. 1, pp. 1-9, 1974.
[9] H. Guttman, "R-trees: A dynamic index structure for spatial searching," inProc. ACM/SIGMOD Conf., 1984, pp. 47-56.
[10] K. Hinrichs and J. Nievergelt, "The grid file: A data structure to support proximity queries on spatial objects," Institut für Informatik, ETH, Zurich, Switzerland, Tech. Rep. 54, July 1983.
[11] W. Kent, "Limitations of Record-Based Information Models,"ACM Trans. on Database Sys., Vol. 4:1, pp. 107-131.
[12] B. S. Lin and S. K. Chang, "GRAIN--A pictorial database interface," inIEEE Proc. Workshop Picture Data Description Management, Aug. 1980.
[13] D. M. McKeown, "Concept maps," Dep. Comput. Sci., Carnegie-Mellon Univ., Pittsburgh, PA, Tech. Rep. CMU-CS-83-117, Apr. 27, 1983.
[14] D. M. McKeown, "MAPS: The organization of a spatial database system using imagery, terrain, and map data," Dep. Comput. Sci., Carnegie-Mellon Univ., Pittsburgh, PA, Tech. Rep. CMU-CS-83-136, July 17, 1983.
[15] J. Orenstein, "Spatial query processing in an object-oriented database system," inProc. ACM SIGMOD Conf., Washington, DC, May 1986, pp. 326-336.
[16] M. Powell and M. Linton, "Database support for programming environments," inProc. Eng. Des. Appl. ACM-IEEE Database Week, May 1983.
[17] K. Ramaswamy, P. Karnik, and N. Roussopoulos, "A roadmap database system," Dep. Comput. Sci., Univ. Maryland, College Park, MD, Tech. Rep., to be published.
[18] J. T. Robinson, "The k-D-B-tree: A search structure for large multidimensional dynamic indexes," inProc. ACM SIGMOD, 1981, pp. 10-18.
[19] N. Roussopoulos, "Intensional semantics of the relational model," Dep. Comput. Sci., Univ. Maryland, College Park, MD, Tech. Rep., Jan. 1984.
[20] N. Roussopoulos, "Overview of ADMS: A high performance database management system" (Invited Paper), inProc. Fall Joint Comput. Conf., Dallas, TX, Oct. 1987.
[21] N. Roussopoulos and H. Kang, "Preliminary design of ADMS±: A workstation-mainframe integrated architecture for database management systems," inProc. 12th Int. Conf. Very Large Data Bases, Kyoto, Japan, Aug. 1986.
[22] N. Roussopoulos and D. Leifker, "An introduction to PSQL: A pictorial structured query language," presented at the IEEE Workshop Visual Lang., Dec. 6-8, 1984.
[23] N. Roussopoulos and D. Leifker, "Direct spatial search on pictorial databases using packed R-trees," inProc. ACM SIGMOD, Austin, TX, May 1985.
[24] H. Samet, "The quadtree and related hierarchical data structures,"Comput. Surveys, vol. 16, pp. 187-260, 1984.
[25] T. Sellis, N. Roussopoulos, and C. Faloutsos, "The R+-tree: A dynamic index for multi-dimensional objects," inProc. VLDB, 1987.
[26] M. Stonebraker, J. Rubenstein, and A. Guttman, "Application of abstract data types and abstract indices," presented at the Eng. Des. Appl. Database Week, ACM SIGMOD, May 23-26, 1983.
[27] G. Y. Tang, "A logical data organization for theIdatabase of pictures an alphanumerical data," inIEEE Proc. Workshop Picture Data Description Management, Aug. 1980.

Index Terms:
pictorial database system; PSQL; spatial search; spatial objects; alphanumeric encodings; query language; data structures; R/sup trees; multidimensional B-trees; data structures; database management systems; query languages; user interfaces
Citation:
N. Roussopoulos, C. Faloutsos, T. Sellis, "An Efficient Pictorial Database System for PSQL," IEEE Transactions on Software Engineering, vol. 14, no. 5, pp. 639-650, May 1988, doi:10.1109/32.6141
Usage of this product signifies your acceptance of the Terms of Use.