|
|
|
|
||||||||||
|
||||||||||
| FAQ | CONTACT US | ||||||||||
ADVANCE
DATA BASE SYSTEM
Unit-ITransaction
processing in DB systems : Concept of transaction , Transaction state,
ACID properties, Concurrent execution of transactions,
Serializability , Recoverability , Concurrency control: Lock-Based
protocols, 2-phase locking protocol, Graph-based protocol,
Timestamp-based protocols. Deadlock handling. Failures
in DB system and recovery techniques : Failure classification, Storage
types, Recovery, Log-based recovery, Deffered and
immediate DB
modification , Checkpoints, Shadow paging , Recovery in concurrent
transactions , Buffer –management, Advanced recovery techniques:
Transaction rollback, Checkpoints, Restart facility.DB security and
authorization: DB security issues and Access control. DB
system Architectures : Centralization ,Client server, Parallel systems,
Distributed systems. Parallel
DBs : I/O parallelism, Inter query/ intra query parallelism, Intra
operation parallelism,, Interoperation parallelism , Distributed DBs : Concepts
in DDBs , Data fragmentation, replication and allocation techniques,
concept of transparency, distributed transaction model, commit
protocols, Coordinator
selection, concurrency control, Deadlock handling. Emerging
DB concepts and applications : Object-oriented DBs : Object oriented data
models, Object classes, Inheritance, Multiple inheritance, Object
identity , object containment, Persistence of objects.Object-relational
DBs, Nested relations, Complex types and object orientation, Querying
with complex types . Data warehousing: Characteristic of data ware houses,
Data modeling ,Data mining: Overview of data mining technology,
Association rules, Application. Concepts
of hierarchical data model: Tree structure diagrams, HSAM, HISAM and
HIDAM, Data retrieval operations.Concept of network data model: Data
structure diagrams, Concept of owner and member records, set membership,
DBTG data retrieval. Books
|
||||||||||
|
|
