Database abstraction layer: Difference between revisions

Revision as of 18:47, 29 April 2021

Latest revision as of 05:14, 24 April 2024

(4 intermediate revisions by 4 users not shown)

Line 1:

{{Short description|Application programming interface}}

{{More citations needed|date=September 2014}}

A '''database abstraction layer''' ('''DBAL'''<ref>{{cite book|author1first1=Tim |last1=Ambler|author2first2=Nicholas |last2=Cloud|title=JavaScript Frameworks for Modern Web Dev|url=https://books.google.com/books?id=2IfDCgAAQBAJ&pg=PA346|year=2015|publisher=Apress|isbn=978-1-4842-0662-1|page=346}}</ref> or '''DAL''') is an [[application programming interface]] which unifies the communication between a computer application and [[database]]s such as [[MSSQL|SQL Server]], [[IBM DB2|DB2Db2]], [[MySQL]], [[PostgreSQL]], [[Oracle database|Oracle]] or [[SQLite]]. 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'''.<ref>{{cite web |url=http://searchdatamanagement.techtarget.com/definition/database-agnostic |title = What is database-agnostic? - Definition from WhatIs.com}}</ref>

== Database levels of abstraction ==

=== Physical level (lowest level) ===

The lowest level connects to the database and performs the actual operations required by the users. At this level the conceptual instruction has been translated into multiple instructions that the database understands. Executing the instructions in the correct order allows the DAL to perform the conceptual instruction.

Line 18:

=== External or view level ===

The external level is exposed to users and developers and supplies a consistent pattern for performing database operations.

<ref>{{Cite web|url=http://www.dmst.aueb.gr/dds/etech/db/abstr.htm|title = Levels of Abstraction}}</ref> Database operations are represented only loosely as SQL or even database access at this level.

Every database should be treated equally at this level with no apparent difference despite varying physical data types and operations.

Line 30:

An example of a database abstraction layer on the language level would be [[ODBC]] that is a platform-independent implementation of a database abstraction layer. The user installs specific [[driver software]], through which ODBC can communicate with a database or set of databases. The user then has the ability to have programs communicate with ODBC, which then relays the results back and forth between the user programs and the database. The downside of this abstraction level is the increased overhead to transform statements into constructs understood by the target database.

Alternatively, there are thin wrappers, often described as ''lightweight'' abstraction layers, such as OpenDBX<ref>{{cite web |url=https://www.linuxnetworks.de/doc/index.php?title=OpenDBX |title=OpenDBX |author==<!--Not stated--> |date=24 June 2012 |website=linuxnetworks.de |access-date=26 July 2018}}</ref> and libzdb.<ref>{{cite web |url=http://www.tildeslash.com/libzdb/ |title=Libzdb |author==<!--Not stated--> |access-date=26 July 2018 |year=2018 |website=tildeslash.com}}</ref> Finally, large projects may develop their own libraries, such as, for example, libgda<ref>{{cite web |url=http://www.gnome-db.org/ |title=GNOME-DB |author==<!--Not stated--> |access-date=26 July 2018 |date=12 June 2015 |quote=Libgda library [...] is mainly a database and data abstraction layer, and includes a GTK+ based UI extension, and some graphical tools.}}</ref> for [[GNOME]].

== Arguments ==

Line 49:

== References ==

{{reflist}}

<references />

{{Database}}