Subquery: Any SQL query can be written in the sub query approach. The SQL subquery returns one or more column as the result. Most SQL systems return a pair wise joining of one and only one column in an inner query with one column of an outer query. The data displayed form the table referenced in outer query only. Correlated subquery: It is a subquery that depends on the outer query. Here, the “WHERE” clause of the correlated subquery uses the information of the outer query. Processing order of correlated sub queries: The inner query is computed for each outer row in the processing order of correlated sub query. First, the outer sub query will get executed and it returns the result. Based on the result of the outer query, the inner subquery will be evaluated (i.e. the subquery will use the value of the outer query).

Question

using rapid miner how to creat decison trea for all attribute and another one with delete one or more of them also how i know the weight of each attribute and what that mean in impact the result

Answer 1

Question

Chapter 7, Problem 15RQ

Program Plan Intro

Subquery:

Any SQL query can be written in the sub query approach.

The SQL subquery returns one or more column as the result.

Most SQL systems return a pair wise joining of one and only one column in an inner query with one column of an outer query.

The data displayed form the table referenced in outer query only.

Correlated subquery: It is a subquery that depends on the outer query. Here, the “WHERE” clause of the correlated subquery uses the information of the outer query.

Processing order of correlated sub queries:

The inner query is computed for each outer row in the processing order of correlated sub query.

First, the outer sub query will get executed and it returns the result.

Based on the result of the outer query, the inner subquery will be evaluated (i.e. the subquery will use the value of the outer query).

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

using rapid miner how to creat decison trea for all attribute and another one with delete one or more of them also how i know the weight of each attribute and what that mean in impact the result

Q.1. Architecture performance [10 marks] Answer A certain microprocessor requires either 2, 4, or 6 machine cycles to perform various operations. ⚫ (40+g+f)% require 2 machine cycles, ⚫ (30-g) % require 4 machine cycles, and ⚫ (30-f)% require 6 machine cycles. (a) What is the average number of machine cycles per instruction for this microprocessor? Answer (b) What is the clock rate (machine cycles per second) required for this microprocessor to be a "1000 MIPS" processor? Answer (c) Suppose that 35% of the instructions require retrieving an operand from memory which needs an extra 8 machine cycles. What is the average number of machine cycles per instruction, including the instructions that fetch operands from memory?

Q.2. Architecture performance [25 marks] Consider two different implementations, M1 and M2, of the same instruction set. M1 has a clock rate of 2 GHz and M2 has a clock rate of 3.3 GHz. There are two classes of instructions with the following CPIs: Class A CPI for M1 CPI for M2 2.f 1.g B 5 3 C 6 4 Note that the dots in 2 fand 1.g indicate decimal points and not multiplication. a) What are the peak MIPS performances for both machines? b) Which implementation is faster, if half the instructions executed in a certain program are from class A, while the rest are divided equally among classes B and C. c) What speedup factor for the execution of class-A instructions would lead to 20% overall speedup? d) What is the maximum possible speedup that can be achieved by only improving the execution of class-A instructions? Explain why. e) What is the clock rate required for microprocessor M1 to be a "1000 MIPS" (not peak MIPS) processor?