Open Source Database (DB) System
Course Code: MCA5133
Course Title: Open Source Database (DB) System (4 Credits
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.