Transaction processing, Models of Transactions, Isolation, Models for Concurrency Controls, Objects and Semantic Commutative. Distributed Databases, Distributed Deadlock, Global Serialization, Security. Data Warehousing, OLAP and Data Mining, Aggregation. XML and Web Data, Object Databases, Historical Developments, Conceptual Object Data Model, ODMG Standard, Objects in SQL, Common Object Request Broker Architecture (CORBA). Building complex database objects: abstract data types, functions, procedures, sequences, triggers and views; building database applications using forms and reports; building data warehouses; establishing and maintaining database security and tuning databases for optimum performance. Several. DBMS’s to be used includes Oracle 11gand the 11g Internet Developer Suite, as the implementation vehicles for providing hands on experience for DBMS installation, database development, implementation and administration.
- editing-lecturer: Jeremiah Onunga