User:Poonlaichu/sandbox

Introduction
View level of data abstraction is how data in the database is viewed by the users which enables the users to manipulate the data without worrying about the location of data and how it is actually stored.There are three levels of data abstraction, namely, internal, conceptual and external levels which are named three-level database management system architecture. It is proposed by American National Standards Institute/ Standards Planning and Requirements Committee (ANSI/ SPARC). Therefore, it is also known as ANSI/ SPARC architecture. For internal level, it is the lowest level of data abstraction that describes how the data are actually stored and organized on the storage medium, thus, it is also known as physical level. As a result, it describes complex low-level data structures in details. For conceptual level, it is the next higher level of abstraction that describe what data are stored in the database, what relationships exist among those data and complete view of the user’s requirements without any concern for the physical implementation, thus, it is also known as logical level. For external level, it is the highest level of abstraction that describes only part of entire database and it permits users to access data in a way that is customized according to their needs, thus, it is also known as view level.

Objectives

 * Is the only part that can be viewed by users.


 * the existence part is to help user can be easily access to the whole database.


 * View level is the highest level of Abstraction


 * To assist users to find the information quickly in the database.


 * For user to viewing data and interact with them

Literature Review
According to Juul (2007), he stated that there are certain level of abstraction in a database. They are Physical level of abstraction, Logical level of abstraction and View level of abstraction. He also stated that the first two level of abstraction is for the system to install data into the database. However, the view level of abstraction is users to assist user to find the data that exist in the database. From the research of Bates & Wileden (1983), they stated that user can view the data through rows and columns in the view level of abstraction, for those tables and relations are used for database to store data. In addition, a database may contained more than one views, user can interact with them and viewing them by using view level. Therefore, View level is the most important level of abstraction in a database, it benefit user a lot and making user more convenient to view and interact with data.