Browse Definitions :
Definition

database abstraction layer

A database abstraction layer is a simplified representation of a database in the form of a written description or a diagram.

Abstraction, in general, is the process of taking away or removing characteristics from something in order to reduce it to a set of essential characteristics. Database abstraction layers facilitate the design of flexible databases. 

The three formal abstraction layers:

  • User model: An informal representation of how the user describes the database.
  • Logical model: More formal, with more detail and often rendered as an entity relationship model (ERM).
  • Physical model: More detail added such as indexing and data types.

The alternative to abstraction layers is hard-coding rules and metadata into the database during development.  In that case, coding also establishes how business terms, definitions, rules, and other information are defined on behalf of the applications that access the database.

Hard-coding is fine for those applications that are originally planned to access the database. However, that approach makes it much more complicated for other applications with different requirements to communicate with the database.  A data abstraction layer allows for maximum flexibility and guarantees that when additional business applications need to access the database, it isn’t necessary to make significant changes to support them. 

This was last updated in June 2014

Continue Reading About database abstraction layer

SearchCompliance
  • ISO 31000 Risk Management

    The ISO 31000 Risk Management framework is an international standard that provides businesses with guidelines and principles for ...

  • pure risk

    Pure risk refers to risks that are beyond human control and result in a loss or no loss with no possibility of financial gain.

  • risk reporting

    Risk reporting is a method of identifying risks tied to or potentially impacting an organization's business processes.

SearchSecurity
  • Pretty Good Privacy (PGP)

    Pretty Good Privacy or PGP was a popular program used to encrypt and decrypt email over the internet, as well as authenticate ...

  • email security

    Email security is the process of ensuring the availability, integrity and authenticity of email communications by protecting ...

  • Blowfish

    Blowfish is a variable-length, symmetric, 64-bit block cipher.

SearchHealthIT
SearchDisasterRecovery
  • What is risk mitigation?

    Risk mitigation is a strategy to prepare for and lessen the effects of threats faced by a business.

  • fault-tolerant

    Fault-tolerant technology is a capability of a computer system, electronic system or network to deliver uninterrupted service, ...

  • synchronous replication

    Synchronous replication is the process of copying data over a storage area network, local area network or wide area network so ...

SearchStorage
  • direct access

    In computer storage, direct access is the process of reading and writing data on a storage device by going directly to where the ...

  • kibi, mebi, gibi, tebi, pebi and exbi

    Kibi, mebi, gibi, tebi, pebi and exbi are binary prefix multipliers that, in 1998, were approved as a standard by the ...

  • holographic storage (holostorage)

    Holographic storage is computer storage that uses laser beams to store computer-generated data in three dimensions.

Close