View - Security Views By B.Senthil Kumar Asst Prof CSE Database Management Systems IV Sem Table of Contents An Introduction What is a View Why use

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Security – Views By: B.Senthil Kumar Asst. Prof, CSE Database Management Systems – IV Sem
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
01/02/10 Database Management Systems - IV Sem 2 Table of Contents An Introduction What is a View? Why use Views? Creating a View Guidelines – Creating a View Creating a View – using column alias Querying a View Updates on View Summary
Background image of page 2
01/02/10 Database Management Systems - IV Sem 3 An introduction Tables and views are database objects Table – basic unit of storage; composed of rows and columns View – logically represents subsets of data from one or more tables
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
01/02/10 Database Management Systems - IV Sem 4 What is a View? A view is a logical ( virtual ) table based on a table or  another view. A view contains no data of its own. The tables on which a view is based are called base tables.
Background image of page 4
01/02/10 Database Management Systems - IV Sem 5 Why use Views? Views restrict access to the data because the view can  display selective columns from the table –  data hiding Used to make simple queries to retrieve the results of  complicated queries –  simplified query formulations Views can provide logical data independence
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
01/02/10 Database Management Systems - IV Sem 6 Creating a View Embed a subquery within the  CREATE VIEW  statement. The subquery can contain complex  SELECT  syntax. CREATE [OR REPLACE] VIEW view_name [(alias[, alias]. ..)]  AS subquery [WITH CHECK OPTION [CONSTRAINT constraint]]
Background image of page 6
01/02/10 Database Management Systems - IV Sem 7 Creating a View Create a view, that contains details of employees in  department 50 The structure of view can be viewd by  DESC .
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/01/2012 for the course CSE,IT 101 taught by Professor Mirunaalini during the Spring '12 term at Indian Institute of Technology, Chennai.

Page1 / 20

View - Security Views By B.Senthil Kumar Asst Prof CSE Database Management Systems IV Sem Table of Contents An Introduction What is a View Why use

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online