Determine the steps of path in association network, Database Management System

Assignment Help:

Determine the steps of path in association network

You can analyse use of paths in association network in the following steps: 

  • Examine every operation and see what associations must traverse in order to get information. For this it is not of necessity those associations traverse in both directions.

For each operation, you should note following points:

  • How often is operation called? How costly is operation to perform?
  • What is "fan-out" along a path through network? Estimate the average count of each "many" association encountered along the path. Multiply individual fan-outs to obtain the fan-out of the complete path, which represents number of accesses on the final class in the path. Note that "one" links do not increase fan-out, although they increase cost of each operation slightly.

But there is no need to concern about such small effects.

  • What is fraction of "hits" on final class, (objects which meet selection criteria, if any are operated on? If most objects are rejected during traversal due to some reason, then a simple nested loop might be inefficient for finding target objects.

 


Related Discussions:- Determine the steps of path in association network

Objectives-database recovery and security, Objectives Define the te...

Objectives Define the terms RECOVERY and INTEGRITY; Define Recovery Techniques; Explain Error and Error detection techniques, and Define types of Authorisation.

What is foreign key, What is foreign key? A relation schema r1 derived ...

What is foreign key? A relation schema r1 derived from an ER schema may contain among its attributes the primary key of another relation schema r2.this attribute is known as a

List the requirements needed to design a trigger, List the requirements nee...

List the requirements needed to design a trigger. The requirements are:- Specifying when a trigger is to be implemented. State the actions to be taken when the trigger im

Boyce-codd normal form (bcnf), Boyce-Codd Normal Form (BCNF) The relati...

Boyce-Codd Normal Form (BCNF) The relation NEWSTUDENT (Enrolmentno, Sno, Sname, Cname, Cno,) has every attributes participating in candidate keys as all the attributes are assu

Product adder required for ecommerce website, Product adder required for Ec...

Product adder required for Ecommerce website Project Description: Want a product adder for 500 products I have a magento website and need products pulled from site A to my si

Create an index for the table client, Create an index for the table Client,...

Create an index for the table Client, field CLIENT_NO of Q ? Command:   CREATE INDEX client_client_no ON client(client_no);

Describe all integrity constraints which are violated, Consider the two rel...

Consider the two relations given below Given that A is the primary key of R, D is the primary key of S and there is a referential integrity among S.A and R.A, discuss all

Write a qbe query to display names of cs department, Consider a table stude...

Consider a table student (std_id, std_name, date_of_birth, percent_marks, dept_name). Write a QBE query to display names of Computer Science department students who have scored mo

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd