Manipulation of information located in a heterogeneous database requires an additional software layer on the top of existing database systems. This software layer is called a multi database system. The local database systems may differ in their concurrency control and transaction management mechanisms since they employ different logical models, data-manipulation and data-definition languages, and A […]
Multi Database Systems
Posted in Database Development by admin - Mar 19 2010
Oracle Architecture Overview
Posted in Database Development by admin - Feb 24 2010
Oracle, Relational Database Management System ( RDBMS ) is a collection of related information and allows access to these information simultaneously. This comprises database and the instance. The information domiciles in the database. The instance which is the combination of background processes and system memory is used to access the data in the database. Architecture […]
Database Recovery Steps
Posted in Database Development by admin - Jan 17 2010
There are several recovery techniques to recover database form failures caused due to system crashes or transaction errors. Recovery of databases from transaction failure done by restoring most consistent state of the respective database before the time of failure, to restore the recent database, system keeps informations on change applied on datas by various transaction […]