Information hiding in pl/sql, PL-SQL Programming

Information Hiding 

With the information hiding, you see only the details that are significant at a given level of algorithm and data structure design. The Information hiding keeps high-level design decisions separate from the low-level design details that are more likely to be change.

Algorithms

You employ information hiding for the algorithms through top-down design. Once you define the aim and interface specifications of a low-level procedure, you can pay no attention to the implementation details. They are hidden at higher levels. For e.g., the implementation of a procedure named raise_salary is hidden. All you require is to know that the procedure will increase a specific employee's salary by a given amount. Any change in the definition of raise_salary is visible to the calling applications.

Data Structures

You implement information hiding for the data structures through data encapsulation. By developing a set of utility subprograms for a data structure, you protect it from users and other developers. In that way, the other developers know how to use the subprograms that operate on the data structure but not how the structure is represented.

With the PL/SQL packages, you can specify whether the subprograms are public or private. Therefore, the packages enforce data encapsulation by letting you put subprogram definitions in a black box. The private definition is hidden and unapproachable. Only the package, not your application, is affected if definition changes. This simplifies the maintenance and enhancement.

Posted Date: 10/2/2012 1:52:04 AM | Location : United States







Related Discussions:- Information hiding in pl/sql, Assignment Help, Ask Question on Information hiding in pl/sql, Get Answer, Expert's Help, Information hiding in pl/sql Discussions

Write discussion on Information hiding in pl/sql
Your posts are moderated
Related Questions
Declaring Objects: You can use the object types wherever built-in types like CHAR or NUMBER can be used. In the block below, you can declare object r of type Rational. Then, yo

LEVEL You use the LEVEL with the SELECT CONNECT BY statement to categorize rows from a database table into a tree structure. The LEVEL returns the level number of a node in a

Using FORALL and BULK COLLECT Together You can unite the BULK COLLECT clause with the FORALL statement, in that case, the SQL engine bulk-binds column values incrementally. In

3CX PBX sync Windows Service Project Description: !! You require access to a commercial version of the 3CX PBX system in order to be able to program the API !! !! You requ

THEO R Y OF CATASTROPHISM OR CATALYSM (CUVIER 1769-1832) - The world has passed thorugh several stages and at the end of each stage there was a catastrophe killing all the

Package STANDARD package named STANDARD defines the PL/SQL atmosphere. The package specification globally declares the exceptions, types, and subprograms that are available a

DELETE Command - SQL Loosely speaking, DELETE removes some existing rows from its target table. Suppose the university decides that course C3 is to be withdrawn. Example shows

Tautologies: Above given table allows us to read the truth of the connectives in the next manner. Just expect we are looking at row three. It means this says that, if there P

Inner Join We have learned how to retrieve data from one table by using SELECT statement. But, as we have learned, normalized relational databases mean the data is spread betw

Implicit Cursor is declared and used by the oracle environment internally. while the explicit cursor is declared and used by the external user. more over implicitly cursors are no