JNTUK B.Tech Advanced Databases (Elective – II) gives you detail information of Advanced Databases (Elective – II) R13 syllabus It will be help full to understand you complete curriculum of the year.
Course Objectives
- Be able to design high-quality relational databases and database applications.
- Have developed skills in advanced visual& conceptual modeling and database design.
- Be able to translate complex conceptual data models into logical and physical data Base designs.
- Have developed an appreciation of emergingdatabase trends as theyapplyto semi-structured data, the internet,andobject-oriented databases.
Course Outcomes
- Identify, describe, and categorize database objects
- Design and implement advanced queries using Structured Query Language
- Design, construct and maintain a database and various database objects using procedural language constructs, forms and reports to solve problems
- Administer a database by recommending and implementing procedures including database tuning, backup and recovery
- Propose, implement and maintain database security mechanisms
- Explore non-relational database systems and structures
Syllabus
UNIT – I : Algorithms for Query Processing and Optimization:Translating SQL queries into relational algebra- algorithms for external sorting-algorithms for select and join operations-algorithms for project and set operations-implementing aggregate operations and outer joins-combining operations using pipelining-using heuristics in query optimization.
UNIT –II: Data base systems architecture and the system Catalog:System architectures for DBMSs, Catalogs for Relational DBMSs, System catalog information in oracle. Practical database design and tuning:Physical Database Design in Relational Databases-an overview of Database Tuning in Relational systems.
UNIT – III: Distributed DBMS Concepts and Design:Introduction-function and architecture of a Distributed DBMS- Distributed Relational Database Design-transparencies in a Distributed DBMS-Date’s Twelve Rules for Distributed DBMS. Distributed DBMS-Advanced Concepts:Distributed Transaction Management-Distributed Concurrency Control-Distributed Deadlock Management-Distributed Database Recovery-The X/Open Distributed Transaction processing model-Replication Servers.
UNIT – IV: Introduction to Object DBMSs:Advanced Database Applications-Weaknesses of RDBMSs-Object oriented Concepts-Storing objects in a Relational Database-Next generation Database systems. Object-Oriented DBMSs-Concepts and Design :Introduction to Object-Oriented Data Models and DBMSs-OODBMS perspectives-Persistence-Issues in OODBMSs-The object Oriented Database System Manifesto-Advantages and Disadvantages of OODBMSs-Object oriented Database Design.
UNIT V: Object-Oriented DBMSs-Standards and Systems:Object management group-Object Database Standard ODMG3.0, 1999-Object store.Object relational DBMSs:Introduction to Object-relational Database systems- third generation Database manifesto-Postgres-an early ORDBMS-SQL3.
UNIT – VI : Emerging database technologies and applications: Hadoop, BIg Data characteristics, NO SQL databases, BASE, Brewer’s theorem, Relationship between CAP, ACID and No SQL databases, comparison with Relational databases, No SQL databases types, Comparative study of NoSQL products, Case studies using MangoDB and Cassandra.
TEXT BOOK
- “Fundamentals of Database Systems”, ElmasriNavate, 5/e, Pearson Education.
- Principles of distributed databases S Ceri and Palgettgi TMH
- Getting started with No SQL Databases , Gaurav Vaish
REFERENCES BOOKS
- “Principles of Distributed Database Systems”, Ozsu, 2/e, PHI.
For more information about all JNTU updates please stay connected to us on FB and don’t hesitate to ask any questions in the comment.