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

  • information governance

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

  • enterprise document management (EDM)

    Enterprise document management (EDM) is a strategy for overseeing an organization's paper and electronic documents so they can be...

  • risk assessment

    Risk assessment is the identification of hazards that could negatively impact an organization's ability to conduct business.

SearchSecurity

  • cyber espionage

    Cyber espionage, also called cyber spying, is a form of cyber attack that is carried out against a competitive company or ...

  • virus (computer virus)

    A computer virus is malicious code that replicates by copying itself to another program, computer boot sector or document and ...

  • spam trap

    A spam trap is an email address that is used to identify and monitor spam email.

SearchHealthIT

SearchDisasterRecovery

  • risk mitigation

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

  • call tree

    A call tree is a layered hierarchical communication model that is used to notify specific individuals of an event and coordinate ...

  • Disaster Recovery as a Service (DRaaS)

    Disaster recovery as a service (DRaaS) is the replication and hosting of physical or virtual servers by a third party to provide ...

SearchStorage

  • dropout

    Dropout refers to data, or noise, that's intentionally dropped from a neural network to improve processing and time to results.

  • cloud storage

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

  • cloud testing

    Cloud testing is the process of using the cloud computing resources of a third-party service provider to test software ...

Close