It explores various ways to carry out the access plan. The access plan is a binary representation of the steps that are required to carry out the statement it is the DBMS equivalent of executable code. The DBMS generates an access plan for the statement. Do all the tables named in the statement exist in the database? Do all of the columns exist and are the column names unambiguous? Does the user have the required privileges to execute the statement? Certain semantic errors can be detected in this step. It checks the statement against the system catalog. Syntax errors and misspellings can be detected in this step. It breaks the statement up into individual words, called tokens, makes sure that the statement has a valid verb and valid clauses, and so on. To process an SQL statement, a DBMS performs the following five steps: The following illustration shows the steps involved in processing an SQL statement, which are discussed throughout the rest of this section. The steps involved are common to all three techniques, although each technique performs them at different times. Before discussing the techniques for using SQL programmatically, it is necessary to discuss how an SQL statement is processed.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |