Google Answers Logo
View Question
 
Q: The importance on insulation between programs, data and data abstraction. ( Answered 3 out of 5 stars,   1 Comment )
Question  
Subject: The importance on insulation between programs, data and data abstraction.
Category: Computers > Software
Asked by: 888-ga
List Price: $10.00
Posted: 23 Jun 2003 23:40 PDT
Expires: 23 Jul 2003 23:40 PDT
Question ID: 221044
What is the importance on insulation between programs, data and data
abstraction.  Is this more important to database administrators,
database designers or end users?
Answer  
Subject: Re: The importance on insulation between programs, data and data abstraction.
Answered By: wlk115-ga on 24 Jun 2003 21:13 PDT
Rated:3 out of 5 stars
 
Hi 888-ga, 

I'm going to start with the second part of you question (momma always
said I did everything bass ackwards ;) because it's a bit subjective.

Is this more important to database administrators, database designers
or end users?

I think I'll let you decide that, because it is important to all of
them and I could not decide who it is MORE important to.

It is important Database Administrators because:
The structure of data files is stored in the DBMS catalog separately
from the access programs. (See paragraph 1 in the explanation below)

It is important Database designers because:
The implementation of the operation is specified separately and can be
changed without affecting the interface.
(See paragraph 2 in the explanation below)

It is important End users because:
A data model hides storage details and present the users with a
conceptual view of the database, which describes only the data of
interest to that user.
(See paragraph 3 in the explanation below)

Database systems
Basic Concepts
http://www.cs.appstate.edu/~rt/DBMS/notes/chap1.pdf

Insulation between Programs and Data, and Data Abstraction

1)  In traditional file processing, the structure of data files is
embedded in the access programs.
Thus, any change to the structure of a file may require changing all
programs that access this file.
Database management system (DBMS) access programs do not require such
changes in most cases. The structure of data files is stored in the
DBMS catalog separately from the access programs. This property is
called program-data independence.

2) There are times that a database is designed such that an operation
on the database is defined in two parts; one part is the operation
name and the other data type of the arguments (or parameters).
The implementation of the operation is specified separately and can be
changed without affecting the interface.

User application programs can operate on the data by invoking these
operations through their names and arguments, regardless, of how the
operations are implemented. This is known as program-operation
independence.

The characteristic that allows program-data independence and
program-operation independence is called Data Abstraction.

3) A DBMS provides users with a conceptual representation of data that
includes many of the details of how the data is stored or how the
operations are implemented.
A data model is a type of data abstraction that is used to provide
this conceptual representation.
A data model hides storage and implementation details that are not of
interest to most database users.

Additional resources:

Databases and Database users
http://netdb.chungbuk.ac.kr/Note/DB/4

Databases and Database Management Systems
Fundamentals of Database Systems
http://www.cc.gatech.edu/classes/AY2002/cs6400_spring/FILE1_revised_wf.pdf

Database Technology
http://www.ida.liu.se/~TDDB38/2001/ALL-DB-COURSES/CourseMaterial/Introduction_2001a.OH.pdf

DBMS Architecture and Data Independence
http://www.cs.uofs.edu/~mccloske/courses/cmps341/en_chap2_lec.html

Introductory Concepts
http://www.utdallas.edu/~lkhan/Fall2001/Class1.doc

Databases and Database Users 
http://www.valdosta.edu/~sfares/cs480/cs4xx.chapter1.fa7.html

~wlk115

search terms used:
insulation between programs, data and data abstraction
programs, data and data abstraction

If you need more information please request a clarification.
888-ga rated this answer:3 out of 5 stars
A lot of content can be found from Google.

Comments  
Subject: Re: The importance on insulation between programs, data and data abstraction.
From: to_be_determined-ga on 26 Jun 2003 06:14 PDT
 
Funny to see the rating comment: "a lot of content can be found from
Google."  Isn't that Google Answer is all about?

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy