DB USER :
DB USER :
• Database USER
• Naive / Parametric End Users
• Application Programmers/ System Analysts:
• writes the code for the application programs writes the code for the application
programs
• Sophisticated Users :
• familiar with the database. They can develop their own database applications according
to their requirement.
• System Analyst :
• who write specialized database application that does not fit into the traditional data-
processing framework.
Database Administrator (DBA) :
• The DBA has a DBA account in the DBMS which called a system or
superuser account.
• DBA also monitors the recovery and backup and provide technical
support.
• DBA repairs damage caused due to hardware and/or software
failures.
• DBA is the one having privileges to perform DCL (Data Control
Language) operations such as GRANT and REVOKE, to allow/restrict a
particular user from accessing the database.
Query Processing
Query Processing
• Query Processing is the activity performed in extracting data from the
database
• translations on high level Queries into low level expressions that can
be used at physical level of file system
• various steps
• Parsing and translation
• Optimization
• Evaluation
Block Diagram
of Query Processing
Detailed
Diagram
STEP1 : Parser
• Syntax check - concludes SQL syntactic validity.
SELECT * FORM TEST
• Semantic check -determines whether the statement is meaningful or
not.
query contains a tablename which does not exist is checked
• Shared Pool check - Every query possess a hash code.
if code exists in shared pool then database will not take additional steps
for optimization and execution.
(Hard Parse and Soft Parse )
• STEP 2 :Optimizer multiple query execution
plan for satisfying a query are examined and most efficient query
plan is satisfied for execution.
• STEP 3 :Execution Engine: Finally
runs the query and display the required result.