Advance Database
Get the full GTU study material, English & Gujarati textbook PDFs, syllabus curriculum, and solved previous year question papers.
English Book & Chapters
English Book Coming Soon
We are working hard to add this material. Stay tuned for updates!
Follow on Instagram for UpdatesGTU Previous Year Papers
Papers Coming Soon
We are working hard to add this material. Stay tuned for updates!
Follow on Instagram for UpdatesAdvance Database Syllabus — Unit-wise Content
The official GTU curriculum for Advance Database (subject code 2722311) as prescribed for IT · Semester 2 divides the course into 6 units, covering 28 listed topics. The unit-wise breakdown below is read from the GTU syllabus document for this subject code, so you can check what the course actually covers before deciding which papers to attempt.
Download the official syllabus PDF (2722311)Unit 1 Database System Architectures
- Centralized Systems
- Client-server System Architecture
- Parallel Systems
- Distributed Systems
- Network Types
Unit 2 Parallel Databases
- Inter-query and Intra-query Parallelism
- Inter- operation and Intra-operation parallelism
Unit 3 Distributed Databases
- Introduction - Distributed Data Processing
- Complicating Factors
- Problem Areas
- Distributed DBMS architecture
- Distributed Database Design – Design Strategies
- Design Issues
Unit 4 Data Warehouse and OLAP
- Introduction- Operational Database Systems and Data Warehouses
- Multidimensional Data Model - Star
- Snowflake, and Fact Constellation Schemas
- Indexing OLAP and Query Processing
- Introduction to Analytical Mining
Unit 5 Object-Based Databases and XML
- Need for complex data types
- Persistent Programming Languages
- Object-Oriented versus Object-Relational
- XML – Structure of XML Data
- Document Schema
- Application Program Interface
- Storage of XML Data
Unit 6 Advanced Data Types and New Applications
- Time in Database
- Spatial and Geographic Data
- Multimedia Database
Study on Android App:
