Explain the paths in the association network, Database Management System

Assignment Help:

Explain the paths in the association network

We can analyze use of paths in the association network as given below:

Calculate each operation
Find associations which it must pass through to get information. Associations could be bi-directional (generally by more than one operation) or unidirectional which can be implemented as pointers.

For each and every operation, we must know the followings:

How frequently is operation needed and how much will it cost?
What is fan-out along a path through network? To find fan-out of complete path, multiply average count of each "many" associations found in path with individual fan-outs.
What are the objects which satisfy selection criteria (if specified) and are operated on? When most of objects are rejected during traversal for some reason, then a simple nested loop can be inefficient at finding target objects.

Related Discussions:- Explain the paths in the association network

Write query to select student from math department, Consider the table stud...

Consider the table student and list names of students in the departments other than maths and computer. SELECT std_name FRM student WHERE dept_name NOT IN (‘Maths','Computer);

Problem about data mining for business intelligence, Do the 11.1 11.1 Cre...

Do the 11.1 11.1 Credit Card Use. Consider the following hypothetical bank data on consumers’ use of credit card credit facilities in Table 11.3. Create a small worksheet in Exce

What is a transaction, What is a Transaction? A transaction is an even...

What is a Transaction? A transaction is an event which happens on the database. Generally a transaction reads a value from the database or writes a value to the database. If y

Give an expression within sql for queries, Consider the following relations...

Consider the following relations: S (S#, SNAME, STATUS, CITY) SP (S#, P#, QTY) P (P#, PNAME, COLOR, WEIGHT, CITY) Give an expression within SQL for each of queries b

Need customer management program, Project Description: This is a Custome...

Project Description: This is a Customer Management project. Customer data is presented in a text file. The program can load this text data into its database columns. The data ma

Dependency Diagram, A Structure of a dependency diagram

A Structure of a dependency diagram

Atomicity-transaction , Atomicity: It describes a transaction to be a one ...

Atomicity: It describes a transaction to be a one unit of processing. We can also say either a transaction will be finished completely or not at all. In the transaction example 1

Distributed Database Management System, Types of Data fragmentation

Types of Data fragmentation

Can your organization scan large format documents, Can your organization sc...

Can your organization scan large format documents? Yes, large format scanning used for such entities as city plans and blueprints is available. We selected scanners with the ab

What is data mining?, Question 1 Define OLTP? Explain the Differences betw...

Question 1 Define OLTP? Explain the Differences between OLTP and Data Warehouse Question 2 What is Architecture? Explain various components involved in it Question

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages