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
Example of Using Aggregation on Nested Tables Example: How many students sat each exam WITH C_ER AS (SELECT CourseId, CAST (TABLE (SELECT DISTINCT StudentId, Mark FROM EXAM

Manipulating Collections Within PL/SQL, the collections add procedural power and flexibility. The biggest benefit is that your program can compute subscripts to process the spec

Cursor Attributes   The Cursors and cursor variables have 4 attributes which give you helpful information about the execution of a data manipulation statement. Syntax:

We are seeking a freelance consultant that is familiar with Appgen applications. We require exporting all our data into a format appropriate for importing into SAP Business One. Pl

Problem: (a) Define the following terms: (i) data mining. (ii) OLAP. (b) Differentiate between snowflake schema and star schema. Support your answer with appropriate

Implicit Cursor Attributes The Implicit cursor attributes returns the information about the execution of an INSERT, DELETE, UPDATE, or SELECT INTO statement. The cursor attribu

Assignment Statement: The assignment statement sets the present value of the variable, parameter, field, or element. The statement consists of an assignment target followed by

Hi there, I have the final part of a submission to do, it is a demonstration that takes place tomorrow. I do not have to use previous information, but i have resources that sho

I need to write one function and one procedure to query a Oracle 10.1 DB using PL SQL. I have the schema and exact queries...along with work Ive started and a template to put the a

Parameter and Keyword Description: collection_name: This keyword identifies the index-by table, nested table, or varray formerly declared within the present scope. cu