Research Background
Database is most one of the key factors in developing an information system, the system itself can be considered as successful if the database can process well in executing data and giving the exact information requested with nominal time. This is when the design of the database play a major part.
To optimize database means to increase the performances of that database. To obtain a system with very good performances supposes to have best performances for every component of that system. One of the most important components of the system is represented by the database. The type of the database, the methods and parameters used to create the database and the way how the database is used could increase or decrease the performances of the entire system.
A data model is a set of constructs for expressing how data is structured, constrained and manipulated. Different data models are required for different types of designs: conceptual schemas, logical schemas (suited to a particular data model or DBMS Interface), and physical schemas that capture implementation detail. A database design system needs to represent and manipulate all of these, either as separate models or as special cases of a more general model
Sistem Selangkah
Bahagian Pengambilan Pelajar (BPP) is the division which is responsible for managing student intakes and admissions for Universiti Teknologi MARA. It is also responsible for promoting UiTM to prospective students, especially Malaysian Certificate of Education (SPM) holders as well as Malaysian Higher Education Certificate (STPM) holders; providing relevant information regarding the available courses offered at UiTM.
Sistem Semakan Syarat Selangkah ke UiTM is one of the system owned and developed by Bahagian Pengambilan Pelajar (BPP) UiTM, this system provide accessible platform for user to access anytime widely through world wide web.
Problem Statement
The current database System Semakan Syarat Selangkah ke UiTM has no logical model which makes it difficult to identify what is the problem that cause the delay in system response during peak time.
The development of the current database for System Semakan Syarat Selangkah ke UiTM is done straight to the physical design without taking into consideration to the logical design of the data model. During peak time which exactly after SPM and STPM result being released, the response time by the database is often delayed and the user frequently get request time out at their browser when they trying to reaching this site. By using awstat analyzer, it’s shows that during that time the user who is trying to reach the site is over 1 million.
The unavailability of the logical model make it not possible to study the design of the database structure to identify what is the main cause that contributing in this problem.
No comments:
Post a Comment