{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

View - Security Views By B.Senthil Kumar Asst Prof CSE...

Info icon This 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
Image of page 1

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

View Full Document Right 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
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
Image of page 3

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

View Full Document Right 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.
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
Image of page 5

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

View Full Document Right 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]]
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 .
Image of page 7

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

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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern