Everything about Database abstraction layer
Application programming interface
A database abstraction layer is an application programming interface which unifies the communication between a computer application and databases such as SQL Server, IBM Db2, MySQL, PostgreSQL, 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. Wikipedia →
🧠Start here: a 6-step reading path
- Read the overview: Database abstraction layerA 5-minute orientation
- Pick up a classic book: Software EngineeringThe most-reprinted book on the subject
- Go sideways: Data access layerA closely related topic
- Go sideways: Open Database ConnectivityA closely related topic
đź“– Definitions
No dictionary entry for this exact phrase.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
- No matching papers found.
đź“š Books worth reading
Software EngineeringRoger S. Pressman, Bruce Maxim · 1982
A developer's guide to data modeling for SQL serverEric Johnson, Eric Johnson undifferentiated · 2008
SystemVerilog for VerificationChris Spear · 2006
Concepts, techniques, and models of computer programmingPeter Van Roy, Seif Haridi · 2004- 📕Video dataMohand-Saïd Hacid, Salima Hassas · 2003
AQA AS and A Level Computer ScienceP.M. Heathcote, R SU Heathcote · 2016
Foundations of computer scienceBehrouz A. Forouzan · 2002
Graph-grammars and their application to computer science and biologyVolker Claus · 1979
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
đź”— Related topics
- Data access layer A data access layer (DAL) is a software architectural layer that provides access to data from one or more sources, such as a relational database, NoSQL…
- Open Database Connectivity In computing, Open Database Connectivity (ODBC) is a C language standard application programming interface (API) for accessing database management systems…
- OLE DB OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB) is an API designed by Microsoft that allows accessing data from a…
- Data Access Manager The Data Access Manager (DAM) was a database access API for the classic Mac OS, introduced in 1991 as an extension to System 7. Similar in concept to ODBC…
- Hardware abstraction A hardware abstraction is software that provides access to hardware in a way that hides details that might otherwise make using the hardware difficult…
- Data Access Language Data Access Language for the Macintosh, or simply DAL, was a SQL-like language and application programming interface released by Apple Computer in 1990…
- Microsoft Data Access Components Microsoft Data Access Components (MDAC; also known as Windows DAC) is a framework of interrelated Microsoft technologies that allows programmers a uniform…
- Database In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software…