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

Ideal data dictionary, An ideal data dictionary should have everything a DB...

An ideal data dictionary should have everything a DBA wants to know about the database. 1 Conceptual, External, and internal database descriptions. 2.    Descriptions of attr

Design a gennalization and specialization hierarchy for an a, Design a genn...

Design a gennalization and specialization hierarchy for an automobile sales company

What is the full form of odbc, What is the full form of ODBC ? ODBC stand...

What is the full form of ODBC ? ODBC stands for Open Database Connectivity.

Include the create database command, Submit the SQL Statements necessary to...

Submit the SQL Statements necessary to create your database according to the following guidelines: Your SQL statements should exactly mirror your ERD. All primary keys,

How can you terminate the mysql server, How can you terminate the MySQL Ser...

How can you terminate the MySQL Server? Typing the following in Command prompt will shut down the server completely as root user % mysqladmin -u root -p shutdown

Explain concept of inheritance with support of example, Explain concept of ...

Explain concept of inheritance with support of suitable example. Inheritance Inheritance is one of milestone of object-oriented programming language as it allows a creati

Examine about the behavioural diagrams, Examine about the Behavioural Diagr...

Examine about the Behavioural Diagrams  The main objective of behavioural diagrams is to visualize, specify, construct and document dynamic aspects of a system. The interactio

What are the objectives of advance object design, What are the Objectives o...

What are the Objectives of Advance object design After this unit, you shall be able to: combine three OOAD models to obtain operations on the classes; develop algo

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