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
Aggregate Operators SQL Supports all of the aggregate operators mentioned in the theory book and many more besides. The syntax, however, involves an unusual trick that SQL cal

Mutual Recursion The Subprograms are mutually recursive if they directly or indirectly call each other. In the illustration below, the Boolean functions odd & even, that dete

Joining in SQL Joining IS_CALLED and IS_ENROLLED_ON in SQL SELECT * FROM IS_CALLED NATURAL JOIN IS_ENROLLED_ON This is an example of an SQL table expression. I have been

Restriction in SQL Syntax: SELECT DISTINCT StudentId FROM IS_CALLED WHERE Name = 'Boris' The WHERE clause operates on the result of the FROM clause in analogo

Dynamic SQL: The Most PL/SQL programs do a predictable, specific job. For illustration, a stored procedure may accept an employee number and salary increase, and then update t

Advantages of Exceptions Using the exceptions for the error handling has many benefits. Without an exception handling, every time you issue a command, you should ensure for th

#quesWrite a cursor to open an employee database and fetch the employee record whose age is greater than 45.tion..

Great Plains (Microsoft Dynamics) Purchases Report Project Description: I want to build a purchases report that matches the General Ledger. presently, when I join the PM20

BEGIN Parameter Description in pl sql: BEGIN: This keyword signals the beginning of the executable section of a PL/SQL block, that contains executable statements. The execut

When Are Constraints Checked Under the model constraints are conceptually checked at all statement boundaries (and only at statement boundaries). By default the same is true