Adding redundant associations for efficient access, Database Management System

Assignment Help:

Adding Redundant Associations for Efficient Access

Redundant associations do not add any type of information, therefore during design we should actually examine structure of object model for implementation and try to establish whether we could optimize critical parts of completed system. New associations can be added? Or old associations can be removed? The derived association does not require adding any information to the network, they help increasing model information in efficient mode.

Related Discussions:- Adding redundant associations for efficient access

Non-query optimisations, Part: Recommended (Non-query) Optimisations Thi...

Part: Recommended (Non-query) Optimisations This section entitled "Recommended (non-query) optimisations" should be a brief report containing recommended optimisations you would

Define instance and schema, Define instance and schema? Instance: C...

Define instance and schema? Instance: Collection of data kept in the data base at a particular moment is known as an Instance of the database. Schema: The o

System analysis and Design, difference between MIS and DSS

difference between MIS and DSS

How can you map null values to other values while display, How can you map ...

How can you map NULL values to other values while display? IF( ) , IFNULL( ) keywords are used to do so. They are 'LIMIT' is used for the following kinds of problems: 1) Ans

Extended star schema model, A customer places orders for parts and belongs ...

A customer places orders for parts and belongs to a particular industry group. An individual order is taken by a particular sales representative on a specific date and the sales re

Database systems have many opposite efforts, Database systems have many op...

Database systems have many opposite efforts ?

Define tables students and teachers as sub tables of people, Write a query ...

Write a query to define tables students and teachers as sub tables of people? Create table students of student under people Create table teachers of teacher under people

Define redo logs, Redo Logs: Any database must have minimum two redo logs....

Redo Logs: Any database must have minimum two redo logs. These are the rules for the database; the redo logs record all modifies to the system objects or user objects. If any type

Describe in brief about object oriented design, Describe about Object orien...

Describe about Object oriented design Object oriented design is concerned with developing an object oriented model of a software system to implement known requirements. Many OO

How can we classify the operations on classes, How can we Classify the oper...

How can we Classify the operations on classes This step fundamentally means all three models functional, object and dynamic (studied in last section) must be combined so that

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages