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
  • smart contract

    A smart contract is a decentralized application that executes business logic in response to events.

  • compliance risk

    Compliance risk is an organization's potential exposure to legal penalties, financial forfeiture and material loss, resulting ...

  • information governance

    Information governance is a holistic approach to managing corporate information by implementing processes, roles, controls and ...

SearchSecurity
  • threat modeling

    Threat modeling is a procedure for optimizing application, system or business process security by identifying objectives and ...

  • social engineering

    Social engineering is an attack vector that relies heavily on human interaction and often involves manipulating people into ...

  • distributed denial-of-service (DDoS) attack

    A distributed denial-of-service (DDoS) attack is one in which multiple compromised computer systems attack a target, such as a ...

SearchHealthIT
SearchDisasterRecovery
  • change control

    Change control is a systematic approach to managing all changes made to a product or system.

  • disaster recovery (DR)

    Disaster recovery (DR) is an organization's ability to respond to and recover from an event that affects business operations.

  • risk mitigation

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

SearchStorage
  • race condition

    A race condition is an undesirable situation that occurs when a device or system attempts to perform two or more operations at ...

  • storage security

    Storage security is the group of parameters and settings that make storage resources available to authorized users and trusted ...

  • cloud storage

    Cloud storage is a service model in which data is transmitted and stored on remote storage systems, where it is maintained, ...

Close