Open Source Database (DB) System

Course Code: MCA5133

Course Title: Open Source Database (DB) System (4 Credits


Back

 

Course Contents

 

Unit 1 – Concepts on Database Management- Components of a database management system, Data management, Join algorithm, transaction management, concurrency control, availability.

 

Unit 2- Software Development Using Open Source Systems -Introduction, Objectives, Overview of Open Source System, Open source tools, Open source components, Open source methodology, Open Source Software Development Models.

 

Unit 3- Open Source Licensing, Contract, and Copyright Law -Basic Principles of Copyright Law, Contract and Copyright, Open Source Software Licensing, Types of OSS licenses, OSS licensing strategies, Issues with Copyrights and Patents, Warranties.

 

Unit 4- Software Development Using Open Source and Free Software Licenses- Introduction, Models of Open Source and Free Software Development, Forking, Choosing an Open Source or Free Software License, Drafting Open Source Licenses.

 

Unit 5- Relational model, languages & systems: relational data model & relational algebra: relational model concepts, relational model constraints, relational algebra, SQL- a relational database language: date definition in SQL, view and queries in SQL, specifying constraints and indexes in sql, a relational database management systems.

 

Unit 6- Open source database system- SAPDB, SQLite, Firebird, PostgreSQL, MySQL.

 

Unit 7- MySQL- MySQL Administration, Stored procedure, triggers, view, fuctions, hostings, sample database.

 

Unit 8- PHP Basics, Installing PHP, Basic scripting, PHP building blocks, PHP structures.

 

Unit 9- PostgreSQL- Short History of Postgres, The Berkeley Postgres Project, Postgres95, PostgreSQL, The SQL language, The advance features.

 

Unit 10- Advance Postgres SQL features- Inheritance, Non-atomic values, Arrays, More advance features

 

Unit 11- InnoDB-Data management, join algorithm, transaction management, concurrency control, availability.

 

Unit 12- Berkley DB- -Data management, join algorithm, transaction management, concurrency control, availability.

 

Unit 13- Experimental evaluation- The testing environment and the benchmark, database in main memory, half of the database in main memory, Database mostly on disk, effects of the size.

 

Back