With this, it evenly replaces all the use of the views when used in the query. The parser creates a tree of the query, known as 'parse-tree.' Further, translate it into the form of relational algebra. When a user executes any query, for generating the internal form of the query, the parser in the system checks the syntax of the query, verifies the name of the relation in the database, the tuple, and finally the required attribute value. The translation process in query processing is similar to the parser of a query. Relational algebra is well suited for the internal representation of a query. But, it is not perfectly suitable for the internal representation of the query to the system. Consequently, SQL or Structured Query Language is the best suitable choice for humans. Thus before processing a query, a computer system needs to translate the query into a human-readable and understandable language. After this, the actual evaluation of the queries and a variety of query -optimizing transformations and takes place. It gets translated into expressions that can be further used at the physical level of the file system. Initially, the given user queries get translated in high-level database languages such as SQL. The query processing works in the following way: Parsing and TranslationĪs query processing includes certain activities for data retrieval. In query processing, it takes various steps for fetching the data from the database. Query Processing is the activity performed in extracting data from the database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |