Open Source Database (DB) System

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