Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
Database abstraction layer
open-in-new
<p>A database abstraction layer (DBAL or DAL) is an <a href="/facts/Application_programming_interface/GMlN4vUr">application programming interface</a> which unifies the communication between a computer application and <a href="/facts/Database/VYcpkevb">databases</a> such as <a href="/facts/MSSQL/eCdt2JBL">SQL Server</a>, <a href="/facts/IBM_Db2/2cYITuuY">IBM Db2</a>, <a href="/facts/MySQL/QEEDNBDP">MySQL</a>, <a href="/facts/PostgreSQL/LHdXuHfl">PostgreSQL</a>, <a href="/facts/Oracle_database/FHv5g732">Oracle</a> or <a href="/facts/SQLite/1PwYzIft">SQLite</a>. Traditionally, all database vendors provide their own interface that is tailored to their products. It is up to the application programmer to implement code for the database interfaces that will be supported by the application. Database abstraction layers reduce the amount of work by providing a consistent API to the developer and hide the database specifics behind this interface as much as possible. There exist many abstraction layers with different interfaces in numerous programming languages. If an application has such a layer built in, it is called database-agnostic. </p>