NC4002 Server Architectures Syllabus:
NC4002 Server Architectures Syllabus – Anna University PG Syllabus Regulation 2021
COURSE OBJECTIVES:
To understand fundamentals of DBMS.
To understand various concept of Database and its working.
To acquaint the students with Client Server Architecture and PL/SQL programming
UNIT I DATABASE COMPUTING MODEL
Client Server Computing: Functions of client, server, middleware components, Advantages and limitations of client server computing Three Tier Architecture: Overview of thin client, application server, web server, Overview of Distributed Database, Overview of Real Application Clusters, Overview of High Performance Database Computing, Overview of Data Warehousing and Data Mining
UNIT II OVERVIEW OF ORACLE DATABASE SERVER ARCHITECTURE
Architecture of Oracle Database and Oracle Instance, Overview of Physical and Logical Structures, Dedicated and Shared Server Configuration, Oracle Server Startup and Shutdown, Creating Database
UNIT III ORACLE TOOLS AND UTILITIES
SQL – Pl/SQL Procedural Extension, Overview, PL/SQL data types & Control Structures, Cursors, Stored Procedures & Functions, Database Triggers, Package Creation, Dynamic SQL Collections
UNIT IV DATABASE ADMINISTRATION
Objects Managing Users, User Configuration Setup, Resource Management, Working with user database account , Backup & Recovery, Database Security, Export & Import Tools, Overview of Grid Based Database
UNIT V DATA STORAGE
Magnetic disk, magnetic tape, CD-ROM, WORM, Optical disk, mirrored disk, fault tolerance, RAID, RAID-Disk network interface cards. Network protection devices, Power Protection Devices, UPS, Surge protectors. Client Server Systems Development: Services and Support, system administration, Availability, Reliability, Serviceability, Software Distribution, Performance, Network management, Help Disk, Remote Systems Management Security, LAN and Network Management issues.
COURSE OUTCOMES:
After completing the course, students will be able to:
CO1: Understand how DBMS works and the importance of various concepts of DBMS.
CO2: Understand oracle architecture and its tools.
CO3: Apply ORACLE in DBMS administration
CO4: Familiarize with the various storage devices.
CO5: Establish a Secure connectivity for a network to any environment.
CO6: Analyse the convergence between the Database and the User environment.
TOTAL:45 PERIODS
REFERENCES
1. Patrick Smith & Steave Guengerich, “Client / Server Computing”, PHI, 2nd edition, 2011.
2. Dawna Travis Dewire, “Client/Server Computing”, TMH, July 2003
3. Korth, Silberchatz, Sudarshan, “Database Concepts”, McGraw Hill,2005
4. Elmasri, Navathe, S.B, “Fundamentals of Data Base System”, Addison Wesley, 6th Edition, 2010.