Object types and collections - performance of application, PL-SQL Programming

Use Object Types and Collections

The Collection types and object types increase your efficiency by allowing for the realistic data modeling. The Complex real-world entities and relationships map directly into the object types. A well-constructed object model can improve the application performance by eliminating the table joins, decreasing the round trips, and the same.

The Client programs, involving the PL/SQL programs, can declare the objects and collections, and pass them as parameters, store them in the database, recover them, and so on. Also, by encapsulating the operations with data, the object types move data-maintenance code out of the SQL scripts and PL/SQL blocks into methods.

The Objects and collections are well-organized to store and retrieve as they can be manipulated as an entire. The object support is also integrated architecturally with the database; therefore it can take benefit of the many scalability and performance improvements built into Oracle8i.

Posted Date: 10/5/2012 4:55:07 AM | Location : United States

Related Discussions:- Object types and collections - performance of application, Assignment Help, Ask Question on Object types and collections - performance of application, Get Answer, Expert's Help, Object types and collections - performance of application Discussions

Write discussion on Object types and collections - performance of application
Your posts are moderated
Related Questions
Relational Operators The relational operators permit you to compare randomly complex expressions. The list below provides the meaning of each operator:

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

First Step at defining type SID in SQL CREATE TYPE SID AS ( C VARCHAR(5) ) ; Explanation: TYPE SID announces that a type named SID is being defined to the syst

How Calls Are Resolved? The figure shows that how the PL/SQL compiler resolves the subprogram calls. When the compiler encounters the procedure or function call, it tries to di

Question: a) Given the following relation: Location(loc_id, bldg_code, room, capacity) The underlined field is a primary key. (i) Write a PL/SQL program using the impl

Project Description: I want a small relational database to be built. I want the database to have the subsequent information tables: Employee Information Document storage

SQL Database: So, an SQL database is one whose symbols are organized into a collection of tables. Now, shows an SQL table as the current value of an SQL variable, ENROLMENT, b

Difference between 9i & 10G When Oracle releases any new databases then it are having some discrepancy with them. But 10G is having much difference than oracle 9i has. Oracle

Use of Table Comparisons - SQL Table comparisons where it is noted that although table expressions cannot be compared, we have TABLE (t) to convert a table expression t into

Aggregate Assignment The %ROWTYPE declaration cannot include an initialization clause. Though, there are two ways to assign values to all fields in a record at once. At First, t