Ask the Expert

Definition of data abstraction and data abstraction layers

What is the definition of data abstraction, and what are the primary data abstraction layers we should be concerned about?

    Requires Free Membership to View

Data abstraction is amazingly useful because it allows humans to understand and build complex systems like databases.

A good place to start understanding the definition of data abstraction is to think about the way the word 'abstract' is used when we talk about a long document. The abstract is the shortened, simplified form. We often read it to get an overview before reading the entire paper. (Actually we often read it INSTEAD of reading the paper, but that's another issue.)

Now think about designing a brand new, complex database system. One way to design the database is to sit down and start writing code. You start at one end and keep writing until the database is finished. In practice there are very few (probably zero) people who can do this; the problem is too complex.

So, we create a simple written description of the database that the users have asked for, which is an abstraction of the database. Then we add a little detail to that, making it into another abstraction, but a somewhat more detailed one. We keep on adding detail until finally it is finished. There is no more detail to add; the abstraction has turned into the thing itself.

The three formal abstraction layers we usually use are:

 

  • User model: How the user describes the database
  • Logical model: More formal, more detail – often rendered as an entity relationship (ER) model
  • Physical model: More geeky detail added – indexing, data types etc.

Data abstraction is simply a way of turning a complex problem into a manageable one.

This was first published in September 2008

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: