Query Processing and Query Optimization

1234567891011121314151617
Across
  1. 4. that checks syntax and existance of tables and column and all things
  2. 6. restricting access to objects based on their identity of user
  3. 7. a premetive operations
  4. 10. rights or permission granted to the user
  5. 12. identifying the user
  6. 13. allow/deny user access to specific areas
  7. 15. what actions are allowed to perform based on their role
  8. 17. responsible to construct the execution plan that minimize the cost
Down
  1. 1. data made available for computation as soon as it is produced
  2. 2. High level logical operation that translate it into physical operation
  3. 3. also known as lazy evaluation
  4. 5. a sequence of primitive operation that can be used to evaluate a query
  5. 8. Who,WHEN, FROM WHERE, WHAT logs recorded
  6. 9. Result of complex expression is calculated and stored as a temporary value
  7. 11. classifies both user and data object
  8. 13. priviledge and other permission are associated with organization role
  9. 14. granting appropriate persmission to access and manipulate data
  10. 16. data processing operation performed in sequential and continuous manner