Geo database system Syllabus for B.Tech 5th sem is covered here. This gives the details about credits, number of hours and other details along with reference books for the course.
The detailed syllabus for Geo database system B.Tech (R13) fifthsem is as follows
OBJECTIVES:
- To introduce the students to the concepts of DBMS, Spatial Database Management System (SDBMS), Spatial Database design, basic application program development and user interfaces.
UNIT I : INTRODUCTION [9 hours]
Data – Information – File system vs DBMS – Database Management Systems – Database Architectures, users and administrators – Classification of Database Management Systems – Spatial Data- Points, Lines, Polygons- definition of SDBMS -user classes of SDBMS – Multi layer architecture of SDBMS – GIS and SDBMS
UNIT II : SPATIAL CONCEPTS AND DATAMODELS [10 hours]
Field based model – object based model – spatial data types – operations on spatial objects Entity Relationship Model (ER Model) – Relational Model – Constraints and Normal forms of Relational Model – mapping ER model to Relational model – ER model with spatial concepts – Object-oriented data modeling with Unified Modeling Language (UML)
UNIT III : QUERY LANGUAGE [9 hours]
SQL – Data Definition – Data Manipulation – Basic structure of SQL – Set operations – Aggregate Functions –Simple queries –spatial vs non spatial- Nested sub queries – Complex queries – Views – Trigger – OGIS standard for extending SQL – example spatial SQL queries – Object relational SQL.
[TOTAL: 45 PERIODS]
OUTCOMES: At the end of the course the student will be able to understand
- Concepts and architecture of SDBMS
- Concepts of SQL and generation of queries
- Concepts of spatial data storage and design of SDBMS
TEXTBOOKS:
- Shashi Shekhar, Sanjay Chawla,”Spatial Databases a Tour” Prentice Hall, 2003.
- Philippe Rigaux, Michel Scholl, Agnès Voisard “Spatial Databases” Morgan Kaufmann, 2001
REFERENCES:
- Abraham Silberschatz, Henry F. Korth and S.Sudharshan, “Database System Concepts”, 6th edition, McGraw Hill, 2011
- Ravi Kothuri, Albert Godfrind, Euro Beinat “Pro Oracle Spatial for Oracle Database 11g”, Apress , 2007
- Regina, LeoHsu“Post GISin Action”,Oreilly & Associates Inc., 2011
For all other B.Tech GI 5th sem syllabus go to Anna University B.Tech GEOINFORMATICS ENGINEERING (GI) 5th Sem Course Structure for (R13) Batch.All details and yearly new syllabus will be updated here time to time. Subscribe, like us on facebook and follow us on google plus for all updates.
Do share with friends and in case of questions please feel free drop a comment.