Wednesday, 5 October 2011

Conceptual View Level

The middle level in the three-level architecture is a conceptual view level, which is also referred to as logical view  level. It describes the entire structure of database such as entities, attributes, data types, relationships, constraints, and user operations. It hides the details of physical storage structures. The conceptual view level supports the external view level to present the data to end-users as they need. This view is relatively constant and the Database Administrator designs it after determining the present and future information needs of the organization. However, to expand the conceptual view, the Database Administrator adds the new objects to fulfill the requirements of the organization, without affecting the external view.
The conceptual view is defined by means of the conceptual schema, which includes definitions of each of the various conceptual record types. The conceptual schema is a complete description of information of database structure such as every record type with all its fields. It also includes security and integrity rules. The conceptual schema is written in DDL, compiled by the DBMS and stored in its data dictionary. The DBMS uses the conceptual schema to create the logical record interface, which is used by the external record of a particular user to present data to that user. Actually, conceptual view level is a collection of the logical records.

10 comments:

  1. It's a nice blog with lot of information,thanks for sharing...
    Hi this is babu, I want to share some information for you,If you want to join any professional course visit this website
    oracle training in chennai It's a best place to learn oracle in chennai
    thanks, babu

    ReplyDelete
  2. It's a nice blog with lot of information,thanks for sharing...
    Hi this is babu, I want to share some information for you,If you want to join any professional course visit this website
    oracle training in Chennai It's a best place to learn oracle in chennai

    thanks, babu

    ReplyDelete
  3. Hi friends, This is Jamuna from Chennai. Your technical information is really useful for me. Keep update your blog.
    Regards..
    Oracle Training

    ReplyDelete
  4. Thank you so much for sharing this informative blog. Your technical information is really useful for me. Keep update your blog.

    Regards..

    PHP Institutes in Chennai



    ReplyDelete
  5. Thanks for sharing this informative blog. SAP CRM is used for maintaining and managing relationship with customers by firm. If you want to know more about SAP, please visit FITA located at Chennai Velachery.
    Regards..
    SAP Institutes in Chennai

    ReplyDelete
  6. Thanks for sharing this information. Salesforce is a cloud based CRM. Nowadays most of the multinational companies used this CRM for managing their customers. To know more details call 9841746595.

    Regards..
    Salesforce Training in Chennai

    ReplyDelete
  7. There are lots of information about latest technology and how to get trained in them, like Hadoop Training Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies(Hadoop Training in Chennai). By the way you are running a great blog. Thanks for sharing this. FITA chennai reviews

    ReplyDelete
  8. Thanks for sharing your informative article on Hive ODBC Driver. Your article is very descriptive and assists me to learn whole concept in detail. Hadoop Training in Chennai

    ReplyDelete