Discuss the term- design optimization, Database Management System

Assignment Help:

Discuss the term- Design Optimization 

We have seen various ways of representing the objects.The fundamental design model uses analysis model as the framework for implementation. The analysis model captures logical information regarding system. To get better result, design model shall contain details to support efficient information access. The inefficient, but semantically-correct analysis model could be optimized to make implementation more fruitful, but an optimized system is more difficult to understand and likely to be reusable in any other context. For the design optimization, as a designer, we must strike an appropriate balance between both efficiency and clarity. 

During design optimization as a designer we must keep following points in our mind:

  • Add redundant associations to reduce access cost and to maximize convenience.
  • Rearrange computation for greater efficiency up to the possible instant.
  • Save derived attributes to reduce re-computation of complicated expression

 


Related Discussions:- Discuss the term- design optimization

DBMS, to develop elrctronic database from manual forms

to develop elrctronic database from manual forms

Describe query evaluation engine, Describe Query evaluation engine? Que...

Describe Query evaluation engine? Query Evaluation engine: Vehicle executes low-level instructions obtained through the DML compiler. The Storage Manager Components gives in

Which language has recently become the defacto standard, Which language has...

Which language has presently become the defacto standard for interfacing application programs along with relational database system? The language which has recently become the

Entity - relation modeling and transformation, Represent the following scen...

Represent the following scenarios with E-R diagrams drawn using the ER Assistant software. The diagrams should indicate cardinality and optionality of relationships. Transform each

Hashed file organisation, Hashed File Organisation Hashing is the most ...

Hashed File Organisation Hashing is the most common form of purely random access to a database or file. It is also used to access columns that do not have an index as an optimi

What is a name, What is a Name? A user-supplied name is used for identi...

What is a Name? A user-supplied name is used for identity. This form of identity is used for files in file systems. The user gives every file a name that uniquely identifies it

Client dbms, i need to submit in this topic.

i need to submit in this topic.

Objectives-file organisation in dbms, Objectives  After reading this un...

Objectives  After reading this unit you should be able to: Explain storage of databases on hard disks; Discuss the execution of various file Organisation techniques;

State the process of inheritance adjustment, Inheritance Adjustment As...

Inheritance Adjustment As in object oriented analysis and design terms inheritance defines a relationship between classes, where as one class shares structure or behaviour def

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