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

ERD, online eductional management system ke diagram

online eductional management system ke diagram

Explain the query processing, Explain the Query Processing  Data Query ...

Explain the Query Processing  Data Query Processing permits a user to report or analyze structured and unstructured data pulled from multiple data sources.

What is conceptual model, What is conceptual model ? A conceptual model...

What is conceptual model ? A conceptual model is a independent of both hardware and software.

Extended star schema, Why did SAP introduce the extended star schema? Expla...

Why did SAP introduce the extended star schema? Explain why it is reported to be better than the traditional schema model?

Wait-die scheme -deadlock prevention, Wait-die" scheme : The idea is based ...

Wait-die" scheme : The idea is based on non-preventive method. It is based on a simple rule:                                 If Ti requests a database resource that is held by T

What are domain constraints, What are domain constraints?  A  domain is...

What are domain constraints?  A  domain is  a  set  of  values  that  might  be  assigned to an attribute  .all  values that appear in a  column of a relation must be taken fro

Develop network database ipad app, I want an iPad app that is a simple 1 pa...

I want an iPad app that is a simple 1 page form to complete with text. The Objective is to allow a few dozen people of the same organization (they're all on iPad) to open the app,

Define the method of recursion, What is recursion? Is it possible for a sto...

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?  How many levels of SP nesting is possible? Recursion is method of proble

Database, why are older data models are being replaced by new data models

why are older data models are being replaced by new data models

What are the uses of the information in the data dictionary, What are the u...

What are the uses of the information in the Data dictionary? The following information is directly taken from the Data dictionary: Information on fields displayed with

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