Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

DBMS Interface

  • Johannes Gehrke
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_673

Synonyms

Communication boundary of a DBMS

Definition

A DBMS interface is the abstraction of a piece of functionality of a DBMS. It usually refers to the communication boundary between the DBMS and clients or to the abstraction provided by a component within a DBMS. A DBMS interface hides the implementation of the functionality of the component it encapsulates.

Key Points

DBMS interfaces can be external or internal [3]. The external DBMS interface is the communication boundary between the DBMS and clients. The external DBMS interface enables clients to access internal DBMS functionality without exposing the mechanisms of how this functionality is implemented. Well-known external DBMS interfaces are SQL, XPath, and XQuery. There are many different types of external DBMS interfaces, for example, stand-alone languages (such as SQL), extensions to existing languages with features from SQL (such as JDBC), and integration into middle-tier programming languages (such as PHP). The external...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Harizopoulos S, Ailamaki A. StagedDB: designing database servers for modern hardware. IEEE Data Eng Bull. 2005;28(2):11–6.Google Scholar
  2. 2.
    Hellerstein JM, Stonebraker M, Hamilton J. Architecture of a database system. Found Trends Databases. 2007;1(2):141–259.CrossRefzbMATHGoogle Scholar
  3. 3.
    Ramakrishnan R, Gehrke J. Database management systems. 3rd ed. McGraw-Hill Science/Engineering/Math; 2002.Google Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Cornell UniversityIthacaUSA

Section editors and affiliations

  • Anastasia Ailamaki
    • 1
  1. 1.Informatique et CommunicationsEcole Polytechnique Fédérale de LausanneLausanneSwitzerland