Check My Work Processing a SQL query The marketing manager...

Check My Work Processing a SQL query The marketing manager needs a list of all customers who placed a custom order exceeding a certain dollar amount during the previous year's 4th quarter holiday season: • Identify the DBMS component at each point in the path of the SQL query's process. 4 2 1 3 7 6 5 Database RAM User 1. User Process 2. User process 3. Listener 4. Data cache 5. Optimizer 6. Network 7. Data files

Transcript

00:01 A diagram that represent the processing slq query.

00:05 So the question asks you to basically identify the component in the pathway.

00:11 So let's say you start out with user.

00:14 This is actually step zero.

00:17 And then we go into step number one.

00:20 This is called network.

00:25 So the sqr request travel across the network to the database server.

00:30 So basically, it gets the query from the client basically is the user so it delivers to the network first then it's going to go to dbms mission so number one is the network and then let's move on to second two second is called listener the listener is on the dbms server so um basically the listener is always listening for incoming requests.

01:21 When it hears a query, basically, so it accepted and pass it to the database for processing.

01:30 So basically, we would think listener asked a reception desk for the database server.

01:35 All right.

01:36 So now, number two is the listener and it sends to number three.

01:42 So number three is what we call the server process.

01:46 Or we also call it user process inside.

01:51 The dbms.

02:12 So the server process takes the query and is responsible for running it.

02:16 So basically it coordinate with the optimizer and also with cache and storage to get result.

02:25 So basically the server or user process is the sql execution engine.

02:36 So basically it's the brain that actually runs the statement.

02:45 Now, then you can see that three goes into four.

02:50 Four is what we call optimizer.

02:56 So optimizer, basically the query is handed from the user processor or server processor to the optimizer...

Question

Please give Ace some feedback