Abstract / Excerpt:

The study used PostgreSQL for the design and implementation of an academic information system (AIS) of Southern Christian College. This software introduces new approaches to managing complex data in the AIS utilizing the object relational database management system (ORDBMS). Complex data in the AIS are illustrated based on their value and structure. For the design and analysis of the AIS the researcher utilized pgAdmin III, SQL Manager Lite for Postgresql and PostgreSQL 9.0. For the development of the AIS application the researcher utilized the Lazarus and ZeosLib connection component libraries in a Windows platform. The methodology of the study was a combination of aspects of both relational and objects oriented analysis, and design following the ANSI's Three-Tier Database Model.The development of the SCC's AIS application followed the commandments of application design with Zeos and PostgreSQL and that partially focuses on the student financial records. The developer implemented four common PostgreSQL type systems, created four complex types in the AIS, and implemented behaviors such as rules (rule based system), functions, triggers and parameterized view. Designing and implementation of AIS using the ORDBMS features of PostgreSQL provided a holistic approach in creating a functional and smart database.

Info

Source Institution	Ateneo de Davao University
Unit	Computer Studies
Authors	Roche T. Magsayo
Page Count	18
Place of Publication	Davao City
Original Publication Date	March 1, 2013
Tags	AIS, ANSI's Three Tier Database Model, Complex Data, Lazarus, ORDBMS, PostgreSQL, SQL Manage Lite for PostgreSQL, ZeosLib

Preview