This Article 
 Bibliographic References 
 Add to: 
ADMS: A Testbed for Incremental Access Methods
October 1993 (vol. 5 no. 5)
pp. 762-774

ADMS is an advanced database management system developed-to experiment with incremental access methods for large and distributed databases. It has been developed over the past eight years at the University of Maryland. The paper provides an overview of ADMS, and describes its capabilities and the performance attained by its incremental access methods. This paper also describes an enhanced client-server architecture that allows an incremental gateway access to multiple heterogeneous commercial database management systems.

[1] A. Amir and N. Rossopoulos, "Optimal view caching,"Inform. Syst., vol. 15, no. 2, pp. 169-171.
[2] J. Blakeley, P. Larson, and F. Tompa, "Efficiently updating materialized views," inProc. ACM-SIGMOD Int. Conf Management of Data, Washington, May 28-30, 1986.
[3] D Bitton., D. DeWitt, and C. Turbyfill, "Benchmarking database systems: A systematic approach," Department of Computer Science, University of Wisconsin at Madison,TR 526, Dec. 1983.
[4] U. Chakravarthy, "Semantic query optimization in deductive databases," Ph.D. dissertation, Department of Computer Science, Univ. Maryland, 1985.
[5] C. L. Chang and R. C. T. Lee,Symbolic Logic and Mechanical Theorem Proving. New York: Academic, 1973.
[6] A. Delis and N. Roussopoulos, "Performance and scalability of client-server database architectures," inProc. 18th Very Large Data Bases Conf., Vancouver, Canada, Aug. 1992, pp. 610-623.
[7] D. J. DeWittet al., "Implementation techniques for main memory databases," inProc. ACM Sigmod(Boston, MA), June 18-21, 1984, pp. 1-8.
[8] N. Economou, "Multi-site incremental database access system," M.S. thesis, Department of Computer Science, University of Maryland, Dec. 1988.
[9] E. Hanson, "A performance analysis of view materialization strategies,"ACM-SIGMOD Int. Conf. Management of Data, San Francisco, CA, May 28-30, 1987.
[10] Y. Kang, "Catalog and binding management of ADMS±," M.S. thesis, Department of Computer Science, University of Maryland, Aug. 1989.
[11] W. Litwin, L. Mark, and N. Roussopoulos, "Interoperability of Multiple Autonomous Databases,"ACM Computing Surveys, Vol. 22, No. 3, Sept. 1990, pp. 267-293.
[12] "Database systems: Achievements and opportunities," Report of the NSF Workshop Invitational Workshop on Future Directions in DBMS Research, 1990.
[13] N. Roussopoulos, "View indexing in relational databases,"ACM Trans. Database Syst., vol. 7, no. 2, June 1982.
[14] N. Roussopoulos, "The logical access path schema of a database,"IEEE Trans. Software Eng., vol. SE-9, Sept. 1982.
[15] N. Roussopoulos, " The incremental access method of ViewCache: Concept and cost analysis," Dep. Comput. Sci. Inst. Advanced Computer Studies, Univ. Maryland, College Park, Tech. Rep. UMIACS-TR-89-15, CS-TR-2193, Mar. 1989; to appear inACM Trans. Database Syst.
[16] N. Roussopoulos and C. Bader, "Dynamic access control for relational views,"Inform. Syst., vol. 10, pp. 361-369, Aug. 1985.
[17] 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.
[18] N. Roussopoulos and H. Kang, "Principles and techniques in the design of ADMS±,"computer, vol. 19, no. 12, Dec. 1986.
[19] N. Roussopoulos and S. Kim, "ROOST: A relational object oriented system," inProc. Int. Conf. Foundations of Data Organization and Algorithms, Paris, France, June 21-23, 1989.
[20] N. Roussoupoulos, L. Mark, T Sellis, and C. Faloutsos, "An architecture for high performance engineering information systems,"IEEE Trans. Software Eng., vol. 17, pp. 22-33, Jan. 1991.
[21] W. R. Rubinstein, M. S. Kubicar, and R. G. G. Cattell, "Benchmarking simple database operations," in [51], pp. 387-394.
[22] T. Sellis, N. Roussopoulos, and C. Faloutsos, "The R+-tree: A dynamic index for multi-dimensional objects," inProc. VLDB, 1987.
[23] A. Stamenas, "High performance incremental relational databases," M.S. thesis, Department of Computer Science, University of Maryland, May 1989.
[24] Sun Microsystems, Inc., "Networking on the Sun Workstation," Revision A of May 15, 1985.
[25] P. Valduriez, "Join indices,"ACM Trans. Database Syst., vol. 12, pp. 218-246, June 1987.
[26] G. Wiederhold, "Views, objects, and databases,"Computer, vol. 19, no. 12, pp. 37-44, Dec. 1986.

Index Terms:
ADMS; incremental access methods; advanced database management system; distributed databases; large databases; client-server architecture; incremental gateway; commercial database management systems; interoperability; heterogeneous DBMS; join index; view index; distributed databases; network operating systems; query processing; very large databases
N. Roussopoulos, N. Economou, A. Stamenas, "ADMS: A Testbed for Incremental Access Methods," IEEE Transactions on Knowledge and Data Engineering, vol. 5, no. 5, pp. 762-774, Oct. 1993, doi:10.1109/69.243508
Usage of this product signifies your acceptance of the Terms of Use.