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

Query optimization, what is meant semantic query optimization? how does it ...

what is meant semantic query optimization? how does it differ from other query optimization techniques?

Modelling and normalisation, Task Part A. Create an ERD from a business pro...

Task Part A. Create an ERD from a business problem. (50 marks) Read the following problem and complete the tasks listed below. THE ABS Blood Bank Australian Blood Services (ABS) i

Determine candidate and primary key, A video rental company has several bra...

A video rental company has several branches. The data held on each branch is the branch address made up of street, city, state, and zip code, and the telephone number. Ea

Define- relational algebra, Define- relational algebra. The relational ...

Define- relational algebra. The relational algebra is a procedural query language. It having of a set of operations that take one or two relation as input and make a new relati

Bid Cunt, How do I use strap on?#

How do I use strap on?#

Marketing interface, as a customer service employee explain five measures y...

as a customer service employee explain five measures you would recommend to make even a displeased students patronize the school canteen

Explain b-tree, What is B-Tree? A B-tree eliminates the redundant stora...

What is B-Tree? A B-tree eliminates the redundant storage of search-key values .It permits search key values to appear only once.

Describe second normal and third normal form, Database Management Systems ...

Database Management Systems 1. Explain SQL Server 2000 Architecture with diagram. 2. Describe Second Normal and Third Normal Form. 3. Explain about query engine and stora

Participation constraints, The participation Constraints shows whether the ...

The participation Constraints shows whether the existence of an entity depends on its being associated to another entity by the relationship type. There are two kinds of participat

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