Welcome to WebmasterServe!

FREE TO JOIN! Join us now to engage in informative and friendly discussions about Webmastering, SEO, SEM, Internet Marketing, Programming, Graphic Design, Online Jobs and more. What are you waiting for? Ready to join our friendly community? It takes just one minute to register.

Dismiss Notice

Join WebmasterServe Forums 
Join the discussion! Have a better idea or an opinion? It takes just one minute to register Click Here to Join

Help Me/Question Why Views Are Used In Dbms?

Discussion in 'Database Management' started by Doominic anderson, Feb 23, 2016.

  1. Doominic anderson

    Yellow Belt

    Joined:
    Jan 30, 2016
    Messages:
    399
    Ratings:
    +21 / -0
    DBMS is a collection of huge amount of data,while it is not introduced,traditional files are used to stored the data in a restricted manner,we cannot store more data and every time we have to create a new file to stored another type of data.
    DBMS has a huge collection of properties which enables the database admin to store data and take data from users.
    Why views are used in DBMS,what are its use?
     
  2. krishatg

    Yellow Belt

    Joined:
    Jan 16, 2016
    Messages:
    240
    Ratings:
    +14 / -0
    Suppose you are the owner of one table and you need to give the access of that table to someone for some purpose. Now you don't want to give the access of full table data ,you want that only some part of the table which is necessary will only be provided in that case you can create a view of that table considering only those fields and data which you want to provide and give access of that view only instead of giving access to whole table.
     
  3. steve taylor

    Yellow Belt

    Joined:
    Feb 12, 2016
    Messages:
    769
    Ratings:
    +25 / -0
    In a database management system, a view is a way of representing information in the database. This can be done by placing the data items in a specific order, by underlining specific items, or by showing only specific items. For any database, there are a number of views that may be specified. Databases with many items tend to have more possible views than databases with few items.
     
  4. bharath

    Staff Member Yellow Belt

    Joined:
    Dec 7, 2015
    Messages:
    772
    Ratings:
    +54 / -0
    A view is nothing, but just giving access to that point either tables or rows. A view can contain number of tables, rows or selected rows, tables for a certain user. View limits a user can view certain Data, modify what they need or don't need.

    It is just like our School Records where a student of 1st class can access only 1st class materials or modify them, but not other classes within the school database.
     
  5. Swati Mishra

    Yellow Belt

    Joined:
    Dec 28, 2015
    Messages:
    644
    Ratings:
    +105 / -0
    A view can select rows from table. We can create view from single table,multiple table. View statement is created by CREATE VIEW statement.
     
  6. saurabh mathur

    Yellow Belt

    Joined:
    Nov 8, 2017
    Messages:
    130
    Ratings:
    +2 / -0
    Views are the only way to provide the query data.They can provide the advantages over the tables. They represent a subset of the data contained in the table. It is the way of portraying the information in the database. It is nothing more than the SQL statement which is stored in the database with associated name.

    Web hosting
     
  7. durgamatha

    Yellow Belt

    Joined:
    Nov 3, 2017
    Messages:
    45
    Ratings:
    +2 / -0
    n some NoSQL databases, views are the only way to query data. Views can provide advantages over tables: Views can represent a subset of the data contained in a table. ... Depending on the SQL engine used, views can provide extra security.
    Best Indian astrologer in Australia
     

Share This Page