Section 3 Flashcards
1
Q
Architecture
A
describes the components of a computer system and the relationships between components.
2
Q
Tools
A
interact directly with database users and administrators and send queries to the query processor.
2
Q
Query Processor
A
manages connections from multiple users and compiles queries into low-level instructions for the storage engine.
3
Q
File system
A
accesses data on storage media.
4
Q
Connection
A
Link between tools and the query processor
5
Q
Execution Plan
A
is a detailed, low-level sequence of steps that specify exactly how to process a query.
6
Q
Query Parser
A
Checks each query for syntax errors and converts valid queries to an internal representation.
7
Q
A
