Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
What is meant by heuristic optimisation?Discuss the major heuristics that are applied during query optimisation.
Ans: In heuristic opimization, heuristics are employed to decrease the cost of optimization in place of analyzing the number of dissimilar plans to find out the optimal plan. For instance A analyzing optimizer would make use of the rule 'perform selection operation as early as possible' without finding out whether the cost is decreased by this transformation. Heuristics approach generally assists to reduce the cost but not always. The heuristics which are applied during query optimization are:
a) Pushes the selection and projection operations down the query tree
b) Left-deep join trees- convenient for pipelined evaluation
c) Non- left-deep join trees
Question 1 Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? Question 2 With a necessary example explain (i)
Answer SQL Queries to extract data from data tables and questions on mapping conceptual data models into relational data model.
What is a dataset? A dataset is an in-memory database that is disconnected from any regular database, but has all the significant characteristics of a regular database. Dataset
Consider the 1ollowin8 relation: CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., crui
What is Distributed system ? Distributed System - A distributed system consists of a number of processing parts in which are interconnected through a computer network and in
Explain the Cascadeless Schedule A cascadeless schedule is one in which for every pair of transactions Ti and Tj like that Tj reads a data item before written by Ti, the commit
Have a look around the site, and at some of the sites they have featured. These are all examples of bad design, and also offer an explanation about why they fall into this category
Explain the cartesian product in Database Management System
What is inheritance? Define it in detail? Inheritance Inheritance can be at the levels of types, or at the level of tables we first consider inheritance of types, then i
One-way Associations If an association is only traversed in single direction, then it is known as one-way association. It is implemented as a pointer or an attribute which con
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!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd